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.