My Oracle Support Banner

Posting Error Sum of Debit And Credit Amounts Must Be Zero When Resolving Unrecieved PO With Debit Memo Less Than Ordered Quantity (Doc ID 2456874.1)

Last updated on NOVEMBER 02, 2018

Applies to:

Oracle Retail Invoice Matching - Version 14.0 and later
Information in this document applies to any platform.

Symptoms

In Retail Invoice Matching (ReIM), IM_POSTING_DOC_ERRORS shows the following error for invoices that are within tolerance:


Steps to Reproduce :


1. Create the PO (Don't receive) - For our example let's say quantity ordered is 100.
2. Create an Invoice based on the PO with details
3. Run the Automatch batch
4. Resolve the quantity discrepancy applying a debit note with a quantity of 96 (100-96=4, is within the tolerance defined so it is possible to apply).
5.Run the Rollup batch
6. Run the Posting batch

Result: Check the table IM_POSTING_DOC_ERRORS - "Sum of Debit and Credit amounts must be zero. Posted debit/credit differ by -32.4 for untaxed amount,-32.4 for signed transaction amount and by-30.0278 for signed transaction amount in primary currency"

Expectation: Docs should be posted since they are within tolerance.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.