E1: 75I: R75I809-Rounding Off Difference In Paise Between P4210 Online Invoice And GST Invoice Total

(Doc ID 2316245.1)

Last updated on OCTOBER 10, 2017

Applies to:

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

Symptoms

On : 9.0 version, Localizations - JAPAC - Sales
R75I809 GST Tax Invoice

ACTUAL BEHAVIOR
---------------
When generating the R75I809, the Invoice Total on the PDF is not the same as the P4210 Online Invoice.

STEPS
-----------------------
1.Create an adjustment definition PR1 for Custom Duty for adjustment control code 2 with flags for Manual Add/Change and Apply on Override Price as checked.
2.Create adjustment definition PR2 meant for CGST for adjustment control code 6 with the same flags being checked.
3.Create adjustment definition PR3 meant for SGST for adjustment control code 6 and the same flags being checked.
4.In P4072, PR1 is setup for 5.15 % of base price. Also PR2 and PR3 are setup for 9 % of current net price. These adjustments are being linked to a schedule.
5.In P75I006, PR2 is linked to CGST/GST and PR3 is linked to SGST/GST.
6.Create a SO as follows
7.In Line 1: Qty 1, Unit Price as 2,048,004.00
8.In Line 2: Qty 2, Unit Price as 480,254.58. However this line has CGST/SGST as 14 %
9.In Line 3: Qty 9, Unit Price as 658.80
10.In Line 4: Qty 2, Unit Price as 658.80
11.In Line 5: Qty 1, Unit Price as 1,759.68
12.In Line 6: Qty 10, Unit Price as 1,759.68
13.In Line 7: Qty 1, Unit Price as 76,014.90. Here CGST/SGST is 6%
14.In Line 8: Qty 2, Unit Price as 10,410.66
15.In Line 9: Qty 10, Unit Price as 1,179.90
16.In P4210 customer service inquiry goto the Online Invoice and notice that the Invoice Total is displayed as 3996874.52
17.Ship Confirm the order.
18.Generate the R75I809
19.In the R75I809, notice that the invoice total is populated as 3996874.51[which is incorrect and different from the Online Invoice of P4210]
20.As per the pdf, calculation should be the Taxable Value[3,305,654.88] + Tax Amount[691,219.64]= 3996874.52[Invoice Total]


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