(BRA) Processing Fiscal Books

This chapter provides an overview of fiscal books, lists prerequisites, and discusses how to:

Click to jump to parent topicUnderstanding Fiscal Books for Brazil

Fiscal books are required by the Brazilian government to report information about taxable transactions and the taxes due on those transactions. You print fiscal books on the 10th, 20th, and the last day of the month for ICMS tax and at the end of the month for IPI tax.

The notas fiscais that are generated by the JD Edwards EnterpriseOne Sales Order Management and JD Edwards EnterpriseOne Procurement systems are automatically converted into the Fiscal Books module. You must manually enter stand-alone notas fiscais.

A program is provided that populates a nota fiscal header and a nota fiscal detail workfile with data from the nota fiscal header and nota fiscal detail tables. Then you run reports from the workfiles to generate reports that comply with the layout which is defined by the ICMS Ordinance 57/95, and you generate electronic media files according to the layout that is defined by the ICMS Ordinance 57/95 (Systema Integrado de Informacoes). Additionally, programs are provided that generate supporting reports and programs that submit fiscal book data to the tax authority electronically.

When you generate Fiscal Books, the system prints an opening and closing page. You create the text for opening and closing pages by using the Fiscal Books Next Numbers program (P7602B).

See Setting Up Opening and Closing Terms for Fiscal Books for Brazil.

To maintain the records and generate fiscal books, you must complete these tasks in this order:

  1. Set up the system for Fiscal Books.

  2. Run the Nota Fiscal Conversion program (R76B200A).

    When you run the Nota Fiscal Conversion program, the system writes information from the Nota Fiscal Header - Brazil (F7601B) and the Nota Fiscal Detail - Brazil (F7611B) tables to the Nota Fiscal - Header (Fiscal Books) table (F76101B) and the Nota Fiscal - Detail (Fiscal Books) table (F76111B).

  3. Run the Integrity Report (R76B0001).

    The Integrity Report process purges records from tables F76101B and F76111B when the record does not exist in both tables.

  4. Maintain fiscal books records as necessary.

  5. Print and review the fiscal books supplementary reports.

  6. Generate and review fiscal books.

  7. Generate the electronic media to submit the fiscal books.

Reporting IPI in Fiscal Books

IPI is a federal tax that applies to domestic or imported manufactured goods. IPI is reported monthly.

Data items BRADEC and BRADCL store the codes that indicate the period for which IPI taxes were calculated. These tables store codes for data item BRADEC or BRADCL:

The system writes or reads codes for BRADCE and BRADCL when you run these programs:

Program

System Action

Nota Fiscal Conversion (R76B200A)

Writes code to table

Verification of ICMS/IPI (P76B1002)

Writes code to table

Inbound Nota Fiscal Maintenance (P76B1001)

Outbound Nota Fiscal Maintenance (P76B1001)

Writes code to table

Verification of IPI (R76B4002)

Reads code in table

DIPI Summary and Statements (R76B4006)

Reads code in table

Outbound Registry (R76B4001)

Reads code in table

Inbound Registry (R76B4016)

Note. Program R76B4016 has been renamed to Inbound Registry. It was formerly Inbound Registry São Paulo. Program R76B4000 (Inbound Registry) is obsolete.

Reads code in table

See Also

Purging Incomplete Fiscal Book Records

Printing Fiscal Books Reports

Understanding the Electronic GIA Workbench for Brazil

Click to jump to parent topicPrerequisites

Before completing the tasks in this chapter:

Click to jump to parent topicGenerating the Fiscal Books Workfiles

This section provides an overview of the fiscal books workfiles, lists prerequisites, and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding Fiscal Books Workfiles

Before you can generate fiscal book reports and the electronic media that you must submit to Sintegra (Systema Integrado de Informacoes), you must create the fiscal book workfiles. The Nota Fiscal Conversion program enables you to specify the notas fiscais that you write to the workfiles. When you run the Nota Fiscal Conversion program, the system writes information from the Nota Fiscal Header - Brazil (F7601B) and the Nota Fiscal Detail - Brazil (F7611B) tables to the Nota Fiscal - Header (Fiscal Books) table (F76101B) and the Nota Fiscal - Detail (Fiscal Books) table (F76111B). Other batch programs that you use to generate fiscal book reports cull data from tables F76101B and F76111B.

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 topicRunning the Nota Fiscal Conversion Program

Select Fiscal Reports - Brazil (G76B111), Nota Fiscal Conversion.

Click to jump to top of pageClick to jump to parent topicSetting the Processing Options for Nota Fiscal Conversion (R76B200A)

These processing options specify how the system writes nota fiscal data to the nota fiscal work files for fiscal books.

Default

1. Fiscal Company

Specify the company for which you want to process nota fiscal data. If you leave this processing option blank, the system processes records for all companies.

2. From Date

Specify the beginning date of the notas fiscais for which you want to process data.

3. Thru Date

Specify the ending date of the notas fiscais for which you want to process data.

4. Nota Fiscal Type

Specify whether you work with inbound or outbound notas fiscais. Values are:

E: Inbound

S: Outbound

Messages

1. IPI Tax Not Credited

Select a message code from the Fiscal Message/Observations UDC (76B/M1). Use this option when notas fiscais show IPI tax that you cannot recover.

2. IPI Tax 50% Recoverable

Select a message code from the Fiscal Message/Observations UDC (76B/M1). Use this option when notas fiscais do not show IPI tax that you can recover.

3. Free Port Zone Discount

Select a message from the Fiscal Message/Observations UDC (76B/M1). The message that you select overrides the message from the Nota Fiscal Header - Fiscal Books table (F76B101B) and prints in the Fiscal Books.

4. Freight, Insurance and Expenses

Select a message from the Fiscal Message/Observations UDC (76B/M1). The message that you select overrides the message from the Nota Fiscal Header - Fiscal Books table (F76B101B) and prints in the Fiscal Books.

5. Substitution

Select a message from the Fiscal Message/Observations UDC (76B/M1). The message you select overrides the message from the Nota Fiscal Header - Fiscal Books table (F76B101B) and prints in the Fiscal Books.

6. ICMS Tax Differential Between States

Select a message from the Fiscal Message/Observations UDC (76B/M1). The message you select overrides the message from the Nota Fiscal Header - Fiscal Books table (F76B101B) and prints in the Fiscal Books.

7. Suffix Code for Transaction Nature

Specify the suffix for the transaction nature codes that you want to exclude from the report. Line items that have transaction nature codes that end with the suffix that you enter will appear in the Fiscal Books with an amount of zero. For example, if a line item for the cost of packaging materials or pallets has the transaction nature suffix that you enter here, the line item appears in the Fiscal Books with 0 for the amount.

8. Message Code for Suffix

Select the message code that you want to print for the suffix of the transaction nature code. You select the message code from the Fiscal Message/Observations UDC (76B/M1).

Processing

1. Refresh Conversion Table

Specify whether the system refreshes the records already written to the Nota Fiscal - Header (Fiscal Books) table (F76101B) and the Nota Fiscal - Detail (Fiscal Books) table (F76111B). If you set this processing option to 1, you must use Data Selection to specify a range of dates for which the system will refresh the records. Values are:

Blank: Do not refresh records.

1: Refresh records.

2. Purge Conversion Table

Specify whether the system purges all records from the Nota Fiscal Header - Fiscal Books table (F76101B) and the Nota Fiscal Details - Fiscal Books table (F76111B).

Codes

1. Cancelled Code 1

Select a code from the Activity/Status Codes UDC (40/AT) to represent canceled notas fiscais.

2. Cancelled Code 2

Select a code from the Activity/Status Codes UDC (40/AT) to represent canceled notas fiscais.

3. Cancelled Code 3

Select a code from the Activity/Status Codes UDC (40/AT) to represent canceled notas fiscais.

4. Cancelled Code 4

Select a code from the Activity/Status Codes UDC (40/AT) to represent canceled notas fiscais.

Click to jump to parent topicMaintaining Inbound and Outbound Notas Fiscais Records for Fiscal Books

This section provides an overview of nota fiscal maintenance and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding Nota Fiscal Maintenance

The JD Edwards EnterpriseOne Sales Order Management and JD Edwards EnterpriseOne Procurement systems write data to the Nota Fiscal Header - Brazil (F7601B) and the Nota Fiscal Detail - Brazil (F7611B) tables when you generate notas fiscais. The system writes data in these tables to the Nota Fiscal - Header (Fiscal Books) table (F76101B) and the Nota Fiscal - Detail (Fiscal Books) table (F76111B) when you run the Nota Fiscal Conversion program (R76B200A). The system uses the data in the F76101B and F76111B tables to create Fiscal Books.

If you generate stand-alone notas fiscais or you generate notas fiscais outside of the JD Edwards EnterpriseOne systems, the data is not included in the F7601B and F7611B tables. Therefore, data for those notas fiscais are not written to the F76101B and F76111B tables when you run the Nota Fiscal Conversion program. You use the Maintenance of Fiscal Books program (P76B1001) to add data for inbound and outbound notas fiscais to the F76101B and F76111B tables before you run the Nota Fiscal Conversion program. You can also use this program to revise or delete nota fiscal records.

Click to jump to top of pageClick to jump to parent topicForms Used to Add Inbound and Outbound Nota Fiscal Records

Form Name

FormID

Navigation

Usage

Nota Fiscal Revisions

W76B1001B

Fiscal Reports - Brazil (G76B111), Inbound Nota Fiscal Maintenance

Click Add on the Work with Nota Fiscal form.

Add header information for an inbound nota fiscal.

Work with Nota Fiscal

W76B1001A

Fiscal Reports - Brazil (G76B111), Outbound Nota Fiscal Maintenance

Add header information for an outbound nota fiscal.

Work with Fiscal Books

W76B1001C

Select Nota Fiscal Detail from the Form menu on the Nota Fiscal Revisions form.

Access the Fiscal Book Revisions form.

Fiscal Book Revisions

W76B1001D

Click Add on the Work with Fiscal Books form.

Enter item information

Click to jump to top of pageClick to jump to parent topicSetting Up Processing Options for Inbound Nota Fiscal Maintenance and Outbound Nota Fiscal Maintenance (P76B1001)

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

Default

This processing option specifies whether the system processes inbound or outbound notas fiscais.

1. Nota Fiscal Type

Specify whether you work with inbound or outbound. notas fiscais. Values are:

E: Inbound

S: Outbound

Click to jump to top of pageClick to jump to parent topicAdding a Nota Fiscal Record for Fiscal Books

Access the Nota Fiscal Revisions form.

Status Code

Enter a value that exists in the Activity/Status Codes (40/AT) UDC table to indicate the status of the line.

Nota Fiscal Type

The system populates the Nota Fiscal Type field with the value that you entered on the Work With Nota Fiscal form. The system enables or disable fields on forms and performs validations based on the value that you enter. The system provides these hard-coded values:

BRNFI-CL: NF Inbound Trans. Classical.

BRNFI-NA: NFe Inbound Transaction - National

BRNFI-SP: NFe Inbound Transaction - São Paulo

BRNFI-TE: NF Inbound Trans. Teleph. Ind.

NFe Number (electronic nota fiscal number)

Specify the electronic nota fiscal number generated by the fiscal authority. This number is forwarded to you by the fiscal authority when you process notas fiscais electronically. The system enables this field only when you select BRNFI-NA, BRNFI-SP, or BRNFI-TE as the nota fiscal type.

Access Key

The system completes this field based on the nota fiscal that you selected. . You use the access key to validate that the nota fiscal legal number is a valid number. This access key is forwarded to you by the fiscal authority when you process notas fiscais electronically. This field accepts the 44-digit numeric key for the national NFe or the 8-digit alphanumeric key for the NFe for São Paulo. The system validates your entry based on the nota fiscal type that you select.

The system enables this field only when you select BRNFI-NA or BRNFI-SP as the nota fiscal type.

Nota Fiscal Date

Enter the date of the nota fiscal.

Issuer CNPJ

Enter the issuer CGC number.

Supplier Number

Enter the address book number of the supplier who issued the nota fiscal.

Issue Date

For inbound notas fiscais,enter the date that you received the nota fiscal. For outbound notas fiscais, enter the date that you issued the nota fiscal.

NF Total

Enter the total amount of the nota fiscal. The system calculates the total as follows:

Merchandise + IPI tax amount + ICMS Substitute tax amount + Complementary Expenses - Discounts

ICMS Discount - Free Port Zone

Enter the amount of the discount available to a free port zone customer.

Fiscal Message Code 01

Enter a code by which records in the Inbound Registry and the Outbound Registry are sorted for summary purposes. You must select a code from the Fiscal Messages/Observations UDC (76BM1).

Fiscal Message Code 02

Enter a code by which records in the Inbound Registry and the Outbound Registry are sorted for summary purposes. You must select a code from the Fiscal Messages/Observations UDC (76B/M1).

Fiscal Comment Code

Enter a code that appears in a comments column in the Inbound Registry and the Outbound Registry. You must select a code from the Fiscal Message/Observations UDC (76B/M1).

NF Value 01

Enter an amount that the system associates with the Fiscal Message Code 01 and the Fiscal Comment Code fields. The system totals the amounts in this field for each Fiscal Message Code summary for the Inbound Registry and the Outbound Registry, and prints the total along with the value in the Fiscal Message Code 01 field. The value in the NF Value 01 field is also displayed with the Fiscal Comment Code in the comment column in the Inbound Registry and the Outbound Registry.

NF Value 02

Enter an amount that the system associates with the Fiscal Message Code 02 and the Fiscal Comment Code fields. The system totals the amounts in this field for each Fiscal Message Code summary for the Inbound Registry and the Outbound Registry, and prints the total along with the value in the Fiscal Message Code 02 field.

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.

Tax Situation

Enter the tax situation code.

Gross Weight

Enter the total weight of the item, including packaging, pallets, and so on.

Weight Unit

Enter the unit measure on which the item weight is calculated, such as liter, kilo, and so on.

Extended Price

Enter the number of units multiplied by the unit price.

IPI Code

Enter the IPI code.

IPI Rate

Enter the rate at which the IPI tax is assessed.

IPI Tax

Enter the IPI tax amount that is printed on the nota fiscal.

ISS Rate

Enter the rate at which ISS tax is assessed.

Reduction Basis

Enter the amount on which ICMS taxes are assessed. In this case, the ICMS taxable amount is reduced due to the sale of given products.

IPI Reduction

Enter the amount on which IPI taxes are assessed. In this case, the IPI taxable amount is reduced due to the sale of given products.

Click to jump to parent topicMaintaining ICMS and IPI Tax Information for Fiscal Books

This section provides an overview of ICMS and IPI tax information for fiscal books and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding ICMS and IPI Tax Information for Fiscal Books

The Verification of ICMS/IPI program (P76B1002) enable you to enter this type of information about the ICMS and IPI taxes that you paid:

The Verification of ICMS/IPI program populates these tables:

The system uses these tables to write information to the Verification of IPI report (R76B4002) and the Verification of ICMS report (R76B4003).

Click to jump to top of pageClick to jump to parent topicForms Used to Maintain ICMS and IPI Taxes

Form Name

FormID

Navigation

Usage

Verification of ICMS/IPI - Demonstratives

W76B1002A

Fiscal Reports - Brazil (G76B111), Verification of ICMS/IPI

Add codes from the Demonstrative Codes UDC (76B/TD) to specify whether an ICMS or IPI tax is a credit or debit. The system prints this information in the ICMS Verification fiscal book.

Verification of ICMS/IPI - Collection Document

W76B1002B

Select Collection Document from the Form menu on the Verification of ICMS/IPI - Demonstratives form.

Add information about the payment of ICMS and IPI taxes, including the date paid and the confirmation number

Verification of ICMS/IPI - Observations

W76B1002C

Select Comments from the Form menu on the Verification of ICMS/IPI - Demonstratives form.

Add comments that print at the end of the Verification of IPI and the Verification of ICMS reports.

Click to jump to top of pageClick to jump to parent topicAdding ICMS and IPI Demonstrative Codes

Access the Verification of ICMS/IPI - Demonstratives form.

Demonstrative Code

Enter a code from the Demonstration Code UDC table (76B/TD).

Click to jump to top of pageClick to jump to parent topicAdding ICMS and IPI Collection Information for Fiscal Books

Access the Verification of ICMS/IPI - Collection Document form.

Delivery Bill Number

Enter the fiscal delivery bill number.

Payment Date

Enter the date of the nota fiscal.

Collection Agency

Enter information about the collection agency.

Delivery Date

For inbound notas fiscais, enter the date that you received the nota fiscal. For outbound notas fiscais,enter the date that you issued the nota fiscal.

Delivery Location

Enter the text that names or describes an address. This 40-character alphabetic field appears on a number of forms and reports. You can enter dashes, commas, and other special characters, but the system cannot search on them when you use this field to search for a name.

Click to jump to top of pageClick to jump to parent topicAdding Comments for ICMS and IPI Taxes for Fiscal Books

Access the Verification of ICMS/IPI - Observations form.

Click to jump to parent topicMaintaining GNRE Information for Fiscal Books

This section provides an overview of GNRE and discusses how to add GNRE information.

Click to jump to top of pageClick to jump to parent topicUnderstanding GNRE

GNRE (Guia Nacional De Recolitimento de Tributos Esaduais) is a document that you use to pay ICMS substitution tax in Brazil. When you pay the tax, the bank gives you a confirmation number to acknowledge that you paid the tax. You must enter the confirmation number into the JD Edwards EnterpriseOne system so that the number can be reported in the fiscal books. The system writes the information to the GNRE Table (F76B105) and uses the information to generate record type 55 when you generate the magnetic tape for reporting purposes.

Click to jump to top of pageClick to jump to parent topicForms Used to Maintain GNRE Information

Form Name

FormID

Navigation

Usage

Maintenance of GNRE

W76B1003A

Fiscal Reports - Brazil (G76B111), Maintenance of GNRE

Enter the confirmation number that the bank sends to you for GNRE.

Click to jump to top of pageClick to jump to parent topicAdding GNRE Information

Access the Maintenance of GNRE form.

Company From

Enter the company that issued the GNRE form.

New GNRE Number

Enter the confirmation number that a bank gives to you, acknowledging that you paid ICMS Substitution tax by using a GNRE document.

Tax ID

Enter the identification code required by various tax authorities. This can be a social security number, federal or state corporate tax ID, sales tax number, and so on. The system verifies the number and prints the separators in their correct format, according to the value of TAXC (Person/Corporation Code). If no value exists for TAXC, the system uses the Corporate Entity.

Payment Date

For inbound notas fiscais, enter the date that you received the nota fiscal. For outbound notas fiscais, enter the date that you issued the nota fiscal.

Company State

Enter the state code of the company that issued the nota fiscal.

Destination State

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

Bank Number

Enter the bank number.

Bank Branch Number

Enter the bank branch number.

Due Date

Enter the due date of the nota fiscal.

Amount

Enter the amount of the nota fiscal.

Fiscal Month

Enter the base month.

Fiscal Year

Enter the base year.

Agreement or Protocol Number

Enter the agreement number.

Click to jump to parent topicGenerating ICMS Magnetic Files (Sintegra)

This section provides an overview of the ICMS magnetic files, lists prerequisites, and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding ICMS Magnetic Files (Sintegra)

The Generate ICMS Magnetic Files - Sintegra program (R76B201) lets you create the flat file that you must submit for fiscal books reporting. Beginning in January 2003, the Brazilian government requires that you use the flat file layout as described in law Convenio ICMS 69/02 when you electronically submit the fiscal books for transactions that occurred after December 31, 2002. You use the format that is required by Convenio ICMS 57/95 for transactions that occurred prior to January 1, 2003. You specify the format that the system uses in the Convenio processing option.

The system reads records from these tables to populate the flat file:

The system reads tables F76111B, F76B101, and F76B001 to create record type 54 records that are based on data from notas fiscais. The record type 54 records that the system creates from tables F76111B and F76101B contain data about IPI and ICMS taxes. The record type 54 records that the system creates from table F76B001 contain data about PIS/PASEP and COFINS tax credits.

The system reads table F41112 to create record type 74 records that are based on transactions for which no nota fiscal exists, such as inventory adjustments.

What You Should Know About Processing Record Types 54, 74, and 75

The system generates record type 54 records from data in the Nota Fiscal - Detail (Fiscal Books) table (F76111B) and generates record type 74 records from data in the Item ASOF File table (F41112). The system then writes record type 75 records that are based on the data in record type 54 or record type 74 records.

Note. The information in this topic refers only to record type 54 records that are based on data in table F76111B. The system also creates record type 54 records that are based on data in the Nota Fiscal Taxes Header - Brazil table (F76B001), but it does not create record type 75 records that are based on those record type 54 records.

The system generates record types 54, 74, and 75 records according to these rules:

Record Type 54 Records That are Based on Tables F76111B and F76101B

The system creates record type 75 records that are based on the record type 54 records, if they exist, and based on record type 74 records, if they exist. The system writes only one record type 75 record for each item. The item data in table F76111B takes precedence over data in table F41112. In other words, if a record type 54 record and record type 74 record exist for an item, the system writes the data from record type 54 record to record type 75. You specify in processing options whether the system creates record type 74, 54, and 75 records.

If the system creates record type 75 records that are based on record type 54 records, the record type 75 records in the flat file contain values for these fields:

If the system creates record type 75 records that are based on record type 74 records, the record type 75 records in the flat file contain zeros for the previously mentioned fields.

Record Type 54 Records That are Based on Table F76B001

If table F7B001 contains an amount (other than zero) for PIS/PASEP or COFINS tax credits, the system sums the amounts for the taxes and writes a record type 54 to the flat file as illustrated in this table:

Segment Number

Segment Value

01 (Type)

54.

02 (CNPJ)

The CNPJ of the supplier on inbound transactions, or the CNPJ of the customer on outbound transactions.

03 (Model)

The Nota Fiscal Mode code.

04 (Series)

The nota fiscal. series number.

05 (Number)

The nota fiscal. number.

06 (CFOP)

The Transaction Nature Code from the first line of a multiple line nota fiscal.

07 (CST)

Zero

08 (Item Sequence)

993

09 (Item Code)

Blanks

10 (Quantity)

Zero

11 (Amount)

The sum of the PIS and COFINS taxes for the nota fiscal. from table F76B001.

12 (Discount Amount)

Zero

13 (ICMS Basis)

Zero

14 (ICMS Basis for Substitution Tax)

Zero

15 (IPI Amount)

Zero

16 (ICMS Rate)

Zero

Modifications to the Sintegra Flat File for 2003

As of January 2003, the format for the flat file for sending Sintegra data was modified by the Brazilian government. The JD Edwards EnterpriseOne system supports both the new format that is required by law Convenio ICMS 69/02 and the old format that is required by law Convenio ICMS 57/95.

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 topicRunning the Generate ICMS Magnetic Files - Sintegra Program

Select Fiscal Reports - Brazil (G76B111), Generate ICMS Magnetic Files - Sintegra.

Click to jump to top of pageClick to jump to parent topicSetting the Processing Options for Generate ICMS Magnetic Files - Sintegra (R76B201)

These processing options specify the company, dates, and type of notas fiscais and fiscal books with which you want to work.

Default

Although processing options are set up during system implementation, you can change processing options each time you run a program.

1. Fiscal Company

Specify the company for which you want to process nota fiscal data. If you leave this processing option blank, the system processes records for all companies.

2. From Date

Specify the beginning date of the nota fiscal for which you want to process data.

3. Thru Date

Use this processing option to specify the ending date of the nota fiscal for which you want to process data.

4. Print Report

Specify whether the system prints a verification report. The report is a dump of the text files. Values are:

Blank: Do not print a report.

1: Print a report.

5. Purpose of File

Specify the purpose of the text file. Values are:

1: Initial submission of text file.

2: Resubmission of text file.

3: Submission of information that was missing from initial submission.

4: Submission of text file with corrected information.

5: Submission of text file due to the original submission containing information for an incorrect State

6. Nature of Transactions

Specify the type of transactions contained in the text file.

7. Summarize Record Type 75

Specify how the system writes type 75 records to the text file. Values are:

1: Summarize records and write by Second Item Number, ICMS Substitution Code, ICMS Rate, and Reduction Rate.

2: Write records by Second Item Number.

File Properties

Although processing options are set up during system implementation, you can change processing options each time you run a program.

1. Directory Name

Specify the directory where the system saves the text file that it generates.

2. Text File Name

Specify the name of the text file.

3. Files by State

Specify whether the system creates separate text files for each state. The system creates separate text files for record type 54 and record type 55 records, and for record type 75 records that are based on record type 54 records. Values are:

Blank: Do not create separate text files. The system appends .TXT to the name that you entered in the Text File Name processing option.

1: Create separate text files. The system names each text file by preceding the name that you entered in the Text File Name processing option with the state code and appending .TXT to the name that you entered in the Text File Name processing option. For example, if you enter Outbound in the Text File Name processing option, for the state of São Paulo, the system writes the file name as: SPOUTBOUND.TXT.

4. Equipment Model

Specify the machine model where the text file was created. The system prints this information on a label that you can attach to a diskette.

5. Media Recording Density

Specify the media recording density. The system prints this information on a label that you can attach to a diskette.

Company

Although processing options are set up during system implementation, you can change processing options each time you run a program.

1. Contact Name

Specify the name of the person authorized to handle questions or problems about the text file.

2. Contact Telephone Number

Specify the telephone number of the person authorized to handle questions or problems about the text file.

3. Company Facsimile Number

Specify the number of the company's facsimile machine.

4. Street Address

Specify the street address of the company.

5. Building Number

Specify the building number of the company.

6. Additional Address Information

Specify additional address information for the company.

7. City or County

Specify the city or county for the company.

8. Zip Code

Specify the postal code number for the company.

9. Branch/Plant (Business Unit) Category Code

Enter the category code of the branch/plant (business unit) in which you have set up the Ownership Code. If you leave this processing option blank, the system uses category code 30.

Processing

Although processing options are set up during system implementation, you can change processing options each time you run a program.

1. Record type 50

Specify whether you want to create this type of record. Values are:

Blank: Do not create records for this record type.

1: Create records. The system lists nota fiscal headers and total amounts.

2. Record type 51

Specify whether you want to create this type of record. Values are:

Blank: Do not create records for this record type.

1: Create records. The system lists nota fiscal headers and total amounts.

3. Record type 53

Specify whether you want to create this type of record. Values are:

Blank: Do not create records for this record type.

1: Create records. The system lists nota fiscal headers and total amounts.

4. Record type 54

Specify whether you want to create this type of record. Values are:

Blank: Do not create records for this record type.

1: Create records. The system lists nota fiscal headers and total amounts.

5. Record type 55

Specify whether you want to create this type of record. Values are:

Blank: Do not create records for this record type.

1: Create records. The system lists nota fiscal headers and total amounts.

6. Record type 70

Specify whether you want to create this type of record. Values are:

Blank: Do not create records for this record type.

1: Create records. The system lists nota fiscal headers and total amounts.

7. Record type 75

Specify whether you want to create this type of record. Values are:

Blank: Do not create records for this record type.

1: Create records. The system lists nota fiscal headers and total amounts.

8. Record type 74

Specify whether the system creates records for record type 74. The Files by State processing option must be blank, and the Record type 74 processing option must be set to 1 to generate records for record type 74. Values are:

Blank: Do not create records for this record type.

1: Create records for record type 74.

9. Convenio

Specify the flat file format for the magnetic file. Values are:

Blank: Use the format that is required by law Convenio ICMS 31/99.

1: Use the format that is required by law Convenio ICMS 69/02.

NF Futura

Although processing options are set up during system implementation, you can change processing options each time you run a program.

1. Billing Invoice.

Specify the suffix for the transaction nature codes that represent billing invoices. The system reports notas fiscais that have transaction nature codes that end with the suffix that you enter as a Nota Fiscal Futura, and prints 0 (zero) for the tax amount on the report.

2. Delivery.

Specify the suffix for the transaction nature codes that represent the taxes for merchandise shipped after a billing invoice is sent. Notas fiscais that have transaction nature codes that end with the suffix that you enter are reported as a Nota Fiscal Futura.

Click to jump to parent topicPurging Incomplete Fiscal Book Records

This section provides an overview of purging incomplete fiscal book records, lists prerequisites, and discusses how to purge incomplete fiscal book records.

Click to jump to top of pageClick to jump to parent topicUnderstanding Purging Incomplete Fiscal Book Records

This program deletes the incomplete notas fiscais from the Nota Fiscal - Header (Fiscal Books) table (F76101B) and the Nota Fiscal - Detail (Fiscal Books) table (F76111B), and prints a report listing the records that were deleted. When you run this program, the system deletes notas fiscais that have a header record and no detail record, and those that have a detail record and no header record.

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 topicPurging Incomplete Fiscal Book Records

Select Fiscal Records - Brazil (G76B111), Integrity Report.

Click to jump to parent topicPrinting Fiscal Books Reports

Fiscal books reports provide supplementary data for the fiscal books that you submit to the government. You produce fiscal books reports for the same tax reporting period as the fiscal books.

This section lists prerequisites and discusses how to:

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 topicPrinting the Issuer Code List Report

The Issuer Code List report lists the codes that are associated with the suppliers which appear on the selected notas fiscais. You can generate this report from a menu option; the system automatically generates this report when you generate the Inbound Book report (R76B4000) in final mode. You send the Issuer Code List report to the appropriate government agency along with the Inbound Registry Fiscal Book.

Select Fiscal Records - Brazil (G76B111), Issuer Code List.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for Issuer Codes List (R76B4004)

Use these processing options to set default information.

Default

These processing options specify the company, and the beginning and ending dates for the notas fiscais that the system processes.

1. Fiscal Company:

Specify the company for which you want to process nota fiscal data. If you leave this processing option blank, the system processes records for all companies.

2. From Date

Specify the beginning date of the notas fiscais for which you want to process data.

3. Thru Date

Specify the ending date of the notas fiscais for which you want to process data.

Click to jump to top of pageClick to jump to parent topicPrinting the Product Codes List Report

The Product Code List report (R76B4005) provides a list of the items and their associated product codes that appear on the selected notas fiscais.

Select Fiscal Records - Brazil (G76B111), Product Code List.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for Product Codes List (R76B4005)

Use this processing option to set default information.

Default

This processing option specifies the company for which you want to process nota fiscal data.

1. Fiscal Company

Specify the company for which you want to process nota fiscal data. If you leave this processing option blank, the system processes records for all companies.

Click to jump to top of pageClick to jump to parent topicPrinting the Retained ICMS Report

This report lists the notas fiscais that contained ICMS substitution for a specified period. You generate this report by state, based on the client state, and send it to each state government.

Select Fiscal Reports - Brazil (G76B111), Notas Fiscais with Retained ICMS.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for Notas Fiscais With Retained ICMS (R76B4007)

Use these processing options to define how the system processes data.

Selection

Although processing options are set up during system implementation, you can change processing options each time you run a program.

1. Nota Fiscal Date

Specify the beginning date of the notas fiscais for which you want to process data.

2.. Fiscal Company

Specify the company for which you want to process nota fiscal data.

Click to jump to top of pageClick to jump to parent topicPrinting the Listing of Interstate Operations

This report lists the notas fiscais that you issued in a specified period. You generate the report by state, based on the customer state, and send it to each state government.

Select Fiscal Records - Brazil (G76B111), Listing of Interstate Operations.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for Interstate Operation Listing (R76B4008)

Use these processing options to set default values.

Default

These processing options specify the company, dates, and type of nota fiscal for which you want to process data.

1. Fiscal Company

Specify the company for which you want to process nota fiscal data. If you leave this processing option blank, the system processes records for all companies.

2. From Date

Specify the beginning date of the notas fiscais for which you want to process data.

3. Thru Date

Specify the ending date of the notas fiscais for which you want to process data.

4. Nota Fiscal Type

Specify whether you work with inbound or outbound notas fiscais. Values are:

E: Inbound

S: Outbound

Click to jump to top of pageClick to jump to parent topicPrinting the Interstate Operations for Inbound Transactions Report

This report summarizes taxes for inbound notas fiscais. The system groups the records by the issuer state. You send the report to the state where the company resides.

Select Fiscal Records - Brazil (G76B111), Interstate Operation Form - Inbound.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for the Interstate Operation Form - Inbound (R76B4009)

Use these processing options to specify default values.

Default

These processing options specify the company and dates for which you want to process nota fiscal data.

1. Fiscal Company

Specify the company for which you want to process nota fiscal data. If you leave this processing option blank, the system processes records for all companies.

2. From Date

Specify the beginning date of the notas fiscais for which you want to process data.

3. Thru Date

Specify the ending date of the notas fiscais for which you want to process data.

Click to jump to top of pageClick to jump to parent topicPrinting the Interstate Operations for Outbound Transactions Report

This report summarizes taxes on outbound notas fiscais. The system groups the records by the issuer state. You send the report to the state where the company resides.

Select Fiscal Records - Brazil (G76B111), Interstate Operation Form - Outbound.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for the Interstate Operation Form - Outbound (R76B4010)

Use these processing options to specify default values.

Default

These processing options specify the company and dates for which you want to process nota fiscal data.

1. Fiscal Company

Specify the company for which you want to process nota fiscal data. If you leave this processing option blank, the system processes records for all companies.

2. From Date

Specify the beginning date of the notas fiscais for which you want to process data.

3. Thru Date

Specify the ending date of the notas fiscais for which you want to process data.

Click to jump to top of pageClick to jump to parent topicPrinting the Annual Declaration - IPM Report

The Annual Declaration - IPM report provides a summary of the ICMS taxes paid for the year.

Select Fiscal Records - Brazil (G76B111). Annual Declaration - IPM.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for Annual Declaration - IPM (R76B4012)

Use these processing options to set default values.

Default

These processing options specify the company and dates for which you want to process nota fiscal data.

1. Fiscal Company

Specify the company for which you want to process nota fiscal data. If you leave this processing option blank, the system processes records for all companies.

2. From Date

Specify the beginning date of the notas fiscais for which you want to process data.

3. Thru Date

Specify the ending date of the notas fiscais for which you want to process data.

Click to jump to parent topicPrinting the DIPI Summaries and Statements

This section provides an overview of the DIPI summaries and statements report, lists a prerequisite, and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding the DIPI Summaries and Statements Report

The DIPI Summaries and Statements program (R76B4006) produces two reports that contain a summary of IPI taxes based on transaction nature codes:

The system determines the layout of the Ficha 23 and Ficha 24 reports by accessing the DIPI Inbound Report Line Defs UDC table (76B/DI) and the DIPI Outbound Report Line Defs UDC table (76B/DO). These UDC tables contain values for transaction nature codes in the Codes field, values for the report (ficha) in the Description 01 field, and line numbers in the Description 02 field.

When you run the DIPI Summaries and Statements program, the system:

For example, suppose these values exist in the 76B/DI UDC table:

Codes

Description 01

Description 02

111

23

01

114

23

05

211

23

01

235

23

04

312

23

08

394

23

10

When you run the DIPI Summaries and Statements program, the system includes all transactions that have a transaction nature code of 111 and 211 on line 01 of the Ficha 23 report.

FICHA 23 - Entradas e Creditos

The FICHA 23 - Entradas e Creditos report contains totals for three columns of data as described in this table:

Report

Columns

Totals

FICHA 23 - Entradas e Creditos (Inbounds and Credits)

Inbound transactions with credits (Com Creditos)

  • Inbound transactions for the domestic market (Entradas-Mercado Nacional).

  • Inbound transactions for foreign markets (Entradas-Mercado Externo).

  • Total of the inbound transactions for domestic and foreign markets (Total Das Entradas).

  • Total of other credits (Total de Outros Creditos). The system completes this field with zeros.

 

Inbound transactions without credits (Sem Creditos).

  • Inbound transactions for the domestic market (Entradas-Mercado Nacional).

  • Inbound transactions for foreign markets (Entradas-Mercado Externo).

  • Total of the inbound transactions for domestic and foreign markets (Total Das Entradas).

  • Total of other credits (Total de Outros Creditos). The system completes this field with zeros.

 

Inbound transactions with credited IPI tax (IPI Creditado)

  • Inbound transactions for the domestic market (Entradas-Mercado Nacional).

  • Inbound transactions for foreign markets (Entradas-Mercado Externo).

  • Total of the inbound transactions for domestic and foreign markets (Total Das Entradas).

  • Total of other credits (Total de Outros Creditos). The system completes this field with zeros.

  • Total of credited IPI (Total Do IPI Creditado).

The system adds up the amounts for records for the FICHA 23 - Entradas e Creditos report by transaction nature codes and prints the summed amounts for the codes on each line as follows:

FICHA 24 - Saidas e Debitos

The FICHA 24 - Saidas e Debitos report (Outbounds and Debits) contains totals for three columns of data as described in this table:

Report

Columns

Totals

FICHA 24 - Saidas e Debitos (Outbounds and Debits)

Outbound transactions with debits (Com Debitos)

  • Outbound transactions for the domestic market (Saidas-Mercado Nacional).

  • Outbound transactions for foreign markets (Saidas-Mercado Externo).

  • Total of the outbound transactions for domestic and foreign markets (Total Das Saidas). The system completes this field with zeros.

 

Outbound transactions without debits (Sem Debitos)

  • Outbound transactions for the domestic market (Saidas-Mercado Nacional).

  • Outbound transactions for foreign markets (Saidas-Mercado Externo).

  • Total of the outbound transactions for domestic and foreign markets (Total Das Saidas). The system completes this field with zeros.

 

Outbound transactions with debited IPI tax (IPI Debitado)

  • Outbound transactions for the domestic market (Saidas-Mercado Nacional).

  • Outbound transactions for foreign markets (Saidas-Mercado Externo).

  • Total of the outbound transactions for domestic and foreign markets (Total Das Saidas).

  • Total of other debits (Total de Outros Debitos). The system completes this field with zeros.

  • Total of debited IPI (Total Do IPI Debitado).

The system sums the amounts for records for the FICHA 24 - Saidas e Debitos report by transaction nature codes and prints the summed amounts for the codes on each line as follows:

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

Before you complete the tasks in this section, verify that the DIPI Inbound Report Line Definitions UDC table (76B/DI) and the DIPI Outbound Report Line Definitions UDC table (76B/DO) contain the values that you need to process the inbound and outbound transactions.

Click to jump to top of pageClick to jump to parent topicPrinting the DIPI Summaries and Statements Report

Select Fiscal Records - Brazil (G76B111). DIPI Summaries and Statements.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for DIPI Summaries and Statements (R76B4006)

Use these processing options to set default values.

Default

These processing options specify the company and dates for which you want to process nota fiscal data, and the beginning credit balance.

1. Fiscal Company

Specify the company for which you want to process nota fiscal data. If you leave this processing option blank, the system processes records for all companies.

2. From Date

Specify the beginning date of the notas fiscais for which you want to process data.

3. Thru Date

Specify the ending date of the notas fiscais for which you want to process data.

4. Credit Balance

Specify the period beginning credit balance for IPI taxes. Because the system does not carry over the balance from the previous month, you must enter the ending balance for last month as the beginning balance for this month. The ending balance for the previous month is on the IPI Verification report for that month. You generate the IPI Verification report when you run the Verification of IPI program (R76B4002).

Click to jump to parent topicPrinting the DIPI Annual Movements Report

This section provides an overview of the DIPI annual movements report, lists a prerequisite, and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding the DIPI Annual Movements Report

The DIPI Annual Movements program (R76B4011) produces a report that lists the customers who comprise the top 80 percent of the sales that are generated for a company, up to 100 customers. If more than 100 customers comprise the top 80 percent, the report lists only the top 100 customers.

The report lists the customers by each of these categories:

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

Set up the DIPI Annual Movements Report UDC table (76B/DA).

Click to jump to top of pageClick to jump to parent topicPrinting the DIPI Annual Movements Report

Select Fiscal Records - Brazil (G76B111), DIPI Annual Movements.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for DIPI Annual Movements (R76B4011)

Use these processing options to set default values.

Default

These processing options specify the company and dates for which you want to process nota fiscal data.

1. Fiscal Company:

Specify the company for which you want to process nota fiscal data. If you leave this processing option blank, the system processes records for all companies.

2. From Date

Specify the beginning date of the notas fiscais for which you want to process data.

3. Thru Date

Specify the ending date of the notas fiscais for which you want to process data.

Click to jump to parent topicGenerating Fiscal Books

This chapter provides an overview of each fiscal book that you can generate and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding the Fiscal Books to Generate for Brazil

The federal government in Brazil requires that you produce fiscal books according to a specified schedule. You electronically send the fiscal books to the government.

These applications generate fiscal books:

Inbound Registry Fiscal Book

The Inbound Registry batch program generates a report that meets the requirements for the Inbound Fiscal Book. The report includes information about inbound notas fiscais, including the transaction nature, state, value, and the tax amount and percentage.

In the detail section, the report totals the ICMS and IPI taxes on the notas fiscais for each date in the date range that you specify in the processing options.

In the summary section, the report totals ICMS tax by transaction nature for each state. You specify how the report handles IPI tax by setting processing options.

Outbound Registry Fiscal Book

The Outbound Registry batch program (R76B4001) generates a report that meets the requirements for the Outbound Fiscal Book. The report includes information about outbound notas fiscais, including the transaction nature, state, value, and the tax amount and percentage.

In the detail section, the report totals the ICMS and IPI taxes on the notas fiscais for each date in the date range that you specify in the processing options.

In the summary section, the report totals ICMS tax by transaction nature for each state. You specify how the report handles IPI tax by setting processing options.

IPI Verification Fiscal Book

This report produces a credit and debit summary of IPI tax amounts that is based on the inbound and outbound notas fiscais. If the company is subject to IPI taxes, you must generate this report every ten days.

Verification of ICMS

This report produces a credit and debit summary of ICMS tax amounts that is based on the inbound and outbound notas fiscais. You must generate this report monthly.

Inventory Records Fiscal Book

The system uses records in the Item ASOF File table (F41112) to create the Inventory Records Fiscal Book. Before you print the Inventory Records Fiscal Book, you must update the records in table F41112.

The system uses codes in these UDC tables to determine the tax values to include in columns for nonrecoverable ICMS taxes and the nonaccumulative COFINS and Pis/Pasep contributions:

Click to jump to top of pageClick to jump to parent topicPrinting the Inbound Registry Fiscal Book

Select Fiscal Reports - Brazil (G76B111), Inbound Registry.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for Inbound Registry (R76B4016)

Use these processing options to set default values, define how the system processes data, and specify the text to print at the end of the report.

Default

Although processing options are set up during system implementation, you can change processing options each time you run a program.

1. Fiscal Company

Specify the company for which you want to process nota fiscal data. If you leave this processing option blank, the system processes records for all companies.

2. From Date

Specify the beginning date of the notas fiscais for which you want to process data.

3. Thru Date

Specify the ending date of the notas fiscais for which you want to process data.

4. Proof/Final Mode

Specify whether the system runs the batch program in proof or final mode. Values are:

Blank: Run in proof mode.

1: Run in final mode.

5. Fiscal Book Code

Specify the type of fiscal book for which you want to convert data. You select a code from the Fiscal Book Code UDC (76/FB).

Processing

Although processing options are set up during JD Edwards EnterpriseOne implementation, you can change processing options each time you run a program.

1. Supplier Number

Specify whether the address book number or the Tax ID number of the supplier prints on the report. Values are:

Blank: Use the tax ID number (CNPJ)

1: Use the address book number

2. Monthly Summary

Specify whether a summary section prints on the report. Values are:

Blank: Do not print summary.

1: Print summary. The system prints a summary of ICMS and IPI tax amounts by Transaction Nature and tax rate percentage for the range of dates set by the From Date and Through Date processing options for this program.

3. Billing Invoices

Specify the suffix for the transaction nature codes that represent billing invoices. The system reports notas fiscais that have transaction nature codes that end with the suffix that you enter as a Nota Fiscal Futura, and prints 0 (zero) for the tax amount on the report.

Text

Although processing options are set up during system implementation, you can change processing options each time you run a program.

1. Text 1

Specify text that will print at the end of the report. The text you enter in this processing option prints next to the amount that you enter in the Amount 1 processing option.

2. Amount 1

Specify an amount that will print at the end of the report. The amount you enter in this processing option prints next to the text that you enter in the Text 1 processing option.

3. Text 2

Specify text that will print at the end of the report. The text you enter in this processing option prints next to the amount that you enter in the Amount 2 processing option.

4. Amount 2

Specify an amount that will print at the end of the report. The amount you enter in this processing option prints next to the text that you enter in the Text 2 processing option.

5. Text 3

Specify text that will print at the end of the report. The text you enter in this processing option prints next to the amount that you enter in the Amount 3 processing option.

6. Amount 3

Specify an amount that will print at the end of the report. The amount you enter in this processing option prints next to the text that you enter in the Text 3 processing option.

Click to jump to top of pageClick to jump to parent topicPrinting the Outbound Registry Fiscal Book

Select Fiscal Reports - Brazil (G76B111), Outbound Registry.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for Outbound Registry (R76B4001)

These processing options specify how the system creates the Outbound Fiscal Book. When you run this program in final mode, the system changes the status code for canceled notas fiscais to 997, changes the status code for all other notas fiscais to 987, and updates the last print date in the Fiscal Books Next Number Control - Brazil table (F7602B).

Default

Although processing options are set up during system implementation, you can change processing options each time you run a program.

1. Fiscal Company

Specify the company for which you want to process nota fiscal data. If you leave this processing option blank, the system processes records for all companies.

2. From Date

Specify the beginning date of the notas fiscais for which you want to process data.

3. Thru Date

Specify the ending date of the notas fiscais for which you want to process data.

4. Proof/Final Mode

Specify whether the system runs the batch program in proof or final mode. Values are:

Blank: Proof mode.

1: Final mode.

5. Fiscal Book Code

Specify the type of fiscal book for which you want to convert data. You select a code from the Fiscal Book Code UDC (76/FB).

6. IPI Tax Print

Specify whether the system prints details or a summary of IPI taxes, or does not print IPI taxes. Values are:

1: Print a line for every IPI tax record for each transaction nature code on a nota fiscal.

2: Print a summary of the IPI taxes for each nota fiscal.

3: IPI taxes are not printed.

Processing

Although processing options are set up during system implementation, you can change processing options each time you run a program.

1. Monthly Summary

Specify whether a summary section prints on the report. Values are:

Blank: Do not print summary.

1: Print summary. The system prints a summary of ICMS and IPI tax amounts by Transaction Nature and tax rate percentage for the range of dates set by the From Date and Through Date processing options for this program.

2. Billing Invoices

Specify the suffix for the transaction nature codes that represent billing invoices. The system reports notas fiscais that have transaction nature codes that end with the suffix that you enter as a Nota Fiscal Futura, and prints 0 (zero) for the tax amount on the report.

3. Delivery

Specify the suffix for the transaction nature codes that represent the taxes for merchandise shipped after a billing invoice is sent. Notas fiscais that have transaction nature codes that end with the suffix that you enter are reported as a Nota Fiscal Futura.

Text

Although processing options are set up during system implementation, you can change processing options each time you run a program.

1. Text 1

Specify text that will print at the end of the report. The text you enter in this processing option prints next to the amount that you enter in the Amount 1 processing option.

2. Amount 1

Specify an amount that will print at the end of the report. The amount you enter in this processing option prints next to the text that you enter in the Text 1 processing option.

3. Text 2

Specify text that will print at the end of the report. The text you enter in this processing option prints next to the amount that you enter in the Amount 2 processing option.

4. Amount 2

Specify an amount that will print at the end of the report. The amount you enter in this processing option prints next to the text that you enter in the Text 2 processing option.

5. Text 3

Specify text that will print at the end of the report. The text you enter in this processing option prints next to the amount that you enter in the Amount 3 processing option.

6. Amount 3

Specify an amount that will print at the end of the report. The amount you enter in this processing option prints next to the text that you enter in the Text 3 processing option.

Click to jump to top of pageClick to jump to parent topicPrinting the Outbound Registry for ISS Fiscal Book

Select Fiscal Reports - Brazil (G76B111), Outbound Registry - ISS.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for Outbound Registry - ISS (R76B4015)

These processing options specify how the system creates the Outbound Registry for ISS Fiscal Book.

When you run this program in final mode, the system changes the status code for canceled notas fiscais to 997, changes the status code for all other notas fiscais to 987, and updates the last print date in the Fiscal Books Next Number Control table (F7602B).

Default

Although processing options are set up during system implementation, you can change processing options each time you run a program.

1. Fiscal Company

Specify the company for which you want to process nota fiscal data. If you leave this processing option blank, the system processes records for all companies.

2. From Date

Specify the beginning date of the notas fiscais for which you want to process data.

3. Thru Date

Specify the ending date of the notas fiscais for which you want to process data.

4. Proof/Final Mode

Specify whether the system runs the batch program in proof or final mode. Values are:

Blank: Proof mode

1: Final mode

5. Services Nota Fiscal

Specify the Transaction Nature code that is associated with Services.

6. Fiscal Book Code

Specify the type of fiscal book for which you want to convert data. You select a code from the Fiscal Book Code UDC (76/FB).

Processing

Although processing options are set up during system implementation, you can change processing options each time you run a program.

1. Status Code 1

Select a code from the Activity/Status Codes UDC (40/AT) to represent canceled notas fiscais.

2. Status Code 2

Select a code from the Activity/Status Codes UDC (40/AT) to represent canceled notas fiscais.

3. Status Code 3

Select a code from the Activity/Status Codes UDC (40/AT) to represent canceled notas fiscais.

4. Status Code 4

Select a code from the Activity/Status Codes UDC (40/AT) to represent canceled notas fiscais.

Text

Although processing options are set up during system implementation, you can change processing options each time you run a program.

1. Text 1

Specify text that prints at the end of the report. You can enter up to 35 characters.

2. Text 2

Specify text that prints at the end of the report. You can enter up to 35 characters.

3. Text 3

Specify text that prints at the end of the report. You can enter up to 35 characters.

4. Text 4

Specify text that prints at the end of the report. You can enter up to 35 characters.

Click to jump to top of pageClick to jump to parent topicPrinting the IPI Verification Fiscal Book

Select Fiscal Reports - Brazil (G76B111), Verification of IPI.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for Verification of IPI (R76B4002)

These processing options specify how the system writes information for verifying IPI taxes. When you run this program in final mode, the system changes the status code for canceled notas fiscais to 997, changes the status code for all other notas fiscais to 987, and updates the last print date in the Fiscal Books Next Number Control table (F7602B).

Default

Although processing options are set up during system implementation, you can change processing options each time you run a program.

1. Fiscal Company

Specify the company for which you want to process nota fiscal data. If you leave this processing option blank, the system processes records for all companies.

2. From Date

Specify the beginning date of the notas fiscais for which you want to process data.

3. Thru Date

Specify the ending date of the notas fiscais for which you want to process data.

4. Fiscal Book Code

Specify the type of fiscal book for which you want to convert data. You select a code from the Fiscal Book Code UDC (76/FB).

Processing

Although processing options are set up during system implementation, you can change processing options each time you run a program.

1. Proof/Final Mode

Specify whether the system runs the batch program in proof or final mode. Values are:

Blank: Proof mode.

1: Final mode.

2. Billing Invoice

Specify the suffix for the transaction nature codes that represent billing invoices. The system reports notas fiscais that have transaction nature codes that end with the suffix that you enter as a Nota Fiscal Futura, and prints 0 (zero) for the tax amount on the report.

4. Delivery

Specify the suffix for the transaction nature codes that represent the taxes for merchandise shipped after a billing invoice is sent. Notas fiscais that have transaction nature codes that end with the suffix that you enter are reported as a Nota Fiscal Futura.

Click to jump to top of pageClick to jump to parent topicPrinting the Verification of ICMS

Select Fiscal Reports - Brazil (G76B111), Verification of ICMS.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for Verification of ICMS (R76B4003)

These processing options specify how the system writes information for verifying ICMS taxes. When you run this program in final mode, the system changes the status code for canceled notas fiscais to 997, changes the status code for all other notas fiscais to 987, and updates the last print date in the Fiscal Books Next Number Control table (F7602B).

Default

Although processing options are set up during system implementation, you can change processing options each time you run a program.

1. Fiscal Company

Specify the company for which you want to process nota fiscal data. If you leave this processing option blank, the system processes records for all companies.

2. From Date

Specify the beginning date of the notas fiscais for which you want to process data.

3. Thru Date

Specify the ending date of the notas fiscais for which you want to process data.

4. Fiscal Book Code

Specify the type of fiscal book for which you want to convert data. You select a code from the Fiscal Book Code UDC (76/FB).

Processing

Although processing options are set up during system implementation, you can change processing options each time you run a program.

1. Proof/Final Mode

Specify whether the system runs the batch program in proof or final mode. Values are:

Blank: Proof mode

1: Final mode

2. Billing Invoice

Specify the suffix for the transaction nature codes that represent billing invoices. The system reports notas fiscais that have transaction nature codes that end with the suffix that you enter as a Nota Fiscal Futura, and prints 0 (zero) for the tax amount on the report.

3. Delivery

Specify the suffix for the transaction nature codes that represent the taxes for merchandise shipped after a billing invoice is sent. Notas fiscais that have transaction nature codes that end with the suffix that you enter are reported as a Nota Fiscal Futura.

4. Summary by Rate

Specify whether the system prints a summary by ICMS tax interest rate. The system will break and print summaries when the rate changes.

Click to jump to top of pageClick to jump to parent topicPrinting the Inventory Records Fiscal Book

Select Fiscal Reports - Brazil (G76B111), Inventory Records.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for Inventory Record (R76B4013)

Use these processing options to define default values.

Default

These processing options specify how the system creates the Inventory Records Fiscal Book.

1. Fiscal Company

Specify the company for which you want to process nota fiscal data. If you leave this processing option blank, the system processes records for all companies.

2. Month

Enter a two-digit value for the month for which the system processes records. For example, enter 05 for May. You must complete this processing option.

3. Year

Specify the year on which to report. Enter a four-digit value.

4. Items with Zero Balance

Specify whether the system includes items with a zero balance on the report. Values are:

Blank: Do not include items with a zero balance on the report.

1: Include items with a zero balance on the report.

5. Proof/Final Mode

Specify whether the system runs the batch program in proof or final mode. Values are:

Blank: Proof mode

1: Final mode.

6. Fiscal Book Code

Specify the type of fiscal book for which you want to convert data. You select a code from the Fiscal Book Code UDC (76/FB).

Click to jump to top of pageClick to jump to parent topicPrinting the Manufacturing and Inventory Control Fiscal Book

Select Fiscal Reports - Brazil (G76B111), Manufacturing and Inventory Control.

Click to jump to top of pageClick to jump to parent topicSetting Processing Options for Record of Manufacturing Control and Inventory (R76B4014)

Use these processing options to specify how the system creates the Manufacturing and Inventory Control Fiscal Book.

Default

Although processing options are set up during system implementation, you can change processing options each time you run a program.

1. Fiscal Company

Specify the company for which you want to process nota fiscal data. If you leave this processing option blank, the system processes records for all companies.

2. Month

Enter a two-digit value for the month for which the system processes records. For example, enter 05 for May. You must complete this processing option.

3. Year

Specify the year on which to report. Enter a four-digit value.

4. Proof/Final Mode

Specify whether the system runs the batch program in proof or final mode. Values are:

Blank: Proof mode

1: Final mode.

5. Third Item Number

Specify whether the system prints the third item number on the report. Values are:

Blank: Do not print the third item number.

1: Print the third item number.

6. Fiscal Book Code

Specify the type of fiscal book for which you want to convert data. You select a code from the Fiscal Book Code UDC (76/FB).