E1: 17: Tax Detail Report - R0018P Includes the SV Order Non-Taxable Amount in the Taxable Amount Column (Doc ID 3051840.1)

Last updated on OCTOBER 11, 2024

Applies to:

Symptoms

When creating service order parts detail lines for non-stock items defined with non-taxable line type, the Non-Taxable Amount is placed in the field Invoice Taxable (F4812H.ITXA).
This leads to incorrect display in the PDF output of R0018P - Tax Detail Report and incorrect data saved in the Tax table – F0018, because the value corresponding to the Non-Taxable amount is printed and included in the Taxable Amount Column and the real / actual value of the Non-Taxable Amount always remains blank.

The issue can be reproduced at will with the following steps:

1. P40205 – Define 2 non-taxable line types for non-stock items:
   - Line type N1 has Inv. Interface = B - G/L Account & Non-Stock (Purchased) and Include in Tax 1 = N - Ln is not subj to applicable taxes
   and
   - Line type N2 is defined with Inv. Interface = N - Non-Stock Item and Include in Tax 1 = N - Ln is not subj to applicable taxes.
2. P4101 - Create 2 non-stock items e.g SV_N1 and SV_N2 defined with line type N1 and line type N2, respectively.
3. P4008 – Define a Tax Rate/Area with a Tax Rate of 25%.
4. P48201 / P17714 – Create a service order and use the above Tax Rate/Area. Note the service order number.
5. P17730 – Create service order parts list by adding the previous non-stock items.
   For line type N1, Estimated Billable Unit = Estimated Billable Amount = Actual Billable Unit = Actual Billable Amount = 28, Taxable = Y.
   For line type N2, Estimated Billable Unit = Estimated Billable Amount = Actual Billable Unit = Actual Billable Amount = 100, Taxable = N.
6. R1775 – Run the UBE to create workfile. Actual Billable Amount for Ln Ty N1 = 28 and for Ln Ty N2 = 100 USD.
7. P4812 – Review the workfile details generated for the above service order and note the Billing IDs.
   For Ln Ty N1: Base Invoice = 35.00, Invoice w/Comp = 35.00, Base Revenue = 28.00 and Revenue w/Comp = 28.00.
   For Ln Ty N2: Base Invoice = 100.00, Invoice w/Comp = 100.00, Base Revenue = 100.00 and Revenue w/Comp = 100.00.
8. R48121 - Invoice the customer. Note the Batch number created for this invoice. Pdf output of the UBE shows the Invoice Amount = 135 and Invoice Tax = 7. This is correct.
9. P48221 – Inquire on the Batch Number to review the Batch details.
10. P48221 – Take Row Exit > Create A/R option to create the A/R records.
11. P4812H – Review the Workfile History details and notice the field Invoice Taxable (F4812H.ITXA) includes the Non-Taxable Amount value too.
12. P0011 – Post the previous Batch Number.
13. R0018P – Notice the Non-Taxable Amount bucket is blank, when it should have been set to e.g. 100.00.

Cause

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