42 Setting Up Your System for Electronic Tax Reporting for Brazil (2010)

This chapter contains the following topics:

42.1 Understanding UDCs for Electronic Tax Reporting in Brazil

Before you work with electronic tax reporting using the Ato COTEPE 09 of 2008 (Ato Comissão Técnica Permanente) for Brazil, you must set up these UDC tables:

42.1.1 Type Code (01/W0)

The system uses the values in this UDC for all address book records that you process.

42.1.2 Item Category Codes (70/C1 – 70/C5)

Set up item category codes 70/C1 – 70/C5 to add information the items that you must report in register 0200 of block 0 according to Ato Cotepe 09 of 2008.

Set up the category codes as shown in this table:

Category Code Used For
70/C1 Item type
70/C2 Mercosur code
70/C3 EX code
70/C4 Item generic code
70/C5 Service code

Consider changing the name of the category codes to a name that is meaningful and relates to the usage of the category code. For example, consider changing the name of 70/C1 from Item Category Code 70 C1 to Item Type. Then, add the values for item types in the Codes field of the category code.

You set processing options in the Item Master Additional Info program (P704101) to identify the category codes for which the system enables you to select values to associate to items. The system writes the values that you associate to the items to register 0200 of block 0 when you run the SPED Fiscal- Block 0 Items & Assets program (R76B0891).

42.1.3 Activity Code (76B/AC)

Set up the Activity Code UDC table with values that the system uses to complete the IND_ATIV field for block 0, register 0000 for tax reporting according to the requirements of Ato COTEPE 09 of 2008. You select a value from this UDC table when you complete the processing options for the SPED Fiscal Constant Setup program (P76B0715).

Examples include:

Code Description
0 Industry
1 Others

42.1.4 Process Block Status (76B/BS)

The system provides hard-coded values to indicate the status of the blocks that you process. Verify that these values exist in your system:

Codes Description
(blank) Not selected
D Done
E Error
P Processing
W Waiting

42.1.5 NFe IBGE Country Code (76B/CD)

Set up values in this UDC table for the country codes that you use when submitting NFe XML files for processing. The system uses the values that you set up in the Legal Company Information section of the XML file. Set up the 2-digit country code in the Codes field, the country name in the Description 01 field, and the 4-digit country code in the Description 02 field.

The system also uses this value in field 4 (COD_PAIS) of register 0150 in block 0 when you report taxes according to the requirements of Ato COTEPE 09 of 2008.

For example, you might set up this value:

Code Description 01 Description 02
02 Brazil 0002

42.1.6 ATO COTEPE 09 COD SIT Xref (76B/CI)

Set up the ATO COTEPE 09 COD SIT Xref UDC table to create a cross-reference between the XML document statuses that the system assigns to processed electronic notas fiscais (NFe) and the numerical codes that the government requires for the Ato COTEPE 09 of 2008 file.

The NFe process uses alphabetical codes, but the Ato COTEPE 09 of 2008 file must include a numerical code to show the status. Therefore, you set up this UDC table with the numerical value in the Special Handling Code field for each of the alphabetical status codes that are used in the NFe process. The system writes the value from the Special Handling Code field to the Ato COTEPE 09 of 2008 file for the associated alphabetical codes that the system stored in the NFe Header table (F76B01TE) when you uploaded the returned NFe.

Examples of codes include:

Codes Description Special Handling Code
A Accepted 00
R Rejected 04
C Canceled 02

42.1.7 ATO COTEPE 09 COD MOD Xref (76B/CM)

Set up values in the ATO COTEPE 09 COD MOD Xref UDC table to create a cross-reference between the codes that the system uses in the NFe process with the codes that the government requires in the Ato COTEPE 09 of 2008 file.

When you generate electronic notas fiscais, the system uses alphabetic codes for electronic notas fiscais for national or Saõ Paulo transactions, and for notas fiscais for the telephone industry. The system stores these values in the NFe Header table (F76B01TE).

The Ato COTEPE 09 of 2008 file must include a numeric values for these types of notas fiscais, so you must set up this UDC to cross-reference the alphabetic code to the required numeric codes. Enter the alphabetic code in the Codes field, and enter the numeric code in the Special Handling Code field. The system writes the value in the Special Handling Code field to the Ato COTEPE 09 of 2008 registers for the associated values that were stored for the notas fiscais in the F76B01TE table.

Examples of codes include:

Codes Description Special Handling Code
BRNFI-NA Electronic nota fiscal (national) 55
BRNFI-TE Electronic nota fiscal telephone industry 22

42.1.8 Code of Purpose (76B/CO)

Set up the purpose codes that are supplied by the government to specify the purpose of your tax reporting submittal. For example, you might set up these codes:

Codes Description
00 Regular remittance of file
01 File substitute's remittance
02 File remittance with additional data to a file previously sent
03 File remittance requested by specific citation

42.1.9 Canceled Status (76B/CT)

The system uses the values in this UDC table to search for canceled notas fiscais, and uses these values when you generate block C registers. These values are hard-coded:

Codes Description
996 Canceled status 996
997 Canceled status 997

42.1.10 Fiscal Codes - IPI (76B/CW)

You assign a value from the 76B/CW UDC table when you work with notas fiscais for goods. You add values for the special handling code to the values that you set up for notas fiscais. You obtain the values for the Special Handling Code field from the government. The system uses the values in this UDC table to determine the value to write to register C170, field 20 (CST_IPI) and register E510, field 3 (CST_IPI) of the XML file that you generate for SPED Fiscal reporting. When you generate the XML file, the system writes a value from the Special Handling Code field that is associated with the code that you assigned to the transaction.

The system writes the first two characters of the value in the Special Handling Code field to the XML file for purchase transactions, and writes characters 4 and 5 to the XML file for sales transactions. Note that character 3 (blank) is not used in the XML file.

You must set up these codes and special handing codes:

Codes Description 01 Description 02 Special Handling Code
1 Taxable With tax 00 50
2 Not taxable Without tax 03 53
3 Others Without tax 49 99
4 Reduced IPI (Taxable/Exempts) With and without tax 02 52
5 Reduced IPI (Taxable/Others) With and without tax 04 54

42.1.11 Fiscal Code (76B/FC)

The system uses the values in this UDC table when you associate fiscal city codes with address book records. You associate the city codes with address book records by using the Supplemental Data program (P00092). Add the city codes for every city for every address book record for which you report data.

42.1.12 Freight Indicator (76B/FO) (Release 9.1 Update)

The last version of the document "Guia Practico da EFD" (version 2.0.5), published by fiscal authority CONFAZ, specifies a change in the values of the Freight Indicator field (IND_FRT) that is considered in block C. This change is effective as of January 1, 2012.

To comply with this requirement, you must update the Description 2 of UDC 76B/FO, which is the actual value retrieved from the Nota Fiscal Freight Handling Code and used to complete the SPED text file.

Beginning in January 2012, the values (including number and text) must be updated to:

  • 0- Contratacao do Frete por conta do Remetente (CIF)

  • 1- Contratacao do Frete por conta do Destinatario (FOB)

  • 2- Contratacao do Frete por conta de Terceiros

  • 3- Transporte Proprio por conta do Remetente

  • 4- Transporte Proprio por conta do Destinatario

  • 9- Sem Occorencia de Transporte

42.1.13 Fiscal Presentation Type (76B/FP)

The JD Edwards EnterpriseOne software provides hard-coded values for this UDC table. You select a value from this UDC table when you complete the fields in the SPED Fiscal Constant Setup program (P76B0715). The system writes the value from the UDC table to the IND_PERFIL field in register 0000 in block 0.

The system also uses the values in this UDC table to determine the records to include according to the rules that you set up in the SPED Fiscal Rules Control program (P76B0780).

Values are:

Codes Description
A Fiscal profile A
B Fiscal profile B
C Fiscal profile C
D Fiscal profile D

42.1.14 Input Nota Fiscal Source (76B/IF)

The system uses the values in this UDC table to identify the type of inbound nota fiscal when you generate block C registers. These values are hard-coded:

Codes Description
1 Stand-alone nota fiscal
2 Complementary nota fiscal
3 2–way match nota fiscal
4 3–way match nota fiscal

42.1.15 Output Nota Fiscal Source (76B/OF)

The system uses the values in this UDC table to identify the type of outbound nota fiscal when you generate block C registers. These values are hard-coded:

Codes Description
5 Stand-alone nota fiscal - SO
6 Complementary nota fiscal - SO
7 Nota fiscal - SO

42.1.16 Cotepe Rule Values (76B/RT)

The system provides hard-coded values for UDC table 76B/RT. You select a value from this UDC table when you set up rules to define the records that are required or not required for tax reporting. Values are:

Codes Description
(blank) Blank
C Conditional
N Must not be informed (not reported)
O Obligatory
OC Include in report if information exists in the system

42.1.17 Transaction Nature Items (76B/TT)

The system uses the values in this UDC table to identify which transaction nature codes you use for inbound and outbound transactions. Set up values for each transaction nature code that you use. Also, you must set up the transaction nature codes in the Setup Transaction Nature Cross Reference - CFOP Cross Reference program (P76B2001). This table lists examples of codes you might use:

Codes Description
111 Inbound transaction 111
112 Inbound transaction 112
511 Outbound transaction 511
512 Outbound transaction 512

42.1.18 Version of Ato Cotepe (76B/VC)

The JD Edwards EnterpriseOne software provides a hard-coded valued that you use to specify the version of Ato COTEPE that you use for reporting. The value for reporting according to Ato COTEPE 09 of 2008 is 09.

42.1.19 Code of Layout Version (76B/VO)

Set up this UDC table with the codes that indicate the version of the layout that you use. For example, you might set up these codes:

Codes Description
001 1.00

01/01/08 - Cotepe

002 1.01

01/01/09 - SPED Fiscal

003 1.02

01/01/2010 - SPED Fiscal


42.2 Setting Up Constants for Electronic Tax Reporting in Brazil

This section provides an overview of constants for electronic tax reporting for SPED Fiscal, lists prerequisites, and discusses how to set up constants.

42.2.1 Understanding Constants for Electronic Tax Reporting for SPED Fiscal

You use the SPED Fiscal Constant Setup program (P76B0715) to set up by legal company (reporting company) information about the layout, purpose, and bookkeeping for data for which you report information. The system stores the constants information in the Ato Cotepe 09 Constant Setup table (F76B0715), and reads the information when you run the extraction or join block processes for electronic tax reporting.

42.2.2 Prerequisites

Before you begin the tasks in this section, verify that these UDCs are set up:

  • Type Code (01/W0)

  • Activity Code (76B/AC)

  • Fiscal Presentation Type (76B/FP)

  • Code of Layout Version (76B/VO)

42.2.3 Forms Used to Set Up Constants for SPED Fiscal

Form Name Form ID Navigation Usage
Work With Ato Cotepe Constant Setup W76B0715A SPED Fiscal Setup (G76B1116), SPED Fiscal Constant Setup Select and verify existing constants setup.
Ato Cotepe Constant Setup Revision W76B0715B Click Add on the Work With Ato Cotepe form. Set up constants for SPED Fiscal.

42.2.4 Setting Up Constants for SPED Fiscal

Access the Ato Cotepe Constant Setup Revision form.

42.2.4.1 Block 0

Accountant Address Number

Enter the address book number of the accountant.

Substitute Contributor Address

Enter the address book number of the substitute contributor. A substitute contributor is someone who pays the taxes in the name of the company.

The system writes the address book number to register 0015 of block 0.

Version Layout Code

Enter a value that exists in the Code of Layout Version UDC table (76B/VO) to specify the tax reporting version to be used.

Fiscal Presentation Type

Enter a value that exists in the Fiscal Presentation Type UDC table (76B/FP). The system writes the value from the UDC table to the IND_PERFIL field in register 0000 in block 0.

Activity Code

Enter a value that exists in the Activity Code UDC table (76B/AC). The system writes the value from the UDC table to the IND_ATIV field in register 0000 in block 0.

Type Code

Enter a value that exists in the Type Code UDC table (01/W0) to specify the type of address book record that the system uses to retrieve information about the reporting entity.


Note:

For inscription type 30, you must set up the address book inscription number. To complete this setup, navigate to the Address Book Revision program (P01012), select the account address number, select Regional Info on Row menu and then Address Book Inscription on the Form menu.

42.2.4.2 Block H

Indicator Inventory Owner

Enter the category code number that exists in the Item Master table (F4101) that specifies who owns the inventory.

42.3 Setting Up the Fiscal City Code for Electronic Tax Reporting in Brazil

This section provides an overview of the fiscal city code and discusses how to associate the fiscal city code to an address book record.

42.3.1 Understanding Fiscal City Codes

Registers 0000, 0100, and 0150 in block 0 require a fiscal city code. You use the Supplemental Data program (P00092) to associate a fiscal city code that exists in the Fiscal Code (76B/FC) UDC table to the address book records for which you report information. Those address book records might include the reporting company, customers, suppliers, and the bookkeeping company.


Note:

The task in this section assumes that a value of AB (address book) exists in the Supplemental Data Setup program (P00091). If this value does not exist, refer to the documentation for the Supplemental Data Setup program for your release for information about adding the value.


Note:

If you have already set up fiscal city codes for a previous ESU, you do not need to set up the codes again.

42.3.2 Forms Used to Associate Fiscal City Codes to Address Book Records

Form Name Form ID Navigation Usage
Work With Supplemental Data W00092D Database Setup CIF Supplemental Data (G01312), Supplemental Data Specify the address book record to which you want to associate a fiscal city code.

42.3.3 Associating the Fiscal City Code to an Address Book Record

Access the Work With Supplemental Data form.

To associate a fiscal city code to an address book record:

  1. Enter the address book number in the Address Number field.

  2. Click Find.

    The system displays the data types that exist for address book records.

  3. Select the record with the data type of $J and click Select.

    The $J data type exists for the fiscal city code.


    Note:

    If data type $J does not exist in your environment, use the Supplemental Data Setup program to add it.

  4. On the General Description Entry form, complete the City Code and Effective Date fields.

42.4 Setting Up Asset Functionality Descriptions for Asset

This section provides an overview of asset functionality information and discusses how to:

  • Set up a supplemental database type.

  • Associate asset functionality descriptions to assets.

42.4.1 Understanding Asset Functionality Information

You must associate a description of the functionality of an asset to the assets that you report in the 0305 register of block 0. The system prints the description of the asset functionality in the XML output file for block 0.

Before you can associate a description of the asset functionality, you must set up a supplemental database type for reportable assets. You use the Supplemental Data program (P00092) to add the data type $A to the Asset Management (AM) supplemental database code. You must use the value $A for the supplemental database type because the SPED Fiscal - Block 0 - Items & Assets program uses this value when processing the output for block 0. The supplemental database code of AM exists in your system if you have the JD Edwards EnterpriseOne Fixed Asset software installed. You set up the $A code once only.

After you set up the database type $A, you associate asset functionality descriptions with the assets that you report in block 0. The system writes the description that you enter to field 3 (Functionality) of register 0305. The output file does not limit the length of the text that you enter for the description. You must associate an asset functionality description to each reportable asset.

42.4.1.1 Summary Steps

To set up the data type and associate a description of the asset functionality to the assets, you:

  1. Use the Supplemental Data Setup program (P00091) to add the data type $A to the Asset Management (AM) supplemental database code.

    You perform this step once only.

  2. Use the Supplemental Data program (P00092) to associate an asset number to the data type and enter text that the system writes to the output file for block 0.

    You perform this step for each reportable asset

42.4.2 Forms Used to Set Up Asset Functionality Information

Form Name Form ID Navigation Usage
Work With Supplemental Database Setup W00091B Use one of these navigations:
CIF Supplemental Data (G01312), Supplemental Data Setup
Fixed Asset System Setup (G1241), Supplemental Data Setup
Review and select existing records.
Work With Data Types W00091G Select a record on the Work With Supplemental Database Setup form and then select Work With Data Type from the Row menu. Review and select existing data type records.
Work With Data Types Revision W00091D Click Add on the Work With Data Types form. Add a new data type for the supplemental database code that you selected on the Work With Data Types form.
Supplemental Database Setup W00092D CIF Supplemental Data (G01312), Supplemental Data Work with supplemental database codes for specific fixed asset records.

Note that the Select the Supplemental Database Code processing option must be set to AM before you can work with codes for asset management.

General Description Entry W00092C Enter an asset ID in the Asset Identification field, and then click Find. Select the data type that you want to work with and then click Select. Associate additional information to the asset. You can enter text in the Remark, Remarks Line 2, and Remarks Line 3 fields to specify the text to appear in register 0305 of Block 0.

42.4.3 Setting Up a Supplemental Database Code

To set up a supplemental database code:

  1. Select CIF Supplemental Data (G01312), Supplemental Data Setup.

  2. On the Work With Supplemental Database Setup form, enter AM in the SDB Code (supplemental database code) field and click Find.

  3. Select the AM record, and then select Work With Data Type from the Row menu.

  4. On the Work with Data Types form, click Add.

  5. On the Data Type Revisions form, complete these fields:

    • Display Mode

      Enter C (code). The fields that appear on the Supplemental Data - General Description Entry forms are determined by the value that you enter in this field. You must enter C to display the fields that you need to associate a code to an asset.

    • Data Type

      Enter $A. You must use the value $A for the data type because the SPED Fiscal - Block 0 - Items & Assets program uses this value when processing the output for block 0.

    • Description

      Enter a description of the data type. For example, you might enter Brazil Asset Functionality.

  6. Click OK

  7. Click Cancel.

  8. On the Work With Data Types form, click Close.

  9. On the Work With Supplemental Database form, click Close.

42.4.4 Associating Asset Functionality Descriptions to Reportable Assets

To associate asset functionality descriptions to reportable assets:

  1. Select CIF Supplemental Data (G01312), Supplemental Data.

  2. On the Work With Supplemental Data form, enter an asset ID number in the Asset Identification field and click Find.

  3. Select the line for data type $A and then click Select.

  4. On the General Description Entry form, enter the description of the functionality in the Remark, Remarks Line 2, and Remarks Line 3 fields.

    The system appends the text that you enter in the Remarks Line 2 and Remarks Line 3 fields to the text that you enter in the Remark field.

  5. Click OK

  6. Repeat Steps 2-5 for all reportable assets.

42.5 Setting Up Rules for SPED Fiscal Registers in Brazil

This section provides an overview of the setup for rules for SPED Fiscal registers and discusses how to:

  • Load the rules for SPED Fiscal registers.

  • Set processing options for SPED Fiscal Rules Control Load Setup (R76B0780).

  • Set processing options for SPED Fiscal Rules Control (P76B0780).

  • Modify or add rules for SPED Fiscal registers.

42.5.1 Understanding How to Set Up Rules for SPED Fiscal Registers

You set up rules for SPED Fiscal registers to specify which records in your system are included or excluded from the output files that you use to report taxes. You use the SPED Fiscal Rules Control program to specify your company profile for each register, and specify the inclusion rules for sales transactions, purchase transactions, and other records. The system uses the rules to determine the records to include for each register. The system saves the records that you create to the Cotepe Rules Table Control table (F76B0780) and reads this table when you generate the records for the flat file.

To set up rules for SPED Fiscal registers:

  1. Run the Rules Control Load Set Up program to populate the F76B0780 table.

    The system populates the F76B0780 with supplied base data. You should set the processing option to run in proof mode.

    See Fields and Values for the SPED Fiscal Rules Table Control Table (F76B0780) for SPED Fiscal (2010)

  2. Use the SPED Fiscal Rules Control program to modify or add records to the F76B0780 table.


    Important:

    You must add rules for the registers that you populate with your custom programming.

  3. Run the Rules Control Load Set Up program in final mode.

    When you run the program in final mode, the system deletes the records that were initially loaded and adds the initial setup.

These parameters apply when you modify or add rules for Ato Cotepe registers:

  • You must set up a rule for each block, record, and profile combination.

  • The input and output rules are jointly applied; if you set up one, you must set up the other.

    For example, if you enter a value in the NF Input field, you must also enter a value in the NF Output field.

  • You cannot enter a value in the Other field if you complete the NF Input and NF Output fields.

  • You cannot enter a value in the NF Input or NF Output fields if you complete the Other field.

42.5.2 Forms Used to Modify or Add Rules for SPED Fiscal Registers

Form Name Form ID Navigation Usage
Work With ATO COTEPE Rules Control W76B0780A SPED Fiscal Setup (G76B1116), SPED Fiscal Rules Control View and select existing records.
ATO COTEPE Rules Control Revision W76B0780B Click Add on the Work With ATO COTEPE Rules Control form. Add or modify rules for SPED Fiscal registers.

42.5.3 Loading the Rules for SPED Fiscal Registers

Select SPED Fiscal Setup (G76B1116), Rules Control Initial Set Up.

42.5.4 Setting Processing Options for SPED Fiscal Rules Control Setup (R76B0780)

Processing options enable you to specify default values for programs and reports.

42.5.4.1 General

Record Rule Mode

Specify whether to run the program in proof or final mode. Values are:

Blank: Proof mode. The system does not update the Cotepe Rules Table Control table (F76B0780), but it generates a report that displays the records.

1: Final mode. The system deletes existing records in the F76B0780 table and inserts new records.

Block Set Up

If you enter 1 in this processing option, the system updates the block setup in the ATO COTEPE Header Block Template (F76B0730) and – ATO COTEPE Detail Block Template (F76B0731) tables for the COTEPE version 09.

Version (Release 9.1 Update)

Enter 1 to execute the program with the changes applied on the latest version. If you leave this processing option blank, the system uses the previous version.

42.5.5 Setting Processing Options for SPED Fiscal Rules Control (P76B0780)

Processing options enable you to specify default values for programs and reports.

42.5.5.1 General

Enter the Ato Cotepe Version to process (Required)

Enter a value from the UDC table 76B/VC that indicates the SPED project version. Values are:

09: SPED Fiscal

FC: FCONT SPED

PC: ePis Cofins

SD: Accounting SPED

42.5.6 Adding or Modifying Rules for SPED Fiscal Registers

Access the ATO COTEPE Rules Control Revision form.

Block

Enter the block to add or modify. Values are:

09: SPED Fiscal

FC: FCONT SPED

PC: ePis Cofins

SD: Accounting SPED

Record

Enter the register number of the block.

Profile

Enter a value that exists in the Fiscal Presentation Type (76B/FP) UDC table to specify the profile to associate with the company. Values are:

A: Fiscal profile A

B: Fiscal profile B

C: Fiscal profile C

D: Fiscal profile D

NF Input

Enter a value from the Cotepe Rule Values (76B/RT) UDC table to specify the whether information for a purchase transaction is included in the flat files for reporting. If you enter a value in this field, you cannot enter a value in the Other field.

Values are:

Blank: Blank

C: Conditional

N: Do not include

O: Obligatory

OC: Include if information exists

NF Output

Enter a value from the Cotepe Rule Values (76B/RT) UDC table to specify the whether information for a sales transaction is included in the flat files for reporting. If you enter a value in this field, you cannot enter a value in the Other field.

Values are:

Blank: Blank

C: Conditional

N: Do not include

O: Obligatory

OC: Include if information exists

Other

Enter a value from the Cotepe Rule Values (76B/RT) UDC table to specify the whether information for a record that is neither a purchase or sales transaction is included in the flat files for reporting. A record classified as other might be information about inventory, customers, suppliers, and so on. If you enter a value in this field, you cannot enter a value in the NF Input or NF Output fields.

Values are:

Blank: Blank

C: Conditional

N: Do not include

O: Obligatory

OC: Include if information exists

42.6 Setting Up Additional Item Information for Electronic Tax Reporting in Brazil

This section provides an overview of the additional information that you can add, lists prerequisites, lists the forms used to add or review additional item information, and discusses how to set processing options for Item Master Additional Info (P704101).

42.6.1 Understanding Additional Item Information

Register 0200 of block 0 requires information that is not stored in the item tables of the standard software. You can use the Item Master Additional Info program to add the additional information to the Item Master Add Info table (F704101). The system reads the data in the F704101 table when you run the SPED Fiscal - Block 0 Items & Assets program (R76B0891) to populate block 0 registers.

You use category codes to associate the additional information to the items. When you use the Item Master program (P4101) to add or modify programs, the system calls the Item Master Additional Info program if the Localization Country Code field in the User Profile Revisions program (P0092) is set to BR (Brazil). The Item Master Additional Info program includes ten category code fields that you can use to associate additional information to items. However, only category codes 70/C1–70/C5 are used for additional information for SPED Fiscal tax reporting.

To report the additional information required for SPED Fiscal tax reporting, you must set up and use specific category codes because the SPED Fiscal - Block 0 Items program writes the data from specific fields in the Item Master Additional Info program to specific fields in register 0200.

See Item Category Codes (70/C1 – 70/C5)


Note:

You must use the Item Master program (P4101) to access the Item Master Additional Info form to add SPED Fiscal information for items for which you have not previously added the SPED Fiscal information.

42.6.2 Prerequisites

Before you complete the tasks in this section, verify that:

  • The category codes that you use for tax reporting are set up in the 70/C1 – 70/C5 UDC tables.

  • Corresponding versions exist for the Item Master (P4101) and the Item Master Additional Info programs.

    When you work with items using the Item Master program, the system uses the processing options from the corresponding version of the Item Master Additional Info program. If you do not set up a corresponding version, the system uses version ZJDE0001. However, Oracle strongly recommends that you set up a specific version for working with additional information for SPED Fiscal.

42.6.3 Forms Used to Add or Modify Additional Item Information

Form Name Form ID Navigation Usage
Work With Item Master Browse W4101E Inventory Master - Brazil (G76B4111), Item Master. Review and select existing item records.
Item Master Revisions W4101A Select an existing item, and then click Select on the Work With Item Master Browse form. Review item information, and access the Brazil-specific forms.
Item Master Regional Information - Brazil W4101BRA On the Item Master Revisions form, select Regional Info from the Form menu.

Select a row, and select Regional Info from the Row menu on the Work With Item Master Browse form.

Complete Brazil-specific tax information for the item.
Item Master Add Info Revision W704101B Click OK on the Item Master Regional Information - Brazil form.

You must use this navigation to add information to items for which you have not previously added the SPED Fiscal information.

Complete the category code fields to enter information required for tax reporting according to SPED Fiscal.

42.6.4 Setting Processing Options for Item Master Additional Info (P704101)

Processing options enable you to specify default processing values.

42.6.4.1 General

Use these processing options to specify the UDC tables (category codes) for which the system enables you to select UDC values to associate to items. For example, if you specify 76B in the first product code processing option and specify AC in the first user-defined codes field, the system displays the name of the 76B/AC UDC table (Activity Code) as the title of the first category code column in the forms for the Item Master Additional Info program, and enables you to select values from the 76B/AC UDC table to associate with the item.


Note:

When setting up these processing options to report taxes according to SPED Fiscal, you must specify specific UDC tables, as noted in the glossaries for the first five processing options. Oracle recommends that you set up a specific version of the Item Master Additional Info program to use when you add additional item master information to items for SPED Fiscal reporting.

Category Code 1

Enter the product code (system code) and the user-defined code for the category code from which you want the system to enable you to select values.

When setting up this processing option to work with tax reporting according to SPED Fiscal, you must specify 70 as the product code and C1 as the user-defined code. The system uses those values if you leave this processing option blank.

The 70/C1 category code must be set up with values for the item type that you report in register 0200 of block 0.

Category Code 2

Enter the product code (system code) and the user-defined code for the category code from which you want the system to enable you to select values.

When setting up this processing option to work with tax reporting according to SPED Fiscal, you must specify 70 as the product code and C2 as the user-defined code. The system uses those values if you leave this processing option blank.

The 70/C2 category code must be set up with values for the mercosur code that you report in register 0200 of block 0.

Category Code 3

Enter the product code (system code) and the user-defined code for the category code from which you want the system to enable you to select values.

When setting up this processing option to work with tax reporting according to SPED Fiscal, you must specify 70 as the product code and C3 as the user-defined code. The system uses those values if you leave this processing option blank.

The 70/C3 category code must be set up with values for the EX code that you report in register 0200 of block 0.

Category Code 4

Enter the product code (system code) and the user-defined code for the category code from which you want the system to enable you to select values.

When setting up this processing option to work with tax reporting according to SPED Fiscal, you must specify 70 as the product code and C4 as the user-defined code. The system uses those values if you leave this processing option blank.

The 70/C4 category code must be set up with values for the item generic code that you report in register 0200 of block 0.

Category Code 5

Enter the product code (system code) and the user-defined code for the category code from which you want the system to enable you to select values.

When setting up this processing option to work with tax reporting according to SPED Fiscal, you must specify 70 as the product code and C5 as the user-defined code. The system uses those values if you leave this processing option blank.

The 70/C5 category code must be set up with values for the service code that you report in register 0200 of block 0.

Category Code 6 – 10

Enter the product code (system code) and the user-defined code for the category code from which you want the system to enable you to select values.

These processing options are not used for reporting of taxes according to SPED Fiscal.

42.7 Setting Up the ICMS Period Balance Amounts in Brazil

This section provides an overview of the setup for the ICMS period balance amount and discusses how to set up the ICMS period balance amount.

42.7.1 Understanding the Setup for the ICMS Period Balance Amount

Registers E110 and E210 of block E for tax reporting according to SPED Fiscal require that you report information about the ending balances that are carried forward to the next period for ICMS and ICMS substitution tax. For the register E110, you must set up the ICMS tax balances for the state of the legal company. The E210 register includes one register for each state in which a company conducts business, so you must set up the ICMS substitution tax balances for each state for the reporting company.

You use the ICMS Period Balance Maintenance program (P76B0770) to enter for each company/state combination the ending balance for ICMS and ICMS substitution tax. You enter the balances for each period of a fiscal year. The system saves the information that you enter in the ICMS Period Balance Maintenance program to the ICMS Period Balance by State and Company table (F76B0770), and reads this table when you generate block E registers.

42.7.2 Forms Used to Set Up the ICMS Period Balance Amounts

Form Name Form ID Navigation Usage
Work with ICMS Period Balance Maintenance W76B0770B SPED Fiscal Setup (G76B1116), ICMS Period Balance Maintenance Review and select existing records.
ICMS Period Balance Maintenance W76B0770A Click Add on the Work with ICMS Period Balance Maintenance form.

Complete the header area field, and then select Add Periods from the Form menu.

Enter ICMS and ICMS substitution tax period-ending balances for a company/state/year combination.

42.7.3 Entering ICMS Period Balance Amounts

Access the ICMS Period Balance Maintenance form.

Company

Enter the company number of the reporting company.

State

Enter a value that exists in the 00/S (State) UDC table to specify the state for which you enter the period balance amounts.

Century

Enter the two-digit century.

Year

Enter the two-digit year.

ICMS Tax Total

Enter the ending balance for each period that has a positive balance that is carried forward to the next period.

ICMS Total Substitution Tax

Enter the ending balance for each period that has a positive balance that is carried forward to the next period.

42.8 Setting Up the IPI Period Balance Amounts in Brazil

This section provides an overview of the setup of IPI period balance amounts and discusses how to enter IPI period balance amounts.

42.8.1 Understanding the Setup of IPI Period Balance Amounts

Register E520 of block E for tax reporting according to SPED Fiscal 09 requires that you report information about the ending balances that are carried forward to the next period for IPI tax. You use the IPI Period Balance Maintenance program (P76B0771) to add the period balance for the reporting company. The system saves the information that you enter to the IPI Period Balance by Company table (F76B0771), and reads this table when you generate block E registers.

42.8.2 Forms Used to Enter IPI Period Balance Amounts

Form Name Form ID Navigation Usage
Work with IPI Period Balance Maintenance W76B0771B SPED Fiscal Setup (G76B1116), IPI Period Balance Maintenance Review and select existing records.
IPI Period Balance Maintenance W76B0771A Click Add on the Work with IPI Period Balance Maintenance form.

Complete the header area fields, and then select Add Periods from the Form menu.

Enter IPI period balances for the fiscal year for the reporting company.

42.8.3 Entering IPI Period Balance Amounts

Access the IPI Period Balance Maintenance form.

Company

Enter the company number of the reporting company.

Century

Enter the two-digit century.

Year

Enter the two-digit year.

IPI Tax Total

Enter the ending balance for each period that has a positive balance that is carried forward to the next period.