This chapter contains these topics:
Section 15.2, "Uploading Fiscal Classification Codes from Government Files (Optional)"
Section 15.3, "Uploading Item Data from a Text File (Optional)"
Section 15.4, "Copying Category Code Values for Items (Optional)"
You must include in some fiscal documents information about the imported content for certain transactions involving the interstate sales of goods with imported content. If you sell products to final consumers, you must include estimated tax amounts in the documents that you provide to the consumer.
The JD Edwards EnterpriseOne software for Brazil provides programs that you can use to upload batches of the required data. Use of the programs described in this chapter is optional. You can use these batch programs to add the required information database tables, or you can manually add the required data to each individual record in the tables.
Some of the upload programs write data to the same tables. Oracle recommends that you use programs in this order:
IBPT Tax Massive Update program (R76B4102) (optional)
The IBPT Tax Massive Update program writes data from a government-provided text file 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). The fiscal classification codes must exist in these tables so that the system can include estimated taxes on the documents that you provide to final consumers. If you do not want to use the IBPT Tax Massive Update program to update these tables, you can use the IPI-IBPT Tax Revision by Fiscal Classification program (P76B18) to add the data to individual records.
|
Important Note: You can update the fiscal classification in the F76B18 table for only one combination of the IPI code and IPI reduction percentage at a time.Any changes to the fiscal classification codes that you make using the IBPT Tax Massive Update program will be used for all IPI calculations. |
Initial Loading Item Master/Item Branch program (R76B4103).
If items that you sell include imported content, you must populate the Tag File F76411 - Item Master table (F76B4101) and Tag File F76412 - Item Branch table (F76B4102) with data that you are required to include in sales orders, and in fiscal documents and reports. You can use the Initial Loading Item Master/Item Branch program to add data to the F76B4101 and F76B4102 tables, or you can add the data to individual records using the Item Master Regional Information Brazil (P4101BR) and Item Branch Regional Information - Brazil (P76412B) programs.
Initial Loading Category Codes Item Master Migration program (R76B4104) and Initial Loading Category Codes Item Branch Migration program (R7BB4105) (optional)
If you used the JD Edwards EnterpriseOne software for Brazil prior to the implementation of the software enhancement that supports import content and item origin information used in ICMS calculations, you might have fiscal classification codes set up in category codes. You can use the Initial Loading Category Codes Item Master Migration and Initial Loading Category Codes Item Branch Migration programs to copy data from item category codes to the Fiscal Classification fields (BLCF) in the Item Master Regional Information - Brazil (F76411) and Item Branch Regional Information - Brazil table (F76412) tables. You can also copy the values in an item category code to the Ex-TIPI fields (B76TIPI) in the F76B4101 and F76B4102 tables. Note that you can also populate the B76TIPI fields using the Initial Loading Item Master/Item Branch program.
|
Important Note: If you modify the fiscal classification codes when you use the Initial Loading Category Codes Item Master Migration and Initial Loading Category Codes Item Branch Migration programs, the system will use the new codes when it calculates IPI taxes. |
This section provides an overview of the fiscal classification code upload, lists prerequisites, and discusses how to:
Run the IBPT Tax Massive Update program.
Set processing options for IBPT Tax Massive Update (R76B4102).
Review the uploaded IBPT values.
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. If you need 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.
Before you begin the tasks in this section:
Prepare the text file that you want to upload.
Add the value R76B4102 to UDC 03B/UP.
Select Text File Processor (G0071), Text File Processor.
From the Work with Text Batches form, select Row, then Process Batch, and then Upload Batch.
On the Upload Text to Transaction File form, enter R76B4102 and click OK.
Processing options enable you to specify default processing values.
Enter the version number of the text file that you upload.
Enter the date on which the uploaded data is in effect. If you do not complete this processing option, the system uses the current date.
Specify the source of the data that you upload. For example, specify IBPT.
Enter the state for which you upload values.
Enter Y (yes) if the first line of the text file includes data to upload.
Specify the delimiter that separate the values in the text file. Your text file delimiter should be a delimiter that is set up in your system.
|
Note: If you use a delimiter that appears in any of the values entered (for example periods or commas, that can show in amounts) you can upload inaccurate information. Choose a delimiter that prevents this problems. |
Use the processing options on this tab to specify the values for which you create classification codes in the IPI taxes table (F76B18). In addition to the classification codes, the F76B18 table includes values for the IPI tax and the IPI reduction; and codes used in the fiscal books for ICMS and IPI taxes.
Enter Y (yes) to have the system create fiscal classification codes in the IPI Taxes table (F76B18).
Specify the IPI tax for which you update the classification code in the F76B18 table.
Enter the IPI reduction amount.
Enter a code from the ICMS Code - Fiscal Value (76/II) UDC table that specifies whether the classification code is for taxable transactions.
Enter a code from the ICMS Code - Fiscal Value (76/II) UDC table that specifies whether the classification code is for taxable transactions.
To review the uploaded IBPT values:
Access the Work With IPI Taxes form in the IPI - IBPT Tax Revision by Fiscal Classification program (P76B18).
See Section 14.3.4, "ICMS, Fiscal Classifications and IBPT Tax Revision (P76B18)"
Select a record, and then select IBP Tax Revision from the Row menu.
On the IBP Tax Revision form, review the uploaded values.
You can change or add values on the IBP Tax Revision form.
This section provides an overview of how to upload item data from a text file, lists prerequisites, and discusses how to:
Run the Initial Loading Item Master/Item Branch program.
Set processing options for Initial Loading Item Master/Item Branch (R76B4103).
To comply with Brazilian regulations, you must include specific item information in sales orders, purchase orders, and fiscal documents and reports for items with imported content. If you used the JD Edwards EnterpriseOne software for Brazil prior to the requirement to include item origin and import content information in documents and reports, you might have item records that do not include the required information.
You can use the Initial Loading Item Master/Item Branch program (R76B4103) to upload data from a text file that you prepare to add the data to the Tag File F76411 - Item Master table (F76B4101) and the Tag File F76412 - Item Branch table (F76B4102). These tables must be populated with the import content information before you can generate documents and reports that include the import content information.
When you prepare a text file with the data that you want to upload, you must use a character delimiter to separate each value. For example, you could use a comma (,) or a pipe (|) to delimit the values in the text file. You must use a delimiter that is set up in your system.
You must set up your text file with field values in a specific order. This list shows the position in the text file for each field value that you can upload:
Position 1: Item (ITM)
Position 2: Branch (MCU)
Position 3: Location (LOCN)
Position 4: Lot (LOTN)
Position 5: Item Origin (BORI)
Position 6: ExTipi (B76TIPI)
Position 7: Import Content (B76CI)
Position 8: Amount from the portion from abroad (B76VPA)
Position 9: Total Amount of the Interstate Outbound (B76TVIO)
This list shows examples of lines in a text file with the values for the fields delimited by a pipe (|):
700592|AM-VENDA||||3|10,23|10|15|
In this line, the positions are populated with values in these positions:
Position 1 (Item): 700592
Position 2 (Branch) AM-VENDA
Position 3 (Location): blank
Position 4 (Lot): blank
Position 5 (Item Origin): blank
Position 6 (Ex-Tipi): 3
Position 7 (Import Content): 10,23
Position 8 (Amount from the portion from abroad): 10
Position 9 (Total Amount of the Interstate Outbound): 15
700592|SP-VENDA||||1|25|19|24|
In this line, the positions are populated with values in these positions:
Position 1 (Item): 7005921
Position 2 (Branch) SP-VENDA
Position 3 (Location): blank
Position 4 (Lot): blank
Position 5 (Item Origin): blank
Position 6 (Ex-Tipi): 1
Position 7 (Import Content): 25
Position 8 (Amount from the portion from abroad): 19
Position 9 (Total Amount of the Interstate Outbound): 24
700600||||3||25|19|24|
In this line, the positions are populated with values in these positions:
Position 1 (Item): 7006001
Position 2 (Branch) blank
Position 3 (Location): blank
Position 4 (Lot): blank
Position 5 (Item Origin): 3
Position 6 (Ex-Tipi): blank
Position 7 (Import Content): 25
Position 8 (Amount from the portion from abroad): 19
Position 9 (Total Amount of the Interstate Outbound): 24
Each set of values must end with a delimiter character.
You must include values for the Item and the Import Content fields when you import the text file. The other values are optional when you upload the text file. However, if you do not include the values when you upload the text file, you must enter import content information for each record in the Item Master Regional Information Brazil program (P4101BR) or the Item Branch Regional Information - Brazil program (P76412B) that describes an item with imported content.
If the field Item (ITM) is completed and fields Branch (MCU), Location (LOCN), and LOT (LOTN) are blank, the system inserts or updates the record in the F76B4101 table. If the Item and Branch fields are populated, the system inserts or updates the record in the F76B4102 table.
Run the Initial Loading Item Master/Item Branch program in proof mode to generate a report that includes information about which items in the text file were located in the Item Master Regional Information - Brazil (F76411) and Item Branch Regional Information - Brazil table (F76412) tables. The items must exist in the F76411 before you can add or update records in the F76B4101 table, and must exist in the F76412 table before you can add or update records in the F76B4102 table. You can set the Show processing option to generate the report showing the validation outcome for all lines in the text file you upload or only the lines with errors.
To upload item data to the F76B4101 and F76B4102 tables:
Prepare the text file.
Access the Initial Loading Item Master/Item Branch program (R76B4103) from Batch Versions (P98305) to set the processing options.
Use the Text File Processor program (P007101) to upload the text file to the Text Processor Detail Table (F007111).
Use the Text File Processor program to run the Item Master/Item Branch program.
Before you perform the tasks in this section:
Prepare the text file that you will upload.
Add R76B4103 to the 03B/UP UDC table.
Select Text File Processor (G0071), Text File Processor.
From the Work with Text Batches form, select Row, then Process Batch, and then Upload Batch.
On the Upload Text to Transaction File form, enter R76B4103 and click OK.
Processing options enable you to specify default processing values.
Enter 1 to run the program in final mode. Leave this processing option blank to run in proof mode. In proof mode, the system generates a report but does not update tables. In final mode, the system updates the Tag file F76411 - Item Master table (F76B4101), the Tag file F76412 - Item Branch table (F76B4102), or both of the tables.
Enter Y (yes) to have the system update the Item Origin field in the F76411 and F76412 tables.
Enter 1 to generate the report with only the lines for which errors occur. Leave this processing option blank to include on the report all lines from the text file.
Enter the delimiter that you use in the text file that you upload. The delimiter should be the same as the delimiter used in the system setup.
This section provides an overview of how to copy category code values for items and discusses how to:
Run the Initial Loading Category Codes Item Master Migration program (R76B4104).
Run the Initial Loading Category Codes Item Branch Migration program (R7BB4105).
Set processing options for R76B4104 and R76B4105.
When producing sales orders, purchase orders, notas fiscais, and fiscal documents, you must include specific information required by government regulations.
If you used the JD Edwards EnterpriseOne software for Brazil prior to the implementation of the software enhancement that supports import content and item origin information used in ICMS calculations, you might have fiscal classification codes set up in category codes.
You can copy fiscal classification codes from existing category codes to the tables that must be populated with the NCM (Mercosul Common Nomneclature) and Ex-TIPI values. You use these programs to copy the category code values:
Initial Loading Category Codes Item Master Migration (R76B4104)
Use this program to copy category code values to F76411.BCLF and F76B4101.B76TIPI. F76411.BCLF is the field for the NCM code in the Item Master Regional Info - BRA table. F76B4101.B76TIPI is the field for the Ex-TIPI code in the Tag File F76411-Item table (F76B4101).
Initial Loading Category Codes Item Branch Migration (R76B4105).
Use this program to copy category code values to F76412.BCLF and F76B4102.B76TIPI. F76412.BCLF is the field for the NCM code in the Tag File F76412 - Item Branch table. F76B4102.B76TIPI is the field for the Ex-TIPI code in the Tag File F76411-Item Branch table (F76B4102).
When you run the R76B4104 and R76B4105 programs, the system validates that an item record exists in the F76411 (for the R76B4104 program) or F76412 (for the R76B4105 program) tables. If the items do not exist, the system prints an error message on a report.
Use one of these navigations:
Brazilian Conversions (G7631A), Initial Loading Category Codes Item Master Migration.
Brazilian Conversions (G7631A), Initial Loading Category Codes Item Branch Migration.
Processing options enable you to specify default processing values.
Enter the item category code from system 70 that corresponds to the NCM codes to copy the values to F76411.BCLF when you run R76B4101 and to F76412.BCLF when you run R76B4102. Valid values are 1-10.
For example, if you have NCM codes set up in UDC 70/02, enter 2. If you leave this processing option blank, then the system does not copy a value to the BCLF fields.
Enter the item category code from system 70 that corresponds to the Ex-Tipi codes to copy the values to F76B4101.B76TIPI when you run R76B4101 and to F76B4102.B76TIPI when you run R76B4102. Valid values are 1-10.
For example, if you have Ex-Tipi codes set up in UDC 70/03 enter 3. If you leave this processing option blank, then the system does not copy a value to the B76TIPI field in the tables.