Error when create paper format for report in Odoo 14.0

report paperformat v14

2 Svar

9406 Vyer

Victor Rodriguez

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>

Ksolves India Limited, Omprakash

Bästa svar

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

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

<odoo>

<data>

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

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

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

</record>

Replace:

</record>

</data>

</odoo>

With:

Cybrosys Techno Solutions Pvt.Ltd

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

Njuter du av diskussionen? Läs inte bara, delta också!

Skapa ett konto idag för att ta del av exklusiva funktioner och engagera dig i vår fantastiska community!

Registrera dig

Relaterade inlägg	Svar	Vyer
V14: Adding a report to print report v14	0 juli 22	40
Binding Mode ID (Report) report v14	1 mars 21	13108
Two paper formats for one report qweb report paperformat	3 maj 24	5307
How to solve report header/footer missing while printing? Löst development report v14	1 sep. 24	9076
carrier_tracking_id from stock.picking on a Report with Studio report carrier v14	0 jan. 22	3833

Denna fråga har flaggats

Njuter du av diskussionen? Läs inte bara, delta också!