Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
2 Odpovědi
7188 Zobrazení

I try create a paper format for a report template, I have this error message:


odoo.tools.convert.ParseError: "null value in column "name" violates not-null constraint

DETAIL:  Failing row contains (959, null, ir.actions.report, null, null, report, list,form, 1, 2021-03-12 17:35:13.849794, 1, 2021-03-12 17:35:13.849794, null, qweb-pdf, null, null, null, 77, null, null, null).


The code that I wrote is this:

<?xml version="1.0" encoding="utf-8"?>
<odoo>
<data>
<record id="purchase_paper_format" model="report.paperformat">
<field name="name">Purchase Order</field>
<field name="default" eval="False"/>
<field name="format">custom</field>
<field name="page_height">297</field>
<field name="page_width">210</field>
<field name="orientation">Portrait</field>
<field name="margin_top">3</field>
<field name="margin_left">15</field>
<field name="margin_right">15</field>
<field name="header_line" eval="False"/>
<field name="header_spacing">3</field>
<field name="dpi">120</field>
</record>

<record id="purchase_format" model="ir.actions.report">
<field name="paperformat_id" ref="report_purchase_order.purchase_paper_format"/>
</record>
</data>
</odoo>
Avatar
Zrušit
Nejlepší odpověď

To eliminate the error, replace the below-mentioned coding with the correct one.

<?xml version="1.0" encoding="utf-8"?>

<odoo>

    <data>

        <record id="purchase_paper_format" model="report.paperformat">

            <field name="name">Purchase Order</field>

            <field name="default" eval="False"/>

            <field name="format">custom</field>

            <field name="page_height">297</field>

            <field name="page_width">210</field>

            <field name="orientation">Portrait</field>

            <field name="margin_top">3</field>

            <field name="margin_left">15</field>

            <field name="margin_right">15</field>

            <field name="header_line" eval="False"/>

            <field name="header_spacing">3</field>

            <field name="dpi">120</field>

        </record>


Replace:

        <record id="purchase_format" model="ir.actions.report">

            <field name="paperformat_id" ref="report_purchase_order.purchase_paper_format"/>

        </record>

    </data>

</odoo>


With:

<record id="purchase.action_report_purchase_order" model="ir.actions.report"> <field name="paperformat_id" ref="report_purchase_order.purchase_paper_format"/> </record>

Avatar
Zrušit
Nejlepší odpověď

Hi,
Here the issue on ir.action.report. In this model, the name field is mandatory and you aren’t added. So if you create a report please add all the necessary information.
If you are trying to add paper format for an existing report. Please add the module name of the report was originally defined, before the record id as follows

<record id="module_name.purchase_format" model="ir.actions.report">
<field name="paperformat_id" ref="report_purchase_order.purchase_paper_format"/>
</record>

I think this may help you.
For more information about PDF reports in Odoo 14 refer the blog
https://www.cybrosys.com/blog/how-to-create-pdf-report-odoo-14

Hope it helps


Avatar
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
0
čvc 22
40
1
bře 21
10418
3
kvě 24
3006
1
zář 24
6787
0
led 22
2012