## (BRA) Filtering Records for IN86 and IN89 Tax Reporting

This chapter provides overviews of IN86 and IN89 tax reporting, filter programs, and tables, and discusses how to:

- Purge IN86 and IN89 work tables.

- Populate the work and complementary tables for journal entries.

- Populate the work and complementary tables for account balances.

- Populate the work and complementary tables for supplier vouchers and payments.

- Populate the work and complementary tables for customer receipts.

- Populate the work and complementary tables for customer invoices.

- Populate the work and complementary tables for fixed assets.

- Populate the work and complementary tables for storage control.

- Populate the work tables for inventory records.

- Populate the work and complementary tables for notas fiscais for services.

- Populate the work and complementary tables for merchandise notas fiscais issued by Company.

- Populate the work and complementary tables for Merchandise Notas Fiscais Issued by Supplier.

- Populate the work and complementary tables for Inbound Service Nota Fiscal Third Parties for IN89.

- Populate the work and complementary tables for bills of material.

### Understanding IN86 and IN89 Tax Reporting for Brazil

IN86 and IN89 refer to legal reporting requirements in Brazil. These requirements requires businesses to report all of their business transactions that occur over a period of time using magnetic media. The government defines the period of time, the required information, and the magnetic media layout. The government also allows businesses to submit additional information with their transaction data.

Typically, the government informs a company that it has been selected for audit and that the company is required to make an IN86 or IN89 submission for the business transactions that occurred within a reporting date range. The company then has 20 work days in which to remit the required submission to the government.

JD Edwards EnterpriseOne software provides a solution for and supports IN86 and IN89 tax reporting only for data that is stored in JD Edwards EnterpriseOne tables. For example, JD Edwards EnterpriseOne tables for Brazil do not store payroll data, so the system does not support IN86 or IN89 data for payroll data.

Brazilian government specifications allow companies to include additional fields in the text files for reporting or to modify the length of fields. To include additional fields or modify the length of the fields, you must customize the programs that are provided by the JD Edwards EnterpriseOne system. JD Edwards EnterpriseOne software does not support changes that you make to the programs that JD Edwards EnterpriseOne software provides.

Terms and Concepts for IN86 and IN89 Tax Reporting

Become familiar with the terms and concepts shown in this table before you process data for IN86 or IN89 tax reporting:

Term | Description
Source Tables | The JD Edwards EnterpriseOne tables from which the system filters data to populate the work and complementary tables. For example, the system filters data from the Nota Fiscal - Detail (Fiscal Books) table (F76111B) to populate the IN86-Work Table for Individuals and Legal Entities table (F76B8601).
Work Tables | The tables that the IN86 and IN89 filter programs populate with transaction data from the source tables.
Complementary Tables | The shared tables that the IN86 and IN89 filter programs populate with auxiliary data from the source tables.
IN86 and IN89 Filter programs | The IN86 and IN89 programs that you run to populate the work tables and complementary tables. Running the filter programs is the first step in preparing data for IN86 and IN89 tax reporting.
IN86 and IN89 Generate programs | The programs that you run to produce the data and text files that you send to the government for IN86 and IN89 tax reporting. Running the generate program is the final step in preparing the data that is contained in source tables for reporting.
Leiame.txt File | The Portuguese name for the Readme.txt file that you submit to the government for IN86 and IN89 tax reporting. This text file must be submitted in Portuguese. The system produces a Leiame.txt file when you run a generate program.
Data Sample | An Adobe Acrobat file (PDF) that contains the first and last 30 records from the data file. The data sample consists of the text file data-strings in the same format as they appear in the data file; the system does not format the data sample with column headings. You must submit a printed copy of the PDF to the government. The system produces a data sample when you run a generate program.
Cover Letter | A printed copy of the Leiame.txt file that you submit for IN86 and IN89 reporting.

### Understanding IN86 and IN89 Filter Programs

Running the filter programs is the first step in producing the data for IN86 and IN89 tax reporting. A filter program reads the appropriate source tables and populates the associated work tables and complementary tables. If the filter program completes its run without errors, the report displays a message that it completed successfully. If the system encounters an error, the report displays a message stating that it did not complete successfully. In some cases, such as when you do not complete the processing options with valid values, the report also displays an error message.

Filter programs populate both work tables and complementary tables. The system populates tables according to the rules shown in this table:

Table Type | Rules
Work Table | When populating a work table, the system writes to the table according to the rules for that particular table. Additionally, if you run a filter program over the same source tables without first purging the records in the work table, the system updates the records in the work table with any changed data from the source table. For example, when you run the IN86-Filter Supplier Vouchers and Payments program (R76B8601), the system populates the IN86-Work Table for Suppliers and Customers (F76B8602) with one record for each transaction. If you change a voucher's gross amount in the source table and then rerun the IN86-Filter Supplier Vouchers/Payments program, the system updates the voucher amount in table F76B8602.
Complementary Table | When populating a complementary table, the system writes one record for the first occurrence of the auxiliary information that is contained in the complementary table. If the auxiliary information appears more than once in the source table, the Update Date field reflects the earliest date. If you run more than one filter program that populates a complementary table, the system updates the Update Date field to reflect the earliest date if a record for the auxiliary information already exists in the Complementary Table. The system does not update any other fields. For example, when you run the IN86-Filter for Mdse NF Issued by Supplier program (R76B100E), the system populates the IN86-Work Table for Individuals and Legal Entities (F76B8601) table. If you have not purged table F76B8601 before running another filter program that populates the table, the system appends records to the table for auxiliary information, or it updates the Update Date field in existing records to the earliest date.

Several filter programs might populate the same table. For example, both the IN86-Filter for Mdse NF Issued by Supplier (R76B100E) and the IN86-Filter for Services Outbound Nota Fiscal (R76B100C) programs populate the IN86-Work Table for Individuals and Legal Entities (F76B8601). You should run all of the programs that are needed for reporting purposes before you run the programs to generate the data and text files for shared tables.

### Understanding How the System Populates the IN86-Work Table for Business Unit Table

The system populates the IN86-Work Table for Business Unit table (F76B006) when you run one of these filter programs:

- IN86-Filter for Journal Entries (R76B911).

- INSS/IN89-Filter for Journal Entries (R76B911).

- IN86-Filter for Account Balance (R76B902).

- INSS/IN89-Filter for Account Balance (R76B902).

After you have processed all of the relevant records, table F76B006 contains each business unit name and description for the journal entry and account balance records.

When the system populates table F76B006, it creates records according to these rules:

- If a record for a business unit does not exist in table F76B006, the system creates a new record with the business unit information.

- If a record for the business unit does exist, the system compares the date in the Update Date field to the general ledger date (data item DGJ) of the transaction being processed.

  If the general ledger date is earlier than the date in the Update Date field, the system updates the Update Date field with the general ledger date.

### Understanding How the System Populates the IN86-Work Table for Account Master Table

The IN86-Work Table for Account Master (F76B901) captures data about the date of the first occurrence of an account.

The system populates table F76B901 when you run one of these filter programs:

- IN86-Filter for Journal Entries (R76B911).

- INSS/IN89-Filter for Journal Entries (R76B911).

- IN86-Filter for Account Balance (R76B902).

- INSS/IN89-Filter for Account Balance (R76B902).

- IN86-Filter Supplier Vouchers/Payments (R76B8601).

- INSS/IN89-Filter Supplier Vouchers/Payments (R76B8601).

- IN86-Filter Customer Receipts (R76B8605).

- INSS/IN89-Filter Customer Receipts (R76B8605).

- IN86-Filter Customer Invoices (R76B8604).

- INSS/IN89-Filter Customer Invoices (R76B8604).

- IN86-Filter Fixed Assets (R76B5200).

- INSS/IN89-Filter Fixed Assets (R76B5200).

- INSS/IN89-Fltr-3rd Party Srvs-Inbound NF (R76B100H).

After you have processed all of the relevant records, table F76B901 contains the date of the first occurrence of an account.

When the system populates table F76B901, it creates records according to these rules:

- If a record for an account does not exist in table F76B901, the system creates a new record with the account information.

- If a record for the account does exist, the system compares the date in the Update Date field to the general ledger Date field (data item DGJ) of the transaction being processed. If the date in the G/L Date field is earlier than the date in the Update Date field, the system updates the Update Date field with the date from the G/L Date field.

### Understanding How the System Populates the IN86-Work Table for Individuals and Legal Entities Table

The IN86-Work Table for Individuals and Legal Entities (F76B8601) captures data about the individuals and legal entities for which you capture transaction data.

The system populates table F76B8601 when you run one of these filter programs:

- IN86-Filter Supplier Vouchers/Payments (R76B8601).

- INSS/IN89-Filter Supplier Vouchers/Payments (R76B8601).

- IN86-Filter Customer Receipts (R76B8605).

- INSS/IN89-Filter Customer Receipts (R76B8605).

- IN86-Filter Customer Invoices (R76B8604).

- INSS/IN89-Filter Customer Invoices (R76B8604).

- IN86-Filter for Services Outbound NF (R76B100C).

- INSS/IN89-Fltr -Services Outbound NF (R76B100C).

- IN86-Filter for Mdse NF by CO (R76B100D).

- INSS/IN89-Fltr-Mdse NF issued by CO (R76B100D).

- IN86-Filter for Mdse NF by Supplier (R76B100E).

- INSS/IN89-Fltr-Msde NF issued by Supplier (R76B100E).

- INSS/IN89-Fltr-3rd Party Srvs-Inbound NF (R76B100H).

After you have processed all of the relevant records, table F76B8601 contains the date of the first occurrence of an individual or legal entity.

When the system populates table F76B8601, it creates records according to these rules:

- If a record for an individual or legal entity does not exist in table F76B8601, the system creates a new record with the appropriate information.

- If a record for the individual or legal entity does exist, the system compares the date in the Update Date field (data item DGJ) in table F76B8601 to the G/L Date field (data item DGJ) in the source table. If the date in the G/L Date field is earlier than the date in the Update Date field, the system updates the Update Date field with the date from the G/L Date field.

### Understanding How the System Populates the IN86-Work Table for Transaction Nature Table

The system populates the IN86-Work Table for Transaction Nature table (F76B400F) when you run one of these filter programs:

- IN86-Filter for Mdse NF by Supplier (R76B100E).

- INSS/IN89-Fltr-Mdse NF issued by Supplier (R76B100E).

- IN86-Filter for Mdse NF by CO (R76B100D).

- INSS/IN89-Fltr-Mdse NF issued by CO (R76B100D).

After you have processed all of the relevant records, table F76B400F contains the date of the first occurrence of the nature of the operation. The nature of the operation is a combination of a transaction nature code (data item BNOP) and a transaction nature suffix (data item BSOP).

When the system populates table F76B400F, it creates records according to these rules:

- If a record for a code/suffix combination does not exist in table F76B400F, the system creates a new record with the code/suffix combination information.

- If a record for the combination does exist, the system compares the date in the Update Date field in table F76B400F to the Fiscal Issue Date (data item BRADLJ) of the record being processed. If the Fiscal Issue Date is earlier than the date in the Update Date field, the system updates the Update Date field with the Fiscal Issue Date.

### Understanding How the System Populates the IN86-Work Table for Item Number and Service Code Table

The system populates the IN86-Work Table for Item Number and Service Code table (F76B400G) when you run one of these filter programs:

- IN86-Filter for Storage Control (R76B100A).

- INSS/IN89-Filter for Storage Control (R76B100A).

- IN86-Filter for Inventory Records (R76B100B).

- INSS/IN89-Filter for Inventory Records (R76B100B).

- IN86-Filter for Services Outbound NF (R76B100C).

- INSS/IN89-Fltr- Services Outbound NF (R76B100C).

- IN86-Filter for Mdse NF by CO (R76B100D).

- INSS/IN89-Fltr-Mdse NF Issued by CO (R76B100D).

- IN86-Filter for Mdse NF by Supplier (R76B100E).

- INSS/IN89-Fltr- Mdse NF Issued by Supplier (R76B100E).

- INSS/IN89-Fltr-3rd Party Srvs-Inbound NF (R76B100H).

- IN86-Filter for Bill of Material (R76B3000).

- INSS/IN89-Filter for Bill of Material (R76B3000).

After you have processed all of the relevant records, table F76B400G contains the date of the first occurrence of the item number (data item LITM).

When the system populates table F76B400G, it creates records according to these rules:

- If a record for an item number does not exist in table F76B400G, the system creates a new record with the item number.

- If a record for the item number does exist, the system compares the date in the Update Date field to the Effective From Date (data item IXEFFF) of the record being processed. If the Effective From Date is earlier than the date in the Update Date field, the system updates the Update Date field with the Effective From Date.

### Purging IN86 and IN89 Work Tables

This section provides an overview of the purge programs and discusses how to:

- Run the purge program.

- Set processing options for the purge programs.

#### Understanding the Purge Program

You use the IN86-Purge Work Tables program (R76B8610) or the INSS/IN89 Purge Work Tables program (R76B8610) to delete all of the records from the specified IN86 and IN89 work tables and complementary tables. You specify the tables to purge in the processing options. You typically run program R76B8610 before you begin processing records for a new reporting period.

Additionally, you might run program R76B8610 to clear the records from a specific work table or complementary table prior to a re-running a filter program that populates the work table or complementary table.

#### Running the Purge Programs

Use one of these navigations to access the R76B8610 program:

Select Brazil IN86 (G76BIN86), IN86-Purge Work Tables.

Select Brazil INSS/IN89 (G76BINSS), INSS/IN89 Purge Work Tables.

#### Setting Processing Options for IN86-Purge Work Table (R76B8610) and INSS/IN89-Purge Work Table (R76B8610)

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

Tables

For each processing option, enter 1 to clear the table, or leave the processing option blank to retain the records in the table.

Processing options are:

- 1. F76B006 - IN86 Work Table for Business Unit

- 2. F76B8200 - IN86 Work Table for Fixed Assets

- 3. F76B8601 - IN86 Work Table for Individual and Legal Entities

- 4. F76B8602 - IN86 Work Table for Suppliers and Customers

- 5. F76B901 - IN86 Work Table for Account Master

- 6. F76B902 - IN86 Work Table for Account Balance

- 7. F76B911 - IN86 Work Table for Journal Entries

- 8. F76B400A - IN86 Work Table for Storage Control

- 9. F76B400B - IN86 Work Table for Inventory Records

- 10. F76B400F - IN86 Work Table for Transaction Nature

- 11. F76B400G - IN86 Work Table for Item Number and Service Code

- 12. F76B410C and F76B411C - IN86 Header and Detail for Services Outbound Nota Fiscal

- 13. F76B410D and F76B411D - IN86 Header and Detail for Merchandise Nota Fiscal Issued by CO

- 14. F76B410E and F76B411E - IN86 Header and Detail for Merchandise Nota Fiscal Issued by Supplier

- 15. F76B3010 - IN86 Work Table for Item Part List

- 16. F76B410H - INSS Work Table for Third Party Inbound Transactions

### Populating the Work and Complementary Tables for Journal Entries for IN86 and IN89

This section provides an overview of the work and complementary tables for journal entries and discusses how to:

- Run the IN86-Filter for Journal Entries (R76B911) and INSS/IN89- Filter for Journal Entries (R76B911) programs.

- Set processing options for the IN86-Filter for Journal Entries (R76B911) and the INSS/IN89- Filter for Journal Entries (R76B911) programs.

#### Understanding the Work and Complementary Tables for Journal Entries

To generate journal entry records for IN86 or IN89, you run the IN86-Filter for Journal Entries program (R76B911) or the INSS/IN89-Filter for Journal Entries program (R76B911). Program R76B911 reads these source tables:

- Account Ledger (F0911)

- Account Master (F0901)

- Business Unit Master (F0006)

This table shows the tables that the system populates when you run program R76B911:

Work Table | Complementary Tables
IN86-Work Table for Journal Entries (F76B911) | IN86-Work Table for Business Unit (F76B006)
Not applicable | IN86-Work Table for Account Master (F76B901)

Program R76B911 processes journal entry transactions at the lowest level of detail that is available. The system processes only the transactions that meet these criteria:

- The ledger type is equal to AA.

- The posting code is equal to P.

The transactions were posted within the date range that you specify in the processing options.

#### Running the IN86-Filter for Journal Entries (R76B911) and the INSS/IN89- Filter for Journal Entries (R76B911) Programs

Select IN86 Data Filter (G76BIN8601), IN86-Filter for Journal Entries.

Select INSS/IN89 Data Filter (G76BINSS01), INSS/IN89-Filter for Journal Entries.

Both navigations access the R76B911 program.

#### Setting Processing Options for the IN86-Filter for Journal Entries (R76B911) and the INSS/IN89- Filter for Journal Entries (R76B911) Programs

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

Select

1. From Date and 2. Thru Date | Specify the beginning or end of the reporting date range. Blank is not a value.

### Populating the Work and Complementary Tables for Account Balances for IN86 and IN89

This section provides an overview of the work and complementary tables for account balances and discusses how to:

- Run the IN86-Filter for Account Balance (R76B902) and INSS/IN89-Filter for Account Balance (R76B902) programs.

- Set processing options for the IN86-Filter for Account Balance (R76B902) and the INSS/IN89-Filter for Account Balance (R76B902) programs.

#### Understanding Work and Complementary Tables for Account Balances

To generate account balances records for IN86 or IN89, you run the IN86-Filter for Account Balance program (R76B902) or the INSS/IN89-Filter for Account Balance program (R76B902). Program R76B902 reads these source tables:

- Account Balances (F0902)

- Account Debit Balances (F0902A)

- Account Master (F0901)

- Business Unit Master (F0006)

This table show the tables that the system populates when you run program R76B902:

Work Tables | Complementary Tables
IN86-Work Table for Account Balance (F76B902) | IN86-Work Table for Business Unit (F76B006)
Not applicable | IN86-Work Table for Account Master (F76B901)

Program R76B902 does these process steps:

- Processes account balances at the lowest level of detail available. For each line in table F0902, the system writes a separate record to table F76B902 for each month within the date range that you specify. For example, if the date range encompasses accounting periods 1 through 3, the system writes three lines for each record in table F0902 - one for each accounting period.

- If the Account Balance by Currency option is enabled in the Company Constants, the system summarizes the records by the base currency codes.

- Uses a beginning balance of zero for revenue accounts.

- Assumes that the Fiscal Date Pattern is based on a calendar year. For example, the system assumes that period 1 is January, period 2 is February, and so on.

The system processes only the accounts that meet these criteria:

- The ledger type is equal to AA.

- The balance during the reporting period is not zero.

- The transactions were posted within the date range that you specify in the processing options.

#### Running the IN86-Filter for Account Balance (R76B902) and the INSS/IN89-Filter for Account Balance (R76B902) Programs

Select IN86 Data Filters (G76BIN8601), IN86-Filter for Account Balance.

Select INSS/IN89 Data Filters (G76BINSS01), INSS/IN89-Filter for Account Balance.

#### Setting Processing Options for the IN86-Filter for Account Balance (R76B902) and the INSS/IN89-Filter for Account Balance (R76B902) Programs

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

Select

1. Fiscal Year | Specify the fiscal year of the reporting period. Enter a two-digit value. For example, for the year 2003, enter 03. Blank is not a value.
2. From Period and 3. Thru Period | Specify the first period or the last period for which you want to process records. Blank is not a value.

### Populating the Work and Complementary Tables for Supplier Vouchers and Payments for IN86 and IN89

This section provides an overview of the work and complementary tables for supplier vouchers and payments and discusses how to:

- Run the IN86-Filter Supplier Vouchers/Payments (R76B8601) and INSS/IN89- Filter Supplier Vouchers/Payments (R76B8601) programs.

- Set processing options for the IN86-Filter Supplier Vouchers/Payments (R76B8601) and the INSS/IN89- Filter Supplier Vouchers/Payments (R76B8601) programs.

#### Understanding Work and Complementary Tables for Supplier Vouchers and Payments

To generate supplier voucher and payment records for IN86 or IN89, you run the IN86-Filter Supplier Vouchers/Payments program (R76B8601) or the INSS/IN89-Filter Supplier Vouchers/Payments program (R76B8601). This program reads these source tables:

- Accounts Payable Ledger (F0411).

- Accounts Payable Matching Document Detail (F0414).

- Accounts Payable - Matching Document (F0413).

This table shows the tables that the system populates when you run program R76B8601:

Work Table | Complementary Tables
IN86-Work Table for Suppliers and Customers (F76B8602) | IN86-Work Table for Individuals and Legal Entities (F76B8601)
| IN86-Work Table for Account Master (F76B901)

Program R76B8901 processes accounts payable transactions that were posted within the date range that you specify in the processing options and applies these rules:

- Excludes unposted vouchers, voided vouchers, and audit trail records for voided vouchers.

- Excludes unposted payments, voided payments, currency gain and loss records.

#### Prerequisite

Verify that the correct special handling codes are associated with the appropriate codes in the Document Type - All Documents UDC table (00/DT).

#### Running the IN86-Filter Supplier Vouchers/Payments (R76B8601) and INSS/IN89- Filter Supplier Vouchers/Payments (R76B8601) Programs

Select IN86 Data Filters (G76BIN8601), IN86-Filter Supplier Vouchers/Payments.

Select INSS/IN89 Data Filters (G76BINSS01), INSS/IN89-Filter Supplier Vouchers/Payments.

#### Setting Processing Options for the IN86-Filter Supplier Vouchers/Payments (R76B8601) and the INSS/IN89- Filter Supplier Vouchers/Payments (R76B8601) Programs

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

Select

1. From Date and 2. Thru Date | Specify the beginning or the end of the reporting date range. You must complete this processing option.

### Populating the Work and Complementary Tables for Customer Receipts for IN86 and IN89

This section provides an overview of the work and complementary tables for customer receipts and discusses how to:

- Run the IN86-Filter Customer Receipts (R76B8605) and INSS/IN89-Filter Customer Receipts (R76B8605) programs.

- Set processing options for the IN86-Filter Customer Receipts (R76B8605) and the INSS/IN89-Filter Customer Receipts (R76B8605) programs.

#### Understanding the Work and Complementary Tables for Customer Receipts

To generate customer receipts records for IN86 or IN89, you run the IN86-Filter Customer Receipts program (R76B8605) or the INSS/IN89-Filter Customer Receipts program (R76B8605). Program R76B8605 reads the A/R Check Detail File (F03B14) table.

This table shows the tables that the system populates when you run the R76B8605 program:

Work Tables | Complementary Tables
IN86-Work Table for Suppliers and Customers (F76B8602) | IN86-Work Table for Individuals/Legal Entities (F76B8601)
Not applicable | IN86-Work Table for Account Master (F76B901)

Program R76B8605 writes one record to table F76B8602 for each record in table F03B14 and applies these rules:

- Sorts data by the Account ID (data item AID), then by the Address Number (data item AN8), and then by the Date (data item DGJ).

  You cannot change the data sequencing.

- Excludes unposted records.

- Excludes voided records.

- Excludes draft and rounding records. The user can delete or change this data selection.

- Writes amounts as positive amounts.

- Populates the Operation Type field (data item OPBR) with the first character of the special handling code that is associated with the Document Type code (data item DCTM) that exists in table F03B14.

  The Document Type codes exist in the Document Type UDC table (00/DT). If the special handling code is blank, the system writes an R to the Operation Type field.

- Populates the Document Type field (data item DTBR) with the second, third, and fourth characters of the special handling code that is associated with the Document Type code (data item DCTM) that exists in table F03B14.

  The Document Type codes exist in the Document Type UDC table (00/DT). If the special handling code is blank, the system writes DUP to the Document Type field.

#### Running the IN86-Filter Customer Receipts (R76B8605) and INSS/IN89-Filter Customer Receipts (R76B8605) Programs

Select IN86 Data Filters (G76BIN8601), IN86-Filter Customer Receipts.

Select INSS/IN89 Data Filters (G76BINSS01), INSS/IN89-Filter Customer Receipts.

#### Setting Processing Options for the IN86-Filter Customer Receipts (R76B8605) and the INSS/IN89-Filter Customer Receipts (R76B8605) Programs

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

Select

1. From Date and 2. Thru Date | Specify the beginning or the end of the reporting date range. Blank is an not a value.

### Populating the Work and Complementary Tables for Customer Invoices for IN86 and IN89

This section provides an overview of the work and complementary tables for customer invoices and discusses how to:

- Run the IN86-Filter Customer Invoices (R76B8604) and INSS/IN89-Filter Customer Invoices (R76B8604) programs.

- Set processing options for the IN86-Filter Customer Invoices (R76B8604) and the INSS/IN89-Filter Customer Invoices (R76B8604) programs.

#### Understanding the Work and Complementary Tables for Customer Invoices

To generate customer ledger records for IN86 or IN89, you run the IN86-Filter Customer Invoices program (R76B8604) or the INSS/IN89-Filter Customer Invoices program (R76B8604). Program R76B8604 reads the Customer Ledger (F03B11) table:

Program R76B8604 populates these tables:

Work Table | Complementary Tables
IN86-Work Table for Suppliers and Customers (F76B8602) | IN86-Work Table for Account Master (F76B901)
Not applicable | IN86-Work Table for Individuals and Legal Entities (F76B8601)

Program R76B8604 writes one record to table F768602 for each record in table F03B11 and applies these rules:

- Excludes unposted records.

- Excludes voided records.

- Excludes invoices with document type of R1, R5, and RU when you run the standard XJDE0001 version.

- Populates the Operation Type field (data item OPBR) with the first character of the special handling code that is associated with the Document Type code (data item DCTM) that exists in the A/R Check Detail File table (F03B14).

  The Document Type codes exist in the Document Type UDC table (00/DT). If the special handling code is blank, the system writes a C to the Operation Type field.

- Populates the Document Type field (data item DTBR) with the second, third, and fourth characters of the special handling code that is associated with the Document Type code (data item DCTM) that exists in table F03B14.

  The Document Type codes exist in the Document Type UDC table (00/DT). If the special handling code is blank, the system writes DUP to the Document Type field.

#### Running the IN86-Filter Customer Invoices (R76B8604) and INSS/IN89-Filter Customer Invoices (R76B8604) Programs

Select IN86 Data Filters (G76BIN8601), IN86-Filter Customer Invoices.

Select INSS/IN89 Data Filters (G76BINSS01), INSS/IN89-Filter Customer Invoices.

#### Setting Processing Options for the IN86-Filter Customer Invoices (R76B8604) and the INSS/IN89-Filter Customer Invoices (R76B8604) Programs

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

Select

1. From Date and 2. Thru Date | Specify the beginning or the end of the reporting date range. Blank is not a value.

### Populating the Work and Complementary Tables for Fixed Assets for IN86 and IN89

This section provides an overview of the work and complementary tables for fixed assets and discusses how to:

- Run the IN86-Filter Fixed Assets (R76B5200) and INSS/IN89- Filter Fixed Assets (R76B5200) programs.

- Set processing options for the IN86-Filter Fixed Assets (R76B5200) and INSS/IN89- Filter Fixed Assets (R76B5200) programs.

#### Understanding the Work and Complementary Tables for Fixed Assets

You run the IN86-Filter Fixed Assets program (R76B5200) or the INSS/IN89-Filter Fixed Assets program (R76B5200) to generate fixed assets records for IN86 or IN89. Program R76B5200 reads these source tables:

- Asset Master File (F1201)

- Asset Account Balances File (F1202)

This table shows the tables that the system populates when you run the R76B5200 program:

Work Table | Complementary Table
IN86-Work Table for Fixed Assets (F76B8200) | IN86-Work Table for Account Master (F76B901)

Program R76B5200 applies these rules as it writes records to table F76B8200:

- If an asset is not disposed, the system includes the asset if the asset's Acquisition Date (data item FAFAJ) is before the date that you enter in the Thru Date in the processing option.

- If an asset is disposed, the system includes the asset if the asset's Disposal Date (data item FADSP) is within the range of dates that are specified in the processing options.

- If a supplemental data table that associates fixed asset numbers to purchase order numbers exists, the system populates the Acquisition Document Type, Document Series, and Acquisition Document Number fields with data from the supplemental data table.

  If no supplemental data table exists, the system leaves the Acquisition Document Type, Document Series, and Acquisition Document Number fields blank.

#### Running the IN86-Filter Fixed Assets (R76B5200) and INSS/IN89- Filter Fixed Assets (R76B5200) Programs

Select IN86 Data Filters (G76BIN8601), IN86-Filter Fixed Assets.

Select INSS/IN89 Data Filters (G76BINSS01), INSS/IN89-Filter Fixed Assets.

#### Setting Processing Options for the IN86-Filter Fixed Assets (R76B5200) and the INSS/IN89- Filter Fixed Assets (R76B5200) Programs

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

Select

1. From Date and 2. Thru Date | Specify the beginning or the end of the reporting date range. You must complete these processing options.
3. Supplemental Data Type | Specify the code for the supplemental data table that associates fixed asset numbers with purchase order numbers. If a supplemental data table that associates fixed asset numbers with purchase order numbers exists, the system updates the Acquisition Document Type, Document Series, and Acquisition Document Number fields in the IN86-Work Table for Fixed Assets table (F76B8200) with data from the supplemental data table. If no supplemental data table exists, the system leaves the Acquisition Document Type, Document Series, and Acquisition Document Number fields blank.

### Populating the Work and Complementary Tables for Storage Control for IN86 and IN89

This section provides an overview of the work and complementary tables for storage control and discusses how to:

- Run the IN86-Filter for Storage Control (R76B100A) and INSS/IN89-Filter for Storage Control (R76B100A) programs.

- Set processing options for the IN86-Filter for Storage Control (R76B100A) and INSS/IN89-Filter for Storage Control (R76B100A) programs.

#### Understanding the Work and Complementary Tables for Storage Control

To generate storage control records for IN86 or IN89, you run the IN86-Filter for Storage Control program (R76B100A) or the INSS/IN89-Filter for Storage Control program (R76B100A). This program reads the Item Ledger File (F4111) table.

The R76B100A program populates these work and complementary tables:

Work Table | Complementary Table
IN86-Work Table for Storage Control (F76B400A) | IN86-Work Table for Item Number and Service Code (F76B400G)

The R76B100A program processes item ledger transactions and applies these rules as it writes records to table F76B400A:

- If a nota fiscal exists for the transaction, the system performs these processes:

- Assigns F as the Nature of Document Type (data item BRND).

- Assigns NF as the Storage Control Document Type field (data item BRSD) if the company issued the nota fiscal.

- Writes the value of the data item BSER from the Nota Fiscal Detail - Brazil table (F7611B) to the Nota Fiscal Series field (data item BSER).

- Writes the value of data item BNNF from table F7611B to the Document Number field (data item BRDN).

- For an outbound nota fiscal, writes the ship-from address number to the Address Number - Ship From field (data item BSFH).

  For an inbound nota fiscal, writes the supplier ship-from address number the Address Number - Ship From field.

- If no nota fiscal exists for the transaction, the system performs these processes:

- Assigns I as the Nature of Document Type (data item BRND).

- Writes either OS or REQ to the Storage Control Document Type field (data item BSRD).

- Writes blanks for the series/subseries (data item BSER).

- Writes the value of data item DOC from table F4111 to the Document Number field (data item BRDN).

- Writes blanks for the Address Number - Ship From field.

- Populates the Movement Indicator field (data item BRMI) with an E for inbound transactions and an S for outbound transactions.

#### Running the IN86-Filter for Storage Control (R76B100A) and INSS/IN89-Filter for Storage Control (R76B100A) Programs

Select IN86 Data Filters (G76BIN8601), IN86-Filter for Storage Control.

Select INSS/IN89 Data Filters (G76BINSS01), INSS/IN89-Filter for Storage Control.

#### Setting Processing Options for the IN86-Filter for Storage Control (R76B100A) and the INSS/IN89-Filter for Storage Control (R76B100A) Programs

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

Select

1. From Date and 2. Thru Date | Specify the beginning or the end of the reporting date range.

### Populating the Work Tables for IN86-Filter for Inventory Records (R76B100B) and INSS/IN89-Filter for Inventory Records (R76B100B) for IN86 and IN89

This section provides an overview of the work tables for inventory records and discusses how to:

- Run the IN86-Filter for Inventory Records (R76B100B) and INSS/IN89-Filter for Inventory Records (R76B100B) programs.

- Set processing options for the IN86-Filter for Inventory Records (R76B100B) and the INSS/IN89-Filter for Inventory Records (R76B100B) programs.

#### Understanding the Work Tables for Inventory Records

To generate inventory records for IN86, you run the IN86-Filter for Inventory Records program (R76B100B) or the INSS/IN89-Filter for Inventory Records program (R76B100B). This program reads these source tables:

- Item ASOF File (F41112).

- Branch/Plant Fiscal Company X-Reference - Brazil (F7606B).

Program R76B100B populates these work tables:

- IN86-Work Table for Inventory Records (F76B400B).

- IN86-Work Table for Item Number and Service Code (F76B400G).

Program R76B100B processes inventory records and applies these rules as it writes records to table F76B400B:

- Populates the Inventory Status field (data item BRIV) according to the value that you set in the Branch Plant (Business Unit) Category Code processing option.

- Populates the Unit of Measure - Primary field (data item UOM1) with the value from data item UOM1 in the Item Master table (F4101).

- Populates the Cumulative Quantity field (data item CMQT) by adding the value for CMQT from table F41112 to the sum of the months that is specified in the Month processing option for table F76B400B.

  For example, if you enter 3 in the Month processing option, the system adds the values for quantity for months one, two, and three (data items NQ01, NQ02, and NQ03) to the value for CMQT.

- Populates the Cumulative Amount field (data item CUMA) by adding the value for CUMA from table F41112 to the sum of the months that is specified in the Month processing option for table F76B400B.

  For example, if you enter 3 in the Month processing option, the system adds the values for amounts for months one, two, and three (data items AN01, AN02, and AN02) to the value for CUMA.

  Important! You must purge table F76B400B before you rerun the program R76B100B. If you do not purge table F76B400B prior to rerunning this filter program, the data will be inaccurate. Unlike other filter programs, when you rerun program R76B100B without first purging table F76B400B, the system adds quantities to the existing records; it does not replace existing values with values that you changed in the source tables.

#### Running the IN86-Filter for Inventory Records (R76B100B) and INSS/IN89-Filter for Inventory Records (R76B100B) Programs

Select IN86 Data Filters (G76BIN8601), IN86-Filter for Inventory Records.

Select INSS/IN89 Data Filters (G76BINSS01), INSS/IN89-Filter for Inventory Records.

#### Setting Processing Options for the IN86-Filter for Inventory Records (R76B100B) and the INSS/IN89-Filter for Inventory Records (R76B100B)

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

Select

1. Century | Specify the calendar century associated with the year. The century is the first two digits of a four-digit year. For example, for the year 1998, enter 19. For the year 2001, enter 20.
2. Fiscal Year | Specify a two-digit fiscal year. For example, for the year 1998, enter 98. For the year 2001, enter 01.
3. Month | Specify the month for which the quantities in the Item ASOF File (F41112) are accumulated. Enter the month in a two-digit format. For example, enter 01 for January.
4. Inventory Date | Specify the last day of the month for which the quantities in the Item ASOF File (F41112) are accumulated. Blank is not a value.
5. Branch Plant (Business Unit) Category Code | Specify the user-defined code table that contains the category code that you set up to hold the inventory status ownership codes, and that you associate with the business unit. If you do not complete this processing option, the system uses the values that you set up in the 00/30 UDC table.
6. Company From | Specify the company whose data you want to work with.

### Populating the Work and Complementary Tables for Notas Fiscais for Services for IN86 or IN89

This section provides an overview of the work and complementary tables for notas fiscais for services and discusses how to:

- Run the IN86-Filter for Services Outbound NF (R76B100C) and INSS/IN89-Fltr -Services Outbound NF (R76B100C) programs.

- Set processing options for the IN86-Filter for Services Outbound NF (R76B100C) and the INSS/IN89-Fltr -Services Outbound NF (R76B100C) programs.

#### Understanding the Work and Complementary Tables for Notas Fiscais for Services

To generate notas fiscais for services records for IN86 or IN89, you run the IN86-Filter for Services Outbound NF program (R76B100C) or INSS/IN89-Fltr -Services Outbound NF (R76B100C). Program R76B100C reads these source tables:

- Nota Fiscal - Header (Fiscal Books) (F76101B).

- Nota Fiscal - Detail (Fiscal Books) (F76111B).

This table shows the work and complementary tables that the system populates when you run the R76B100C program:

Work Tables | Complementary Tables
IN86-Work Table for Services Outbound Nota Fiscal Header (F76B410C) | IN86-Work Table for Individuals and Legal Entities (F76B8601)
IN86-Work Table for Services Outbound Nota Fiscal Detail (F76B411C) | IN86-Work Table for Item Number and Service Code (F76B400G)

The system applies these rules as it writes records to tables F76B410C and F76B411C:

- For F76B410C, if the line status (data item TRTY) for the item is 996 or 997 in table F76101B, the system writes an S to the Cancel Situation - Brazil field (data item BRCS). Otherwise, the system writes an N to the Cancel Situation - Brazil field.

- For F76B411C, if the Item Number field (data item LITM) in table F76111B is blank, the system populates the Complementary Description field in table F76B411C (data item BRD60) with a concatenation of the values from the Description field (data item DSC1) and the Description -2 field (data item DSC2) from table F76111B.

  If the Item Number field in table F76111B is blank, the system does not populate the Complementary Description field.

#### Running the IN86-Filter for Services Outbound NF (R76B100C) and INSS/IN89-Fltr -Services Outbound NF (R76B100C) Programs

Select IN86 Data Filters (G76BIN8601), IN86-Filter for Services Outbound NF.

Select INSS/IN89 Data Filters (G76BINSS01), INSS/IN89-Fltr -Services Outbound NF.

#### Setting Processing Options for the IN86-Filter for Services Outbound NF (R76B100C) and the INSS/IN89-Fltr -Services Outbound NF (R76B100C) Programs

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

Select

From Date and Thru Date | Specify the beginning or the end of the reporting date range.

### Populating the Work and Complementary Tables for Merchandise Notas Fiscais Issued by CO for IN86 and IN89

This section provides an overview of the work and complementary tables for Merchandise Notas Fiscais Issued by CO and discusses how to:

- Run the IN86-Filter for Mdse Nota Fiscal by CO (R76B100D) and INSS/IN89-Filter for Mdse Nota Fiscal by CO (R76B100D) programs.

- Set processing options for the IN86-Filter for Mdse Nota Fiscal by CO (R76B100D) and INSS/IN89-Filter for Mdse Nota Fiscal by CO (R76B100D) programs.

#### Understanding the Work and Complementary Tables for Merchandise Notas Fiscais Issued by CO

To generate notas fiscais for merchandise records for IN86 or IN89, you run the IN86-Filter for Mdse NF CO program (R76B100D) or INSS/IN89-Fltr -Mdse NF issued by CO program (R76B100D). This program reads these source tables:

- Nota Fiscal - Header (Fiscal Books) (F76101B).

- Nota Fiscal - Detail (Fiscal Books) (F76111B).

- Nota Fiscal Header - Brazil (F7601B).

This table shows the work and complementary tables that the system populates when you run the R76B100D program:

Work Tables | Complementary Tables
IN86-Work Table for Merchandise Nota Fiscal Issued by CO Hdr (F76B410D) | IN86-Work Table for Individuals and Legal Entities (F76B8601)
IN86-Work Table for Merchandise Nota Fiscal Issued by CO Dtl (F76B411D) | IN86-Work Table for Transaction Nature (F76B400F)
Not applicable | IN86-Work Table for Item Number and Service Code (F76B400G)

Program R76B100D processes nota fiscal records and applies these rules as it writes records to table F76B410D:

- Populates the Nota Fiscal Document Model field (data item BRMD) with the value from the Description 01 field from the Sintegra CFOP Cross Reference UDC table (76B/TN) that is associated with the first line on the nota fiscal.

  If the system cannot determine a value from the UDC, it writes 01 for the Nota Fiscal Document Model field.

- Populates the Address Number field (data item AN8) according to these rules:

  - If the record is outbound, writes the value from the Address Number field (data item AN8) from table F76101B.

  - If the record is inbound, writes the value from the Fiscal Issuer Address Number field (data item BRAANE) from table F76101B.

- Populates the Freight Mode field (data item BRFM) with either CIF or FOB.

  The system writes FOB if a value for freight, insurance, or expenses exists in table F76101B. Otherwise, the system writes CIF to the Freight Mode field.

- Populates the Invoice Type field (data item BRIT) with the value that you specify in the processing options.

- Populates the Movement Indicator field (data item BRMI) with an E for inbound transactions and an S for outbound transactions.

- Leaves the Volume Type field (data item BRVT) blank because the value is not stored in the source tables.

  You can use the appropriate IN86 maintenance program to complete this field.

- If the line status (data item TRTY) for the item is 996 or 997 in table F76101B, the system writes an S to the Cancel Situation - Brazil field (data item BRCS).

  Otherwise, the system writes an N to the Cancel Situation - Brazil field.

- If a nota fiscal record exists in table F7601B, the system populates these fields:

  - Transportation Type field (data item BRTT) is populated from the Equipment Type field (data item EQUP) in table F7601B.

  - Carrier Number field (data item ANCR) is populated from the Carrier Number field (data item ANCR) in table F7601B.

  - Volume Quantity field (data item TOQN) is populated from the Total Quantity field (data item TOQN) in table F7601B.

  - Gross Weight field (data item BRGW) is populated from the Gross Weight field (data item ITWT) in table F7601B.

  - Net Weight filed (data item BRNW) is populated from the Net Weight field (data item TOWT) in table F7601B.

  - Vehicle Identification field (data item LICP) is populated from the License Plate Number field (data item LICP) in table F7601B.

- If a nota fiscal record exists in table F76101B but does not exist in the F7601B, such as those records entered into table F76101B by using the Maintenance of Fiscal Books program (P76B1001), the system leaves these fields blank:

  - Transportation Type (data item BRTT)

  - Carrier Number (data item ANCR)

  - Volume Quantity (data item TOQN)

  - Gross Weight (data item BRGW)

  - Net Weight (data item BRNW)

  - Vehicle Identification (data item LICP)

The system applies these rules as it writes records to table F76B411D:

- Populates the Nota Fiscal Document Model field (data item BRMD) with the value from the Description 01 field from the Sintegra CFOP Cross Reference UDC table (76B/TN) that is associated with each detail line on the nota fiscal. If the system cannot determine a value from the UDC, it writes 01 for the Nota Fiscal Document Model field.

- If the Item Number field (data item LITM) in table F76111B is blank, populates the Complementary Description field in table F76B411D (data item BRD60) with a concatenation of the values from the Description field (data item DSC1) and the Description -2 field (data item DSC2) from table F76111B. If the Item Number field in table F76111B contains an item number, the system does not populate the Complementary Description field.

- Populates the Movement Indicator field (data item BRMI) with an E for inbound transactions and an S for outbound transactions.

- Populates the Nature of Operation - Brazil field (data item BRNO) with a concatenation of the value in the Transaction Nature field (data item BNOP) from the Nota Fiscal Detail - Brazil table (F7611B) and the value in the Transaction Suffix field (data item BSOP) from table F76B111 if the record in table F76B111 was generated by a JD Edwards EnterpriseOne program. If the record in table F76B111 was manually entered by using the Maintenance of Fiscal Books program (P76B1001), the system concatenates a value for BNOP or BRNOP from the Table for BNOP Conversion (Fiscal Books only) (F76B200) and the value in the Transaction Suffix field (data item BSOP) from table F76B111.

- Populates the Merchandise Movement field (data item BRMM) with the value that you specify in the processing options.

When it writes records to table F76B8601, the system writes records for both the Participant Address Book Number (data item AN8 from table F76B410D) and the Carrier Address Book Number (data item ANCR from table F76B410D).

Data Selection

Program R76B100D processes transactions for merchandise notas fiscais that were issued by the company. The company might issue both outbound notas fiscais that are based on sales orders and inbound notas fiscais that are based on purchase returns and ship-to returns. You must set the data selection for program R76B100D to encompass all of the relevant notas fiscais. For example, you might create separate versions of program R76B100D and set the data selection for the Document Type and Transaction Nature Suffix to different values to process the various types of transactions.

#### Running the IN86-Filter for Mdse Nota Fiscal by CO (R76B100D) and INSS/IN89-Filter for Mdse Nota Fiscal by CO (R76B100D) Programs

Select IN86 Data Filters (G76BIN8601), IN86-Filter for Mdse NF by CO.

Select INSS/IN89 Data Filters (G76BINSS01), INSS/IN89-Fltr -Mdse NF issued by CO.

#### Setting Processing Options for the IN86-Filter for Mdse Nota Fiscal by CO (R76B100D) and the INSS/IN89-Filter for Mdse Nota Fiscal by CO (R76B100D) Programs

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

Select

1. From Date and 2. Thru Date | Specify the beginning or the end of the reporting date range.

Default

1. Invoice Type | Specify a default Invoice Type. The value that you enter must exist in the Invoice Type UDC table (76B/IT). The system assigns the invoice type that you enter to the records for all of the transactions which are included in the date range that you specify in the processing options. Because the transactions in the date range might include transactions that should have an invoice type other than the one you enter, the invoice type that you enter might not be valid for all of the transactions. You must use the IN86-Maintain Mdse NF by CO program (P76B200D) on the G76BIN8602 menu and the INSS/IN89-Maintain Mdse NF issued by CO program (P76B200D) on the G76BINSS02 menu to review all of the records that are produced by program R76B100D and correct the invoice type as necessary. Values are: 1: Cash transactions 2: Installment transactions
2. Merchandise Movement | Enter a default Merchandise Movement code. The value that you enter for the invoice type must exist in the Movement Indicator UDC table (76B/MM). The system assigns the movement indicator that you enter to the records for all of the transactions that are included in the date range that you specify in the processing options. Because the transactions in the date range might include transactions that should have a movement indicator other than the one you enter, the movement indicator that you enter might not be valid for all of the transactions. You must use the IN86-Maintain Mdse NF by CO program (P76B200D) on the G76BIN8602 menu and the INSS/IN89-Maintain Mdse NF issued by CO program (P76B200D) on the G76BINSS02 menu to review all of the records that are produced by program R76B100D and correct the movement indicator as necessary. Values are: N: No S: Yes

### Populating the Work and Complementary Tables for Merchandise Notas Fiscais Issued by Supplier for IN86 and IN89

This section provides an overview of the work and complementary tables for merchandise notas fiscais issued by suppliers and discusses how to:

- Run the IN86-Filter for Mdse NF by Supplier (R76B100E) and INSS/IN89-Fltr-Msde NF issued by Supplier (R76B100E) programs.

- Set processing options for the IN86-Filter for Mdse NF by Supplier (R76B100E) and the INSS/IN89-Fltr-Msde NF issued by Supplier (R76B100E) programs.

#### Understanding the Work and Complementary Tables for Merchandise Notas Fiscais Issued by Supplier

To generate merchandise notas fiscais issued by suppliers records for IN86 and IN89, you run the IN86-Filter for Mdse NF by Supplier program (R76B100E) or the INSS/IN89-Fltr-Msde NF issued by Supplier (R76B100E). This program reads these source tables:

- Nota Fiscal - Header (Fiscal Books) (F76101B)

- Nota Fiscal - Detail (Fiscal Books) (F76111B)

Program R76B100E populates these work and complementary tables:

Work Tables | Complementary Tables
IN86-Work Table for Merchandise NF Issued by Supplier Header (F76B410E) | IN86-Work Table for Individuals and Legal Entities (F76B8601)
IN86-Work Table for Merchandise NF Issued by Supplier Detail (F76B411E) | IN86-Work Table for Transaction Nature (F76B400F)
Not applicable | IN86-Work Table for Item Number and Service Code (F76B400G)

Program R76B100E processes nota fiscal records and applies these rules as it writes records to table F76B410E:

- Populates the Nota Fiscal Document Model field (data item BRMD) with the value from the Description 01 field from the Sintegra CFOP Cross Reference UDC table (76B/TN) that is associated with the first line on the nota fiscal. If the system cannot determine a value from the UDC, it writes 01 for the Nota Fiscal Document Model field.

- Populates the Invoice Type field (data item BRIT) according to the value that you enter in the Invoice Type processing option.

The system applies these rules as it writes records to table F76B411E:

- Populates the Nota Fiscal Document Model field (data item BRMD) with the value from the Description 01 field from the Sintegra CFOP Cross Reference UDC table (76B/TN) that is associated with each detail line on the nota fiscal.

  If the system cannot determine a value from the UDC, it writes 01 for the Nota Fiscal Document Model field.

- If the Item Number field (data item LITM) in table F76111B is blank, populates the Complementary Description field in table F76B411E (data item BRD60) with a concatenation of the values from the Description field (data item DSC1) and the Description -2 field (data item DSC2) from table F76111B.

  If the Item Number field in table F76111B contains an item number, the system does not populate the Complementary Description field.

- Populates the Nature of Operation - Brazil field (data item BRNO) with a concatenation of the value in the Transaction Nature field (data item BNOP) from the Nota Fiscal Detail - Brazil table (F76111B) and the value in the Transaction Suffix field (data item BSOP) from table F76111B if the record in table F76111B was generated by a JD Edwards EnterpriseOne program.

  If the record in table F76111B was manually entered by using the Maintenance of Fiscal Books program (P76B1001), the system concatenates a value for BNOP or BRNOP from the Table for BNOP Conversion (Fiscal Books only) table (F76B200) and the value in the Transaction Suffix field (data item BSOP) from table F76111B.

- Populates the Merchandise Movement field (data item BRMM) with the value that you specify in the processing options.

#### Running the IN86-Filter for Mdse NF by Supplier (R76B100E) and INSS/IN89-Fltr-Msde NF issued by Supplier (R76B100E) Programs

Select IN86 Data Filters (G76BIN8601), IN86-Filter for Mdse NF by Supplier.

Select INSS/IN89 Data Filters (G76BINSS01), INSS/IN89-Fltr-Mdse NF issued by Supplier.

#### Setting Processing Options for the IN86-Filter for Mdse NF by Supplier (R76B100E) and the INSS/IN89-Fltr-Msde NF issued by Supplier (R76B100E) Programs

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

Select

1. From Date and 2. Thru Date | Specify the beginning or the end of the reporting date range.

Defaults

1. Invoice Type | Specify a default Invoice Type. The value that you enter must exist in the Invoice Type UDC table (76B/IT). Values are: 1: Cash transactions 2: Installment transactions
2. Merchandise Movement | Enter a default Merchandise Movement code. The value that you enter must exist in the Merchandise Movement UDC table (76B/MM). Values are: N: No S: Yes

### Populating the Work and Complementary Tables for Inbound Service Nota Fiscal Third Parties for IN89

This section provides an overview of the work and complementary tables for inbound service notas fiscais for third parties and discusses how to:

- Run the INSS/IN89-Fltr-3rd Party Srvs-Inbound NF program (R76B100H).

- Set processing options for the INSS/IN89-Fltr-3rd Party Srvs-Inbound NF program (R76B100H).

#### Understanding the Work and Complementary Tables for Inbound Service Nota Fiscal Third Parties

To generate service notas fiscais issued by third parties records for IN89, you run the Fltr-3rd Party Srvs-Inbound NF program (R76B100H). This program reads these source tables:

- Nota Fiscal - Header (Fiscal Books) (F76101B).

- Nota Fiscal - Detail (Fiscal Books) (F76111B).

The Fltr-3rd Party Srvs-Inbound NF program populates these work and complementary tables:

Work Table | Complementary Tables
INSS-Work Table for Services Third Party Inbound NF Header (F76B410H) | IN86-Work Table for Item Number and Service Code (F76B400G)
Not applicable | IN86-Work Table for Account Master (F76B901)
Not applicable | IN86-Work Table for Individuals and Legal Entities (F76B8601)

The Fltr-3rd Party Srvs-Inbound NF program retrieves INSS values only if these conditions are met:

- A purchase order was entered, the service was received, and an inbound nota fiscal was generated from the receipt.

- A 3-way voucher match was performed for the service.

- The Nota Fiscal Conversion program (R76B200A) was run.

- The Calculate A/P Tax Withholding program (R76B0411A) was run for INSS taxes.

The Fltr-3rd Party Srvs-Inbound NF program does not populate the INSS values in table F76B410H for transactions for which you perform these actions:

- You enter a stand-alone nota fiscal using the Stand Alone Nota Fiscal program (P7611B).

- You use a 2-way voucher match instead of a 3-way voucher match.

- You enter a fiscal books record by using the Maintenance of Fiscal Books program (P76B1001).

The Fltr-3rd Party Srvs-Inbound NF program processes nota fiscal records and applies these rules as it writes records to table F76B410H:

- Populates the Document Type INSS - Brazil field (BSFH) with the second, third, and fourth characters of the special handling code that is associated with the Document Type code (data item DCT) that exists in table F76101B.

  The Document Type codes exist in the Document Type - All Documents UDC table (00/DT). If the Special Handling Code field in the UDC table is blank, the system writes the nota fiscal document type to the Document Type INSS - Brazil field in table F76B410H.

- If the Item Number field (data item LITM) in table F76111B is blank, populates the Complementary Description - Brazil field in table F76B410H (data item BRD60) with a concatenation of the values from the Description field (data item DSC1) and the Description -2 field (data item DSC2) from table F76111B.

  If the Item Number field in table F76111B is populated, the system does not populate the Complementary Description - Brazil field.

- Populates the INSS Basis field (BRBINSS) with a 3 if the value in the Total Taxable Base field (BRTXTT) in the Voucher Additional Information Brazil table (F76B0411) is a 3, and populates the INSS Basis field with zeros (0) if the value in the Total Taxable Base field is other than a 3.

  If the system cannot find an INSS record in table F76B0411, the system populates the INSS Basis field (BRBINSS) with blanks.

- Populates the INSS Tax field (BRAINSS) with the value in the Amount field (AA) in table F76B0411 if the value in the Total Taxable Base field (BRTXTT) in table F76B0411 is 3, and populates the INSS Tax field with zeros (0) if the value in the Total Taxable Base field is other than a 3.

  If the system cannot find an INSS record in table F76B0411, the system populates the INSS Basis field (BRBINSS) with blanks.

- Leaves these fields blank when the program does not return values for the INSS Basis and INSS Tax Amount:

- Document Company (KCO)

- Document (DOC)

- Pay Item (SFX)

- Pay Item Extension Number (SFXE)

- Document Type - Voucher Only (DCTV)

#### Running the INSS/IN89-Fltr-3rd Party Srvs-Inbound NF (R76B100H) Program

Select INSS/IN89 Data Filters (G76BINSS01), INSS/IN89-Fltr-3rd Party Srvs-Inbound NF.

#### Setting Processing Options for the INSS/IN89-Fltr-3rd Party Srvs-Inbound NF Program (R76B100H)

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

Default

Date From and Date Thru | Specify the beginning or the end of the reporting date range. Blank is an not a value.

### Populating the Work and Complementary Tables for Bills of Material for IN86 and IN89

This section provides an overview of the work and complementary tables for bills of material and discusses how to:

- Run the IN86-Filter for Bill of Material (R76B3000) and INSS/IN89-Filter for Bill of Material (R76B3000) programs.

- Set processing options for the IN86-Filter for Bill of Material (R76B3000) and the INSS/IN89-Filter for Bill of Material (R76B3000) programs.

#### Understanding the Work and Complementary Tables for Bills of Material

To generate item and parts records for IN86 or IN89, you run the IN86-Filter for Bill of Material program (R76B3000) or the INSS/IN89-Filter for Bill of Material program (R76B3000). This program reads the Bill of Material Master File (F3002) table.

The system populates these work and complementary tables when you run program R76B3000:

Work Table | Complementary Table
Work Table for Item/Part List (F76B3010) | IN86-Work Table for Item Number and Service Code (F76B400G)

Program R76B3000 processes end item and component item records to populate table F76B3010 with the bill of material structure for each finished product and all of the components that are required to build a unit of the finished product. The system applies these rules as it writes records to table F76B3010:

- When you set the Reporting Period Flag processing option to 1, includes in the report all of the components that have an Effective Thru Date (data item EFFT) which is greater than or equal to the date in the From Date processing option.

- When you set the Reporting Period Flag processing option to 2, includes in the report all of the components that have an Effective From Date (data item EFFF) which is less than or equal to the date in the Thru Date processing option.

- When you set the Reporting Period Flag processing option to 3, includes in the report all of the components that meet these criteria:

  - The Effective From Date (data item EFFF) is less than or equal to the date that you specify in the Thru Date processing option.

  - The Effective Thru Date (data item EFFT) is greater than or equal to the date that you specify in the From Date processing option.

- Processes records that have the bill type that you specify in the processing options.

- Does not include components with these properties:

  - LNTY = T

  - COBY = I

  - SBNT = 0 and COBY = Blank

  - STKT = 0

- For components of phantom items, if the component's stocking type equals zero, writes the records as-if the phantom item's component is a component of the phantom item's parent item.

  The system also changes the component line number to a unique number.

- Includes all of the ingredients consumed during process manufacturing for each co-product/by-product.

Data Selection

JD Edwards EnterpriseOne software sets the Data Selection as indicated in this table:

Operator | Left Operand | Comparison | Right Operand
Where | BC Units - Batch Quantity (F3002) | Is equal to | <Zero)
Or | BC Co-Products/By-Products/Intermediate (F3002) | Is not equal to | <Blank)
And | BC Units- Batch Quantity (F3002) | Is not equal to | (Zero)
And | BC Quantity - Standard Required Quantity (F3002) | Is equal to | (Zero)

If you modify the data selection from the settings that are provided, these results might occur:

- If you do not set the Batch Quantity to equal zero, the system stores multiple batch-bills-of-material for each component; and the final report might contain multiple bills of material that point to the same component.

- If you do not set the Co-Products/By-Products/Intermediate to equal zero, as well as setting the Batch Quantity to equal zero, the system filters out the co-products/by-products because of the method in which table F3002 stores co-product/by-product items.

What You Should Know About Processing Options for Program R76B3000

The values that you specify in some of the processing options for the IN86-Filter for Bill of Material program (R76B3000) or the INSS/IN89-Filter for Bill of Material program (R76B3000) affect the way that the other processing options work. The system applies these rules for the processing options:

- If you set the Reporting Period Flag processing option to 1, you must enter a valid value in the From Date processing option. If you do not enter a valid value, the system does not process any records and displays an error message.

- If you set the Reporting Period Flag processing option to 2, you must enter a valid value in the Thru Date processing option. If you do not enter a valid value, the system does not process any records and displays an error message.

- If you set the Reporting Period Flag processing option to 3, you must enter valid values in the From Date and Thru Date processing options.

  If you do not enter valid values, the system does not process any records and displays an error message.

- When you set the Reporting Period Flag processing option to 1, the system includes in the report all of the components that have an Effective Thru Date (data item EFFT) which is greater than or equal to the date in the From Date processing option.

- When you set the Reporting Period Flag processing option to 2, the system includes in the report all of the components that have an Effective From Date (data item EFFF) which is less than or equal to the date in the Thru Date processing option.

- When you set the Reporting Period Flag processing option to 3, the system includes in the report all of the components that meet these criteria:

  - The Effective From Date (data item EFFF) is less than or equal to the date that you specify in the Thru Date processing option.

  - The Effective Thru Date (data item EFFT) is greater than or equal to the date that you specify in the From Date processing option.

#### Prerequisite

Create a zero-batch bill of material.

See Generating MPS for Batch Bills.

#### Running the IN86-Filter for Bill of Material (R76B3000) and INSS/IN89-Filter for Bill of Material (R76B3000) Programs

Select IN86 Data Filters (G76BIN8601), IN86-Filter for Bill of Material.

Select INSS/IN89 Data Filters (G76BINSS01), INSS/IN89-Filter for Bill of Material.

#### Setting Processing Options for the IN86-Filter for Bill of Material (R76B3000) and the INSS/IN89-Filter for Bill of Material (R76B3000) Programs

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

Defaults

Type Bill of Material | Specify the type of bill of material for which the system produces the report. The type of bill of material that you specify must exist in the Bill Type UDC table (40/TB). The report includes all components that are assigned the bill type that you specify. If you leave this processing option blank, the system uses M for manufacturing bill of material.

Select

Reporting Period Flag | Specify the reporting period. If you do not complete this option, the system does not produce the report. Values are: 1: The system includes in the report all of the components that have an Effective Thru Date (data item EFFT) which is greater than or equal to the date in the From Date processing option. If you set the Reporting Period Flag processing option to 1, you must enter a value in the From Date processing option. If you do not enter a value, the system does not process any records and displays an error message. 2: The system includes in the report all of the components that have an Effective From Date (data item EFFF) which is less than or equal to the date in the Thru Date processing option. If you set the Reporting Period Flag processing option to 2, you must enter a value in the Thru Date processing option. If you do not enter a value, the system does not process any records and displays an error message. 3: The system includes in the report all of the components that have an Effective From Date (data item EFFF) that is less than or equal to the date that you specify in the Thru Date processing option and that have an Effective Thru Date (data item EFFT) that is greater than or equal to the date that you specify in the From Date processing option. If you set the Reporting Period Flag processing option to 3, you must enter values in the From Date and Thru Date processing options. If you do not enter values, the system does not process any records and displays an error message.
From Date and Thru Date | Specify the date or dates that the system uses to determine the components to include in the report. When you enter a valid date in the From Date processing option and set the Reporting Period Flag processing option to 1, the system includes in the report all of the components that have an Effective Thru Date (data item EFFT) which is greater than or equal to the date in the From Date processing option. If you do not enter a valid date in the From Date processing option when you set the Reporting Period processing option to 1, the system does not process any records. When you enter a valid date in the Thru Date processing option and set the Reporting Period Flag processing option to 2, the system includes in the report all of the components that have an Effective From Date (data item EFFF) which is less than or equal to the date in the Thru Date processing option. If you do not enter a valid date in the Thru Date processing option when you set the Reporting Period processing option to 2, the system does not process any records. When you enter valid dates in both the From Date and Thru Date processing options and set the Reporting Period Flag processing option to 3, the system includes in the report all of the components that have an Effective From Date (data item EFFF) that is less than or equal to the date that you specify in the Thru Date processing option and all of the components that have an Effective Thru Date (data item EFFT) that is greater than or equal to the date that you specify in the From Date processing option. If you do not enter valid dates in both the From Date and Thru Date processing options when you set the Reporting Period Flag processing option to 3, the system does not process any records.