E1: 42: Sales Invoices Created from EDI Sales Orders (R47011) Have a Rounding Difference with the Amounts Calculated with the Web Ordering System (Doc ID 2869643.1)

Last updated on MAY 17, 2022

Applies to:

Symptoms

Customers place their order on a website, with the VAT tax included in their price. The web orders are then extracted into a text file EDI Inbound Purchase Order Edit/Create (R47011) is used to process the orders in JD Edwards. When the order is created in the JD Edwards EnterpriseOne system there is often a small rounding difference, such as 0.01 Euro on the final Extended Amount after Tax.

The client has provided an example from their system.

1. A customer creates a two-line sales order from a non-JD Edwards web ordering system.
   1. Line 1.000 Extended Amount is 7.00 including tax
   2. Line 2.000 Extended Amount is 49.00 including tax
   3. Order Total is 56.00 including tax
2. The data from the web is extracted into a flat file and imported into the JD Edwards EnterpriseOne EDI tables.
3. Client runs EDI Inbound Purchase Order Edit/Create (R47011)
   1. Line 1.000 Extended Amount is 5.83 without tax
   2.  Line 2.000 Extended Amount is 40.83 without tax
   3. Total without tax is 46.66
4. After Sales Order is created, customer finds and selects the order in Customer Service Inquiry (P4210)and takes the Row Exit to Online Invoice (P42230).
   1. The invoice Total after tax is added is 55.99 Euro instead of 56.00 Euro.

Changes

Cause

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