(BRA) Processing IN68 Records for Tax Reporting

This chapter provides overviews of IN68 tax reporting and the text file generation programs, and describes how to:

• Work with the Physical and Legal Person Table - IN68.

• Work with the Codes Table for IN68.

• Work with accounts receivable and accounts payable records.

• Work with account balance records.

• Work with general ledger records.

• Work with nota fiscal records for items.

• Work with nota fiscal records for services.

• Working with item ledger records.

• Working with inventory records.

• Working with product data records.

• Working with fixed assets records.

• Working with fixed assets with depreciation on hold records.

• Working with fixed assets with currency corrections.

Understanding IN68 Tax Reporting

In Brazil, the federal government requires that all companies submit electronic media reports for:

• All of their commercial activities that generate payables and receivables.

• The depreciation of fixed assets and the accounting activities that are associated with the fixed assets.

• The Bill of Material structure and the CARDEX transactions that are used for the accounting of raw materials which are used in the manufacture and shipping of end items, if the company is a manufacturer.

To meet this legal requirement in Brazil, you must create and file IN68 text files. The IN68 reporting process is based on the law SRF No. 068, which is effective as of 1995. This law requires the generation of fiscal information for the collection of income tax that must be sent to the Brazilian Government Department of Revenue.

JD Edwards EnterpriseOne software provides batch processes that you use to create IN68 work files for several financial and manufacturing systems as well as work files for the JD Edwards EnterpriseOne Sales Order Management, JD Edwards EnterpriseOne Procurement, and JD Edwards EnterpriseOne Fixed Assets systems.

For each of the required IN68 text files, you create the IN68 work files, and then review and revise them as necessary. Then you generate a text file that you submit to the tax authority.

When you run the process to create a work file, the system populates the Physical and Legal Person Table - IN68 (F76B70) and Codes Table - IN68 (F76B80) tables with the person/legal entity code (table F76B70) and the IN68 codes (table F76B80) from the records that the system reads when creating the work file. Then, when you generate the final report and text file, the system validates that each record in the work file has an entry in tables F76B70 and F76B80.

Note. Only some of the batch programs write records to table F76B70.

You generate the text files for tables F76B70 and F76B80 after you generate all of the other required text files. You purge these tables before you generate the work files for the next IN68 reporting period.

Understanding the IN68 Text File Generation Programs

The batch processes for generating IN68 produce reports and text files that you forward to the tax authority. You can set a processing option to generate only the report. When you run the batch processes, the system names the text files by appending the extension .txt to the code for the report. For example, when you run the Final Creation for Item Ledger - IN68 program (R76B507), the system creates a report with the code of R76B509 and names the text file F76B509.txt. The system saves the text file to the directory that you specify in the processing options. You must generate and save the file on a client machine; you cannot generate or save the file on a server.

This table shows the batch processes you use to generate reports and text files for IN68:

The above programs write records to the text file only after they evaluate the records in the workfiles and tables F76B80 and F76B70.

Using Data Selection for each batch process, you determine the records that the system should consider for IN68. The XJDE0001 version for each batch process contains default data selection.

When you generate the reports and text files, the system validates the information in the selected records in the workfiles against table F76B80, and writes a record to the report and text file for each record in the workfile if the required data is in table F76B80. If the data is not in table F76B80, the system writes an error message to the report and text file.

Each selected record in the text file must contain the codes that are required by the final creation batch process. In addition, the values for the type of data expressed by the code must match; and the G/L Date of the record in table F76B80 must be less than or equal to the G/L Date of the selected record in the workfile.

Example of Validation

The Work File Creation for Accounts Receivable - IN68 program (R03B580) creates table F76B20. The Final Creation for accounts receivable and accounts payable program generates the report and text file for the table.

When you run the Final Creation for AR and AP program for each selected record in table F76B20, the Final Creation for AR and AP program writes a record to the F03B581.txt file if the F76B80 record meets these criteria:

• A G/L Date that is less than or equal to the G/L Date of the F76B20 record read.

• Code 02.

• Code 06.

• Code 07.

• An Operation Type that is equal to the Operation Type of the F76B20 record read.

• A Document Type that is equal to the Document Type of the F76B20 record read.

• A Search Type that is equal to the Search Type of the F76B20 record read.

Codes Validated

This table shows the codes that the system validates for each batch process:

Working with the Physical and Legal Person Table - IN68

This section provides an overview of the Physical and Legal Person Table - IN68 and describes how to:

• Purge the Physical and Legal Person Table - IN68.

• Add records in the Physical and Legal Person Table - IN68.

• Run the Final Creation for Physical and Legal Person - IN68 (R76B707) Program.

• Set processing options for the Final Creation for Physical and Legal Person - IN68 program (R76B707).

Understanding the Physical and Legal Person Table - IN68

All of the JD Edwards EnterpriseOne programs that cull address book information for IN68 reports write records to the Physical and Legal Person Table - IN68 (F76B70). These records include information such as the federal and state tax IDs. Data in table F76B70 becomes part of the IN68 reporting.

When you generate certain work files for IN68, the system also writes records to the Physical and Legal Person Table - IN68 (F76B70). When you generate the final text files and reports for those work files, the system validates information in the work file tables against table F76B70. The validation assures that a record exists in table F76B70 for every customer, supplier, or other entity for which you are reporting a transaction that is reportable for IN68 purposes. You submit a text file containing the records in table F76B70 along with the other IN68 text.

These programs write records to the F76B70 table:

• Work File Creation for Accounts Receivable - IN68 (R03B580).

• Work File Creation for A/P IN68 (R04530).

• Work File Creation for Nota Fiscal Item - IN68 (R76B300).

• Work File Creation for Nota Fiscal of Services - IN68 (R76B400).

• Work File Creation for Item Ledger - IN68 (R76B500).

If you create notas fiscais outside of the JD Edwards EnterpriseOne systems for customers, suppliers, or others who are not in the JD Edwards EnterpriseOne Address Book system, you must add the required data to table F76B70. You can also revise existing records in table F76B70.

Purging Records

After you generate all of the required text files for an IN68 reporting period, you purge the table so that you do not carry over data from one reporting period to the next.

You should purge the Physical and Legal Person Table - IN68 (F76B70) only after all of the text files and reports for a reporting period are complete. If you purge this table before generating all reports and text files, the system displays error messages for any report or text file for which required data does not exist in table F76B70.

Generating the Physical and Legal Person Text File and Report for IN68

The Final Creation, Physical/Legal Entities batch process lets you generate a report and a text file for IN68 reporting. You can also choose to generate only a report. The batch process names the text file F76B709.txt and saves it to the directory that you enter in the processing options. If a file with this name exists in the directory that you specify, the system replaces the existing file with the new text file that you generate.

You must generate and save the file on a client machine; you cannot generate or save the file on a server.

Forms Used to Add and Revise Records in Table F76B70

Running the Purge Program

Select Filter Programs - IN68 (G76BIN681), Work File Creation-Physical/Legal Entity.

Adding Records in Table F76B70

Access the Revision of Individuals / Legal Entities - [Register] form.

Running the Final Creation For Physical/Legal Person (R76B707) Program

Select Final Generation and Integrities - IN68 (G76BIN683), Final Creation, Physical/Legal Entities.

Setting Processing Options for the Final Creation for Physical and Legal Person - IN68 Program (R76B707)

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

Report Generation

This processing option specifies whether the system generates a text file and where the system stores the text file.

Directory TXT

This processing option specifies whether the system generates a text file and where the system stores the text file.

Working with the Codes Table for IN68

This section provides an overview of the Codes Table - IN68 (F76B80) and describes how to:

• Purge the Codes Table - IN68.

• Add records to the Codes Table - IN68.

• Run the Final Creation of Codes - IN68 (R76B807) Program.

• Set processing options for the Final Creation of Codes - IN68 program (R76B807).

Understanding the Codes Table for IN68

All of the programs for IN68 reports write records to the Codes Table - IN68 (F76B80). These records include information such as the bank and bank account numbers that are used for financial transactions. Data in table F76B80 becomes part of the IN68 reporting.

If you create notas fiscais outside of the JD Edwards EnterpriseOne systems for customers, suppliers, or others who are not in the JD Edwards EnterpriseOne Address Book system, you must add the required data to table F76B80 by using the Revision of Codes - IN68 program (P76B804).

Purging Records

After you generate all of the required text files for an IN68 reporting period, you purge table F76B80 so that you do not carry over data from one reporting period to the next.

You should purge the Codes Table - IN68 (F76B80) only after all text files and reports for a reporting period are complete. If you purge this table before generating all reports and text files, the system displays error messages for any report or text file for which required data does not exist in table F76B80.

Adding and Revising Records

When you generate work files for IN68, the system also writes records to the Codes Table - IN68 (F76B80). When you generate the final text files and reports for IN68 reporting, the system validates information in the work file tables against table F76B80. The validation assures that a record exists in table F76B80 for every transaction that is reportable for IN68 purposes. You submit a text file containing the records in table F76B80 along with the other IN68 text files.

If you generate reportable transactions outside of the JD Edwards EnterpriseOne systems, you must add the required data to table F76B80. You can also revise existing records in the table.

Generating the Code Table for IN68 Text File and Report

The Final Creation of Codes batch process lets you generate a report and a text file for IN68 reporting. You can also choose to generate only a report. The batch process names the text file F76B809.txt and saves it to the directory that you enter in the processing options. If a file with this name exists in the directory that you specify, the system replaces the existing file with the new text file that you generate.

You must generate and save the file on a client machine; you cannot generate or save the file on a server.

Forms Used to Add and Revise Records in Table F76B80

Running the Purge F76B800 Program (R76B800)

Select Filter Programs - IN68 (G76BIN681), Work File Creation (Clearing) for Codes.

Adding Records in Table F76B80

Access the Revision of Codes - Register form.

Running the Final Creation of Codes (R76B807) Program

Select Final Generation and Integrities - IN68 (G76BIN683), Final Creation of Codes.

Setting Processing Options for the Final Creation of Codes - IN68 Program (R76B807)

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

Report Generation

These processing options specify whether the system generates a text file and where the system stores the text file.

Directory TXT

These processing options specify whether the system generates a text file and where the system stores the text file.

Working With Accounts Receivable and Accounts Payable Records for IN68

This section provides overviews of accounts receivable records and accounts payable records for IN68, and describes how to:

• Run the Work File Creation for Accounts Receivable - IN68 program (R03B580).

• Set processing options for the Work File Creation for Accounts Receivable - IN68 program (R03B580).

• Run the Work File Creation for A/P program (R04530).

• Set processing options for Work File Creation for A/P program (R04530).

• Add records to the Account Payable and Receivable Table - IN68.

• Run the Final Creation for Accounts Payable/Receivable - IN68 program (R03B581).

• Set processing options for Final Creation for Accounts Payable/Receivable - IN68 program (R03B581).

Understanding Accounts Receivable Records for IN68

To generate Accounts Receivable records for IN68, you run the Work File Creation for Accounts Receivable - IN68 batch process (R03B580) to generate the Account Payable and Receivable Table - IN68 (F76B20). Table F76B20 is the work file that contains a subset of data from these tables:

• Customer Ledger (F03B11).

• Address Book Master (F0101).

• User-Defined Codes (F0005).

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

After you generate the work file, you can use the Account Payable and Receivable Revisions program (P03B130) to review and make any necessary changes to the work file. After you make the necessary changes, you run the Final Creation for Accounts Payable/Receivable - IN68 batch process (R03B581) to create a report and the text file that you send to the tax authority.

This graphic shows how the system processes accounts receivable records for IN68 tax reporting:

Accounts receivable records for IN68

Understanding the Work File Creation for A/R Batch Process (R03B580)

You run the Work File Creation for A/R batch process (R03B580) to generate the Account Payable and Receivable Table - IN68 (F76B20). The Work File Creation for A/R process also populates records in the Physical and Legal Person Table - IN68 (F76B70) and the Codes Table - IN68 (F76B80).

By using Data Selection, you determine the records in the Customer Ledger (F03B11) that the system should consider for IN68. The XJDE0001 version for this batch process contains default data selection.

For each selected F03B11 record, the Work File Creation for A/R process writes a record to table F76B20 according to these rules:

• Verifies that the address number that appears in the F03B11 record exists in the Address Book Master table (F0101).

• Identifies each address that is read from table F0101 with the description of the Search Type field in the User-Defined Codes table (F0005).

  For example, if the description for the search type is Customer, the record is identified as a Customer record. You set up search types in the Search Type UDC (01/ST).

• Writes a record to the table F76B20 according to the input in the Operation Type and Document Type processing options.

• Determines the Debit/Credit Indicator according to the arithmetic operator (>, <) in the Gross Amount field in table F03B11.

  If RPAG >= 0, then the Debit/Credit Indicator = D for A/R. If the RPAG < 0, then the Debit/Credit Indicator = C for A/P.

After writing a record to table F76B20, the batch process:

• Populates table F76B70 if a corresponding record does not exist.

• Populates table F76B80 if a corresponding record does not exist.

  Note. The system writes to table F76B20 when you run the Work File Creation for A/R batch process and the Work File Creation for A/P IN68 batch process (R04530).

Understanding Accounts Payable Records for IN68

To generate Accounts Payable records for IN68, you run the Work File Creation for A/P IN68 batch process (R04530) to generate the Account Payable and Receivable Table - IN68 (F76B20). Table F76B20 is the work file that contains a subset of data from these tables:

• Accounts Payable Ledger (F0411).

• Accounts Payable - Matching Document (F0413).

• Accounts Payable Matching Document Detail (F0414).

• Address Book Master (F0101).

• User-Defined Codes (F0005).

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

After you generate the work file, you can use the Account Payable and Receivable Revisions - IN68 program (P03B130) to review and make any necessary changes to the work file. After you make the necessary changes, you run the Final Creation for Accounts Payable/Receivable - IN68 batch process (R03B581) to create a report and the text file that you send to the tax authority.

This graphic shows how the system processes accounts payable records for IN68 tax reporting:

Accounts Payable records for IN68

Understanding the Work File Creation for A/P (R04530) Program

You run the Work File Creation for A/P batch process (R04530) to generate the Account Payable and Receivable Table - IN68 (F76B20). The Work File Creation for A/P program also populates records in the Physical and Legal Person Table - IN68 (F76B70) and the Codes Table - IN68 (F76B80).

Using Data Selection, you determine the records in the Accounts Payable Ledger table (F0411) that the system should consider for IN68. The XJDE0001 version for this batch process contains default data selection.

For each selected F0411 record, the Work File Creation for A/P program writes a record to table F76B20 according to these rules:

• Verifies that the address number that appears in the F0411 record exists in the Address Book Master table (F0101).

• Identifies each address that is read from table F0101 with the description of the Search Type field in the User-Defined Codes table (F0005). For example, if the description for the search type is Customer, the record is identified as a Customer record. You set up search types in the 01/ST UDC.

• Writes a record to table F76B20 according to the input in the Operation Type and Document Type processing options.

• Determines the Debit/Credit Indicator according to the arithmetic operator (>, <) in the Gross Amount field in the F03B11 table.

  If RPAG >= 0, then the Debit/Credit Indicator = D for A/R. If the RPAG < 0, then the Debit/Credit Indicator =C for A/P.

After writing a record to table F76B20, the batch process:

• Populates table F76B70 if a corresponding record does not exist.

• Populates table F76B80 if a corresponding record does not exist.

  Note. The system writes to table F76B20 when you run the Work File Creation for A/R batch process (R03B580) or the Work File Creation for A/P batch process.

Understanding the Account Payable and Receivable Table - IN68 Program (F76B20)

After you generate the Account Payable and Receivable Table - IN68 (F76B20), you can review and modify records in the table. When you modify a record, you can add information, such as the Pay Item or Batch Number, that the work file creation process does not provide. You can add a record only if the account number for the record you add has a valid Used Code in the Codes Table - IN68 table (F76B80). The account number is a concatenation of the business unit, object account, and subsidiary. If the values that you enter do not have a corresponding Used Code in table F76B80, the system displays an error message.

You use the Accounts Payable and Receivable Revisions (P03B130) program to add or modify records in table F76B20.

Understanding the Final Creation for A/R and A/P Program (R03B581)

The Final Creation for A/R and A/P batch process (R03B581) lets you generate a report and a text file for IN68 reporting. You can also choose to generate only a report. The batch process names the text file F03B581.txt and saves it to the directory that you enter in the processing options. If a file with this name exists in the directory that you specify, the system replaces the existing file with the new text file that you generate.

You must generate and save the file on a client machine; you cannot generate or save the file on a server. The batch process writes records to the F03B581.txt file only after it evaluates the records in the Codes Table - IN68 table (F76B80) and the Physical and Legal Person Table - IN68 table (F76B70).

By using Data Selection, you determine the records in the Account Payable and Receivable Table - IN68 (F76B20) that the system should write to the report and text file. The XJDE0001 version for this batch process contains default data selection.

For each selected record in table F76B20, the batch process writes a record to the F03B581.txt file if table F76B80 contains a record that meets all of these requirements:

• A Code of 02, the G/L Date is less than or equal to the G/L Date of the F76B20 record read, and the Operation Type is equal to the Operation Type of the F76B20 record read. If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

• A Code of 06, the G/L Date is less than or equal to the G/L Date of the F76B20 record read, and the Document Type is equal to the Document Type of the F76B20 record read. If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

• A Code of 07, the G/L Date is less than or equal to the G/L Date of the F76B20 record read, and the Search Type is equal to the Search Type of the F76B20 record read. If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

For each record in table F76B20, the batch process writes a record to the F03B581.txt file if all of these conditions exist:

• Table F76B70 contains a record that has a G/L Date that is less than or equal to the G/L Date of the F76B20 record read.

• Search Type is equal to the Search Type of the F76B20 record read.

• An address number that is equal to the address number of the F76B20 record read.

If the process does not find a record in table F76B70 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

After it processes the information in tables F76B20, F76B70, and F76B80, the Final Creation for A/R and A/P process writes this information to the report:

• Data about the lines on the text file, including the sequence number, description of the line, the beginning and ending positions, the size of the record, and the number of decimal places, if any.

• A list of the records that are written to the text file.

• A summary section that includes data on the total length of the text string, a count of the records read, and total length of each record in the text file.

• The error messages generated.

Forms Used Add and Revise Records for Table F76B20

Running the Work File Creation for Accounts Receivable - IN68 (R03B580)

Select Filter Programs - IN68 (G76BIN681), Work File Creation for A/R.

Setting Processing Options for the Work File Creation for Accounts Receivable - IN68 Program (R03B580)

These processing options specify how the system populates the Account Payable and Receivable Table - IN68 (F76B20) when you run the Work File Creation for Accounts Receivable batch process (R03B580).

Default

Process

Running the Work File Creation for A/P (R04530) Program

Select Filter Programs - IN68 (G76BIN681), Work File Creation for A/P.

Setting Processing Options for the Work File Creation for A/P Program (R04530)

These processing options specify how the system populates the Account Payable and Receivable Table - IN68 (F76B20) when you run the Work File Creation for A/P batch process (R04530).

Select

Defaults

Process

Adding Records to Table F76B20

Access the Supplier/Customer Revisions form.

Running the Final Creation for Accounts Payable/Receivable - IN68 (R03B581) Program

Select Final Generation and Integrities - IN68 (G76BIN683), Final Creation for A/R and A/P.

Setting Processing Options for the Final Creation for Accounts Payable/Receivable - IN68 Program (R03B581)

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

Processing

These processing options specify whether the system generates a text file and where the system stores the text file.

Working with Account Balance Records for IN68

This section provides overview of account balance records and describes how to:

• Run the Update Account Balances (F76B11) - IN68 batch process (R098303).

• Set processing options for the Update Account Balances (F76B11) - IN68 program (R098303).

• Add records to table F76B11.

• Run the Final Creation for Account Balances - IN68 program (R098301).

• Set processing options for the Final Creation for Account Balances - IN68 program (R098301).

Understanding Account Balance Records for IN68

To generate Accounting Balances records for IN68, you run the Update Account Balances (F76B11) - IN68 batch process (R098303) to generate the Account Balances - IN68 table (F76B11). The F76B11 is a work file that contains a subset of data from these tables:

• Account Ledger (F0911)

• Account Master (F0901)

• Account Balance (F0902)

• Automatic Accounting Instructions Master (F0012)

After you generate the work file, you can use the Account Balances Revisions - IN68 program (P098301) to review and make any necessary changes to the work file. After you make the necessary changes, you run the Final Creation for Account Balances - IN68 batch process (R098301) to create a report and the text file that you send to the tax authority.

This graphic shows how the system processes account balance records for IN68 tax reporting:

Account balance records for IN68

Understanding the Update Account Balances (F76B11) - IN68 Batch Process (R098303)

You run the Update Account Balances (F76B11) - IN68 batch process (R098303) to generate the Account Balances - IN68 table (F76B11). The Update Account Balances (F76B11) - IN68 process also populates records in the Codes Table - IN68 table (F76B80).

Using Data Selection, you determine the records in the Accounts Balances table (F0902) that the system considers for IN68. The system provides a default data selection on the XJDE0001 version.

For each selected F0902 record, the batch process writes records to these tables:

• Account Balance - IN68 (F76B11).

• Codes Table - IN68 (F76B80).

When you run the Update Account Balances (F76B11) - IN68 process, the system performs these processes:

• Reads the AA ledger records in the Account Master table (F0901) according to the processing options that you set.

• Updates an existing record or writes a new record to table F76B11 for each company/period/account combination.

  The account is a concatenation of the business unit and the object.subsidiary account. The Subledger field is not used to differentiate account numbers; the system writes a blank amount to table F76B11 for the Subledger field. The system updates records or writes new records that are based on a processing option.

• Writes a record to table F76B80 for each account number and a description for each period.

• Calculates the total debits and total credits by accumulating the amounts from the Account Ledger table (F0911) for each period.

• Compares the period totals from tables F0901 and F0911 and, if the totals are not the same, writes to an error report the F0902 record information and the amount of the difference.

Beginning Balances for Periods

The GLG4 and GLG5 AAI accounts for each company determine the beginning balance for period 1. If an account is a retained earnings account or a balance sheet account, the period 1 beginning balance is the value in the beginning balance prior year ending (PYE) field (GBAPYC); otherwise, it is zero. For example, if the object account in table F0902 is equal to the GLG4 object account, or less than or equal to the GLG5 object account, the value in the GBAPYC field is the period 1 beginning balance.

The beginning balance for subsequent periods is the sum of the beginning balance of the previous period and the net postings of the previous period.

Example of Beginning Balances

Period 1 beginning balance = GBAPYC or zero, based on GLG4 and GLG5

Period 2 beginning balance = Period 1 beginning balance + Period 1 net postings (GBAN01)

Period 3 beginning balance = Period 2 beginning balance + Period 2 net postings (GBAN02)

Period 4 beginning balance = Period 3 beginning balance + Period 3 net postings (GBAN03)

Account Balances for IN68 (R098303) Report

The Update Account Balances (F76B11) - IN68 program (R098303) generates a summary report that includes this information:

• Beginning balance total.

• Total debit amount.

• Total credit amount.

• Ending balance total.

• Number of table F0902 records read.

• Number of table F76B11 records written or updated.

The process also generates an error report when the totals on tables F0902 and F0911 do not match. The error report includes this information:

• Company.

• Account ID, number, and description.

• Century and fiscal year.

• Ledger type.

• Period.

• Amount of the difference between tables F0902 and F0911.

Understanding the Account Balances - IN68 Table (F76B11)

After you generate the Account Balances - IN68 table (F76B11), you can review, modify, add, and delete records in the table. When you modify a record, you can add information, such as Total Debits or Total Credits, that the Update Account Balances (F76B11) - IN68 program (R098303) does not provide. You can add a record only if the account number for the record that you add has a valid Used Code in the Codes Table - IN68 table (F76B80). The account number is a concatenation of the business unit, object account, subsidiary, and subledger. If the values you enter do not have a corresponding Used Code in table F76B80, the system displays an error message.

You use the Account Balances Revisions program (P098301) to add or revise records in table F76B11.

Understanding the Final Creation for Account Balances - IN68 Program (R098301)

The Final Creation for Account Balances - IN68 program (R098301) lets you generate a report and a text file for IN68 reporting. You can also choose to generate only a report. The batch process names the text file F76B119.txt and saves it to the directory that you enter in the processing options. If a file with this name exists in the directory that you specify, the system replaces the existing file with the new text file that you generate. You must generate and save the file on a client machine; you cannot generate or save the file on server.

Using Data Selection, you determine the records in the Account Balances - IN68 table (F76B11) that the system considers for IN68. The XJDE0001 version for this batch process contains default data selection.

The batch process writes records to the F76B119.txt file only after it evaluates the records in tables F76B80 and F76B11.

For each selected record in table F76B11, the batch process writes a record to the F76B119.txt file if all of these conditions exist:

• Table F76B80 contains a record that has a Code of 01.

• G/L Date is less than or equal to the Date in the F76B11 record read

• Used Code (BRCUT) is equal to the Account Number of the F76B11 record read.

If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

The Final Creation for Account Balances - IN68 program produces a report that contains this information:

• Data about the lines on the text file, including the sequence number; description of the line; the beginning and ending positions; the size of the record; and the number of decimal points, if any.

• A summary section that includes data on the total length of the text string, a count of the records read, a count of the records written, the total debit amount, the total credit amount, and the total of the debits and credits.

• The error messages generated.

Forms Used Add and Revise Records for Table F76B11

Running the Update Account Balances (F76B11) - IN68 Batch Process (R098303)

Select Filter Programs - IN68 (G76BIN681), Update Account Balances (F76B11) - IN68.

Setting Processing Options for the Update Account Balances (F76B11) - IN68 Process (R098303)

These processing options specify the periods for which you want to process account balances and whether the system clears previous records from the Account Balances - IN68 table (F76B11).

Periods

Initialize

Adding Records to Table F76B11

Access the Account Balance Revisions - IN68 form.

Running the Final Creation for Account Balances - IN68 Program (R098301)

Select Final Generation and Integrities (G76BIN683), Final Creation for Account Balances - IN68.

Setting Processing Options for the Final Creation for Account Balances - IN68 Program (R098301)

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

Process

These processing options specify whether the system generates a text file and where the system stores the text file.

Working With General Ledger Records for IN68

This section provides overviews of general ledger records and describes how to:

• Run the Update General Ledger - IN68 program.

• Set processing options for the Update General Ledger (F76B10) - IN68 program (R098313).

• Add records to table F76B10.

• Run the Final Creation for Journal Entries - IN68 program (R098311).

• Set processing options for the Final Creation for Journal Entries - IN68 program (R098311).

Understanding General Ledger Records for IN68

To generate General Ledger records for IN68, you run the Update General Ledger (F76B10) - IN68 batch process (R098313), which populates the Journal Entries - IN68 table (F76B10). Table F76B10 is a work file that contains a subset of data from these files:

• Account Ledger (F0911)

• Account Master (F0901)

• User-Defined Codes (F0005)

• Business Unit Master (F0006)

After you generate the work file, you can use the Journal Entries Revisions - IN68 program (P098311) to review and make any necessary changes to the work file. After you make the necessary changes, you run the Final Creation for Journal Entries - IN68 batch process (R098311) to create a report and the text file that you send to the tax authority.

This graphic shows how the system processes general ledger records for IN68 tax reporting:

General ledger records for IN68

Understanding the Update General Ledger - IN68 Program (R098313)

You run the Update General Ledger - IN68 program (R098313) to generate the Account Ledger - IN68 table (F76B10). The Update General Ledger - IN68 program also populates the Codes Table - IN68 table (F76B80).

You determine the records in the Account Ledger table (F0911) that the system considers for IN68. The XJDE0001 version for this batch process contains default data selection.

For each selected F0911 record, the batch process writes records to these tables:

• Account Ledger - IN68 (F76B10)

• Codes Table - IN68 (F76B80)

When you run the Update General Ledger - IN68 program, the system performs these processes, in this order:

1. Reads posted AA ledger records in table F0911, according to the processing options that you set.

2. Updates an existing record or writes a new record to table F76B10 for each company/GL date/account/subledger combination.

   The account is a concatenation of the business unit and the object.subsidiary account. The system updates records or writes new records that are based on a processing option.

3. Updates table F76B80 with the account, business unit, and operation code for each GL date.

   You use a processing option to specify the operation code.

4. Generates a summary report that includes this information:

   • Total debit amount.

   • Total credit amount.

   • Total of debits and credits.

   • The number of F0911 records read.

   • The number of F76B10 records written or updated.

Understanding the Journal Entries - IN68 Table (F76B10)

After you generate the Journal Entries - IN68 table (F76B10), you can review, modify, add, and delete records in the table. When you modify a record, you can add information, such as the Cost Center or Operation Type, that the Update General Ledger (F76B10) - IN68 program (R098313) does not provide. You can add a record only if the account number for the record that you add has a valid Used Code in the Codes Table - IN68 table (F76B80). The account number is a concatenation of the business unit, object account, and subsidiary. Additionally, when you revise or add a record, the system validates the value that you enter in the Operation Type, Cost Center, Expense Cost Center, and Historical Code fields against values in table F76B80. If the values that you enter do not have a corresponding Used Code in table F76B80, the system displays an error message.

You use the Journal Entries Revisions - IN68 program (P098311) to add or modify records in table F76B10.

Understanding the Final Creation for Journal Entries - IN68 Program (R098311)

The Final Creation for Journal Entries - IN68 program (R098311) lets you generate a report and a text file for IN68 reporting. You can also choose to generate only a report. The batch process names the text file F76B109.txt and saves it to the directory that you enter in the processing options. If a file with this name exists in the directory that you specify, the system replaces the existing file with the new text file that you generate. You must generate and save the file on a client machine; you cannot generate or save the file on a server.

Using Data Selection, you determine the records in the Account Ledger - IN68 table (F76B10) that the system considers for IN68. The XJDE0001 version for this batch process contains data selection.

The batch process writes records to the F76B109.txt file only after it evaluates the records in the Codes Table - IN68 table (F76B80) and table F76B10.

For each selected record in table F76B10, the batch process writes a record to the F76B109.txt file if table F76B80 contains a record that meets all of these requirements:

• A Code of 01, the G/L Date is less than or equal to the G/L Date in the F76B10 record read, and the Used Code (BRCUT) is equal to the Account Number of the F76B10 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

• A Code of 02, the G/L Date is less than or equal to the G/L Date in the F76B10 record read, and the Used Code (BRCUT) field is equal to the Operation Type (BRTPO) field in the F76B10 record.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

• A Code of 03, the G/L Date is less than or equal to the G/L Date in the F76B10 record read, and the Used Code (BRCUT) is equal to the Cost Center in the F76B10 record.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

After it processes the information in tables F76B10 and F76B80, the Final Creation for Journal Entries - IN68 program writes this information to the report:

• Data about the lines on the text file, including the sequence number; description of the line; the beginning and ending positions; the size of the record; and the number of decimal points, if any.

• A list of the records that are written to the text file.

• A summary section that includes data on the total length of the text string and a count of the records read.

• The error messages generated.

Forms Used Add and Revise Records for Table F76B10

Running the Update General Ledger - IN68 Program

Select Filter Programs - IN68 (G76BIN681), Update General Ledger (F76B10) - IN68.

Setting Processing Options for the Update General Ledger (F76B10) - IN68 Program (R098313)

These processing options specify the operation type and whether to clear the work file.

Operation Type

Initialize

Adding Records to Table F76B10

Access the Journal Entries Revisions - IN68 form.

Running the Final Creation for Journal Entries - IN68 (R098311) Program

Select Final Generation and Integrities - IN68 (G76BIN683), Final Creation for Journal Entries - IN68.

Setting Processing Options for the Final Creation for Journal Entries - IN68 Program (R098311)

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

Process

These processing options specify whether the system generates a text file and where the system stores the text file.

Working with Nota Fiscal Records for Items for IN68

This section provides overview for nota fiscal records for items and describes how to:

• Run the Work File Creation for Nota Fiscal Item - IN68 program (R76B300).

• Set processing options for the Work File Creation for Nota Fiscal Item - IN68 program (R76B300).

• Add records to tables F76B30 and F76B31.

• Run the Final Creation for Notas Fiscais for Goods - IN68 program (R76B307).

• Set processing options for the Final Creation for Notas Fiscais for Goods - IN68 program (R76B307).

Understanding Nota Fiscal Records for Items for IN68

To generate nota fiscal records for Items for IN68, you run the Work File Creation for Nota Fiscal Item - IN68 batch process (R76B300) to generate the Nota Fiscal Header/Table for Goods - IN68 table (F76B30) and the Nota Fiscal Detail/Table for Goods - IN68 table (F76B31). These work files contains a subset of data from these files:

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

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

• Transaction Nature - Brazil (F7615B).

• Code - ICMS IPI Tax Summary (F7617B).

• IPI Taxes (F76B18).

• Address Book Master (F0101).

• User-Defined Codes (F0005).

• Business Unit Master (F0006).

After you generate the work file, you can use the Revision of Nota Fiscal Item - IN68 program (P76B304) to review and make any necessary changes to the work files. After you make the necessary changes, you run the Final Creation for Nota Fiscal Item - IN68 batch process (R76B307) to create reports and the text files that you send to the tax authority.

This graphic shows how the system processes nota fiscal records for items for IN68 tax reporting:

Nota fiscal records for items for IN68

Understanding the Work File Creation for Nota Fiscal Item (R76B300) Program

You run the Work File Creation for Nota Fiscal Item program (R76B300) to generate the Nota Fiscal Header/Table for Goods - IN68 table (F76B30) and the Nota Fiscal Detail/Table for Goods - IN68 table (F76B31). The Work File Creation for Nota Fiscal Item program also populates records in the Physical and Legal Person Table - IN68 table (F76B70) and the Codes Table - IN68 table (F76B80).

Using Data Selection, you determine the records in the Nota Fiscal - Header (Fiscal Books) table (F76101B) that the system should consider for IN68. The XJDE0001 version for this batch process contains default data selection.

For each selected F76101B record, the batch process writes records to these tables:

• Nota Fiscal Header/Table for Goods - IN68 table (F76B30).

• Nota Fiscal Detail/Table for Goods - IN68 table (F76B31).

• Physical and Legal Person Table - IN68 (F76B70).

• Codes Table - IN68 (F76B80).

Before writing a record to tables F76B30 and F76B31, the batch process performs these actions:

• Verifies that the address number that appears in the F76B101B record exists in the Address Book Master table (F0101).

• Identifies each address that is read from table F0101 with the description of the Search Type field in the User-Defined Codes table (F0005).

  For example, if the description for the search type is Customer, the record is identified as a customer record. You set up search types in the Search Type UDC (01/ST).

• Writes values to table F76B30 and table F76B31 according to the input in the Operation Type, Document Type, Inbound/Outbound, and IPI tax processing options.

• Determines the Debit/Credit Indicator according to the arithmetic operator (>, <) in the Gross Amount. field in table F76101B.

• Writes information about the ICMS tax, ICMS Substitution, and freight charges.

• Accumulates these totals for the records read:

  • Total value of the goods.

  • Base value of IPI.

  • Value of IPI.

  • Value of Discount.

  • Total value of NF.

After writing records to tables F76B30 and F76B31, the batch process:

• Populates table F76B70

• Populates table F76B80

Understanding How to Add or Modify Records in Tables F76B30 and F76B31

After you generate the Nota Fiscal Header/Table for Goods - IN68 table (F76B30) and the Nota Fiscal Detail/Table for Goods - IN68 table (F76B31), you can review and modify records in the tables. If the values that you enter do not have a corresponding Used Code in the Codes Table - IN68 table (F76B80), the system displays an error message.

You use the Revision of Nota Fiscal Item (P76B304) program to add or modify records.

Understanding the Final Creation for Notas Fiscais for Goods - IN68 (R76B307) Program

The Final Creation for Nota Fiscal Item (R76B307) program lets you generate a report and a text file for IN68 reporting. You can also choose to generate only a report.

This batch process generates reports and text files, depending on how you set the Inbound/Outbound processing option. This table shows the reports and corresponding text files for the R76B307 program:

If a file with the same name exists in the directory that you specify, the system replaces the existing file with the new text file that you generate. The batch process saves the text files to the directory that you enter in the processing options. You must generate and save the file on a client machine; you cannot generate or save the file on a server. The batch process writes records to the text files only after it evaluates the records in the Codes Table -IN86 table (F76B80) and the Physical and Legal Persons Table - IN68 table (F76B70).

Using Data Selection, you determine the records in the Nota Fiscal Header/Table for Goods - IN68 table (F76B30) and the Nota Fiscal Detail/Table for Goods - IN68 table (F76B31) that the system should consider for IN68. The XJDE0001 version for this batch process contains default data selection.

For each record in table F76B30, the batch process writes a record to the text files if table F76B80 contains a record that meets all of these requirements:

• A Code of 06, the G/L Date is less than or equal to the G/L Date of the F76B30 record read, and the Used Code is equal to the Document Type of the F76B30 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

• A Code of 07, the G/L Date is less than or equal to the G/L Date of the F76B30 record read, and the Used Code is equal to the Search Type of the F76B30 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

• A Code of 08, the G/L Date is less than or equal to the G/L Date of the F76B30 record read, and the Used Code is equal to the Model Fiscal Documents of the F76B30 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

• A Code of 11, the G/L Date is less than or equal to the G/L Date of the F76B30 record read, and the Used Code is equal to the Mode of Transport of the F76B30 record read. If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

• A Code of 12, the G/L Date is less than or equal to the G/L Date of the F76B30 record read, and the Used Code is equal to the Volume Type of the F76B30 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

• A Code of 13, the G/L Date is less than or equal to the G/L Date of the F76B30 record read, and the Used Code is equal to the Modality of Freight of the F76B30 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

For each record in table F76B31, the batch process writes a record to the text files if table F76B80 contains a record that has:

• A Code of 02, the G/L Date is less than or equal to the G/L Date of the F76B31 record read, and the Used Code is equal to the Operation Type of the F76B31 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

• A Code of 03, the G/L Date is less than or equal to the G/L Date in the F76B31 record read, and the Used Code is equal to the Cost Center in the F76B31 record.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

• A Code of 14, the G/L Date is less than or equal to the G/L Date of the F76B31 record read, and the Used Code is equal to the Products in the F76B31 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

• A Code of 15, the G/L Date is less than or equal to the G/L Date of the F76B31 record read, and the Used Code is equal to the Unit of Measure in the F76B31 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

• A Code of 16, the G/L Date is less than or equal to the G/L Date of the F76B31 record read, and the Used Code is equal to the Federal Tax Situation in the F76B31 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

• A Code of 18, the G/L Date is less than or equal to the G/L Date of the F76B31 record read, and the Used Code is equal to the Fiscal classification in the F76B31 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

Forms Used Add and Revise Records for Tables F76B30 and F76B31

Running the Work File Creation for Nota Fiscal Item Program (R76B300)

Select Filter Programs - IN68 (G76BIN681), Work File Creation for Nota Fiscal Item

Setting Processing Options for the Work File Creation for Nota Fiscal Item - IN68 Program (R76B300)

These processing options specify values for the Nota Fiscal Header/Table for Goods - IN68 table (F76B30) and Nota Fiscal Detail/Table for Goods - IN68 table (F76B31).

Values

Processing

Adding Records to Tables F76B30 and F76B31

Access the Master of Goods form.

Running the Final Creation for Notas Fiscais for Goods - IN68 (R76B307) Program

Select Final Generation and Integrities - IN68 (G76BIN683), Final Creation for Nota Fiscal Item.

Setting Processing Options for the Final Creation for Nota Fiscal Item - IN68 Program (R76B307)

These processing options specify whether the system generates a text file and where the system stores the text file. You also specify whether you want to work with inbound or outbound notas fiscais.

Report Generation

Directory TXT

Working with Nota Fiscal Records for Services for IN68

This section provides overviews of nota fiscal records for services and describes how to:

• Run the Work File Creation for Nota Fiscal Services (R76B400) program.

• Set processing options for the Work File Creation for Nota Fiscal Services program (R76B400).

• Add records for tables F76B40 and F76B41.

• Run the Final Creation, Nota Fiscal of Services program (R76B407).

• Set processing options for the Final Creation, Nota Fiscal of Services program (R76B407).

Understanding Nota Fiscal Records for Services for IN68

To generate nota fiscal records for services for IN68, you run the Work File Creation for Nota Fiscal of Services - IN68 batch process (R76B400) to generate the Nota Fiscal Header/Table for Services- IN68 table (F76B40) and the Nota Fiscal Detail/Table for Services - IN68 table (F76B41). These work files contain a subset of data from these files:

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

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

• Address Book Master (F0101).

• User-Defined Codes (F0005).

After you generate the work file, you can use the Revision of Nota Fiscal of Services - IN68 program (P76B404) to review and make any necessary changes to the work files. After you make necessary changes, you run the Final Creation for Nota Fiscal of Services - IN68 batch process (R76B407) to create reports and the text files that you send to the tax authority.

This graphic shows how the system processes nota fiscal records for services for IN68 tax reporting:

Nota fiscal records for services for IN68

Understanding the Work File Creation for Nota Fiscal Services (R76B400) Program

You run the Workfile Creation-Nota Fiscal Services program (R76B400) to generate the Nota Fiscal Header/Table for Services - IN68 table (F76B40) and the Nota Fiscal Detail/Table for Services - IN68 table (F76B41). The Workfile Creation-Nota Fiscal Services program also populates records in the Physical and Legal Person Table - IN68 table (F76B70) and the Codes Table - IN68 table (F76B80).

Using Data Selection, you determine the records in the Nota Fiscal - Header (Fiscal Books) table (F76101B) that the system should consider for IN68. The XJDE0001 version for this batch process contains default data selection.

For each selected F76101B record, the batch process writes records to these tables:

• Nota Fiscal Header/Table for Services - IN68 table (F76B40).

• Nota Fiscal Detail/Table for Services - IN68 table (F76B41).

• Physical and Legal Person Table - IN68 (F76B70).

• Codes Table - IN68 (F76B80).

Before writing a record to tables F76B40 and F76B41, the Workfile Creation-Nota Fiscal Services program:

• Verifies that the address number that appears in the F76101B record exists in the Address Book Master table (F0101).

• Identifies each address that is read from table F0101 with the description of the Search Type field in the User-Defined Codes table (F0005).

  For example, if the description for the search type is Customer, the record is identified as a customer record. You set up search types in the 01/ST UDC.

• Writes values to table F76B40 and table F76B41 according to the input in the Operation Type, Document Type, Inbound/Outbound, and IPI tax processing options.

• Determines the Debit/Credit Indicator according to the arithmetic operator (>, <) in the Gross Amount field in table F76101B.

• Writes information about the ICMS, IRRF, and ISS taxes.

After writing records to tables F76B30 and F76B31, the Workfile Creation-Nota Fiscal Services program:

• Populates table F76B70

• Populates table F76B80

Understanding the Final Creation for Nota Fiscal for Services (R76B407) Program

The Final Creation for Nota Fiscal of Services program (R76B407) lets you generate a report and a text file for IN68 reporting. You can also choose to generate only a report.

This batch process generates reports and text files, depending on how you set the Inbound/Outbound processing option. This table shows the reports and corresponding text files for the R76B407 program:

If a file with the same name exists in the directory that you specify, the system replaces the existing file with the new text file that you generate. The batch process saves the text files to the directory that you enter in the processing options. You must generate and save the file on a client machine; you cannot generate or save the file on a server. The batch process writes records to the text files only after it evaluates the records in the Physical and Legal Persons Table - IN68 table (F76B70) and the Codes Table - IN68 table (F76B80).

Using Data Selection, you determine the records in the Nota Fiscal Header/Table for Services - IN68 table (F76B40) and the Nota Fiscal Detail/Tables for Services - IN68 table (F76B41) that the system should consider for IN68. The XJDE0001 version for this batch process contains default data selection.

For each record in table F76B40, the Final Creation, Nota Fiscal of Services program writes a record to the text files if table F76B80 contains a record that meets all of these requirements:

• A Code of 06, the G/L Date is less than or equal to the G/L Date of the F76B40 record read, and the Used Code is equal to the Document Type of the F76B40 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

• A Code of 07, the G/L Date is less than or equal to the G/L Date of the F76B40 record read, and the Used Code is equal to the Search Type of the F76B40 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

• A Code of 08, the G/L Date is less than or equal to the G/L Date of the F76B40 record read, and the Used Code is equal to the Model Fiscal Documents of the F76B40 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

For each record in table F76B41, the batch process writes a record to the text files if all of these conditions exist:

• Table F76B80 contains a record that has a Code of 21.

• G/L Date is less than or equal to the G/L Date of the F76B41 record read.

• Used Code is equal to the Service Code in the F76B41 record read.

If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

After it processes the information in tables F76B40, F76B41, F76B70, and F76B80, the Final Creation, Nota Fiscal of Services program writes this information to the reports:

• Value of the service for each record.

• Total of the value of services.

• Number of records processed.

Forms Used Add and Revise Records for Tables F76B40 and F76B41

Running the Work File Creation for Nota Fiscal Services (R76B400) Program

Select Filter Programs - IN68 (G76BIN681), Workfile Creation-Nota Fiscal Services.

Setting Processing Options for the Work File Creation-Nota Fiscal Services Program (R76B400)

These processing options specify values for the Nota Fiscal Header/Table for Services - IN68 table (F76B40) and the Nota Fiscal Detail/Table for Services - IN68 (F76B41) table.

Values

Processing

Adding Records to Tables F76B40 and F76B41

Access the Master of Services form.

Running the Final Creation for Nota Fiscal for Services (R76B407) Program

Select Final Generation and Integrities - IN68 (G76BIN683), Final Creation, Nota Fiscal of Services.

Setting Processing Options for the Final Creation, Nota Fiscal of Services Program (R76B407)

These processing options specify whether the system generates a text file and where the system stores the text file. You also specify whether you want to work with inbound or outbound notas fiscais.

Report Generation

Directory TXT

Working with Item Ledger Records for IN68

This section provides overviews of item ledger records and describes how to:

• Run Work File Creation for the Item Ledger - IN68 program (R76B500).

• Set processing options for the Work File Creation for Item Ledger - IN68 program (R76B500).

• Add or modify records in table F76B50.

• Run the Final Creation for the Item Ledger program (R76B507).

• Set processing options for the Final Creation for the Item Ledger program (R76B507).

Understanding Item Ledger Records for IN68

To generate Item Ledger records for IN68, you run the Work File Creation for Item Ledger - IN68 batch process (R76B500) to generate the Item Ledger Table - IN68 (F76B50). Table F76B50 is the work file that contains a subset of data from these files:

• Item Ledger File (F4111).

• Item Master (F4101).

• Item Branch File (F4102).

• Account Master (F0901).

• User-Defined Codes (F0005).

• Business Unit Master (F0006).

• Distribution/Manufacturing - AAI Values (F4095).

• Line Type Control Constants (F40205).

After you generate the work file, you can use the Revision of Item Ledger - IN68 program (P76B504) to review and make any necessary changes to the work file. After you make necessary changes, you run the Final Creation for Item Ledger - IN68 batch process (R76B507) to create a report and the text file that you send to the tax authority.

This graphic shows how the system processes item ledger records for IN68 tax reporting:

Item ledger records for IN68

Understanding the Work File Creation for Item Ledger Program (R76B500)

You run the Work File Creation for Item Ledger - IN68 program (R76B500) to generate the Item Ledger Table - IN68 (F76B50). The Work File Creation for Item Ledger - IN68 program also populates records in the Physical and Legal Person Table - IN68 table (F76B70) and the Codes Table - IN68 table (F76B80).

Using Data Selection, you determine the records in the Item Ledger File table (F4111) that the system should consider for IN68. The system provides a default data selection on the XJDE0001 version for this batch process.

For each selected F4111 record, the Work File Creation for Item Ledger - IN68 program writes records to these tables:

• Item Ledger Table - IN68 (F76B50).

• Physical and Legal Person Table - IN68 (F76B70).

• Codes Table - IN68 (F76B80).

Before writing a record to table F76B50, the Work File Creation for Item Ledger - IN68 program:

• Verifies that the address number that appears in the F4111 record exists in the Address Book Master table (F0101).

• Identifies each address that is read from table F0101 with the description of the Search Type field in the User-Defined Codes table (F0005).

  For example, if the description for the search type is Customer, the record is identified as a customer record. You set up search types in the 01/ST UDC.

• Writes values to table F76B50 according to the input in the Nature of Stock, Operation Type, and Document Type processing options.

• Determines the Debit/Credit Indicator according to the arithmetic operator (>, <) in the Gross Amount field in the Customer Ledger table (F03B11).

After writing a record to table F76B50, the Work File Creation for Item Ledger - IN68 program:

• Populates table F76B70

• Populates table F76B80

Understanding the Final Creation for Item Ledger Program (R76B507)

The Final Creation for Item Ledger program (R76B507) lets you generate a report and a text file for IN68 reporting. You can also choose to generate only a report. The batch process names the text file F76B509.txt and saves it to the directory that you enter in the processing options. If a file with this name exists in the directory that you specify, the system replaces the existing file with the new text file that you generate. You must generate and save the file on a client machine; you cannot generate or save the file on a server. The batch process writes records to the F76B509.txt file only after it evaluates the records in the Physical and Legal Person Table - IN68 table (F76B70) and the Codes Table - IN68 table (F76B80).

Using Data Selection, you determine the records in the Item Ledger Table - IN68 (F76B50) that the system should consider for IN68. The XJDE0001 version for this batch process contains default data selection.

For each selected record in table F76B50, the Final Creation for Item Ledger program writes a record to the F76B509.txt file if table F76B80 contains a record that meets all of these requirements:

• A Code of 01, the G/L Date is less than or equal to the G/L Date of the F76B50 record read, and the Used Code is equal to the Chart of Accounts of the F76B50 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

• A Code of 02, the G/L Date is less than or equal to the G/L Date of the F76B50 record read, and the Used Code is equal to the Operation Type of the F76B50 record read.

  If the process does not find a record in the table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

• A Code of 03, the G/L Date is less than or equal to the G/L Date of the F76B50 record read, and the Used Code is equal to the Cost Center of the F76B50 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

• A Code of 06, the G/L Date is less than or equal to the G/L Date of the F76B50 record read, and the Used Code is equal to the Document Type of the F76B50 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

• A Code of 14, the G/L Date is less than or equal to the G/L Date of the F76B50 record read, and the Used Code is equal to the Products of the F76B50 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

• A Code of 23, the G/L Date is less than or equal to the G/L Date of the F76B50 record read, and the Used Code is equal to the Nature of Stock of the F76B50 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

After it processes the information in tables F76B50, F76B70, and F76B80, the Final Creation for Item Ledger program writes this information to the report:

• Total amount of the product.

• Number of records.

Forms Used Add and Revise Records for Tables F76B50

Running the Work File Creation for Item Ledger Program (R76B500)

Select Filter Programs (G76BIN681), Work File Creation for Item Ledger-IN68.

Setting Processing Options for the Work File Creation for Item Ledger - IN68 Program (R76B500)

These processing options specify values for the stock type, document type, and operation type that appear in reports and text files.

The program provides three processing options for defining the nature of stock. Use the Nature of Stock processing option to choose a value that the system validates. If you do not want to choose one of the valid values that is listed in the Nature of Stock processing option, you can complete the Nature of Stock Override and the Nature of Stock Description to enter a value that the system does not validate.

Each record that the system writes to the Item Ledger Table - IN68 (F76B50) contains a document or order type. When the system writes a description of the document or order type to table F76B50, it uses the document type code and description from the Item Ledger table (F4111) unless you specify a different code and description on the document type and operation type processing options.

Values

Processing

Adding Records to Table F76B50

Access the Revision of Item Ledger - [Register] form.

Running the Final Creation for Item Ledger Program (R76B507)

Select Final Generation and Integrities - IN68 (G76BIN683), Final Creation for Item Ledger.

Setting Processing Options for the Final Creation for Item Ledger Program (R76B507)

These processing options specify whether the system generates a text file and where the system stores the text file.

Report Generation

Directory TXT

Working with Inventory Records for IN68

This section provides overview of inventory records for IN68 and describes how to:

• Run the Work File Creation for Inventory Records program (R76B510).

• Set processing options for the Work File Creation for Inventory Records program (R76B510).

• Add records to table F76B51.

• Run the Final Creation for Inventory Records program (R76B517).

• Set processing options for the Final Creation for Inventory Records program (R76B517).

Understanding Inventory Records for IN68

To generate Inventory records for IN68, you run the Work File Creation for Inventory Records - IN68 batch process (R76B510) to generate the Inventory Records Table - IN68 (F76B51). Table F76B51 is the workfile that contains a subset of data from these files:

• Item ASOF File (F41112).

• Item Master (F4101).

• Item Branch File (F4102).

• User-Defined Codes (F0005).

• Business Unit Master (F0006).

• Item Master Regional Information - Brazil (F76411).

• Line Type Control Constants File (F40205).

• IPI Taxes (F76B18).

After you generate the workfile, you can use the Revision of Inventory Records - IN68 program (P76B514) to review and make any necessary changes to the workfile. After you make the necessary changes, you run the Final Creation for Inventory Records - IN68 batch process (R76B517) to create a report and the text file that you send to the tax authority.

This graphic shows how the system processes inventory records for IN68 tax reporting:

Inventory records for IN68

Understanding the Work File Creation for Inventory Records Program (R76B510)

You run the Work File Creation for Inventory Records program (R76B510) to generate the Inventory Records Table - IN68 (F76B51). The Work File Creation for Inventory Records program also populates records in the Codes Table- IN68 table (F76B80).

Using Data Selection, you determine the records in the Item ASOF File table (F41112) that the system should consider for IN68. The XJDE0001 version for this batch process contains default data selection.

For each selected F41112 record, the batch process writes records to these tables:

• Item Ledger Table - IN68 (F76B51).

• Codes Table - IN68 (F76B80).

Before writing a record to table F76B51, the Work File Creation for Inventory Records program:

• Verifies that the address number that appears in the F41112 record exists in the Address Book Master table (F0101).

• Writes values to the Inventory Records Table - IN68 (F76B51) according to the input in the Nature of Stock processing option.

After writing a record to table F76B51, the Work File Creation for Inventory Records program populates the Codes Table - IN68 table (F76B80).

Understanding the Final Creation for Inventory Records Program (R76B517)

The Final Creation for Inventory Records program (R76B517) lets you generate a report and a text file for IN68 reporting. You can also choose to generate only a report. The Final Creation for Inventory Records program names the text file F76B519.txt and saves it to the directory that you enter in the processing options. If a file with this name exists in the directory that you specify, the system replaces the existing file with the new text file that you generate. You must generate and save the file on a client machine; you cannot generate or save the file on a server. The batch process writes records to the F76B519.txt file only after it evaluates the records in the Codes Table - IN68 table (F76B80).

Using Data Selection, you determine the records in the Inventory Records Table - IN68 (F76B51) that the system should consider for IN68. The XJDE0001 version for this batch process contains default data selection.

For each selected record in table F76B51, the Final Creation for Inventory Records program writes a record to the F76B519.txt file if table F76B80 contains a record that meets all of these requirements:

• A Code of 03, the G/L Date is less than or equal to the G/L Date of the F76B51 record read, and the Used Code is equal to the Cost Center of the F76B51 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record to the report.

• A Code of 10, the G/L Date is less than or equal to the G/L Date of the F76B51 record read, and the Used Code is equal to the Localization of the F76B51 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record to the report.

• A Code of 14, the G/L Date is less than or equal to the G/L Date of the F76B51 record read, and the Used Code is equal to the Products of the F76B51 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record to the report.

• A Code of 15, the G/L Date is less than or equal to the G/L Date of the F76B51 record read, and the Used Code is equal to the Unit of Measure of the F76B51 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record to the report.

• A Code of 18, the G/L Date is less than or equal to the G/L Date of the F76B51 record read, and the Used Code is equal to the Fiscal Classification of the F76B51 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record to the report.

• A Code of 23, the G/L Date is less than or equal to the G/L Date of the F76B51 record read, and the Used Code is equal to the Nature of Stock of the F76B51 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record to the report.

After it processes the information in tables F76B51 and F76B80, the Final Creation for Inventory Records program writes this information to the report:

• Total amount of the product.

• Number of records.

Forms Used Add and Revise Records for Table F76B51

Running the Work File Creation for Inventory Records Program (R76B510)

Select Filter Programs - IN68 (G76BIN681), Work File Creation for Inventory Records.

Setting Processing Options for the Work File Creation for Inventory Records Program (R76B510)

These processing options specify values for the stock type, document type, and operation type that the program uses when processing the Inventory Records Table - IN68 (F76B51) table. The program provides three processing options for defining the nature of stock. Use the Nature of Stock processing option to choose a value that the system validates. If you do not want to choose one of the valid values listed in the Nature of Stock processing option, you can complete the Nature of Stock Override and the Nature of Stock Description to enter a value that the system does not validate.

Each record that the system writes to table F76B51 contains a document or order type. When the system writes a description of the document or order type to table F76B51, it uses the document type code and description from the Item Ledger File table (F4111) unless you specify a different code and description in the document type and operation type processing options.

Values

Processing

Adding Records to Table F76B51

Access the Revision of Inventory Records - [Register] form.

Running the Final Creation for Inventory Records Program (R76B517)

Select Final Generation and Integrities (G76BIN683), Final Creation for Inventory Records.

Setting Processing Options for the Final Creation for Inventory Records Program (R76B517)

These processing options specify whether the system generates a text file and where the system stores the text file.

Report Generation

Directory TXT

Working with Product Data Records for IN68

This section provides overviews of product data records and describes how to:

• Run the Work File Creation for Data of Products program (R76B600).

• Set processing options for the Work File Creation for Data of Products program (R76B600).

• Add records to tables F76B60 and F76B61.

• Run the Final Creation for Data of Products program (R76B607).

• Set the processing options for Final Creation for Data of Products program (R76B607).

Understanding Product Data Records for IN68

To generate product data records for IN68, you run the Work File Creation for Data of Products - IN68 batch process (R76B600) to generate the Products Table - IN68 (F76B60) and the Packing and Raw Material Table - IN68 (F76B61). These tables are the work files that contains a subset of data from these files:

• Bill of Materials Master File (F3002).

• Item Master (F4101).

• Item Branch File (F4102).

• User-Defined Codes (F0005).

• Business Unit Master (F0006).

After you generate the work file, you can use the Revision of Data of Products - IN68 program (P76B604) to review and make any necessary changes to the work file. After you make the necessary changes, you run the Final Creation for Data of Products - IN68 batch process (R76B607) to create a report and the text file that you send to the tax authority.

This graphic shows how the system processes product data records for IN68 tax reporting:

Product data records for IN68

Understanding the Work File Creation for Data of Products Program

Using Data Selection, you determine the records in the Bill of Material Master File table (F3002) that the system should consider for IN68. The XJDE0001 version for this batch process contains default data selection.

The batch process writes data about finished products to the Products Table - IN68 table (F76B60) and writes data about raw materials to the Packing and Raw Material Table - IN68 table (F76B61). You use processing options to specify which items are finished or raw materials.

After writing a record to table F76B60 or table F76B61, the Work File Creation for Data of Products program populates the Codes Table - IN68 table (F76B80).

Understanding the Final Creation for Data of Products Program (R76B607)

The Final Creation for Data of Products program (R76B607) lets you generate reports and text files for IN68 reporting. You can also choose to generate only a report.

The Final Creation for Data of Products program writes qualifying records from the Products Table - IN68 (F76B60) and the Packing and Raw Material Table - IN68 (F76B61) as shown in this table:

If a file with the same name exists in the directory that you specify, the system replaces the existing file with the new text file that you generate. The batch process saves the text files to the directory that you enter in the processing options. You must generate and save the file on a client machine; you cannot generate or save the file on a server. The batch process writes records to the text files only after it evaluates the records in the Codes Table - IN68 table (F76B80)

Using Data Selection, you determine the records in table F76B60 that the system should consider for IN68. The system automatically selects the corresponding records in table F76B61. The XJDE0001 version for this batch process contains default data selection.

For each selected record in table F76B60, the Final Creation for Data of Products program writes a record to the appropriate text files if table F76B80 contains a record that meets all of these requirements:

• A Code of 03, the G/L Date is less than or equal to the G/L Date in the F76B60 record read, and the Used Code is equal to the Cost Center in the F76B60 record.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

• A Code of 14, the G/L Date is less than or equal to the G/L Date of the F76B60 record read, and the Used Code is equal to the Products in the F76B60 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

• A Code of 15, the G/L Date is less than or equal to the G/L Date of the F76B60 record read, and the Used Code is equal to the Unit of Measure in the F76B60 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

For each selected record in table F76B61, the Final Creation for Data of Products program writes a record to the appropriate text files if table F76B80 contains a record that meets these criteria:

• A Code of 15, the G/L Date is less than or equal to the G/L Date of the F76B61 record read, and the Used Code is equal to the Unit of Measure in the F76B61 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

• A Code of 24, the G/L Date is less than or equal to the G/L Date of the F76B61 record read, and the Used Code is equal to the Raw Material in the F76B61 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

• A Code of 25, the G/L Date is less than or equal to the G/L Date of the F76B61 record read, and the Used Code is equal to the Packing in the F76B61 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

Forms Used Add and Revise Records for Tables F76B60 and F76B61

Running the Work File Creation for Data of Products Program

Select Work Filter Programs - IN68 (G76BIN681), Work File Creation for Data of Products.

Setting Processing Options for the Work File Creation for Data of Products Program (R76B600)

These processing options specify how the system validates finished products, raw materials, and packing materials, and whether the system clears records from the Products Table - IN68 (F76B60) and the Packing and Raw Materials Table - IN68 (F76B61).

Values

Processing

Adding Records to Tables F76B60 and F76B61

Access the Revision of Data of Products - [Register Products] form.

Running the Final Creation for Data of Products Program (R76B607)

Select Final Generation and Integrities - IN68 (G76BIN683), Final Creation for Data of Products.

Setting Processing Options for the Final Creation for Data of Products Program (R76B607)

These processing options specify whether the system generates a text file and where the system stores the text file.

Report Generation

Directory TXT

Working with Fixed Assets Records for IN68

This section provides overviews of fixed assets records for IN68 and describes how to:

• Run the Work File Creation for Fixed Assets (R76B620) program.

• Set processing options for the Work Table Creation for Fixed Assets - IN68 program (R76B620).

• Add records to table F76B62.

• Run the Final Creation for Fixed Assets - IN68 program (R76B627).

• Set processing options for the Final Creation for Fixed Assets - IN68 program (R76B627).

Understanding Fixed Assets Records for IN68

To generate fixed asset records for IN68, you run the Work Table Creation for Fixed Assets - IN68 batch process (R76B620) to generate the Fixed Assets Table - IN68 (F76B62). Table F76B62 is the work file that contains a subset of data from these files:

• Asset Master File (F1201).

• Asset Account Balance File (F1202).

• Account Master (F0901).

• Account Ledger (F0911).

• User-Defined Codes (F0005).

• Business Unit Master (F0006).

After you generate the work file, you can use the Revision of Fixed Assets program (P76B62) to review and make any necessary changes to the work file. After you make the necessary changes, you run the Final Creation for Fixed Assets - IN68 batch process (R76B627) to create a report and the text file that you send to the tax authority.

This graphic shows how the system processes fixed asset records for IN68 tax reporting:

Fixed asset records for IN68

Understanding the Work File Creation for Fixed Assets Program (R76B620)

You run the Work Table Creation for Fixed Assets - IN68 program (R76B620) to generate the Fixed Assets Table - IN68 (F76B62). The Work Table Creation for Fixed Assets program also populates records in the Codes Table - IN68 table (F76B80).

Using Data Selection, you determine the records in the Asset Master table (F1201) that the system should consider for IN68. The XJDE0001 version for this batch process contains default data selection.

For each selected F1201 record, the batch process writes records to these tables:

• Fixed Assets Table - IN68 (F76B62).

• Codes Table - IN68 (F76B80).

After writing a record to table F76B62, the Work Table Creation for Fixed Assets program populates table F76B80.

Understanding the Final Creation for Fixed Assets - IN68 Program (R76B627)

The Final Creation for Fixed Assets - IN68 program (R76B627) lets you generate a report and a text file for IN68 reporting. You can also choose to generate only a report. The batch process names the text file F76B629.txt and saves it to the directory that you enter in the processing options. If a file with this name exists in the directory that you specify, the system replaces the existing file with the new text file that you generate. You must generate and save the file on a client machine; you cannot generate or save the file on a server. The batch process writes records to the F76B629.txt file only after it evaluates the records in the Codes Table - IN68 table (F76B80).

Using Data Selection, you determine the records in the Fixed Assets Table - IN68 (F76B62) that the system should consider for IN68. The XJDE0001 version for this batch process contains default data selection.

For each selected record in table F76B62, the Final Creation for Fixed Assets program writes a record to the F76B629.txt file if table F76B80 contains a record that meets all of these requirements:

• A Code of 01, the G/L Date is less than or equal to the G/L Date of the F76B62 record read, and the Used Code is equal to the Account field of the F76B62 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

• A Code of 01, the G/L Date is less than or equal to the G/L Date of the F76B62 record read, and the Used Code is equal to the Depreciation Account field of the F76B62 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

• A Code of 04, the G/L Date is less than or equal to the G/L Date of the F76B62 record read, and the Used Code is equal to the Expense of the F76B62 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

• A Code of 06, the G/L Date is less than or equal to the G/L Date of the F76B62 record read, and the Used Code is equal to the Document Type of the F76B62 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

• A Code of 27, the G/L Date is less than or equal to the G/L Date of the F76B62 record read, and the Used Code is equal to the Fixed Asset Situation of the F76B62 record read.

  If the process does not find a record in table F76B80 that meets the requirements for inclusion in the text file, the process writes an error record on the report.

Forms Used Add and Revise Records for Table F76B62

Running the Work File Creation for the Fixed Assets Program (R76B620)

Select Filter Programs - IN68 (G76BIN681), Work Table Creation for Fixed Assets.

Setting Processing Options for the Work Table Creation for Fixed Assets - IN68 Program (R76B620)

These processing options specify whether the system generates a text file and where the system stores the text file.

Values

Processing

Adding Records to Table F76B62

Access the Maintenance Register of Goods - IN68 form.

Running the Final Creation for Fixed Assets - IN68 Program (R76B627)

Select Final Generation and Integrities - IN68 (G76BIN683), Final Creation for Fixed Assets - IN68.

Setting Processing Options for the Final Creation for Fixed Assets - IN68 Program (R76B627)

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

Report Generation

Working with Fixed Assets with Depreciation on Hold Records for IN68

This section provides overview of fixed assets with depreciation and describes how to:

• Run the Table Creation for Fixed Assets w/Depr on Hold - IN68 (R76B630) program.

• Set processing options for the Table Creation for Fixed Assets w/Depr on Hold - IN68 program (R76B630).

• Add records to table F76B63.

• Run the Final Creation for Fixed Assets w/ Depr on Hold - IN68 program (R76B637).

• Set processing options for the Final Creation for Fixed Assets w/ Depr on Hold - IN68 program (R76B637).

Understanding Fixed Assets with Depreciation on Hold Records

To generate fixed asset with depreciation on hold records for IN68, you run the Table Creating for Fixed Assets w/ Depr on Hold - IN68 program (R76B630) to generate the Information for Depreciation on Hold Table - IN68 (F76B63). Table F76B63 table is the work file that contains a subset of data from these files:

• Asset Master File (F1201).

• Asset Account Balances File (F1202).

• Account Master (F0901).

After you generate the work file, you can use the Revision of Fixed Assets with Depreciation on Hold - IN68 program (P76B63) to review and make any necessary changes to the work file. After you make the necessary changes, you run the Final Creation for Fixed Assets w/ Depr on Hold - IN68 batch process (R76B637) to create a report and the text file that you send to the tax authority.

This graphic shows how the system processes fixed assets with depreciation on hold records for IN68 tax reporting:

Fixed assets with depreciation on hold records for IN68

Understanding the Table Creation for Fixed Assets w/Depr on Hold - IN68 Program (R76B630)

You run the Table Creation for Fixed Assets w/Depr on Hold - IN68 program (R76B630) to generate the Information for Depreciation on Hold Table - IN68 (F76B63). The Table Creation for Fixed Assets w/ Depr on Hold - IN68 program also populates records in the Codes Table - IN68 (F76B80).

Using Data Selection, you determine the records in the Asset Master table (F1201) that the system should consider for IN68. The XJDE0001 version for this batch process contains default data selection.

For each selected F1201 record, the batch process writes records to these tables:

• Information for Depreciation on Hold Table - IN68 (F76B63).

• Codes Table - IN68 (F76B80).

After writing a record to table F76B63, the batch process populates table F76B80.

Understanding the Final Creation for FAs w/ Depr on Hold Program (R76B637)

The Final Creation for FAs w/ Depr on Hold program (R76B637) lets you generate a report and a text file for IN68 reporting. You can also choose to generate only a report. The Final Creation for FAs w/ Depr on Hold program names the text file F76B639.txt and saves it to the directory that you enter in the processing options. If a file with this name exists in the directory that you specify, the system replaces the existing file with the new text file that you generate. You must generate and save the file on a client machine; you cannot generate or save the file on a server. The batch process writes records to the F76B639.txt file only after it evaluates the records in the Codes Table - IN68 table (F76B80).

Using Data Selection, you determine the records in the Information for Depreciation on Hold Table - IN68 (F76B63) that the system should consider for IN68. The XJDE0001 version for this batch process contains default data selection.

Forms Used Add and Revise Records for Table F76B63

Running the Table Creation for Fixed Assets w/Depr on Hold - IN68 Program (R76B630)

Select Filter Programs - IN68 (G76BIN681), Table Creation for Fixed Assets w/ Depr on Hold - IN68.

Setting Processing Options for the Table Creation for Fixed Assets w/Depr on Hold - IN68 Program (R76B630)

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

Values

Processing

Adding Records to Table F76B63

Access the Maintenance of Suspension of Depreciation form.

Running the Final Creation for FAs w/ Depr on Hold Program (R76B637)

Select Final Generation and Inquiries - IN68 (G76BIN683), Final Creation for FAs w/ Depr on Hold - IN68.

Setting Processing Options for the Final Creation for Fixed Assets w/ Depr on Hold - IN68 Program (R76B637)

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

Report Generation

These processing options specify whether the system generates a text file and where the system stores the text file.

Working with Fixed Assets with Currency Corrections for IN68

This section provides an overview of fixed assets with currency corrections and describes how to:

• Add records to table F76B64.

• Run the Final for Balances/JEs w/ Currency - IN68 Program (R76B647).

• Set processing options for Final for Balances/JEs w/ Currency - IN68 Program (R76B647).

Understanding Fixed Assets with Currency Corrections

To generate fixed asset with currency correction records for IN68, you must manually populate the Balances/JEs w/ Currency Correction Table - IN68 (F76B64).

You use the Revision of Balances/JEs w/ Currency Correction - IN68 program (P76B64) to add records to the Balances/JEs w/Currency Correction Table - IN68 (F76B64). Only records that you add to the table appear in the Fixed Assets with Currency Conversion Text File and Report for IN68. You can also revise existing records.

After you populate the table, you run the Final Creation Balances/JEs w/ Currency Correction - IN68 batch process (R76B647) to create a report and the text file that you send to the tax authority.

This graphic shows how the system processes fixed assets with currency corrections for IN68 tax reporting:

Fixed assets with currency corrections for IN68

Understanding the Final for Balances/JEs w/ Currency - IN68 Program (R76B647)

The Final for Balances/JEs w/ Currency - IN68 program (R76B647) lets you generate a report and a text file for IN68 reporting. You can also choose to generate only a report. The batch process names the text file F76B649.txt and saves it to the directory that you enter in the processing options. If a file with this name exists in the directory that you specify, the system replaces the existing file with the new text file that you generate. You must generate and save the file on a client machine; you cannot generate or save the file on a server. The batch process writes records to the F76B649.txt file only after it evaluates the records in the Codes Table - IN68 table (F76B80).

Using Data Selection, you determine the records in the Balances/JEs w/ Currency Correction Table - IN68 (F76B64) that the system should consider for IN68. The XJDE0001 version for this batch process contains default data selection.

Forms Used Add Records to Table F76B64

Adding Records to Table F76B64

Access the Revision of Balances/JEs w/ Currency - [Maintenance] form.

Running the Final for Balances/JEs w/ Currency - IN68 Program (R76B647)

Select Final Generation and Inquiries - IN68 (G76BIN683), Final for Balances/JEs w/ Currency - IN68.

Setting Processing Options for the Final Creation Balances/JEs w/ Currency Correction - IN68 Program (R76B647)

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

Report Generation