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:

When you set the Record Type 74 processing option to 1, the system creates records from data in table F41112. You can populate table F41112 only on a monthly basis. Therefore, the data that the system uses to populate records for record type 74 always encompasses an entire month, even when you set the From Date and Thru Date processing options to encompass a period of less than a month.
For example, if you set the From Date processing option to December 1, 2010, and the Thru Date processing option to December 15, 2010, the system applies that reporting period to all record types except record type 74. For record type 74, the system populates records for the period of December 1, 2010, through December 31, 2010.

The system generates these records when you set the processing options as follows:

Processing Options	Results
Processing options are set as follows: Record type 54 = 1 Record type 74 = 1 Record type 75 = 1 Files by State = 1	The system writes to the flat file as follows: The system does not generate record type 74 records when the Files by State processing option is set to 1, even when the Record type 74 processing option is set to 1. Consequently, the system does not generate record type 75 records that are based on record type 74 records when the Files by State processing option is set to 1. The system generates record type 54 records from data in table F7611B and then generates record type 75 records as follows: If both table F76111B and table F41112 contain data for an item, the system writes a record type 54 record and a record type 75 record that is based on the record type 54 record; it does not create a record type 74 record for the item. If the system writes a record type 54 record for the item, the system writes a separate text file for each state for the record type 54 record and the record type 75 record. The system writes a single record type 75 record for each item from record type 54 records.
Processing options are set as follows: Record type 54 = 1 Record type 74 = 1 Record type 75 = 1 Files by State = 0	The system writes to the flat file as follows: The system generates record type 54 records from data in table F76111B and record type 74 records from data in table F41112, and then it generates record type 75 records as follows: If both table F76111B and table F41112 contain data for an item, the system writes a record type 54 record and a record type 75 record that is based on the record type 54 record, and a record type 74 record for the item. The system does not create a record type 75 record that is based on the record type 74 record. The system generates record type 74 records and record type 75 records that are based on record type 74 records, only when no data for an item exists in table F76111B and a quantity for an item exists in table F41112. The system writes a single record type 75 record for each item from record type 54 and record type 74 records. Record type 75 records that are based on record type 74 records contain no tax data because they are based on table F41112.

Processing Options

Results

Processing options are set as follows:

Record type 54 = 1
Record type 74 = 1
Record type 75 = 1
Files by State = 1

The system writes to the flat file as follows:

The system does not generate record type 74 records when the Files by State processing option is set to 1, even when the Record type 74 processing option is set to 1. Consequently, the system does not generate record type 75 records that are based on record type 74 records when the Files by State processing option is set to 1.
The system generates record type 54 records from data in table F7611B and then generates record type 75 records as follows:
If both table F76111B and table F41112 contain data for an item, the system writes a record type 54 record and a record type 75 record that is based on the record type 54 record; it does not create a record type 74 record for the item.
If the system writes a record type 54 record for the item, the system writes a separate text file for each state for the record type 54 record and the record type 75 record.
The system writes a single record type 75 record for each item from record type 54 records.

Processing options are set as follows:

Record type 54 = 1
Record type 74 = 1
Record type 75 = 1
Files by State = 0

The system writes to the flat file as follows:

The system generates record type 54 records from data in table F76111B and record type 74 records from data in table F41112, and then it generates record type 75 records as follows:
If both table F76111B and table F41112 contain data for an item, the system writes a record type 54 record and a record type 75 record that is based on the record type 54 record, and a record type 74 record for the item. The system does not create a record type 75 record that is based on the record type 74 record.
The system generates record type 74 records and record type 75 records that are based on record type 74 records, only when no data for an item exists in table F76111B and a quantity for an item exists in table F41112.
The system writes a single record type 75 record for each item from record type 54 and record type 74 records.
Record type 75 records that are based on record type 74 records contain no tax data because they are based on table F41112.