(BRA) Setting Up the System for Brazilian Taxes

This chapter provides an overview of the system set up for processing Brazil taxes, and discusses how to:

Click to jump to parent topicUnderstanding Setup for Brazilian Taxes Processing

Before the JD Edwards EnterpriseOne systems can calculate Brazilian taxes, you must set up the tax tables, UDCs, AAIs, and other information that the system needs to perform the calculations. In Brazil, sales and use taxes are calculated on both inbound (procurement) and outbound (sales) transactions.

You can set up the system to perform calculations for these taxes:

Click to jump to top of pageClick to jump to parent topicCommon Fields Used in This Chapter

ICMS Code

Enter a code that indicates how ICMS tax is applied. You set up the codes that you need in the ICMS Code - Fiscal Value UDC (76/II). The system uses the code when it calculates ICMS tax, and when printing fiscal books.

ICMS Substitution

Enter a code that specifies whether a client or product is subject to tax substitution. Values are:

Y: Use list price.

Z: Use net price.

N: No.

IPI Code

Enter a code that indicates how IPI tax is assessed. This code determines in which column of the Inbound/Outbound Fiscal Book the system prints the IPI tax amount. You must enter a code that already exists in IPI Code Fiscal Value UDC table (76/IP). Values are:

1: Taxable

2: Exempt

3: Other

Item Number

Enter a number that the system assigns to an item. It can be in short, long, or third item number format. This field is optional for ICMS tax. Complete this field only to set up ICMS tax rates for specific items.

Click to jump to parent topicSetting Up UDCs

You must set up country-specific UDCs to process taxes for Brazil.

See Setting Up UDCs for Tax Processing for Brazil.

Click to jump to parent topicSetting Up AAIs

In addition to the standard AAIs that you set up for the system, you must set up distribution automatic accounting instructions (AAIs) to account for Brazilian taxes. For example, you must set up AAI 4385 for debits and AAI 4390 for credits for Programa de Integração Social/Programa de Formação do Patrimônio do Servidor Público (PIS/PASEP) and Contribuição para Financiamento da Seguridade Social (COFINS) taxes.

See Setting Up AAIs for Tax Processing for Brazil.

Click to jump to parent topicSetting Up Transaction Nature Codes

This section provides an overview of transaction nature codes and discusses how to set up transaction nature codes.

Click to jump to top of pageClick to jump to parent topicUnderstanding Transaction Nature Codes

The transaction nature code is a three-character code that has a two-character suffix. You set up transaction nature codes to identify whether a transaction is inbound, outbound, in-state, cross-border, and so on. The Brazilian government specifies the codes that apply for each type of transaction.

After you set up transaction nature codes, you can associate online text, print text, or both.

Note. If you need to delete a transaction nature code, you must first delete the online or the print text, or both.

Click to jump to top of pageClick to jump to parent topicPrerequisite

Verify that the UDC tables for IPI Code - Fiscal Value (76/IP), ICMS Code - Fiscal Value (76/II), and ICMS Tax Substitution Markup (76/SM) are set up.

Click to jump to top of pageClick to jump to parent topicForms Used to Set Up Transaction Nature Codes

Form Name

FormID

Navigation

Usage

Transaction Nature

W7615BE

Brazilian Localization Setup (G76B41B), Transaction Nature.

On Work With Transaction Nature, click Add.

Add transaction nature codes.

Media Object Viewer

W4310J

On Work With Transaction Nature, click either Online Text or Print Text, then select Online Text or Print Text from the Row menu.

Associate online or print text to a transaction nature code.

Click to jump to top of pageClick to jump to parent topicAdding Transaction Nature Codes

Access the Transaction Nature form.

Transaction Nature

Enter a three-character code that for tax purposes, identifies a type of transaction. To enter values for the Transaction Nature code, use this convention: X.YY X defines the origin of the transaction (inbound or outbound). Values for X are:

1: Inbound, inside the state.

2: Inbound, other states.

3: Inbound, import.

5: Outbound, inside state.

6: Outbound, other states.

7: Outbound, export.

YY defines the transaction as a whole, such as a sales transaction.

Examples of Transaction Nature codes:

511: In-state sale.

611: Out-of-state sale.

Transaction Suffix

Enter a value to complete this two-character field in conjunction with the Transaction Nature code to identify the complementary implications of a type of transaction. For example, the suffix might indicate that a certain type of transaction represents a inventory change, or that a transaction is eligible for a certain type of tax.

Values might include:

01: Bonus

02: Demo

03: Sample

04: Return merchandise

05: Back order

06: Donation

Examples of Transaction Nature codes with suffixes:

511 01: In-state sale, bonus.

511 05: In-state sale, back order.

DIPI Classification

Enter the DIPI Classification code, which is a four-character, alphanumeric field that you can use for tax reporting. Use this code to link the product with the Transaction Nature.

ICMS Code

Enter a code that indicates how ICMS tax is applied. You set up the codes that you need in the ICMS Code - Fiscal Value UDC (76/II). The system uses the code when it calculates ICMS tax, and when printing fiscal books.

ICMS Substitution

Enter a code that specifies whether a client or product is subject to tax substitution. Values are:

Y: Use list price.

Z: Use net price.

N: No.

IPI Code

Enter a code that indicates how IPI tax is assessed. This code determines in which column of the Inbound/Outbound Fiscal Book the system prints the IPI tax amount. You must enter a code that already exists in the IPI Code Fiscal Value (76/IP) UDC table. Values are:

1: Taxable

2: Exempt or not taxable

3: Other

Special ICMS TAX FLAG

Enter an amount that specifies the tax for ICMS (Imposto sobre Circulaçao de Marcadorias e Servicos). The Brazilian sales and services tax (ICMS) is a state tax that is levied on the sale and import of goods, as well as on the rendering of services of transport, freight, energy and communications. Since the ICMS is a state tax, rates vary according to the place where the sale or import takes place or the services are rendered.

Click to jump to parent topicSetting Up Tax Codes for ICMS and IPI

This section provides and overview of tax codes and discusses how to set up tax codes.

Click to jump to top of pageClick to jump to parent topicUnderstanding Tax Codes

You set up tax codes to define the taxes that apply to an item. The tax codes that you set up determine the ICMS and IPI taxes that apply to the item. When you enter a purchase or sales order for the item, the system uses the tax code from the F76412 table. If the tax code does not exist in table F76412, the system uses the tax code from the F76411 table.

Click to jump to top of pageClick to jump to parent topicPrerequisite

Verify that the UDC tables for IPI Code - Fiscal Value (76/IP), ICMS Code - Fiscal Value (76/II), and Tax Code (76/CT) are set up.

Click to jump to top of pageClick to jump to parent topicForms Used to Set Up Tax Codes

Form Name

FormID

Navigation

Usage

Work With Tax Codes

W7617BA

Brazilian Localization Setup (G76B41B), Tax Code Revision.

Review and select tax codes.

Tax Code Revisions

W7617BB

On Work With Tax Codes, click Add.

Add and revise tax codes.

Click to jump to top of pageClick to jump to parent topicSetting Up Tax Codes

Access the Tax Code Revisions form.

Tax Code

Enter an auxiliary code that you use to combine ICMS and IPI tax characteristics. The code that you specify must exist in the Tax Code UDC table (76/CT). Values might include:

01: Taxed domestic goods (IPI and ICMS)

02: Taxed domestic goods (ICMS taxed, IPI tax rate Zero)

03: Exempt products

04: Export

05: ICMS deferred, IPI suspended

06: ICMS exempt, IPI taxed

ICMS Code

Enter a code that indicates how ICMS tax is applied. You set up the codes that you need in the ICMS Code - Fiscal Value UDC (76/II). The system uses the code when it calculates ICMS tax, and when printing fiscal books.

IPI Code

Enter a code that indicates how IPI tax is assessed. This code determines in which column of the Inbound/Outbound Fiscal Book the system prints the IPI tax amount. You must enter a code that already exists in the IPI Code Fiscal Value (76/IP) UDC table. Values are:

1: Taxable

2: Exempt or not taxable

3: Other

Click to jump to parent topicSetting Up ICMS (Imposto sobre Circulaço de Mercadorias e Serviços) Tax Calculations and IPI (Imposto sobre Produto Industrializado) Tax

This section provides overviews of ICMS taxes and calculations, IPI taxes and calculations and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding ICMS Taxes

ICMS (Imposto sobre Circulaço de Mercadorias e Serviços) is a state tax that the government levies on purchasing and sales transactions in Brazil. The tax rate varies from state to state, and some products can be taxed at different rates. The price of the product always includes ICMS tax, but the amount of this tax also appears on the nota fiscal.

When you set up ICMS tax rates, you must complete these fields before the system can calculate the ICMS differential:

The system applies tax rates by exception. Set up all of the general tax rates first. Then, if the transaction has special or unique settings, use ICMS Tax Revisions to set up the ICMS tax on a case-by-case basis. Enter the data of the transaction as a record, and then enter the exceptions.

Click to jump to top of pageClick to jump to parent topicUnderstanding ICMS Substitution(Imposto sobre Circulaço de Mercadorias e Serviços Substituto)

In Brazil, ICMS Substitution is ICMS tax charged on interstate transactions, or on special products and clients. Although this tax appears to be the same as ICMS, it is applied differently.

The rates are the same rates that are used by the ICMS calculation. A markup is applied to the price of the supplier to forecast the price that will be charged in the next transaction.

You enter ICMS substitution rates on the same forms as you enter ICMS tax rates.

Click to jump to top of pageClick to jump to parent topicUnderstanding IPI Taxes

To calculate the IPI tax that you pay to the customers and suppliers, you must set up tax rates and tax reductions. You can set up IPI tax rates by fiscal classification. You can also set up a default IPI tax rate that applies to all customers and suppliers.

Click to jump to top of pageClick to jump to parent topicPrerequisites

Before you complete the tasks in this section:

Click to jump to top of pageClick to jump to parent topicForms Used to Set Up ICMS and IPI Tax Rates

Form Name

FormID

Navigation

Usage

ICMS Tax Revision

W7608BD

Brazilian Localization Setup (G76B41B), ICMS Tax Revision.

On Work With ICMS Tax Rates, click Add.

Set up ICMS tax rates

IPI Tax Revision

W76B18D

Brazilian Localization Setup (G76B41B), IPI Tax Revision.

On Work With IPI Tax Rates, click Add.

Set up IPI tax rates

Address Book Additional Information - Brazil

W01012BRA

Address Book - Brazil (G76B01), Address Book Revisions.

On Work With Addresses, select a record and then select Regional Info from the Row menu.

Click the Fiscal Information.

Associate ICMS codes and IPI codes with customers, suppliers, and branch/plants.

Item Master Regional Information - Brazil

W4101BRA

Inventory Master - Brazil (G76B4111), Item Master - Brazil.

On Work With Item Master Regional Information - Brazil, select an item and click Select.

Add ICMS and IPI tax information to items.

Item Branch Regional Information - Brazil

W76412BA

Inventory Master - Brazil (G76B4111), Item Branch/Plant - Brazil.

On Work With Item Branch Regional Information - Brazil, select an item and click Select.

If the values are different at the Item Branch, Item Branch/Location, or Item Branch/Location/Lot level, use this form to enter ICMS and IPI information instead of the Item Master Regional Information - Brazil form.

Click to jump to top of pageClick to jump to parent topicSetting Up ICMS Tax Rates

Access the ICMS Tax Revision form.

From State

Enter a user-defined code (00/S) that specifies the state or province. This code is usually a postal service abbreviation.

To State

Enter the U.S. Postal state code that you define in the State and Provinces UDC (00/S). You can define special state codes for foreign countries and Canadian provinces, if appropriate.

Mark-up Level

Enter a code that is used in conjunction with an Address Book Category code to create different ICMS Substitution markup tables depending on the customer markup level. This field cannot be left blank. To make this field a blank space, type an asterisk (*).

Item Number

Enter a number that the system assigns to an item. It can be in short, long, or third item number format.

This field is optional for ICMS tax. Complete this field only to set up ICMS tax rates for specific items.

ICMS State Tax and ICMS Interstate Tax

Enter a number that identifies the percentage of tax that should be assessed or paid to the corresponding tax authority, based on the tax area.

Enter the percentage as a whole number and not as the decimal equivalent. For example, to specify 7 percent, enter 7, not .07.

ICMS Reduction

Enter a factor that the system uses to reduce the amount of the taxable base of a product.

Substitution Mark-up

Enter a percentage of markup applied to the ICMS taxable amount.

Substitution Reduction

Enter a factor that reduces the ICMS substitution tax amount.

Click to jump to top of pageClick to jump to parent topicSetting Up IPI Tax Rates

Access the IPI Tax Revisions form.

Fiscal Classification

Enter a code that specifies groups of products, as defined by the local tax authorities. The product groups are based on taxing conventions and other national statistics. The system uses this code to determine the applicable tax rate for a product.

Print Message

Enter a user-defined code (40/PM) that you assign to each fiscal print message that appears on the nota fiscal.

Item Number

Enter a number that the system assigns to an item. It can be in short, long, or third item number format.

IPI Tax and IPI Reduction

Enter a number that identifies the percentage of tax that should be assessed or paid to the corresponding tax authority, based on the tax area.

Enter the percentage as a whole number and not as the decimal equivalent. For example, to specify 7 percent, enter 7, not .07.

For IPI tax, complete this field to identify a tax rate for a tax authority that has jurisdiction in a geographic area.

ICMS Code

Enter a code that indicates how ICMS tax is applied. You set up the codes that you need in the ICMS Code - Fiscal Value UDC (76/II). The system uses the code when it calculates ICMS tax, and when printing fiscal books.

Complete this field to associate tax information with the fiscal classification.

IPI Code

Enter a code that indicates how IPI tax is assessed. This code determines in which column of the Inbound/Outbound Fiscal Book the system prints the IPI tax amount. You must enter a code that already exists in the IPI Code Fiscal Value (76/IP) UDC table. Values are:

1: Taxable

2: Exempt or not taxable

3: Other

Complete this field to associate tax information with the fiscal classification.

Click to jump to top of pageClick to jump to parent topicAssociating ICMS and IPI Codes with Address Book Records

Complete the ICMS Code field on the Fiscal Information tab with the appropriate ICMS tax code, and complete the IPI Code field with the appropriate IPI tax code.

See (BRA) Entering Tax Information for Address Book Records.

Click to jump to top of pageClick to jump to parent topicSetting Up ICMS and IPI Information in the Item Master Table

Complete these fields with the appropriate values for the item master:

See Understanding Item Master Information.

Click to jump to parent topicSetting Up GL Class Codes for PIS/PASEP and COFINS Tax Credits

This section discusses how to set up GL class codes for tax credits.

You must set up GL Class codes for PIS/PASEP and COFINS tax credits for the suppliers. Additionally, because you are the supplier when you sell goods or services, you must set up a supplier master for the fiscal companies and GL Class codes for the fiscal companies. Before the system can calculate PIS/PASEP and COFINS tax credits for purchase and sales transactions, the supplier master records for the suppliers and for the fiscal companies must contain a GL Class code for PIS/PASEP and for COFINS tax credits. You assign a GL Class code on the GL Distribution tab of the Supplier Master Revisions form.

See Entering Supplier Master Information.

The source of the GL Class code that the system uses when calculating PIS/PASEP and COFINS tax credits depends on the type of transaction that the system processes. Inbound transactions include transactions that have Transaction Nature codes that are less than 500. Inbound transactions include those in which you generate notas fiscais from purchase orders, ship-to sales returns, and ship-from sales returns. Outbound transactions include transactions that have Transaction Nature codes that are greater than 500. Outbound transactions include those in which you generate notas fiscais from sales orders and purchase returns.

This table displays the source of the GL Class code that the system uses when debiting or crediting accounts for inbound and outbound transactions:

Account

Distribution AAI

Source of GL Class Code

Inbound debit account

4385

The GL Class code that exists in the F0401 table for the supplier.

Inbound credit account

4390

The GL Class code that exists in the F76B0401 table for the PIS/PASEP or COFINS tax.

Outbound debit account

4220

The GL Class code that exists in the F76B0401 table for the PIS/PASEP or COFINS tax.

Outbound credit account

4240

The GL Class code that exists in the F0401 table for the fiscal company.

Click to jump to parent topicSetting Up Tax Codes for PIS/PASEP (Programa de Integração Social/Programa de Formação do Patrimônio do Servidor Público) and COFINS (Contribuição para Financiamento da Seguridade Social) Tax Credits

This section provides an overview of tax codes for PIS/PASEP and COFINS tax credits and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding Tax Codes for PIS/PASEP and COFINS Tax Credits

The Review AP Tax Code program (P76B0401) lets you set up tax codes that the system uses to calculate tax credits on notas fiscais. After you set up tax codes in the Review AP Tax Code program, you associate the tax codes with the suppliers on the Tax Information tab of the Address Book Additional Info - Brazil program (P01012BR). You use the Purchase Use Tax Setup - Brazil program (P76B003) to associate purchase use codes to the tax codes. The system uses the associations between the tax codes, purchase use codes, and suppliers to determine how to apply PIS/PASEP and COFINS tax credits.

Note. You must enter a C in the Retention/Aggregation/Credit field (data item BRRTA) for tax codes that you set up for PIS/PASEP and COFINS tax credits. Tax codes that have an R or an A in the Retention/Aggregation/Credit field are not valid tax codes for PIS/PASEP or COFINS credits.

Click to jump to top of pageClick to jump to parent topicUnderstanding the Association of Purchase Use Codes with Tax Codes

You use the Purchase Use Tax Setup - Brazil program (P76B003) to set up associations between purchase use codes and tax codes for PIS/PASEP (Programa de Integração Social/Programa de Formação do Patrimônio do Servidor Público) and COFINS (Contribuição para Financiamento da Seguridade Social) tax credits. When you run the Nota Fiscal Check & Close program (P76B900) or the Generate Nota Fiscal - Brazil program (R76558B), the system accesses the associations between the purchase use codes and tax codes to determine whether to calculate the taxes. If an association exists in the F76B003 table between a tax code and the purchase use code on a line item, the system calculates the tax as specified by the tax code. When you set up the associations, select the appropriate Apply option to instruct the system to calculate the tax.

Click to jump to top of pageClick to jump to parent topicPrerequisite

Verify that the tax codes for withholding taxes are set up in the Tax Code AP user-defined code UDC (76B/TR).

Click to jump to top of pageClick to jump to parent topicForms Used to Set Up Tax Codes for PIS/PASEP and COFINS Tax Credits

Form Name

FormID

Navigation

Usage

Tax Information Revisions

W76B0401A

AP Tax Processing - Brazil (G76B0414), Review AP Tax Code.

On Work with Tax Information, click Add.

Set Up Tax Codes for PIS/PASEP and COFINS Tax Credits.

Purchase Use Tax Setup Revisions

W76B003B

Brazil Localization Setup (G76B41B), Purchase Use Tax Setup.

On Work With Purchase Use Tax Setup, click Add.

Associate purchase use codes with tax codes for PIS/PASEP and COFINS credits.

Click to jump to top of pageClick to jump to parent topicSetting Up Tax Codes for PIS/PASEP and COFINS Tax Credits

Access the Tax Information Revisions form.

Brazil Tax Information

Enter a user-defined code that discusses the tax. The code can be up to eight characters long.

Tax Type

Enter the type of Brazilian tax. You enter a code that exists in the Tax Code AP UDC table (76B/TR). You must enter 05 for PIS/PASEP or 06 for COFINS. The system activates the tax tab based on the value that you enter.

Tax Rate

Enter the retention or aggregation tax rate applied to the service transaction.

GL Offset (general ledger offset)

Enter a code that determines the trade account that the system uses as the offset when you post invoices or vouchers. The system concatenates the value that you enter to the AAI item RC (for JD Edwards EnterpriseOne Accounts Receivable) or PC (for JD Edwards EnterpriseOne Accounts Payable) to locate the trade account. For example, if you enter TRAD, the system searches for the AAI item RCTRAD (for receivables) or PCTRAD (for payables).

You can assign up to four alphanumeric characters to represent the GL offset or you can assign the three-character currency code (if you enter transactions in a multicurrency environment). You must, however, set up the corresponding AAI item for the system to use; otherwise, the system ignores the GL offset and uses the account that is set up for PC or RC for the company specified.

If you set up a default value in the GL Offset field of the customer or supplier record, the system uses the value during transaction entry unless you override it.

Note. Do not use code 9999. It is reserved for the post program and indicates that offsets should not be created.

Retention/Aggregation/ Credit

Enter a value that Specifies whether retention or aggregation applies. You must enter a C in the Retention/Aggregation/Credit field (data item BRRTA) for tax codes that you set up for PIS/PASEP or COFINS credits. Tax codes that have an R or an A in the Retention/Aggregation/Credit field are not valid tax codes for PIS/PASEP or COFINS credits.

Alternate Payee Address Number

Enter an alternate address to which JD Edwards EnterpriseOne Accounts Payable can send payments due.

IR Code

Enter a code that identifies the type of IR tax. You must set up valid codes in the Recieta Code UDC (76B/IR) table.

Payment Terms

Enter a code that specifies the terms of payment, including the percentage of discount available if the invoice is paid by the discount due date. Use a blank code to indicate the most frequently-used payment term. You define each type of payment term on the Payment Terms Revisions form. Examples of payment terms include:

Blank: Net 15

001: 1/10 net 30

002: 2/10 net 30

003: Due on the 10th day of every month

006: Due upon receipt. This code prints on customer invoices.

Click to jump to top of pageClick to jump to parent topicAssociating Purchase Use Code with Tax Codes

Access the Purchase Use Tax Setup Revisions.

Purchase Use Code

Enter the purchase use code to which you want to associate tax codes.

PIS

Complete this field in the Taxes Information section.

Enter a tax code that contains 05 in the Tax Type field (data item BRTXTP) and a C in the Retention/Aggregation/Credit field (data item BRRTA) in the F76B0401 table. Only tax codes that contain 05 in the Tax Type field and C in the Retention/Aggregation/Credit field are valid for PIS/PASEP tax credits. If the tax code that you enter does not contain 05 and C, the system displays an error message.

Apply PIS

Complete this field in the Taxes Information section.

Enables the Apply PIS field only when you complete the corresponding PIS field. You must select this option before the system calculates PIS/PASEP credits based on the code that you entered in the PIS field.

COFINS

Complete this field in the Taxes Information section.

Enter a tax code that contains 06 in the Tax Type field (data item BRTXTP) and a C in the Retention/Aggregation/Credit field (data item BRRTA) in the F76B0401 table. Only tax codes that contain 06 in the Tax Type field and C in the Retention/Aggregation/Credit field are valid for COFINS tax credits. If the tax code that you enter does not contain 06 and C, the system displays an error message.

Apply COFINS

Complete this field in the Taxes Information section.

Enables the Apply COFINS field only when you complete the corresponding COFINS field. You must select this option before the system will calculate COFINS credits that are based on the code which you enter in the COFINS field.

Click to jump to parent topicSetting Up Tax Line Types for PIS/PASEP and COFINS Tax Credits

This section discusses how to set up tax line types for tax credits.

Before the system can process Programa de Integração Social/Programa de Formação do Patrimônio do Servidor Público (PIS/PASEP) and Contribuição para Financiamento da Seguridade Social (COFINS) tax credits, you must set up line types for the taxes in the Line Type Constants program (P40205). When you set up line types for PIS/PASEP and COFINS, set the options on Line Type Constants Revisions form as:

Option

Setting

GL Interface

Off

AR Interface

Off

AP Interface

Off

CSMS Interface

Off

Inv. Interface

N

GL Offset

Select the appropriate GL Posting Code from the GL Posting Category UDC (41/9).