İçereği Atla
Bu soru işaretlendi
reportpaperformatv14
2 Cevaplar
7312 Görünümler
Avatar
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>
Avatar
Vazgeç
Avatar
Omprakash
En İyi Yanıt

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
Vazgeç
Avatar
Cybrosys Techno Solutions Pvt.Ltd
En İyi Yanıt

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
Vazgeç
İlgili Gönderiler Cevaplar Görünümler Aktivite
V14: Adding a report to print
report v14
Avatar
0
Tem 22
40
Binding Mode ID (Report)
report v14
Avatar
Avatar
1
Mar 21
10569
Two paper formats for one report
qweb report paperformat
Avatar
Avatar
Avatar
Avatar
3
May 24
3119
How to solve report header/footer missing while printing? Çözüldü
development report v14
Avatar
Avatar
1
Eyl 24
6909
carrier_tracking_id from stock.picking on a Report with Studio
report carrier v14
Avatar
0
Oca 22
2090