E1: 42: Tax Rounding at Invoice Level (Doc ID 1628278.1)

Last updated on JANUARY 31, 2017

Applies to:

JD Edwards EnterpriseOne Sales Order Management - Version 9.1 and later
JD Edwards EnterpriseOne Sales Order Entry - Version 9.1 and later
JD Edwards EnterpriseOne Sales Order Processing - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

Currently, JDE EnterpriseOne only offers the option to round the taxes at Line level or Order level (not at Invoice level). Rounding discrepancies between R42565 and R42800 may appear depending on the setup.

Example:                                                        
Tax Rules (P0022) are set to round at order level - "Sales Order Taxes at Order Level" flag is checked.                                    
Sales Order 1: order amount 1912.50, tax rate 19%, tax 363.38, total amount 2275.88                
Sales Order 2: order amount 637.50, tax rate 19%, tax 121.13, total amount 758.63                  
Total tax amount therefore is 363.38 + 121.13 = 484.51                        
Using consolidated invoicing for the customer, we get an R42565 total of 3034.51                   
What the client wants is to have the 19% tax calculated at the invoice level, so they want it to add 1912.50 (order 1 net) plus 637.50 (order 2 net), add that up to 2550.00 total net, and then apply the 19% to that, which is 484.50, resulting in an invoice total of 2550 + 484.50 = 3034.50.                   

Customer would like a processing option behind either R42800 or R42565 which would allow tax rounding at invoice level.

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