Accounting Error when Voiding an AP Invoice with Multiple Tax Categories (Same Rate)

44 views
Skip to first unread message

Andres Lopez Andrade

unread,
Nov 12, 2025, 10:07:04 AMNov 12
to iDempiere

Hi

I am experiencing a critical accounting issue when voiding (reversing) an AP Invoice. The problem occurs when the invoice contains two different charges that are linked to two different tax categories, but both categories share the same percentage rate.

When the document is voided, the system generates incorrect accounting. It seems to take the first tax line (e.g., "Service Tax") and duplicates it, while completely ignoring the second tax line (e.g., "Goods Tax").

Steps to Reproduce:

  1. Setup Tax Categories: Create two different Tax Categories:

    • Category 1: "Service Tax" (with a 15% tax rate).

    • Category 2: "Goods Tax" (also with a 15% tax rate).

  2. Setup Charges: Create two Charges:

    • Charge 1: "Service Charge", assign it to the "Service Tax 15%" category.

    • Charge 2: "Goods Charge", assign it to the "Goods Tax 15%" category.

  3. Create AP Invoice: Create a new AP Invoice (CxP document).

  4. Add Lines: Add two lines to the invoice:

    • Line 1: Select the "Service Charge".

    • Line 2: Select the "Goods Charge".

  5. Post Invoice: Complete and post the document.

    • Observation: At this stage, the accounting is generated correctly. Each line correctly posts to its corresponding tax account (Service Tax and Goods Tax).

  6. Void Document: Void (reverse) the posted invoice.

Expected Result: The reversal document should generate accounting entries that are a perfect inverse of the original posting, correctly reversing both the "Service Tax" line and the "Goods Tax" line.

Actual Result (The Bug): The system generates a flawed accounting entry for the reversal. It incorrectly takes the first tax line (Service Tax 15%) and duplicates it. It completely ignores the second tax line (Goods Tax 15%). This leads to an incorrect and unbalanced GL entry.

I am attaching screenshots that show the setup of the tax categories, the charges, the original (correct) posting, and the incorrect accounting generated by the voiding process.

chrome_3g3XYNFbQR.png
chrome_nrEn497TT0.png
chrome_9FCCFlPU86.png
chrome_506Dt8BYDh.png
chrome_tAjCxMxvjf.png
hdnihF0kAg.png

Carlos Antonio Ruiz Gomez

unread,
Nov 23, 2025, 2:10:07 PM (12 days ago) Nov 23
to idem...@googlegroups.com
Andres, I think is better to open a bug report if the bug can be reproduced with actual release-13

Regards,

Carlos Ruiz

Andres Lopez Andrade

unread,
Nov 24, 2025, 9:03:03 AM (11 days ago) Nov 24
to idem...@googlegroups.com
Hello Carlos,
I was planning to test the case tomorrow during the Community Testing Day and, if necessary, open a bug report to have it reviewed.
Thank you for your response.


De: idem...@googlegroups.com <idem...@googlegroups.com> en nombre de Carlos Antonio Ruiz Gomez <car...@gmail.com>
Enviado: domingo, 23 de noviembre de 2025 14:09
Para: idem...@googlegroups.com <idem...@googlegroups.com>
Asunto: Re: [idempiere] Accounting Error when Voiding an AP Invoice with Multiple Tax Categories (Same Rate)
 
--
You received this message because you are subscribed to a topic in the Google Groups "iDempiere" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/idempiere/u1eWch5XIgQ/unsubscribe.
To unsubscribe from this group and all its topics, send an email to idempiere+...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/idempiere/6e89c7f6-144e-434f-a02a-d4bd71655632%40gmail.com.
Reply all
Reply to author
Forward
0 new messages