Understanding the Fiscal Classification Code Upload
The Consumer Protection Code states that you must include in fiscal documents provided to consumers the approximate total amount of federal, state, and municipal taxes levied on the sale of goods or services.
Companies must include in a specific field in the fiscal document the approximate amount of taxes, per item or service sold. Additionally, the fiscal document header should include the total amount of taxes for all items and services sold.
The Brazilian Institute of Tax Planning (IBPT) provides a text file with the approximate average tax burden of all products and services, based on the Mercosur Common Nomenclature (NCM) and on the Brazilian Nomenclature Service (NBS). You can upload the data from the text file into the JD Edwards EnterpriseOne software for Brazil. In the JD Edwards EnterpriseOne system for Brazil, the codes are referred to as fiscal classification codes.
You must upload the data from the Brazilian Institute of Tax Planning in the order in which the data appears in the IBP Tax table (F76B19).
This list shows the positions of the values that you can upload:
Position 1: Fiscal Classification (NCM or NBS code)
You must include a value for this field.
Position 2: Ex TIPI
Position 3: Effective Date
Position 4: State
Position 5: Fiscal Classification Type
The value that you enter in this field must exist in the Fiscal Classification Type UDC table (76B/TL).
Position 6: Description
Position 7: National Rate
Position 8: Imported Rate
Position 9: Data Source
You must provide a value for this field.
Position 10: Version Number
You must upload a value for the version number.
You must upload the data in a specific order, with each value separated by the delimiter you choose, and with a delimiter character at the end of the string. If you do not upload values for a position, you must still include a space for the value. For example, if you intend to upload the text file with the Fiscal Classification (position 1), State (position 4), Fiscal Classification Type (position 5), Source (position 9), and Version Number (position 10) using a semi-colon (;) for the delimiter, the text file line that you prepare will look like this:
0102;;;AB;2;;;;9;10;
When you run the upload process, the system populates values in the IBP Tax table (F76B19). The system uses this table, along with values in the IPI tax table (F76B18) when you work with notas fiscais. The classification codes must exist in both the F76B19 and F76B18 tables. To update the fiscal classification codes in the F76B18 table, you can set processing options that enables you to do so.
To upload the fiscal classification codes from the government-provided text files:
Obtain the text file from the Brazilian Institute of Tax Planning.
If the values in the text file are not in the order required to upload the values to the JD Edwards EnterpriseOne system, modify the text file.
Access the IBPT Tax Massive Update program (R76B4102) from Batch Versions (P98305) to set the processing options.
Use the Text File Processor program (P007101) to upload the government-provided text file to the Text Processor Detail Table (F007111).
Use the Text File Processor program to run the IBPT Tax Massive Update program.
The IBPT Tax Massive Update program writes the data to the IBP Tax Information table (F76B19), and, if you set the processing options to do so, it writes fiscal classification codes to the IPI Taxes table (F76B18).
After you upload data, you can use the IPI - IBPT Tax Revision by Fiscal Classification program (P76B18) to verify that the data loaded correctly.