R12: AP: The Total Tax Amount of Debit Memos Not Equal the Tax Amount of Original Standard Invoice (Doc ID 2657064.1)

Last updated on DECEMBER 07, 2020

Applies to:

Goal

There is one standard invoice which is matched to Receipt. When return the goods several times and return all of them, that may cause the variance between Returns and original Receipt. Then the total Tax Amount of Debit Memos will not equal the Tax Amount of original Standard Invoice.

STEPS
-----------------
The issue can be reproduced at will with the following steps:
1. Purchasing(PO) responsibility > Purchase Orders > Purchase Orders, create a new order.
2. Purchasing(PO) responsibility > Receiving > Receipts, receive the order and save. The standard invoice is created by concurrent program "Pay On Receipt AutoInvoice" and "Payables Open Interface Import".
3. Purchasing(PO) responsibility > Receiving > Returns, return the goods several times and return all of them. Several Debit Memos are created.The total Tax Amount of Debit Memos doesn't equal the Tax Amount of original Standard Invoice.

AMOUNT SAMPLE
-----------------
Standard Invoice:

Item Amount       333
Tax Amount          27
Invoice Amount    360

Debit Memo (Returned the goods 5 times):
124-101　   -66　*8%=5.28    -5　　-71
124-102　   -66　*8%=5.28    -5　　-71
124-103       -67　*8%=5.36    -5　   -72
124-104       -67　*8%=5.36    -5　   -72
124-105       -67　*8%=5.36    -5　   -72
---------------------------------------------------------
                   -333                      -25     -358

The total Tax Amount of Debit Memos is -25 JPY, but the Tax Amount of original Standard Invoice is 27 JPY.
How to adjust the tax variance between Debit Memos and original standard invoice?
 

Solution

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