GL/Class Code Cross-Reference (76/GL)
Set up UDC table 76/GL for Brazilian tax accounting. Brazilian localization uses AAIs 4220 and 4240 in the JD Edwards EnterpriseOne Sales Order Management system, and AAIs 4385 and 4390 in the JD Edwards EnterpriseOne Procurement system to account for Brazilian taxes, freights, expenses, insurance, and discounts. The system uses these four key fields to associate these AAIs with an account:
Company
AAI
Document type
GL class code
When you set up the G/L Code Cross-Reference UDC, complete the fields in the following way:
Complete the Codes field by using the first three characters of the tax name followed by four characters that represent the general ledger class of the item or service at the branch/plant level.
The first three characters of the codes must be completed as illustrated in this table:
Tax, Cost, or Discount
Code
ICMS Differential
DIF
Expenses
EXP
Freight
FRT
ICMS
ICM
ICMS Recoverable
ICR
IPI
IPI
IPI Recoverable
IPR
ICMS Repasse Discount
REP
ICMS Substitution Recoverable
SBR
Insurance
SEG
ICMS Substitution Tax
SUB
Trade Discount
TDC
PIS Tax
PIS
COFINS Tax
COF
PIS Substitution
SUP
COFINS Substitution
SUC
Create codes for default AAIs that point to a specific default account.
The system first searches for a code with a specific general ledger class in the last four fields (for example, EXPIN30, where IN30 is the item general ledger class). If a specific code that includes the item's general ledger class does not exist, then the system locates the default code (for example, EXP****).
Complete the Description 01 field with the general ledger offset account for the JD Edwards EnterpriseOne Distribution system AAI to which the system posts the transaction.
See Understanding the 76/GL UDC Table for PIS/PASEP and COFINS Tax Credits.