E1: 42: Sales Update on Intercompany Orders Results in Small Differences between AP Invoice and AR Invoice
(Doc ID 2514546.1)
Last updated on OCTOBER 28, 2019
Applies to:JD Edwards EnterpriseOne Sales Order Management - Version 9.2 and later
Information in this document applies to any platform.
Sales Update (R42800)
Loss of functionality
On some but not all Intercompany Sales Orders the SK Sales Invoice (Accounts Receivable) is off by .01 to .03 from the OK Voucher Invoice (Accounts Payable) due to rounding differences at the time of Sales Update (R42800).
Significance of the loss
- The impact of the issue is that an accountant has to write off a .01 to .03 difference between the AP invoice and the AR invoice so that the AP check sent by the vendor matches the AR cash receipt applies by the customer
- The write off amount is also needed to make the G/L Balance match between the AP transaction and the AR transaction
- The requirement to write off a .01 to .03 amount is an inconvenience and interruption for busy accounting personnel.
Sequence of events
- Create a 24 line Sales Intercompany Customer Order with specific values on each line.
- Generate the SK Sales Order and OK Purchase order for the selling branch and supplying branch.
- Process the SK Sales Invoice and OK Voucher Invoice through Sales Update (R42800)
- There was a .01 difference between the AR Invoice and AP Invoice.
- When a payment is sent there is a .01 difference.
- The AR Cash Receipts person has to write off the .01 difference in order to mark the invoice as fully paid.
Where the issue happens
This occurs in all environments including the production (live) environment.
Expected or acceptable result
The SK Sales Invoice (Accounts Receivable) and OK Voucher Invoice (Accounts Payable) should be identical on Intercompany Orders.
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