Skip to Content
This question has been flagged
1 Atsakyti
110 Rodiniai
Portretas
Charity Kiguhi

In Odoo (Accounting → Configuration → Management → Accounting Reports), report lines have a “Hide if Zero” option.

This works as expected on several financial reports, but does not work on the Aged Payable report.

In Aged Payable:

  • Vendors with zero balance still appear

  • All period columns (period0 … period5) are zero

  • total is zero

  • “Hide if Zero” is enabled on the report line

I understand that Aged Payable uses a custom Python engine (_report_custom_engine_aged_payable) and grouping (partner_id, id).

Questions:

  1. Is “Hide if Zero” expected to work on Aged Payable?

  2. Does the custom engine bypass the standard zero-line filtering?

  3. What is the correct way to hide vendors with zero total balance in Aged Payable?

Any clarification on the intended behavior or best practice would be appreciated

Portretas
Atmesti
Portretas
Ray Carnes (ray)
Best Answer

Although the balance for a Vendor may be $0 it is still possible a payment and a bill have not been matched (reconciled). 

The report will always show Vendors with a $0 balance if reconciliation has not been completed for that Vendor. 

Portretas
Atmesti