My Oracle Support Banner

E1: 43: Discrepancy Between Tax Summary Report (R0018P1) and Tax Detail Report (R0018P) When the Tax Is Defined by Item or Group of Items (Doc ID 2801056.1)

Last updated on AUGUST 23, 2021

Applies to:

JD Edwards EnterpriseOne Procurement and Subcontract Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When a tax rate/area is defined in the Work With Tax Rate/Areas (P4008) for an item or group of items, it is assigned to transactions but it does not appear on the output of Tax Detail Report (R0018P). This happens even if there are records written in Tax File (F0018) for those transactions. The Tax Summary Report (R0018P1) does consider the records from Taxes (F0018) table whilst Tax Detail Report (R0018P) does not.


The issue can be reproduced at will in the following scenarios:

Scenario 1:

  1. Define a tax rate/area in P4008 for a group of item 3.
  2. Set an item as taxable with Purchasing Taxable set as Y in Item/Branch Plant Info.
  3. Set an item as taxable with Purchasing Taxable set as 3 in Item/Branch Plant Info.
  4. Create a purchase order for a supplier with the tax rate from step 1.
  5. Add the 2 items on the details. Note that both of them has the tax area populated on the detail line, even though only one has the Purchasing Taxable set as 3, same as define in the P4008.
  6. Receive the purchase order in full.
  7. Create a 3-way voucher match (with summarization turned off) and note the tax is applied and calculated for both lines.
  8. Check F0411 table. 2 records has been added corresponding to the 2 items.
       - the one for the item with Purchasing Taxable set as Y has Short Item No (ITM) populated with short F0401.ITM
       - the one for the item with Purchasing Taxable set as 3 has Short Item No (ITM) populated with a value of 3
  9. Post the voucher. Ensure the processing option is set to update Tax File F0018.
  10. Check the F0018 table for the records created. The F0018.ITM gets the values from F0411.ITM.
  11. Run R0018P1. The output displays the data for the transactions as per F0018 table.
  12. Run R0018P. The output displays only the data for the F0018 detail line with F0018.ITM = 3.


Scenario 2:

  1. Use same tax rate/area defined in P4008 for a group of item 3.
  2. Set a non-stock item with a line type having Inv Interface as N, Include in Tax 1 as Y (which means that the non-stock item with this line type is taxable) and Edit Item Master for Non-Stock Item flag NOT checked.
  3. Create a purchase order for a supplier with the tax rate from step 1.
  4. On the detail line add that non-stock item.
  5. Create a 2-way voucher match (with summarization turned off) and note the tax is applied and calculated.
  6. Check F0411 table. A record has been added and it has Short Item No (ITM) as blank.
  7. Post the voucher. Ensure the processing option is set to update Tax File.
  8. Check the F0018 table for the record created. The F0018.ITM gets blank value from F0411.ITM.
  9. Run R0018P1. The output displays the data for the transaction as per F0018 table.
  10. Run R0018P. The output doesn’t displays anything as no data found.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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