Posting Batch Fails with an ERROR_MSG "Header Amount Of xxx Does Not Equal to Total Detail Amount Of yyy" in IM_POSTING_DOC_ERRORS Table (Doc ID 1106138.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Invoice Matching - Version 13.1 and later
Information in this document applies to any platform.
Checked for relevance on December 3rd, 2014

Symptoms

When a tax discrepancy on an item in the invoice is resolved using "Debit Memo - Tax Item Only", the invoice fails after running the Posting batch with below ERROR_MSG in IM_POSTING_DOC_ERRORS table:

"Header amount of xxx does not equal to total detail amount of yyy".



Steps to Reproduce:
1. Create a Purchase Order (PO) for 3 items and receive in full.
2. Create the invoice for all 3 items such that one item has Tax discrepancy and other item has quantity discrepancy.
3. Resolve the Tax discrepancy by choosing "System Tax" as correct and resolution "Debit Memo - Tax Item Only" for the item.
4. Resolve quantity discrepancy on the item through "Detail Matching" screen and by using "Debit Memo - Quantity".
5. Run the Rollup batch.
6. Run the Posting batch and notice that two Debit Memos are posted, but the invoice remains in the "MTCH" status.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms