E1: 76B: ICMS Differential Tax is Using the Wrong Percentage (Doc ID 2591649.1)

Last updated on MAY 15, 2023

Applies to:

Symptoms

When a purchase order is received (P4312) with the Vendor in the state of Sao Paulo (SP) and the Branch Plant in the state of Bahia (BA), the ICMS Tax Differential is incorrectly calculated on the Nota Fiscal. This occurs because the ICMS Tax Rate (P7608B) From BA to SP is selected when the correct rate that should be selected is the rate From SP To BA.

Steps to Duplicate:

1. ICMS Tax Rates (P7608B) are setup From SP To BA as follows
   1. ICMS State Tax = 18%
   2. ICMS Interstate Tax = 7%
   3. ICMS Differential Percent = 11% (18%-7%)
   4. ICMS Reduction Tax = 26.570%
2. ICMS Tax Rates (P7608B) are setup From BA to SP as follows 
   1. ICMS State Tax = 18%
   2. ICMS Interstate Tax = 12%
   3. ICMS Differential Percent = 6% (18%-12%)
3. Create a Purchase Order with a Bahia (BA) branch plant and Sao Paulo (SP) Supplier with an Extended Amount of 57,810.00
4. On PO Additional Information (Brazil) (P43120BR):
   1. Transaction Nature = 212
   2. Tax Code 12 (Pay ICMS, Exempt IPI)
   3. Purchase Use Code = CON (Internally Consumed)
5. Receive PO and Create and Close Nota Fiscal
6. Inquire on Nota Fiscal (P7610B)
   1. ICMS Basis is Correctly Calculated as 42,449.88 (57,810.00 minus 26.570%)
   2. Nota Fiscal (P7610B) shows the Amount of ICMS Tax to be paid as 2,546.99 (6% of 42,449.88)
   3. Amount of ICMS Tax to be paid should be 4,669.49 (11% of 42,449.88)

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.