Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
2 Odgovori
658 Prikazi
Avatar
Fanha Giang 
<record id="vn_b01b_dnn_tt133_bs_413" model="account.report.line">
    <field name="name">3. Thuế và các khoản phải nộp Nhà nước (413)</field>
    <field name="code">BS413_133</field>
    <field name="foldable" eval="True"/>
    <field name="groupby">account_id</field>
    <field name="expression_ids">
        <record id="vn_b01b_dnn_tt133_bs_413_balance" model="account.report.expression">
            <field name="label">balance</field>
            <field name="engine">domain</field>
            <field name="formula" eval="['|', '|', '|', '|', ('account_id.code','=like','3331%'), ('account_id.code','=like','3334%'), ('account_id.code','=like','3335%'), ('account_id.code','=like','3338%'), ('account_id.code','=like','3339%')]"/>
            <field name="subformula">-sum_if_neg</field>
        </record>
    </field>
</record>

I have code above, with my data, I want the 413 line to be 23,562,151

but it is 0.

Could you please help me to correct it.

Avatar
Opusti
Avatar
Fanha Giang
Avtor Best Answer

Solved.

I update the source then use like:

Engine: Prefix of Account Codes

Label: balance

Formula: -333C

Avatar
Opusti
Avatar
D Enterprise
Best Answer

Solution:

Change subformula to sum to include all balances (positive and negative):
<record id="vn_b01b_dnn_tt133_bs_413" model="account.report.line">

    <field name="name">3. Thuế và các khoản phải nộp Nhà nước (413)</field>

    <field name="code">BS413_133</field>

    <field name="foldable" eval="True"/>

    <field name="groupby">account_id</field>

    <field name="expression_ids" eval="[(0, 0, {

        'label': 'balance',

        'engine': 'domain',

        'formula': ['|', '|', '|', '|',

            ('account_id.code', '=like', '3331%'),

            ('account_id.code', '=like', '3334%'),

            ('account_id.code', '=like', '3335%'),

            ('account_id.code', '=like', '3338%'),

            ('account_id.code', '=like', '3339%')

        ],

        'subformula': 'sum',

    })]"/>

</record>

i hope it is helpfull

Avatar
Opusti
Fanha Giang
Avtor

hi, thanks for reply.
This is in VN report. that field must get all the negative balance of that accounts. not just sum all the balance.