R76A0024

AR SOP Credit Invoice Ledger

Use the AR SOP Credit Invoice Ledger program to print a report that lists the credit invoices that you have issued for customers. You specify the date range to print in the processing options.

Credit Invoice System Set Up (G76A00D), AR SOP Credit Invoice Ledger

R76A8510

(ARG, CHL and PER) Report Control Draft - ARG - 03B

Prints a list of all receipts with the Lecops payment instrument.

No processing options exist for this report.

Run this report from the Batch Versions program.

Date From

Enter the beginning of the range of dates for which you run the report.

Date To

Enter the end of the range of dates for which you run the report.

R75A0210

Print Tax Invoice/Adjustment Note

Use this program to print a tax invoice in the approved format that corresponds to a customer's purchase, or a statement of adjustments made to the payment of an invoice (such as discounts).

Australian GST (G75A031), Print Tax Invoice/Adjustment Note

R75A0220

Print Withholding Tax Summary Report

Use this program to print a summary of tax withheld from a supplier who has not provided an ABN number.

Australian GST (G75A031), Print Withholding Tax Summary Report

R75A0230

Print Recipient Created Tax Invoice

Use this program to print a tax invoice in the approved format that is produced by the recipient of goods or services, rather than by the supplier, as the result of an agreement between the customer and the supplier.

Australian GST (G75A031), Print Recipient Created Tax Invoice

R75A0240

Print RCTI Adjustment Notes

Use this program to print statement of adjustments made to the payment of a recipient-created tax invoice (such as short-supply).

Australian GST (G75A031), Print RCTI Adjustment Notes

1. Report Mode

Specify whether you want to run the report in proof mode, update mode, or reprint mode. Running the report in proof mode does not update the F75A200 table. Values are:

Blank: Run the report in proof mode.

1: Update mode.

2: Reprint mode.

Note. When you run the report in reprint mode, you must enter the print control reference number of the original adjustment note in the Print Control Reference processing option.

2. Print Control Reference.

Specify the print control reference number of the original GST tax invoice or adjustment note that you are reprinting if you are reprinting an adjustment note.

3. Invoice Selection

Specify the types of invoices that you want to create. Values are:

1: Create sales invoices and AR invoices.

2: Create AR invoices only.

4. Document Type 1, 5. Document Type 2, 6. Document Type 3, 7. Document Type 4, and 8. Document Type 5

Specify the document type that you want to use to select the transactions for which you are creating GST tax invoices.

9. Adjustments

Specify whether to create adjustment notes for tax invoices. When you pay an invoice, you should create an adjustment record if a discount is taken or if the invoice is underpaid. These adjustments necessitate a write-off and must be reported to the Australian Tax Office (ATO) as adjustments to the original invoice.

Values are:

Blank: Do not create.

1: Create.

Payment Summary

Enter 1 to print payment summary forms.

1. Report Mode.

Specify whether to run the report in proof mode, update mode, or reprint mode. Running the report in proof mode does not update the F75A0201 table. Values are:

Blank: Run the report in proof mode.

1: Update mode.

2: Reprint mode.

1. Report Mode.

Specify whether to run the report in proof mode, update mode, or reprint mode. Running the report in proof mode does not update the F75A0202 table. Values are:

Blank: Run the report in proof mode.

1: Update mode.

2: Reprint mode.

R74B100

Monthly VAT Payable Report - Belgium

Use this report to obtain an overview of the VAT and Taxable amounts, and the totals for the different VAT codes. This report provides information about reports codes 00, 01, 02, 03, 45, 46, 47, 48, 49, 54, 64, and 98 (future use).

Belgium Localization (G74B), Monthly VAT Payable Report - Belgium

R74B110

Monthly VAT Recoverable Report

Use this report to obtain an overview of the VAT and Taxable amounts, and the totals for the different VAT codes. This report provides information about reports codes 55, 56, 57, 59, 61, 62, 63, 81, 82, 83, 84, 85, 86, 87, and 99 (future use).

Belgium Localization menu (G74B), Monthly VAT Recoverable Report

R74B150

Yearly VAT Report (Paper)

This report provides this information:

• Creates a flat file for the yearly VAT report for Belgium. The system only selects Belgian customers.

• Checks the VAT number; if any errors are located, displays the errors in an exceptions report.

• Creates a cover letter for the flat file.

Belgium Localization menu (G74B), Yearly VAT Report (Paper)

R74B200

Yearly VAT Report (Flat File)

This report:

• Creates the listing for the yearly VAT report for Belgium

• Creates a cover letter for the Belgian authorities

Belgium Localization menu (G74B), Yearly VAT Report (Flat File)

R74B250

Quarterly VAT Report (Flat File)

Use this report to create a hard copy report, in addition to the standard electronic flat file output. The report lists VAT numbers that are incorrect; the directory and file name of the electronic flat file output; and a cover letter for the Belgian Authorities, which is submitted along with the electronic flat file output.

Belgium Localization menu (G74B), Quarterly VAT Report (Flat File)

R74B300

Quarterly VAT Report (Paper)

Use this report to generate a customer detail report along with a separate cover letter. You must customize this program to populate the fields on the report with the information you want to view.

No processing options exist for this report.

Belgium Localization menu (G74B), Quarterly VAT Report (Paper)

Legal Format

The reports must be printed in the legal format. The government authority does not allow any format other than its official paper documents. You should obtain the official paper documents from the Belgian authorities.

Reporting

VAT returns must be completed for each month on a special form and filed with the local tax office before the 20th day of the following month. You must also pay any excess collected VAT over deductible VAT before that day.

GL Date

All vouchers and invoices are included in the monthly reports, based on their GL date.

1. Period starting date and 2. Period end date

Specify the first day of the month or the last day of the month being reported.

3. Print Flag

Specify whether to update each individual Print Flag field in the F0018 table. If you leave this processing option blank, the system updates each individual PrintYN (alias TDPRT1) field in the Taxes table with a Y. This processing option enables you to use the Print (Y/N) field in the Data Selection of the report to exclude previously printed VAT amounts. If you enter 1 in this processing option, the system does not update this field. You do not have to update the Print Flag field. Values are:

Blank: Updates.

1: Does not update.

4. Company

Specify the company for which the system runs the report. You can include only one company per report. You must run this report multiple time for multiple companies.

5. Company Address Number

Specify the address book number associated with the Company address that you want to appear in the header section on each page of the report.

Legal Format

The reports must be printed in the legal format. The government authority does not allow any format other than its official paper documents. You should obtain the official paper documents from the Belgian authorities.

Reporting

VAT returns must be completed for each month on a special form and filed with the local tax office before the 20th day of the following month. You must also pay any excess collected VAT over deductible VAT before that day.

GL Date

All vouchers and invoices are included in the monthly reports, based on their GL date.

1. Period starting date and 2. Period end date

Specify the first day of the month or the ending day of the month being reported.

3. Print Flag

Specify whether to update each individual Print Flag field in the F0018 table. If you leave this processing option blank, the system updates each individual PrintYN (alias TDPRT1) field in the Taxes table with a Y. This processing option enables you to use the Print (Y/N) field in the Data Selection of the report to exclude previously printed VAT amounts. If you enter 1 in this processing option, the system does not update this field. You do not have to update the Print Flag field. Values are:

Blank: Updates.

1: Does not update.

4. Company

Specify the company for which the system runs the report. You can include only one company per report. You must run this report multiple time for multiple companies.

5. Company Address Number

Specify the address book number associated with the Company address that you want to appear in the header section on each page of the report.

Output

The Yearly VAT Report (Paper) produces a hard copy report in addition to the standard electronic flat file output. Hard copies of the report contain VAT numbers that are incorrect, the directory and file name of the electronic flat file output, and a cover letter for the Belgian Authorities that is submitted along with the electronic flat file output.

You should print two copies of the final report. You give one copy to the government authorities, and you keep one copy on file for audit purposes. Contact the Belgian tax authorities for more information regarding Belgian tax practices.

Processing Options

A processing option enables the user to produce an equivalent hard copy of the Yearly VAT Report (Flat File) report (R74B200), which can be printed in the format chosen by the user. This report lists Total Sales by Customer (excluding VAT amounts) and Total VAT amounts by Customer. You can specify the version of the Yearly VAT Report (Paper) report to be printed.

You should not include zero VAT amounts in the electronic flat file. You can set the Minimum Taxable Amount to Report processing option on the Process tab to exclude all customers under specified amounts.

Report Execution

The report should be executed locally to successfully create the electronic flat file. Two methods are:

• Users can override the default report execution logic settings by choosing Advanced from the Row menu when submitting the report.

• Select the LOCAL option. By selecting the LOCAL option, you direct the report to run locally and enable the creation of the electronic flat file in the local PC directory that is indicated.

Object Configuration Manager (P986110) can be configured so that the execution logic for this program always occurs locally.

Running the Report

Each time that you run the report, you must indicate a unique file name for the output. If you run the same report twice with the same file name indicated, you double the data that is contained in the electronic flat file.

Report Validation

This report validates the VAT number, or Tax Identification number, of each customer.

Validation occurs when the report is submitted. If an incorrect VAT number is encountered, the first page of the report output describes the number and the type of error that are encountered.

The VAT number, or Tax Identification number, is stored in the TaxId field (Alias TAX) field that is located in the F0101 table.

If invalid VAT numbers are associated with customer records, you must correct those numbers and rerun the report to avoid a government-assessed penalty.

Note. You should run the report in proof mode until all of the VAT validation issues are corrected.

VAT Numbers

In some cases, such as recognized health care providers, you might not have a VAT number for that customer. In those cases, you can assign 99_NB as a VAT/Tax ID value.

In any case for which you do not know the VAT number, you can enter 99_unknown or 99_onbekend in the VAT/Tax ID field.

Multiple Company Reporting

The VAT Yearly program supports multiple company reporting for the paper report and the electronic file. You select multiple company reporting by including multiple companies in the data selection.

Note. For electronic reporting, the program produces a flat file in the format that is accepted by the Belgian authorities. However, for paper reporting, you might need to submit a separate cover letter to the Belgian authorities that includes a description of each of the companies and its VAT information.

1. Start date and 2. End date

Specify the first day of the year or the ending day of the year for which you are running the report.

3. Tax exemption

Specify whether an exemption is applicable. Most companies do not claim a tax exemption, although certain smaller companies are eligible. Values are:

Blank: Not applicable.

1: Applicable.

4. Article 6 of royal decree nr. 50

Specify whether an article 6 of royal decree nr. 50 is applicable. This decree generally applies to small companies and industries, such as small farm operations. Values are:

Blank: Not applicable.

1: Applicable.

5. Minimum Taxable Amount to Report

Specify the minimum taxable amount that must be reported.

6. Final Mode

Specify whether the system executes the report in proof or final mode. Values are:

Blank: Proof mode

1: Final mode

1. Tax exemption

Specify whether an exemption is applicable. Most companies do not claim a tax exemption, although certain smaller companies are eligible. Values are:

Blank: Not applicable.

1: Applicable

2. Start date for exemption

Specify the effective date of the tax exemption.

3. Article 6 or royal decree nr. 50

Specify whether an article 6 of royal decree nr. 50 is applicable. This decree generally applies to small companies and industries such as small farm operations. Values are:

Blank: Not applicable.

1: Applicable.

4. Intrastat tax return

Specify whether an Intrastat tax return is applicable. Only companies for which the article 6 of royal decree nr. 50 is applicable may have to declare an Intrastat tax return. Values are:

Blank: Not applicable.

1: Applicable.

Reporting Year

Quarterly reports must be based on the calendar year, not the fiscal year that is associated with a particular company. The date range is specified in the processing options of the report.

Output

The Quarterly VAT Report (Flat File) program produces a hard copy report, in addition to the standard electronic flat file output. Hard copies of the report contain VAT numbers that are incorrect; the directory and file name of the electronic flat file output; and a cover letter for the Belgian Authorities, which is submitted along with the electronic flat file output. This feature is equivalent to that provided in the Yearly VAT Report (Paper) program (R74B150).

You should print two copies of the final report. You give one copy to the government authorities, and you keep one copy on file for audit purposes. Contact the Belgian tax authorities for more information regarding Belgian tax practices.

Processing Options

A processing option enables the user to produce an equivalent hard copy of the Quarterly VAT Report (Paper) program (R74B300), which can be printed in the format chosen by the user. You can specify the version of the Quarterly VAT Report (Flat File) report to be printed.

You should not include zero VAT amounts in the electronic flat file. You can set the Minimum Taxable Amount to Report processing option on the Process tab to exclude all customers under specified amounts.

Report Execution

The report should be executed locally for the successful creation of the electronic flat file. Two methods are:

• Users can override the default report execution logic settings by choosing Advanced from the Row menu when submitting the report.

• Selecting the LOCAL option. By selecting the LOCAL option, you direct the report to run locally and enable for the creation of the electronic flat file in the local PC directory that is indicated.

Object Configuration Manager (P986110) can be configured so that the execution logic for this program always occurs locally.

Running the Report

Each time that you run the report, you must indicate a unique file name for the output. If you run the same report twice with the same file name indicated, you double the data that is contained in the electronic file output.

Report Validation

This report validates the VAT number, or Tax Identification number, of each customer, according to the validation routines that are appropriate to each EU country.

Validation occurs when the report is submitted. If an incorrect VAT number is encountered, the first page of the report output describes the number and the type of error that are encountered.

The VAT number, or Tax Identification number, is stored in the TaxId field (Alias TAX) field that is located in the F0101 table.

If invalid VAT numbers are associated with customer records, you must correct those numbers and rerun the report to avoid the government-assessed penalty.

Note. You should run the report in proof mode until all of the VAT validation issues are corrected.

VAT Numbers

In some cases, such as recognized health care providers, you might not have a VAT number for that customer. In those cases, you can assign 99_NB as a VAT/Tax ID value.

For any case for which you do not know the VAT number, you can enter 99_unknown or 99_onbekend in the VAT/Tax ID field.

Multiple Company Reporting

The Quarterly VAT Report (Flat File) program supports multiple company reporting for the paper report and the electronic file. You select multiple company reporting by including multiple companies in the data selection.

Note. For electronic reporting, the program produces a flat file in the format that is accepted by the Belgian authorities. However, for paper reporting, you might need to submit a separate cover letter to the Belgian authorities that includes a description of each of the companies and its VAT information.

1. Start date and 2. End date

Specify the first day of the quarter or the ending day of the quarter being reported.

3. Quarter

Specify the reporting quarter. You must specify the quarter by using a value that is set up in the Processing Quarter UDC (07/QU).

4. Minimum Taxable Amount to Report

Specify the minimum taxable amount to report.

5. Proof or Final Mode. Enter 1 to run in Final Mode

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

Blank: Proof mode

1: Final mode

Code Column

You might want to use the code blank or T. The three countries involved must be European member states.

• Company A in country 1 sells and invoices goods to Company B in country 2.

• Company B in country 2 sells and invoices the goods to Company C in country 3.

• Company A in country 1 ships the goods directly to Company C in country 3, and Company B assigns C as the entity that is responsible for VAT registration.

Case 1 - Country 1 = Belgium

Company A reports this as a Category 1 transaction, so the Code field is blank.

Case 2 - Country 2 = Belgium

Company B reports this as a Category 2 transaction, so the Code field is updated with T.

Case 3 - Country 3 = Belgium

Company C has nothing to declare because it does not sell to the EC.

Summary:

T is used if goods are invoiced and delivered to a customer in another EC member state (bill-to and ship-to), and the goods themselves are purchased and shipped immediately from a vendor in another EC member state. The goods do not arrive in the warehouses of the reporting company.

Notes Column

You might want to use this column to indicate that manual adjustments have been made to this customer's sales total.

R76321B

Transaction Journal

Lists and totals all of the journal entries in the Journal Entry Book by company, day, and accounting period. The system prints an ending balance for each page and carries that balance forward to the next page so that each page of the journal can stand alone.

G/L Report - Brazil (G76B09), Transaction Journal

R76B09410

Four Columns Trial Balance

Prints a trial balance report that shows total debits and credits for each account.

G/L Reports - Brazil (G76B09), Four Columns Trial Balance

R76B420

General Ledger

Lists all transactions by company and general ledger account for a specific accounting period. The report includes all general ledger accounts with a post edit code, even if the amount for the account is zero.

G/L Reports - Brazil (G76B09), General Ledger

1. Mode

Enter 1 to run the report in final mode. The system updates the next number of the fiscal book that is based on the next numbers which you have set up for the company.

If you leave this processing option blank, the report does not update the page number.

2. Opening and Closing Statement

Enter 1 to print Opening Statement and Closing Statement on the report. If you are running the report in final mode, you must enter 1 for this processing option.

3. Subledgers

Enter 1 to print subledgers on the report.

4. JE Explanation

Specify one of these values:

1: Print JE explanation 1

2: Print JE explanation 2

If you leave this processing option blank, both explanation 1 and explanation 2 print on the report.

5. Pages

Enter the number of pages to include between the last page and Closing Statement.

6. Statement Codes

Enter statement codes in the Opening and Closing processing options. Values are:

A: Opening statement codes (default).

E: Closing statement codes.

1. Report Date

Enter the report (issue) date. If you leave this processing option blank, the system date is used. This date will be updated in the next numbers table if you run the report in final mode.

2. Beginning Date and 3. Ending Date

Enter the beginning and ending date to use for the transactions.

4. Reference Month and 5. Reference Year

Enter the reference month and year to print in the report header.

6. Suppress Printing

Enter 1 to not print the transaction date in the report header or leave this processing option blank to print the transaction date.

1. Company

Enter the company to print in the report header. This processing option is required.

1. Book Code

Enter the book code or leave this processing option blank for DG.

1. Fiscal Year and Period Number

For the fiscal year, specify the last two digits of the fiscal year, for example, enter 07 for 2007. If you complete the Fiscal Year processing option, you must also complete the Period Number processing option.

For the period number, specify the period. If you complete the Period Number processing option, you must also complete the Fiscal Year processing option.

Print

Specify whether to include accounts with zero balances for the specified period. Values are:

Blank. Include accounts with zero balances.

1: Do not include accounts with zero balances.

Accounts that are assigned a posting edit code N print even when you set this processing option to 1. Accounts that are assigned a posting edit code N are header accounts, which do not have balances.

Level of Detail

Specify the lowest level of detail (3–9) to print on the report. For example, if you specify level 7 as the lowest level and your chart of accounts includes levels 8 and 9, level 7 will include the totals for accounts with level 8 and 9 amounts, but the system will not print the detail for levels 8 and 9. If your chart of accounts skips levels, the system might produce inaccurate results when it rolls up detail levels.

Alternatively, you can leave this processing option blank to print all levels of detail on the report.

Ledger Type

Specify the type of ledger. Enter a value from UDC table 09/LT. If you do not complete this processing option, the system prints amounts for ledger type AA.

If you specify the CA ledger type and the CA ledger type includes amounts for multiple currencies, the totals will be meaningless.

Currency Code

Specify the currency that the system includes in the report when you post account balances by currency. To limit the report to amounts for a specific currency code, enter the code for the currency. The value that you enter must exist in the F0013 table. To include amounts for all currencies, enter *.

Leave this processing option blank if you do not post balances by currency.

1. From Period/Date

Specify a from period or enter a from date in which to begin printing account balances in detail. For a from period, values are:

0: Year to date.

1: Current period.

2: Inception to date.

2. Thru Fiscal Year/Period or Thru Date

Specify a through fiscal year and fiscal period or enter a through date in which to print account balances in detail. for which the account balances are to be shown in detail.

1. Account Number

Specify one of these account formats to use to print account numbers on the report:

1: Account number (default).

2: Short account ID.

3: Unstructured account.

2. Print Units (FUTURE)

Reserved for future use.

3. New Page

Enter 1 to skip to a new page when a new business unit is printed or leave this processing option blank to print without page breaks.

4. Omit Accounts

Enter 1 omit accounts that have no balance or detail for the selected period to print on the report.

1. Ledger Type

Enter a ledger type code from UDC table 09/LT or leave this processing option blank to include ledger type AA.

2. Document Type (FUTURE)

Reserved for future use.

3. Posted/Unposted

Enter 1 to print both posted and unposted transactions or leave this processing option blank to print only posted transactions.

1. Subledger and 2. Subledger Type

Enter a specific subledger or enter * to print include all subledgers. If you enter a specific subledger, you must also enter a subledger type.

3. Print Subledger

Enter 1 to print the subledger on the report or leave this processing option blank if you do not want subledger to print.

1. Currency Code (FUTURE)

Reserved for future use.

1. Summary

Specify a specific business unit type for object range summarization or enter + to include all types or * to include all nonblank types.

2. Business Unit Type

Enter a beginning and an ending object for the object account range for account summarization.

1. Date Order

Enter 1 to print detail information in ascending date order or leave this processing option blank to print in descending date order.

1. Company Number

Enter a company number to print for each page heading.

R0018P8

GST/PST Tax

Use this program to print GST/PST tax amount for each tax authority. The report lists GST and PST and subdivides PST into seller-assessed PST and self-assessed PST.

Tax Processing and Reporting (G0021), GST/PST Tax

1. Detail Records

Enter a 1 to flag the detail records as having been printed.

1. Tax Identification

1. Enter the form of tax identification displayed on the report.

Blank. No ID displayed

1. European Company ID

2. European Individual ID

3. Tax ID

2. Tax Amount

Enter a 1 to reverse the sign on the Self Assessment (Use) Taxes. If left blank, the tax amount will print with the sign in the tax file.

R76H4020

(CHL) Rents Withholding Ledger

Use this report to review the posted transactions for which income tax withholding applies for a specified period. The report is sorted by voucher date, internal document type, and number.

Accounts Payable (G76H04), Rents Withholding Ledger

R76H4030

(CHL) Rents Withholding Certificate

Use this report to obtain the annual fees withholding certificate by supplier and legal company for the specified year. This report includes the fees paid for each month.

Accounts Payable (G76H04), Rents Withholding Certificate

R76H9001

(CHL and PER) Account Balance by Object Account

Lists all accumulated balances for a fiscal period by object account.

This report shows debit and credit balances from the F76H902T table. Information in this table is updated when you update the F0902 table.

General Accounting (G76H09) or General Accounting (G76P09), Account Balance by Object Account

R76H9003

(CHL and PER) General Journal

Lists all journal entries for a specific period and assigns the legal number to each entry.

General Accounting (G76H09) or General Accounting (G76P09), General Journal

R76H9005

(CHL and PER) Print Number (folio) Blank Pages

Prints legal company information, report heading titles, and page numbers, based on processing option settings.

The decimal position for amounts that appear on this general ledger legal report are defined for each currency in the Designate Currency Codes program (P0013). You can print unique page numbers for all reports or unique page numbers for individual reports and, if necessary, you can print page numbers on blank pages. Do not enter data selection.

General Accounting (G76H09) or General Accounting (G76P09), Print Number (folio) Blank Pages

R76H9421

(CHL and PER) Account Ledger by Object Account

Lists all transactions for a specific period by object account.

This report uses the standard processing options available for the General Ledger by Object Account report as well as specific processing options for localization. Versions exist for each category code (21–23).

Data selection is by general ledger accounts with the category code specified in the version. Data sequence is by legal company, category code, and general ledger account ID.

General Ledger (G76H09) or General Accounting (G76P09), Account Ledger by Object Account

R76P9470

(CHL and PER) Account Ledger by Category Code

Lists all transactions for a specific period by category code.

This report uses the standard processing options available for the General Ledger by Object Account report as well as specific processing options for localization.

General Ledger (G76H09) or General Accounting (G76P09), Account Ledger by Category Code

R76P4040

(PER) IGV Withholding Ledger

Use the general sales tax withholding ledger report (Impuesto General a la Venta)[IGV]) to generate a report of the transactions for which IGV tax was withheld.

Accounts Payable (G76P04), IGV Withholding Ledger

R76P4050

(PER) Profit Withholding Certificate

Run the Profit Withholding Certificate program to generate the certificates that show the professional fees and withholding amounts withheld from suppliers.

Accounts Payable (G76P04), Profit Withholding Certificate

R76P4510

(PER) IGV PDT

Use the general sales tax electronic media (IGV) (Programa de Declaración Telematica [PDT]) program write records to the Text Processor Header (F007101) and Text Processor Detail (F007111) tables. You then use the Text File Processor program (P00710) to work with the records and generate a flat file for IGV withholding.

Accounts Payable (G76P04), IGV PDT

R76P4600

(PER) IGV Withholding Report

Use this report to view information related to SPOT vouchers. The report includes the bank deposit number and deposit date for the original vouchers from which the SPOT vouchers are generated.

Accounts Payable (G76P04), IGV Withholding Report

Mode

Enter 1 to print in final mode and update tables. Leave this processing option blank to print in proof mode.

Legal Company

Enter the legal company for which you run the report.

Reprint Documents

Enter 1 to reprint document which have been printed. Enter 2 to include in the report transactions which have not been printed, and transaction which have been printed. Leave this processing option blank to print the transaction which have not been printed.

Date From

Enter the first date of a range of dates that the system uses to select records to process.

Date Thru

Enter the last date of a range dates that the system uses to select records to process.

Document Type

Enter a document type which exists in the Document Type (00/DT) UDC table that the system uses to determine the next legal number used for the folio. If you leave this processing option blank, the system does not assign a folio number.

Report Title

Enter 1 in the first field to suppress printing of a report title. Leave the first field blank to print the report title that you enter in the second and third fields. You can enter up to 40 characters each in the second and third fields.

Legal Company Printed in Header

Leave this processing option blank to print information about the legal company in the report header. Enter 1 to suppress printing of the legal company information.

Proof or Final Mode

Enter 1 to print in final mode and update tables. Leave this processing option blank to print in proof mode.

Legal Company

Enter the legal company for which you run the report.

Adjustment Code

Enter a value from the Adjustment Code (76A/CA) UDC table to specify the inflation index code that the system uses to select records to process.

Document Type

Enter a value from the Document Types (00/DT) UDC table to specify the document type that the system uses to select records to process.

Year - Calendar Year

Enter a one-digit or two-digit number for the calendar year for which you run the report.

City

Enter the city from which the certificate is issued. If you leave this processing option blank, the system uses the city of the company as specified in the address book record for the company.

Issue Date

Enter the issue date of the certificate. If you leave this processing option blank, the system uses the system dates.

Report Title

Leave this processing option blank to print the report title that you enter in the Report Title Line 1 and the Report Title Line 2 processing options. Enter 1 to suppress printing of a report title.

Report Title Line 1

Enter up to 40 characters that the system prints as the report title.

Report Title Line 2

Enter up to 40 characters that the system prints as additional text for the report title.

Print Company Header Information

Leave this processing option blank to print information about the legal company in the report header. Enter 1 to suppress printing of the legal company information.

Print Footer Information

Leave this processing option blank to print the footer message. Enter 1 to suppress printing of the footer message.

Concept Description

Enter a description for the rent withholding concept.

1. Cost Center

Specify how to print cost centers. Values are:

Blank: Print detail by cost center.

1: Print all of the cost centers for a legal company and print summary information for the object and subsidiary account.

2. Level of Detail

Specify the level of detail. The system summarizes all general ledger balances by the account level of detail specified. Values are 3–9. The default value is 9.

3. Legal Company

Specify the company number in which to retrieve general ledger balances.

4. Process Method

Specify the process method. Values are:

Blank: Print asset and liabilities according to the operation sign. Asset accounts appear with a positive sign in the Asset column and liabilities appear with a negative sign in the Liability column.

A: Print asset accounts in the Asset column and liability accounts in the Liability column according to AAI items GLG2 (Beginning Assets) and GLG3 (Beginning Liabilities).

5. Mode

Specify the processing mode in which to run the report. Values are:

Blank: Proof (trial) mode.

1: Final mode.

6. Business Unit

Specify the business unit in which to print object and subsidiary accounts.

Ledger Type

Specify the ledger type code from the UDC table 76H/XX (76H is the product code, and XX is the user-defined code). The system uses LL (ledger types to process) as the default value.

Category Code

Specify the category code (UDC table 09/21–09/23) in which to group the general ledger accounts. The category code description appears on the report instead of the general ledger account.

If you leave this processing option blank, balances are grouped by object and subsidiary account.

Document Type

Specify the document type to use to retrieve the next number by company. The document type must exist in UDC table 00/DT. The system uses next numbers by company and document type to assign the page number on the report.

If you leave this processing option blank, no page number is assigned.

Print Report Title

Specify whether to print the report title.

Blank: Print the report title. The system uses the titles from the Report Title and Report Title Continuation processing options.

1: Do not print the report title.

Report Title

Enter the report title that you want to appear in the report heading.

Report Title Continuation

Enter the remainder of the report title, if applicable.

Legal Company Information

Specify whether to print legal company information.

Blank: Print the legal company information on the report. The system uses the legal company information from the JD Edwards EnterpriseOne Address Book system, which includes registered name, address, company's line of business, agents, and representatives.

1 Do not print the legal company information on the report.

Accounts with Zero Amounts

Specify whether to print accounts with zero amounts.

Blank: Do not print accounts with zero amounts.

1 Print accounts with zero amounts.

2: Do not print accounts with zero amounts and with the same level of detail that is specified in the Level of Detail processing option.

Period Number

Specify the tax period to print on the report.

Fiscal Year

Specify the fiscal year to print on the report.

Mode

Specify the processing mode in which to run the report. Values are:

Blank: Proof mode. The system starts the page numbering with 1.

1: Final mode. The system uses the next number of the company and document type for the page number

1. Document Type

Specify the document type to use to retrieve the next number by company. The document type must exist in UDC table 00/DT. The system uses next numbers by company and document type to assign the page number on the report.

If you leave this processing option blank, no page number is assigned.

2. Print Report Title

Specify whether to print the report title.

Blank: Print the report title. The system uses the titles from the Report Title and Report Title Continuation processing options.

1: Do not print the report title.

3. Report Title

Enter the report title that you want to appear in the report heading.

4. Report Title Continuation

Enter the remainder of the report title, if applicable.

1. From Date and 2. Thru Date

Specify the beginning and ending dates in which to print detailed journal entries for this report.

1. Legal Company

Specify the company number in which to retrieve general ledger balances. If you leave this processing option blank, the system uses company 00000.

2. Ledger Type

Specify the ledger type code from the UDC table 76H/XX (76H is the product code, and XX is the user-defined code). The system uses LL (Ledger types to process) as the default value.

1. Account Number Category Code

Specify the account number category code to print on the report. Values are 21, 22, and 23.

If you leave this processing option blank, the system prints the account number.

1. Adjustment Registration Date

Specify a registration date to use for the report. If you leave this processing option blank, the system uses the general ledger date of the adjustment.

2. Registration Entry

Specify how the system determines the next available registration number for adjustments. Values are:

Blank: Use the fiscal year from the registration date in the Adjustment Registration Date processing option.

1: Use the fiscal year from the general ledger date of the adjustment. This value is not recommended.

1. As if Currency

Specify the currency code to use for as if currency reporting. Use this processing option to convert and print amounts in a currency different from the currency in which they were originally entered. If you leave this processing option blank, amounts print in the domestic currency of the company.

2. As if Date

Enter the as if date to use to retrieve the exchange rate for the currency specified in the As if Currency processing option.

If you leave this processing option blank, the system uses the system date to retrieve the exchange rate.

1. Legal Company

Specify the company number in which to retrieve the transactions.

2. Document Type

Specify the document type to use to retrieve the next number by company. The document type must exist in UDC table 00/DT. The system uses next numbers by company and document type to assign the page number on the report.

If you leave this processing option blank, the number specified in the Initial Number processing option is used as the initial page number.

3. Initial Number

Enter the initial page number to use. Ensure that the Document Type processing option is blank.

If you leave this processing option blank, the system uses next numbers by company for the document type specified in the Document Type processing option.

1. Pages Quantity

Specify the number of pages to print.

2. Titles

Specify whether to print the report title.

Blank: Print the report title. The system uses the titles from the Legal Company Information and Report Title processing options.

1: Do not print the report title.

3. Legal Company Information

Specify whether to print legal company information.

Blank: Print the legal company information on the report. The system uses the legal company information from the JD Edwards EnterpriseOne Address Book system, which includes registered name, address, company's line of business, agents, and representatives.

1: Do not print the legal company information on the report.

4. Report Title

Enter the report title to appear in the report heading.

5. Report Title Continuation

Enter the remainder of the report title, if applicable.

1. Document Type

Specify the document type to use to retrieve the next number by company. The document type must exist in UDC table 00/DT. The system uses next numbers by company and document type to assign the page number on the report.

If you leave this processing option blank, no page number is assigned.

2. Print Report Title

Specify whether to print the report title.

Blank: Print the report title. The system uses the titles from the Report Title and Report Title Continuation processing options.

1: Do not print the report title.

3. Report Title

Enter the report title that you want to appear in the report heading.

4. Report Title Continuation

Enter the remainder of the report title, if applicable.

5. Legal Company Information

Specify whether to print the legal company information in the heading of the report.

Blank: Print the legal company information in the heading of the report. The system uses the legal company information from the JD Edwards EnterpriseOne Address Book system, which includes registered name, address, company's line of business, agents, and representatives.

1: Do not print the legal company information in the heading on the report.

Legal Company

Specify the company number in which to retrieve the transactions.

Mode

Specify the processing mode in which to run the report. Values are:

Blank: Proof mode. The system starts the page numbering with 1.

1: Final mode. The system uses the next number of the company and document type for the page number

1. Document Type

Specify the document type to use to retrieve the next number by company. The document type must exist in UDC table 00/DT. The system uses next numbers by company and document type to assign the page number on the report.

If you leave this processing option blank, no page number is assigned.

2. Print Report Title

Specify whether to print the report title.

Blank: Print the report title. The system uses the titles from the Report Title and Report Title Continuation processing options.

1: Do not print the report title.

3. Report Title

Enter the report title that you want to appear in the report heading.

4. Report Title Continuation

Enter the remainder of the report title, if applicable.

5. Legal Company Information

Enter the legal company.

6. Legal Company

Specify whether to print the legal company information in the heading of the report.

Blank: Print the legal company information in the heading of the report. The system uses the legal company information from the JD Edwards Enterprise One Address Book system, which includes registered name, address, company's line of business, agents, and representatives.

1 Do not print the legal company information in the heading on the report.

Proof or Final Mode

Enter 1 to print in final mode and update tables. Leave this processing option blank to print in proof mode.

Legal Company

Enter the legal company for which you run the report.

Reprint

Enter 1 to reprint previously printed vouchers. Leave this processing option blank to suppress printing of previously printed vouchers.

Document Type

Enter a value from the Document Types (00/DT) UDC table to specify the document type that the system uses to select records to process.

Title

Leave this processing option blank to print the report title that you enter in the Report Title Line 1 and the Report Title Line 2 processing options. Enter 1 to suppress printing of a report title

Title First Line

Enter up to 40 characters that the system prints as the report title.

Title Second Line

Enter up to 40 characters that the system prints as a second line of the report title.

Print Company Header Information

Leave this processing option blank to print information about the legal company in the report header. Enter 1 to suppress printing of the legal company information.

Date From

Enter the first date of a range of dates that the system uses to select records to process.

Date Thru

Enter the last date of a range of dates that the system uses to select records to process.

Legal Company

Enter the legal company for which you run the report.

Fiscal Year

Enter a one-digit or two-digit number for the calendar year for which you run the report.

Report Title

Leave this processing blank to print the text that you enter in the Title processing options. Enter 1 to suppress printing of the report title.

Title

Enter the text that the system prints as the report title. You can enter up to 40 characters.

Title (continued)

Enter additional text that the system appends to the text that you enter in the Title processing option. You can enter up to 40 characters.

Print Legal Company Information

Leave this processing option blank to print information about the legal company in the report header. Enter 1 to suppress printing of the legal company information.

Legal Company

Enter the legal company for which you run the report.

Century

Enter the first two digits of the calendar century associated with the year.

Fiscal Year

Enter a one-digit or two-digit number for the calendar year for which you run the report.

Period Number

Enter the number of the accounting period for which you run the report.

Mother's Name Type Code

Enter a value from the Type Code (01/W0) UDC table that identifies the supplier's mother's name. You complete this option only when the supplier is an individual.

Father's Name Type Code

Enter a value from the Type Code (01/W0) UDC table that identifies the supplier's father's name. You complete this option only when the supplier is an individual.

Proof or Final Mode

Enter 1 to print in final mode and update tables. Leave this processing option blank to print in proof mode.

Reprint

Enter Y to generate a certificate with a new legal number. Leave this processing option blank to use the same legal number when you reprint.

R76C0001

Rent Withholding

Use version ZJDE0001 to view rent withholding certificates, version ZJDE0002 to view to view rent withholding by GL offset, and version ZJDE0003 to view rent withholding by tax area.

Tax Reports (G76C13), Rent Withholding

R76C0002

Withholdings Report

Use version ZJDE0001 to view withholding transactions by document and version ZJDE0002 to view withholding transactions for which payment was made to a third-party.

Tax Reports (G76C13), Withholdings Report

R76C0003

VAT Withholding

Use version ZJDE0001 to view VAT withholding by account, version ZJDE0002 to view VAT withholding by GL offset, and version ZJDE0003 to view VAT withholding by tax area.

Tax Reports (G76C13), VAT Withholding

R76C0004

Timbre Withholding

Use this report to print the withholding certificate.

Tax Reports (G76C13), Timbre Withholding

R76C0911

General Journal by Category Code

Prints balance information for category 21, 22, or 23. This report is useful for statutory accounting.

Fiscal Books by Category Code (G76C15), General Journal by Category

R76C0911A

G/L with Total by Object Account

Prints a daily book that has been developed according to the DIAN reports requirements.

Fiscal Books without Category Code (G76C152), G/L with Total by Object Account

R76C094

Inventory and Balance Sheet by Category Code

Generates the inventory and balance fiscal book by category code.

Fiscal Books by Category Code (G76C15), Inventory and Balance by Category Code

R76C094B

Inventory and Balance Sheet by Object Account

Generates the inventory and balance fiscal book by account.

Fiscal Books without Category Code (G76C152), Inventory and Balance by Object Account

R76C0941

Trial Balance by Category Code

Prints a report if the PUC is assigned category code 21, 22, or 23 in the chart of accounts.

Fiscal Books by Category Code (G76C15), Trial Balance by Category Code

R76C09411

Debits and Credits T/B by Object Account

Prints a general ledger report by account and has been developed according to DIAN reports requirements.

This report prints if the PUC is assigned category code 21, 22, or 23 in the chart of accounts. The PUC is specified in the object account.

Review the data selection for this report to ensure that it corresponds to the processing options that you set for the report. For the process number, specify the next number from UDC table 76C/02.

Fiscal Books without Category Code (G76C152), Debits and Credits T/B by Object Account

R76C094211

G/L with Subledger Totals

Prints only subledgers with activity during the specified period.

Fiscal Books by Category Code (G76C15), G/L with Subledger Totals

R76C9415B

Daily Book by Complete Document

Prints a general ledger report with debit and credit amounts. Print this report to satisfy the DIAN (Direccion de Impuestos y Aduanas Nacionales de Colombia) requirements of producing a report showing all accounting transactions with matching documents.

No processing options exist for this report.

Fiscal Books without Category Code (G76C152), Daily Book by Complete Document

R76C9422

G/L by Object Account with Subledger Total

This report prints a general ledger with subledger totals for active subledgers for the period specified in the processing options. The report includes previous balances by subledger. The report has been developed according to the DIAN reports requirements

Fiscal Books without Category Code (G76C152), G/L by Object Account with Subledger Total

Period

Enter the period for which you run the report. You must enter a range of dates in the data selection.

Issue Date

Enter the issue date to be printed on the certificate. If you leave this processing option blank, the system uses the system date.

City

Enter the city where the deposit for the withholding was made.

Print City

Enter 1 to print on the certificate the city in which the withholding occurred.

Level

Enter the level break that is specified in the data sequence. Enter 1 to break on account. Enter 2 to break on tax area. Enter 3 to break on GL offset. If you do not complete this processing option, the system breaks the report on the account.

Company

Enter the company that the system uses when generating or regenerating records. If you leave this processing option blank, the system processes records for all companies.

Name

Enter the name of the person who is responsible for the information shown in the certificate.

Additional Information

Enter additional information that appears on the certificate.

Print Percentage

Enter 1 to print on the certificate the percentage of the withholding.

Reverse Sign

Enter 1 to reverse the sign for the fiscal rate and the total tax amount.

Name

Specify the name of the third-party that the system prints on the certificate. Enter 1 to print the value from the Alpha Name field (ALPH). Enter 2 to print the value form the Address field (ADD1). Enter 3 to print the value from the Notes field (DS01). If you leave this processing option blank, the system prints the value from the Alpha Name field.

Regenerate

Enter 1 to delete all data in the F76CT2 table.

Date From

Enter the first day of the range of dates that the system uses to select records from the F76CT2 table to delete.

Date To

Enter the last day of the range of dates that the system uses to select records from the F76CT2 table to delete.

Address Number

Enter the address number that the system uses to select records to delete from the F76CT2 table.

Title

Enter the title to print on the certificate.

IVA Withholding

Enter 1 to generate a certificate of IVA withholding (Print IVA Amount). Enter a different character to generate other certificates.

Consolidate

Enter 1 to print one certificate for all companies.

Tolerance Level

Enter 1 to specify a percentage as a tolerance level in order to approach the percentage of the IVA withheld to a 50 percent or 100 percent.

Percentage

Enter the value to use as tolerance level for the print of the IVA withheld.

Note. Enter the percentages in integers. For example, enter 3 percent as 3.

Date From

Enter the first day of the range of dates that the system uses to select records to process.

Date Thru

Enter the last day of the range of dates that the system uses to select records to process.

Tax Area Description

Enter 1 to print the tax area description at the top of the page. Enter 2 to print the account description.

Note. This parameter must be equal to the sequence order.

Reverse Sign

Enter 1 to reverse the sign in A/R transactions.

Skip Lines

Enter 1 to skip to lines when either the document number or GL date is not sequential.

Company to Generate or Regenerate

Enter the company that the system uses when generating or regenerating records. If you leave this processing option blank, the system processes records for all companies.

Totals by Document

Enter 1 to print totals by document. A different value will print totals by third-party.

A/P Tax Report

Enter 1 to print an A/P Tax Report. A different value prints the A/R Tax Report.

Note. The batch type in the data selection of an AP tax report must be different from the batch type in the data selection of an A/R tax report.

Regenerate

Enter 1 to delete all data in the F76CT2 table.

Date From

Enter the first day of the range of dates that the system uses to select records from the F76CT2 table to delete.

Date To

Enter the last day of the range of dates that the system uses to select records from the F76CT2 table to delete.

Address Number

Enter the address number that the system uses to select records to delete from the F76CT2 table.

Line Two

Enter the text that the system prints as line two of the report title. This processing option is optional.

Line Three

Enter the text that the system prints as line three of the report title. This processing option is optional.

Period

Enter the period for which you run the report. You must enter a range of dates in the data selection.

Issue Date

Enter the issue date to be printed on the certificate. If you leave this processing option blank, the system uses the system date.

City

Enter the city where the deposit for the withholding was made.

Print City

Enter 1 to print on the certificate the city in which the withholding occurred.

Level

Enter the level break that is specified in the data sequence. Enter 1 to break on account. Enter 2 to break on tax area. Enter 3 to break on GL offset. If you do not complete this processing option, the system breaks the report on the account.

Name

Enter the name of the person who is responsible for the information shown in the certificate.

Additional Information

Enter additional information that appears on the certificate.

Print Percentage

Enter 1 to print on the certificate the percentage of the withholding.

Reverse Sign

Enter 1 to reverse the sign for the fiscal rate and the total tax amount.

Name

Specify the name of the third-party that the system prints on the certificate. Enter 1 to print the value from the Alpha Name field (ALPH). Enter 2 to print the value form the Address field (ADD1). Enter 3 to print the value from the Notes field (DS01). If you leave this processing option blank, the system print the value from the Alpha Name field.

Regenerate

Enter 1 to delete all data in the F76CT2 table.

Date From

Enter the first day of the range of dates that the system uses to select records from the F76CT2 table to delete.

Date To

Enter the last day of the range of dates that the system uses to select records from the F76CT2 table to delete.

Address Number

Enter the address number that the system uses to select records to delete from the F76CT2 table.

Title

Enter the title to print on the certificate.

VAT Withholding

Enter 1 to generate a certificate of VAT withholding. Enter a different character to generate other certificates.

Consolidate

Enter 1 to print one certificate for all companies.

Tolerance Level

Enter 1 to specify a percentage as a tolerance level in order to approach the percentage of the VAT withheld to a 50 percent or 100 percent.

Percentage

Enter the value to use as tolerance level for the print of the VAT withheld.

Note. Enter the percentages in integers. For example, if the value is 3 percent, enter 3.

Dates From and Dates To

Enter the date range in which to print transactions.

Category Code

Enter the category code 21, 22, or 23in which the PUC is specified.

Dates From and Dates To

Enter the date range in which to print transactions.

1. Period

Enter the fiscal year and period number to generate the report. These dates must match the dates entered for the Data File Generation A/R and Data File Generation A/P programs.

1. Zero Accounts

Leave this processing option blank to include active accounts with zero amounts in the report. Enter 1 to suppress printing of accounts with zero amounts.

2. A/P Third Party (accounts payable third party)

Leave this processing option blank to include detailed balances by accounts payable subledger. Enter 1 to suppress printing of detailed balances.

3. A/R Third Party

Leave this processing option blank to include detailed balances by accounts receivable subledger. Enter 1 to suppress the printing of detailed balances.

4. Other Third Party

Leave this processing option blank to include detailed balances for accounts different from accounts payable and accounts receivable. Enter 1 to suppress printing of detailed balances.

1. Level of Detail

Enter the detail level for category code 21 for which inventory and balance report generation is required. If you leave this processing option blank, the system prints all levels.

1. Ledger Type

Enter the ledger type from UDC table 09/LT in which to generate the report. If you generate more than one ledger type (book), separate the ledgers with a comma.

If you leave this processing option blank, the system uses ledger type AA.

PUC Category Code - Colombia

Enter the category code (21) from which information is retrieved for the report.

Category Code used for PUC levels - Colombia

Enter 13 for this processing option. This value is required. It corresponds to category code 09/13 and contains PUC level accounts, which are updated by the Update Level in Category Code programs.

1. Fiscal Year and Period Number

Enter the fiscal year and period number in which to generate the report.

Printing Level

Specify the account level of detail for category code 21. Ensure that you associate a level to the category code to print header and total lines.

If you leave this processing option blank, the system prints all levels.

1. Ledger Types

Enter the ledger type from UDC table 09/LT in which to generate the report. If you generate more than one ledger type (book), separate the ledgers with a comma.

If you leave this processing option blank, the system uses ledger type AA.

PUC Category Code - Colombia

Enter the category code (21) from which information is retrieved for the report.

Category Code used for PUC levels - Colombia

Enter 13 for this processing option. This value is required. It corresponds to category code 09/13 and contains PUC level accounts, which are updated by the Update Level in Category Code programs.

1. Regenerate F76C0902

Enter 1 to regenerate the F76C0902 table and print the report with a new data selection. If you enter any other value, the report does not regenerate the table.

2. Company

Specify the company in which to generate the report. If you leave this processing option blank, the report includes all companies (consolidation).

3. Purge Files

Specify whether to purge tables for the company specified in the Company processing option. Values are:

Blank: Do not purge tables

1: Purge tables.

1. Group

Specify how to group the report. Values are:

1: Group by business unit

2: Group by company

3: Group all companies

1. Optional Report Title

Enter a title for the report in the processing options for Line 1 and Line 2.

1. Version

Enter the version for the R76C0902A

Ledger Type I, Ledger Type II, Ledger Type III, and Ledger Type IV

Specify a ledger type from UDC table 09/LT. You can specify up to four ledger types.

Subledger

Specify the general ledger subledger. If you leave this processing option blank, the system uses * for all subledgers.

1. Report Content

Specify the transactions to show in detail (not summarized as a balance forward). Values are:

0: Year to date.

1: Current period.

2: Inception to date.

3: Period Range. (You must enter dates in the second processing on the Dates tab.

1. Fiscal Year and Period

Enter the fiscal year and period for which the general ledger is to be prepared. If you leave this processing option blank, the system uses the financial reporting year and period for the company.

2. Fiscal Year and Period

Enter the fiscal year and period number if the Report Content processing option is 3.

1. Account Format

Specify the account number to print.

1: Account number.

2: Short account ID.

3: Unstructured account.

2. Print Units

Specify whether to print units. Values are:

Blank: Do not print units. (Print amounts only.)

1: Print units.

3. Omit Zero Balance

Specify whether to include accounts that have no balance and no detail for the specified period. Values are:

Blank: Include accounts.

1: Omit accounts.

1. Document Type

Specify whether to include a document type if a specific ledger is used. If you leave this processing option blank, all document types are included.

2. Subledger

Enter a specific subledger or enter * for all subledgers.

3. Subledger Type

Enter the subledger type if you entered a specific subledger in the Subledger processing option.

1. Currency Code

Enter a specific currency code or enter * for all currency codes.

1. Ledger Types

Enter the ledger types to print on the report. If you leave the first processing option blank, the system uses ledger type AA.

Enter values for the three remaining Ledger Type processing options, if applicable.

R00314

(FRA) Bank Account Exception Report

Lists any drafts with an invalid bank transit number, customer bank account number, or control digit.

Draft Remittance and Collection (G03B162), Bank Account Exception Report

R09473

(FRA, ITA, USA) Debit/Credit T/B by Object

Verifies the accuracy of transactions in individual account ledgers. When all of the transactions are accurate, the totals in this report equal the totals in the G/L reports and the G/L Registration Report (R09404).

French Reports (G093151), T/B by Object and Subsidiary

R70470

(ESP, FRA, ITA) G/L by Category Code

Validates information in legal reports and can be used as the basis for internal auditing. You can also use the report as a basis for external auditing by a third-party, such as a fiscal authority or auditing firm.

French Reports (G093151), G/L by Category Code

R70472

(FRA, ITA) T/B by Category Code

Verifies the accuracy of transactions in individual account ledgers. When all of the transactions are accurate, the totals in this report equal the totals in the General Ledger report and the General Ledger Registration report.

French Reports (G093151), T/B by Category Code

R7403B926

(FRA, ITA) A/R Inventory Book

The A/R Inventory Book report lists the total open amount for each customer by company. If a customer has open amounts in more than one company, the open amount for each company is listed separately.

French Reports (G093151), A/R Inventory Book.

R7404026

(FRA, ITA) A/P Inventory Book

The A/P Inventory Book report lists the total open amount for each supplier by company. If a supplier has open amounts in more than one company, the open amount for each company is listed separately.

French Reports (G093151), French Reports.

R74099A

(FRA, ITA) Sequential Number Report - Tax File

Use this report to verify that document numbers are in sequential order without interruptions, the system prints a report based on the Taxes table (F0018).

French Reports (G093151), Sequential Number Report - Tax File.

R74099B

(FRA, ITA) Sequential Number Report - A/P Ledger

Use this report to verify that document numbers are in sequential order without interruptions, the system prints a report based on the Accounts Payable Ledger (F0411).

French Reports (G093151), Sequential Number Report - A/P Ledger.

R74099C

(FRA, ITA) Sequential Number Report - A/R

Use this report to verify that document numbers are in sequential order without interruptions, the system prints a report based on the Customer Ledger (F03B11).

French Reports (G093151), Sequential Number Report - A/R

R7409C1

(ESP, FRA, ITA) G/L by Object and Subsidiary

Validates information in legal reports and can be used as the basis for internal auditing. You can also use this report as a basis for external auditing by a third-party, such as a fiscal authority or auditing firm.

French Reports (G093151), G/L by Object and Subsidiary.

R7409C3

(FRA, ITA) T/B by Object and Subsidiary

Verifies the accuracy of transactions in individual account ledgers. When all of the transactions are accurate, the totals in this report equal the totals in the General Ledger report and the General Ledger Registration report.

French Reports (G093151), T/B by Object and Subsidiary.

R7409C5

(FRA) General Journal

Prints transactions chronologically by the date when the entries were posted to the general ledger. Within the same date, the entries are ordered by:

• Time when the entries are entered or posted

• Type of transaction, such as purchase, sale, and miscellaneous expense

• Account number order

French Reports (G093151), General Journal.

Country or 'B' type

Enter 1 to validate the bank transit number based on the B bank type method. If you do not complete this processing option, the system validates the transit number based on the available country specific validation rules.

Period Number

Specify the period for which the trial balance prints. If you complete this processing option, you must also specify the fiscal year for the period in the Fiscal Year processing option. If you leave this processing option blank, the program uses the current period defined on the Set Up Company form and recorded in the F0010 table.

Fiscal Year

Specify the last two digits of the fiscal year for which the trial balance prints, for example, enter 07 for 2007. If you complete this processing option, you must also complete the Period Number processing option.

If you leave this processing option blank, the program uses the current fiscal year defined for the JD Edwards EnterpriseOne General Accounting system and recorded in the F0010 table.

Ledger Type 1, Ledger Type 2, and Ledger Type 3

Specify the first, second, and third ledger type on which you want to report. Enter a value from UDC table 09/LT.

1. Accounts with Zero Balances

Specify whether to include accounts with zero balances in the selected period.

2. Balance and Difference Columns

Specify if you want a Balance and a Difference column print on the report. The Balance column prints the account's current balance, calculated from the table. This Balance column is then compared to the Cumulative YTD Total column on the report, which is calculated from the F0911 table. Any differences found between the Cumulative YTD Total column and the Balance column are printed in the Difference column on the report.

3. Summarize Subsidiary Accounts

Specify whether the system summarizes all subsidiary accounts into one object account.

4. Total by GLG AAI Account Ranges

Specify if you want totals for the GLGx AAI ranges to print on the report. These totals print after the appropriate object account, according to the account ranges set up for the default company (company 00000) in AAI item GLGx. Totals are printed for these account ranges:

GLG2 - GLG3: Assets.

GLG3 - GLG5: Liabilities.

GLG5: YTD Income.

GLG6 - GLG7: Revenues.

GLG8 - GLG9: Cost of Goods Sold (COGS).

GLG11 - GLG13: Other Income.

GLG13 - GLG12: Other Expenses.

5. Class Total Level

Specify how the system classifies accounts for purposes of subtotaling. The report classifies accounts by account number. You can classify by one, two, three, or four digits of the account number. The report includes a class total for each classification.

For example, if you classify accounts by two digits, the report includes a class total for accounts 1000 through 1099, another class total for accounts 1100 through 1199, and so on. If you classify accounts by three digits, the report includes a class total for accounts 1100 through 1110, another class total for accounts 1111 through 1119, and so on.

If you classify accounts by all four digits, each object account has its own class total; subsidiary accounts to a single object are included in the class total.

The system includes class totals at the level that you specify and at lower levels. For example, if you classify accounts by two digits, the report includes a class total for accounts 1000 through 1999, in addition to the class totals for accounts 1000 through 1099, 1100 through 1199, and so on.

1. Mode

Specify the mode in which you want to run this report.

Note. You can run this report in final mode only once for the selected period and fiscal year. The transactions that are printed in final mode do not appear if you run the report again.

1. As-If Currency

Specify an as if currency code in which to print amounts for this report. This processing option allows you to review amounts in a currency other than the currency in which they are stored. Only amounts associated with the AA ledger type are converted to the as if currency. If you leave this processing option blank, amounts do not print in an as if currency.

If you leave this processing option blank, the As If Currency column does not appear on the report.

2. As-Of Date

Specify the date on which to retrieve the exchange rate for the as if currency from the F0015 table. If you enter a value for the As If Currency Code processing option and leave this processing option blank, the system uses the date specified in the Thru Date processing option for the exchange rate.

1. Fiscal Dates

Specify the fiscal dates in which to print the report in four processing options.

Beginning Period Number, Beginning Fiscal Year, Ending Period Number, and Ending Fiscal Year

Use these processing options to specify:

The first period and the fiscal year of the first period in which to print the report.

The last period and the fiscal year of the last period in which to print the report.

2. Ledger Types

Specify the ledger types to include on the report in three processing options.

Ledger Type 1, Ledger Type 2, and Ledger Type 3

Specify the first, second, and third ledger type to include in the report. Enter valid ledger types from UDC table 09/LT.

1. Account Category Code (21–43)

Use this processing option to include account numbers from an alternate chart of accounts on the report. Enter the category code that contains the alternate chart of accounts as R0xx, where xx is the category code number. If you leave this processing option blank, the system uses R021.

2. Subledger/Type

Specify whether you want to print the Subledger and Subledger Type columns on the report.

3. Business Unit

Specify whether you want the report to include a column that lists the business unit for each account.

4. Accounts with Zero Balances

Specify whether to include accounts with zero balances in the selected period. Values are:

Blank: Do not include accounts with zero balances.

1: Include accounts with zero balances.

5. Unposted Transactions

Specify whether to print unposted transactions on the report.

6. Total for Posted and Unposted Transactions

Specify whether separate totals for posted and unposted transactions should print on the report.

You can print totals for posted and unposted transactions only if you have set the Unposted Transactions processing option accordingly.

7. First Profit and Loss Account

Specify where the balance sheet accounts end and the profit and loss accounts begin in the alternate chart of accounts.

If you complete this processing option, the report includes subtotals for balance sheet and profit and loss accounts.

8. Column Format

Specify which optional columns to include on the report.

9. Report Sequence

Specify the data sequencing for the system to use when processing this report. All options include category code as the first item of sequencing. Values are:

Blank: Sequence by next number. Records are sorted in order of general ledger date and assigned a next number for each Account ID. Period totals do not print on the report.

1: Sequence by period. Records are printed on the report in ascending order by general ledger date. Period totals and period end balances print on the report.

1. Mode

Specify the mode in which you want to run the report.

When you run this report in final mode, only those records that have been printed in final mode on a trial balance report (R7409C3 or R70472) print.

1. Period Number and 2. Fiscal Year

Specify the period and the two-digit fiscal year for which to print the trial balance.

If you leave these processing option blanks, the program uses the current period and current fiscal year that is defined for the JD Edwards EnterpriseOne General Accounting system on the Set Up Company form and recorded in the F0010 table.

3. Ledger Type 1, 4. Ledger Type 2, and 5. Ledger Type 3

Specify the first, second, and third ledger type to include in the report. Enter a valid code from UDC table 09/LT. If you leave all three of the ledger types blank, the system includes only ledger type AA.

1. Account Category Code

Use this processing option to include account numbers from an alternate chart of accounts. Specify the category code that contains the alternate chart of accounts. Values are:

R021: Category code 21.

R022: Category code 22.

R023: Category code 23.

2. Accounts with Zero Balances

Specify whether to include accounts with zero balances. Values are:

Blank: Include accounts with zero balances.

1: Do not include accounts with zero balances.

3. Class Total Level

Specify how the system should classify accounts for purposes of subtotaling. The report classifies accounts by account number.

Enter a number that corresponds to the number of account number digits you want to use to classify accounts. You can classify by one, two, three, or four digits of the account number. The report includes a class total for each classification. Values are:

1: Classify by the first digit of the account number.

2: Classify by the first two digits of the account number.

3: Classify by the first three digits of the account number.

4: Classify by all four digits of the account number.

If you leave this processing option blank, the report will not include any class totals.

You can use this processing option in conjunction with the Last Balance Sheet Account processing option to include subtotals for balance sheet and profit-and-loss accounts. If you do not specify a Class Total Level, the report will not include subtotals for balance sheet and profit-and-loss accounts.

For example, if you classify accounts by two digits, the report will include a class total for accounts 1000 through 1099, and another class total for accounts 1100 through 1199, and so on. If you classify accounts by three digits, the report will include a class total for accounts 1100 through 1110, and another class total for accounts 1111 through 1119, and so on. If you classify accounts by all four digits, each object account will have its own class total; subsidiary accounts to a single object will be included in the class total.

The system includes class totals at the level you specify and at lower levels.

For example, if you classify accounts by two digits, the report will include a class total for accounts 1000 through 1999 in addition to the class totals for accounts 1000 through 1099, 1100 through 1199, and so on.

4. Last Balance Sheet Account

Specify where the balance sheet accounts end and the profit and loss accounts begin in the alternate chart of accounts.

This processing option works in conjunction with the Class Total Level processing option. The system ends the balance sheet accounts and begins the profit and loss accounts at the end of the class that contains the account number you specify. For example, if you specify account number 622000 with Class Total Level 1, the system ends the balance sheet accounts with class 6 (the first digit of 622000). If you specify account number 622000 with Class Total Level 2, the system ends the balance sheet accounts with class 62 (the first two digits of 622000).

If you do not specify a Class Total Level the report will not include subtotals for balance sheet and profit-and-loss accounts.

1. Mode

Specify the mode in which to run this report. Values are:

0: Proof mode.

1: Final mode.

Note. You can run this report in final mode only once for the selected period and fiscal year. The transactions that are printed in final mode will not print appear if you run the report again.

1. Balances

Specify whether to include customers with a negative balance on the A/R Open Amounts Report. If a customer has a negative balance, that customer has overpaid you. Values are:

Blank: Positive balance.

1: Negative balance.

1. As-If Currency

Specify whether to show amounts in a currency other than the currency in which the amounts are stored on the system. The system translates and shows domestic amounts in this As-If currency. For example, an amount in FRF can appear as-if it is in EUR.

Enter the code for As-If currency or leave this processing option blank if you do not want to show amounts in an alternate currency.

Note. This processing option allows you to view amounts in a different currency as a hypothetical scenario only. The amounts that appear in the different currency are not saved to the system.

2. As-Of Date

Specify an As-Of date if you enter a currency code for the As-If Currency processing option. This option processes the exchange rate as of the date you specify.

Enter the As-Of date, or leave this processing option blank to use the system date.

Note. A valid exchange rate must exist in the exchange rate table between the two currencies based on the As-Of date.

1. Balances

Specify whether to include suppliers with a negative balance on the A/P Open Amounts Report. If you have a supplier has a negative balance, you have overpaid that supplier. Values are:

Blank: Positive balance.

1: Negative balance.

1. As-If Currency

Specify whether to show amounts in a currency other than the currency in which the amounts are stored on the system. The system translates and shows domestic amounts in this As-If currency. For example, an amount in FRF can appear as-if it is in EUR.

Enter the code for as-if currency, or leave this processing option blank if you do not want to show amounts in an alternate currency.

Note. This processing option allows you to view amounts in a different currency as a hypothetical scenario only. The amounts that appear in the different currency are not saved to the system.

2. As-Of Date

Specify an As-Of date if you enter a currency code for the As-If Currency processing option. This option processes the exchange rate as of the date you specify.

Enter the As-Of date, or leave this processing option blank to use the system date.

Note. A valid exchange rate must exist in the exchange rate table between the two currencies based on the As-Of date.

1. From Date and 2. Thru Date

Specify the beginning or the end of the range of general ledger dates from which you want to select transactions.

1. From Date and 2. Thru Date

Specify the beginning or the end of the range of general ledger dates from which you want to select transactions.

1. From Date and 2. Thru Date

Specify the beginning or the end of the range of general ledger dates from which you want to select transactions.

3. Level Break on Business Unit

Specify whether to begin a new business unit on a new page.

4. Model Business Unit

Specify the model business unit that contains the account descriptions you want to use. If you leave this processing option blank, the transaction account descriptions will be used.

5. Accounts with Zero Balances

Specify whether the system should include accounts with zero balances. Values are:

Blank: Include accounts with zero balances.

1: Do not include accounts with zero balances.

1. Version

Specify either the French or Italian version of the G/L by Object and Subsidiary report. Values are:

Blank: French version. Lists the batch number and batch type for each transaction.

1: Omits the batch number and batch type columns and instead lists the general ledger registration number and currency code for each transaction.

1. Mode

Specify the mode in which to run the report. Values are:

Blank: Proof mode.

1: Final mode.

Note. When you run this report in final mode, only those records that have been printed in final mode on a trial balance report (R7409C3 or R70472) will be printed.

1. As-If Currency

Specify an as if currency code in which to print amounts for this report. This processing option allows you to review amounts in a currency other than the currency in which they are stored. Only amounts associated with the AA ledger type are converted to the as if currency. If you leave this processing option blank, amounts do not print in an as if currency.

If you leave this processing option blank, the As If Currency column does not appear on the report.

2. As-Of Date

Specify the date on which to retrieve the exchange rate for the as if currency from the F0015 table. If you enter a value for the As If Currency Code processing option and leave this processing option blank, the system uses the system date.

1. Model Business Unit

Specify the model business unit that contains the account descriptions you want to use. If you leave this processing option blank, the transaction account descriptions will be used.

3. Summarize Subsidiary Accounts

Specify whether to summarize all subsidiary accounts into one object account. Values are:

Blank: Do not summarize subsidiary accounts.

1: Summarize subsidiary accounts.

4. Class Total Level

Specify how the system should classify accounts for purposes of subtotaling. The report classifies accounts by account number.

Enter a number that corresponds to the number of account number digits you want to use to classify accounts. You can classify by one, two, three, or four digits of the account number. The report includes a class total for each classification. Values are:

1: Classify by the first digit of the account number.

2: Classify by the first two digits of the account number.

3: Classify by the first three digits of the account number.

4: Classify by all four digits of the account number.

If you leave this processing option blank, the report will not include any class totals.

You can use this processing option in conjunction with the Last Balance Sheet Account processing option to include subtotals for balance sheet and profit-and-loss accounts. If you do not specify a Class Total Level, the report will not include subtotals for balance sheet and profit-and-loss accounts.

For example, if you classify accounts by two digits, the report will include a class total for accounts 1000 through 1099, and another class total for accounts 1100 through 1199, and so on. If you classify accounts by three digits, the report will include a class total for accounts 1100 through 1110, and another class total for accounts 1111 through 1119, and so on. If you classify accounts by all four digits, each object account will have its own class total; subsidiary accounts to a single object will be included in the class total.

The system includes class totals at the level you specify and at lower levels.

For example, if you classify accounts by two digits, the report will include a class total for accounts 1000 through 1999 in addition to the class totals for accounts 1000 through 1099, 1100 through 1199, and so on.

1. As-If Currency

Specify an as if currency code in which to print amounts for this report. This processing option allows you to review amounts in a currency other than the currency in which they are stored. Only amounts associated with the AA ledger type are converted to the as if currency. If you leave this processing option blank, amounts do not print in an as if currency.

If you leave this processing option blank, the As If Currency column does not appear on the report.

2. As-Of Date

Specify the date on which to retrieve the exchange rate for the as if currency from the F0015 table. If you enter a value for the As If Currency Code processing option and leave this processing option blank, the system uses the system date.

Beginning Period Number, Beginning Fiscal Year, Ending Period Number, and Ending Fiscal Year

Specify the first period and the fiscal year of the first period in which to print the general journal.

Specify the last period and the fiscal year of the last period in which to print the general journal.

You can leave these processing options blank and complete the Beginning Date and Ending Date processing options instead.

Beginning Date and Ending Date

Specify the beginning date and ending date of the time period in which to print the general journal.

You can leave these processing options blank and complete the four processing options for fiscal dates instead.

3. Ledger Type 1, 4. Ledger Type 2, and 5. Ledger Type 3

Specify the first, second, and third ledger type to include in the report. Enter a valid code from UDC table 09/LT. If you leave all three of the ledger types blank, the system includes only ledger type AA.

1. Account Category Code

Specify whether to print account numbers from an alternate chart of accounts on the report. Enter the number of the category code that contains the alternate chart of accounts. The system uses the account descriptions from the category code table.

Leave this processing option blank to use default account numbers. You can specify a model business unit that contains the account descriptions you want to appear on the report.

2. Model Business Unit

If you use default account numbers, use this processing option to specify the model business unit that contains the account descriptions to print on the report. If you use default account numbers and you leave this processing option blank, the transaction account descriptions will print.

If you use an alternate chart of accounts, you do not have to complete this processing option. The system uses the account descriptions from the category code table.

3. Multiple Account Summarization

Specify whether to summarize entries to the same account in multiple business units. Regardless of whether you summarize accounts, debits and credits will not be summarized. Values are:

Blank: Print entries in detail.

Y: Summarize entries to the same account in multiple business units.

4. Business Unit

Specify whether the report includes a column that lists the business unit for each account. Values are:

Blank: Do not include the Business Unit column.

Y: Include the Business Unit column.

5. Subledger/Type

Specify whether to print the Subledger and Subledger Type columns on the report. Values are:

Blank: Do not print the columns.

Y: Print the columns.

1. Mode

Specify the mode in which you want to run the report. Values are:

0: Proof mode.

1: Final mode. Only those records that have been printed in final mode on the Trial Balance report (R7409C3 or R7409C4) will be printed.

1. As-If Currency

Specify an as if currency code in which to print amounts for this report. This processing option allows you to review amounts in a currency other than the currency in which they are stored. Only amounts associated with the AA ledger type are converted to the as if currency. If you leave this processing option blank, amounts do not print in an as if currency.

If you leave this processing option blank, the As If Currency column does not appear on the report.

2. As-Of Date

Specify the date on which to retrieve the exchange rate for the as if currency from the F0015 table. If you enter a value for the As If Currency Code processing option and leave this processing option blank, the system uses the system date.

R741201A

Asset Master List

The Asset Master List report (R741201A) provides a detailed asset analysis.

German Localization (G74D), Asset Master List

R741201B

Asset Master Acquisitions

The Asset Master Acquisitions report (R741201B) provides a detailed asset acquisition analysis.

German Localization (G74D), Asset Master Acquisitions

R741202A2

Anglangengitter Report: Value Adjustments

Print this Anglangengitter report to review changes in the value of an asset. Use this report for side-by-side comparison with the Acquisition Cost report (R741202A1).

German Localization (G74D), Value Adjustments

R741202A1

Anglangengitter Report: Acquisition Cost

Print this Anglangengitter report to review asset acquisition information. Use this report for side-by-side comparison with the Value Adjustments report (R741202A2).

German Localization (G74D), Acquisition Cost

Century

Specify the calendar century associated with the year. Enter the first two digits of the year. For example, 19 indicates any year beginning with 19 (1998, 1999), 20 indicates any year beginning with 20 (2000, 2001), and so on.

Fiscal Year

Specify the number that identifies the fiscal year. Generally, you can either enter a number in this field or leave it blank to indicate the current fiscal year (as defined on the Company Setup form).

Specify the year at the end of the first period rather than the year at the end of the fiscal period. For example, a fiscal year begins October 1, 1998 and ends September 30, 1999. The end of the first period is October 31, 1998. Specify the year 98 rather than 99.

Company

Specify the code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany transactions.

Note. You can use company 00000 for default values such as dates and AAIs. You cannot use company 00000 for transaction entries.

Month of Period End (1 - 12)

Specify the number indicating the current accounting period. This number, used in conjunction with the Company Constants table (F0010) and the General Constants table (F0009), enables the user to define up to 14 accounting periods. See General Ledger Date. The current period number is used to determine posted before and posted after cut off warning messages. It is also used as the default accounting period in the preparation of financial reports.

Totals on Company (For YES type 1)

Specify whether to print the totals by company on the report. Values are:

Blank: Do not print the totals.

1: Print the totals.

Totals on Business Unit (For YES type 1)

Specify whether to print the totals by business unit on the report. Values are:

Blank: Do not print the totals.

1: Print the totals.

Totals on Accounting Class (For YES type 1)

Specify whether to print the totals by accounting class on the report. Values are:

Blank: Do not print the totals.

1: Print the totals.

Totals on Parent (For YES type 1)

Specify whether to print the totals by parent on the report. Values are:

Blank: Do not print the totals.

1: Print the totals.

Century

Specify the calendar century associated with the year. Enter the first two digits of the year. For example, 19 indicates any year beginning with 19 (1998, 1999), 20 indicates any year beginning with 20 (2000, 2001), and so on.

Fiscal Year

Specify the number that identifies the fiscal year. Generally, you can either enter a number in this field or leave it blank to indicate the current fiscal year (as defined on the Company Setup form).

Specify the year at the end of the first period rather than the year at the end of the fiscal period. For example, a fiscal year begins October 1, 1998 and ends September 30, 1999. The end of the first period is October 31, 1998. Specify the year 98 rather than 99.

Company

Specify the code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany transactions.

Note. You can use company 00000 for default values such as dates and AAIs. You cannot use company 00000 for transaction entries.

Month of Period End (1 - 12)

Specify the number indicating the current accounting period. This number, used in conjunction with the Company Constants table (F0010) and the General Constants table (F0009), enables the user to define up to 14 accounting periods. See General Ledger Date. The current period number is used to determine posted before and posted after cut off warning messages. It is also used as the default accounting period in the preparation of financial reports.

Totals on Company (For YES type 1)

Specify whether to print the totals by company on the report. Values are:

Blank: Do not print the totals.

1: Print the totals.

Totals on Business Unit (For YES type 1)

Specify whether to print the totals by business unit on the report. Values are:

Blank: Do not print the totals.

1: Print the totals.

Totals on Accounting Class (For YES type 1)

Specify whether to print the totals by accounting class on the report. Values are:

Blank: Do not print the totals.

1: Print the totals.

Totals on Parent (For YES type 1)

Specify whether to print the totals by parent on the report. Values are:

Blank: Do not print the totals.

1: Print the totals.

Show Depreciation (For YES type '1')

Specify whether to display depreciation on the report. Values are:

Blank: Do not display depreciation.

1: Display depreciation.

1. Period Number

Specify the period number for the report. If you leave this processing option blank, the system uses the financial reporting date.

Note. If you want the financial reporting date to be company-specific, you must sequence by asset number, company, or business unit.

2. Fiscal Year

Specify the period number for the report. If you leave this processing option blank, the system uses the financial reporting date.

Note. If you want the financial reporting date to be company-specific, you must sequence by asset number, company, or business unit.

1. Report Journal Entry Creation Mode

Specify whether to run the program in preliminary or final mode. Values are:

Blank: Preliminary Mode.

1: Final Mode.

2. JE G/L Date

Specify the GL date for journal entries that the system creates.

3. Reverse Journal Entries

Specify whether the system creates reversing journal entries. Values are:

Blank: Do not create reversing entries.

R: Create reversing entries.

4. JE Document Type

Specify the document type that the system uses when it creates journal entries.

5. JE Name - Alpha Explanation

Use the processing option to specify whether the system uses flexible accounting. Values are:

Blank: Do not use flex accounting.

1: Use flex accounting.

R74U0137

End of Year Return CIS36

Generates an annual report that summarizes payments and deductions made during the tax year to all CIS subcontractors, regardless of the card or certificate that they hold. You can use the data selection to select subcontractors who hold specific cards or certificates, or you can select all subcontractors.

Periodic Processing (G74U0220), End of Year Return CIS36

R74U137A

End of Year Return CIS36 - CIS4

Generates an annual report that summarizes payments and deductions made during the tax year to CIS subcontractors who hold CIS4 registration cards.

Periodic Processing (G74U0220), End of Year Return CIS36 - CIS4

R74U0137B

End of Year Return CIS36 - CIS5

Generates an annual report that summarizes payments and deductions made during the tax year to CIS subcontractors who hold CIS5 construction tax certificates.

Periodic Processing (G74U0220), End of Year Return CIS36 - CIS5

R74U0137C

End of Year Return CIS36 - CIS6

Generates an annual report that summarizes payments and deductions made during the tax year to CIS subcontractors who hold CIS6 subcontractor tax certificates.

Periodic Processing (G74U0220), End of Year Return CIS36 - CIS6

R74U0138

Supplier Analysis Report

Use this report to review a detailed list of your CIS subcontractors, including information about their CIS subcontractor documents. The report includes warning messages for missing, expired, or invalid documents.

Accounts Payable Reports (G74U0214), Supplier Analysis Report

1. Date - From and 2. Date - Thru

Enter the beginning and ending dates in which to include data for the report in these processing options.

1. Mode

Enter 1 to print the report in final mode or leave this processing option blank to print it in proof mode.

2. CIS Voucher Status

Enter the CIS voucher status.

R00400

(ITA) VAT Report by Tax Area Code

Prints a report of VAT by tax area code. This report includes the VAT for Accounts Payable and Accounts Receivable transactions in two separate columns. You must print the report on a special legal form that is prenumbered and approved by the tax authorities.

Italian VAT Processing (G00213), VAT Report by Tax Area Code

R004051

(ITA) Monthly VAT Report

Print a report that includes accounts payable and accounts receivable VAT. You print the report on a required form.

Italian VAT Processing (G00213), Monthly VAT Report

R09404

(ITA) G/L Registration Report

Prints a list of the general ledger transactions for each month in chronological and sequential order

Italian Reports (G093152), G/L Registration Report

R09473

(FRA, ITA, USA) Debit/Credit T/B by Object

See R09473 - (FRA, ITA, USA) Debit/Credit T/B by Object.

See Processing Options for Debit/Credit T/B by Object (R09473).

Verifies the accuracy of transactions in individual account ledgers. When all of the transactions are accurate, the totals in this report equal the totals in the G/L reports and the G/L Registration report (R09404).

Italian Reports (G093152), T/B by Object & Subsidiary.

R70470

(ESP, FRA, ITA) G/L by Category Code

See R70470 - (ESP, FRA, ITA) G/L by Category Code.

See Processing Options for G/L by Category Code (R70470).

Validates information in legal reports and can be used as the basis for internal auditing. You can also use the report as a basis for external auditing by a third-party, such as a fiscal authority or auditing firm.

Italian Reports (G093152), G/L by Category Code

R70472

(FRA, ITA) T/B by Category Code

See R70472 - (FRA, ITA) T/B by Category Code.

See Processing Options for T/B by Category Code (R70472).

Verifies the accuracy of transactions in individual account ledgers. When all of the transactions are accurate, the totals in this report equal the totals in the General Ledger report and the General Ledger Registration report.

Italian Reports (G093152), T/B by Category Code

R7403B926

(FRA, ITA) A/R Inventory Book

See R7403B926 - (FRA, ITA) A/R Inventory Book.

See Processing Options for A/R Inventory Book (R7403B026).

The A/R Inventory Book report lists the total open amount for each customer by company. If a customer has open amounts in more than one company, the open amount for each company is listed separately.

Italian Reports (G093152), A/R Inventory Book.

R7404026

(FRA, ITA) A/P Inventory Book

See R7404026 - (FRA, ITA) A/P Inventory Book.

See Processing Options for the A/P Inventory Book (R7404026).

The A/P Inventory Book report lists the total open amount for each supplier by company. If a supplier has open amounts in more than one company, the open amount for each company is listed separately.

Italian Reports (G093152), Italian Reports.

R7404430

(ITA) Print W/T Payment Proposal

Use this report to review information about withholding tax amounts and Italian bank identification codes and descriptions. You can also verify payment information before you write the actual payments for your suppliers.

Italian Tax Processing (G002131), Print W/T Payment Proposal.

R74079

(ITA) Invoice List Control Report

Prints a list of suspended VAT invoices that still need to be paid. When you print the report, the system verifies that the invoice has not been paid on the as of date that you specify for the report. The system then calculates the open amount.

Italian Tax Processing (G002131), Invoice List Control Report

R74099A

(FRA, ITA) Sequential Number Report - Tax File

See R74099A - (FRA, ITA) Sequential Number Report - Tax File.

See Processing Options for the Sequential Number Report - Tax File (R74099A).

Use this report to verify that document numbers are in sequential order without interruptions, the system prints a report based on the Taxes table (F0018).

Italian Reports (G093152), Sequential Number Report - Tax File.

R74099B

(FRA, ITA) Sequential Number Report - A/P Ledger

See R74099B - (FRA, ITA) Sequential Number Report - A/P Ledger.

See Processing Options for the Sequential Number Report - A/P Ledger (R74099B).

Use this report to verify that document numbers are in sequential order without interruptions, the system prints a report based on the Accounts Payable Ledger (F0411).

Italian Reports (G093152), Sequential Number Report - A/P Ledger

R74099C

(FRA, ITA) Sequential Number Report - A/R

See R74099C - (FRA, ITA) Sequential Number Report - A/R.

See Processing Options for the Sequential Number Report - A/R Program (R74099C).

Use this report to verify that document numbers are in sequential order without interruptions, the system prints a report based on the Customer Ledger (F03B11).

Italian Reports (G093152), Sequential Number Report - A/R

R7409C1

(ESP, FRA, ITA) G/L by Object and Subsidiary

See R7409C1 - (ESP, FRA, ITA) G/L by Object and Subsidiary.

See Processing Options for G/L by Object and Subsidiary (R7409C1).

Validates information in legal reports and can be used as the basis for internal auditing. You can also use this report as a basis for external auditing by a third-party, such as a fiscal authority or auditing firm.

Italian Reports (G093152), G/L by Object and Subsidiary.

R7409C3

(FRA, ITA) T/B by Object and Subsidiary

See R7409C3 - (FRA, ITA) T/B by Object and Subsidiary.

See Processing Options for T/B by Object and Subsidiary (R7409C3).

Verifies the accuracy of transactions in individual account ledgers. When all of the transactions are accurate, the totals in this report equal the totals in the General Ledger report and the General Ledger Registration report.

Italian Reports (G093152), T/B by Object and Subsidiary.

R74093

(ITA) Print VAT Summary Report

To review the total amount of VAT that is due to the Italian government, print the summary VAT report.

Italian Tax Processing (G002131), Print VAT Summary Report

Enter the From and Through GL Dates:

From Date or Through Date

Suppress page headings

Enter 1 to suppress report headings and page numbers. If left blank page headings will be printed.

Insert a Blank Line

Enter 1 to insert a blank line when Tax Area Codes are skipped.

Reverse the Sign Option

Enter 1 to reverse the sign on AR transactions.

1. Processing Mode

Specify whether to run the report in proof or final mode. Values are:

Blank: Proof mode.

1: Final mode.

2. AP or AR Form

Specify whether to print the Monthly VAT Report (R004051) for AR or AP. Values are:

Blank: Run the AR Monthly VAT Report.

1: Run the AP Monthly VAT Report.

Note. The data selection for batch type should be different for the AR and AP Monthly VAT Report.

3. Reverse Sign

Specify whether to reverse the sign of the transaction amounts on the report. Values are:

Blank: Do not reverse.

1: Reverse.

1. From GL Date

Specify a beginning GL date for the system to use when it selects records for the report.

2. Through GL Date

Specify an ending GL date for the system to use when it selects records for the report. If you leave this processing option blank, the system uses the system date.

3. Tax Rate for Intra-community VAT

Specify the tax rate for intracommunity VAT that you want to print on the report. This depends on whether you are running the AR version (Input VAT - minus sign) or the AP version (Output VAT - plus sign). Values are:

Blank: Print the tax rate on line 1 of Tax Rate/Area Revision.

1: Print the tax rate on line 2 of Tax Rate/Area Revision.

1. Sequential Numbers and Dates

Specify whether you want the system to skip lines on the report when document numbers or GL dates are not sequential. Values are:

Blank: Do not skip.

1: Skip lines. If you select this processing option, the system skips two lines.

2. Document Description

Specify how you want the system to print the document type description. Values are:

Blank: Print the document type description from the invoice remark.

1: Print the document type description from the user-defined codes.

3. Suppress Header

Specify whether you want the system to suppress the printing of print headings and page numbers. Values are:

Blank: Print.

1: Suppress.

4. Enter the Year that should be printed with the page numbers of the report

Specify whether you want the system to print the year along with the page numbers on the report. Enter the last two digits of the fiscal year that you want to print on the report. If you leave this processing option blank and the report heading is not suppressed, the system prints runtime page numbers.

5. Enter the Number to be used as the first page number of the report

Specify the number from which you want to start the page numbering for the report. If you leave this processing option blank and the report heading is not suppressed, the system prints runtime page numbers.

1. Enter the Currency Code for As-If currency reporting.

Specify the currency code for as-if currency reporting. This option enables you to print amounts in a currency other than the currency in which they are stored. Either enter a currency code or leave this option blank to print amounts in the currency in which they are stored.

2. Enter the As-Of date for processing the exchange rate for the as-if currency.

Specify the as-of date for processing the exchange rate for the as-if currency. If you leave this option blank, the system uses the exchange rate that is valid for the system date.

1. Processing Mode

Specify the mode in which you want to run the report. Values are:

Blank: Run the report in proof mode.

1: Run the report in final mode without headings and titles.

2: Run the report in final mode with headings and titles.

2. Registration Number

Specify how the system assigns registration numbers. Values are:

Blank: Assign a registration number to each document.

1: Assign a registration number to each individual journal entry line.

3. Adjustment Registration Date

Specify the adjustment registration date. Enter any specific registration date. If you leave this processing option blank, the system assigns the general ledger date of the adjustment.

4. Next Available Registration Number for Adjustments

Specify how the system assigns the next available registration number for adjustments entered in the prior year. Values are:

Blank: Use the next available registration number from the current fiscal year.

1: Use the next available registration number from the fiscal year of the adjustment general ledger date, which would be for the previous fiscal year. This option is not recommended.

1. From Date and 2. Thru Date

Specify the beginning date and ending date for the system to use when selecting records for the report.

3. Enter the company number to be used to store and retrieve G/L balance values

Specify the company number for which the report is printed. If you leave this processing option blank, the system prints the report for company 00000.

1. Enter the Year that should be printed with the page numbers of the report

Enter the year that you want to print on the page numbers of the report. If you leave this processing blank, runtime page numbers are printed in proof mode and no page numbers are printed in final mode.

2. Enter the Number to be used as the first page number of the report

Specify the number from which you want to start the page numbering for the report. If you leave this processing option blank, runtime page numbers are generated in proof mode and no page numbers are generated in final mode.

3. Enter the Account Number to print on the report

Specify whether the system includes account numbers from the alternate chart of accounts on the report. Enter the category code that contains the alternate chart of accounts. Values are:

Blank: Do not include account numbers from the alternate chart of accounts. Use the regular account number (BU.Obj.Sub).

21: Include account numbers from the chart of accounts in category code 21.

22: Include account numbers from the chart of accounts in category code 22.

23: Include account numbers from the chart of accounts in category code 23.

1. Enter the Currency Code for as-if currency reporting.

Specify the currency for as if currency reporting. This processing option allows amounts to print in a currency other than the currency in which they were originally entered. Enter a currency code from F0013 table. If you leave this processing option blank, the system prints amounts in the currency in which they were originally entered.

2. Enter the As-Of date for processing the exchange rate for the as-if currency.

Specify the effective date for processing the exchange rate for the as if currency. If you leave this processing option blank, the system uses the exchange rate associated with the system date.

From Due Date

Enter the beginning of the date range for which you print the report.

Through Due Date

Enter the end of the date range for which you print the report.

Print

Enter 1 to print the supplier address on the report.

As of Date

Enter the As of Date. If left blank, the System Date will be used.

1. Currency Code

1. Enter the Currency Code for as-if currency reporting. This option allows for amounts to print in a currency other than the currency they are stored in. Amounts will be translated and print in this as-if currency. If left blank, amounts will print in their database currency.

2. Date

2. Enter the As-Of date for processing the current rate for the as-if currency. If left blank, the system date will be used.

1. Processing Mode

Specify whether to run the report in proof or final mode. Values are:

Blank: Proof mode.

1 Final mode.

1. From date and 2. Thru date

Specify the beginning date or the ending date for the system to use when it selects records for the report.

3. Company

Specify the company for the system to include on the report.

4. Tax Rate for Payable Intra-Community Offset VAT.

Specify the tax rate for payable intracommunity offset VAT that you want to print on the report. Values are:

Blank: Print tax rate 1 on the report.

1: Print tax rate 2 on the report.

5. VAT Register Class for Payable Intra-Community Offset VAT.

Specify the VAT register class for payable intracommunity offset VAT. Select a valid VAT register class from UDC table 74/01.

6. VAT Register Type for Payable Intra-Community Offset VAT.

Specify the VAT register type for payable intracommunity offset VAT. Select a valid register type from UDC table 74/02.

1. Print Header Option

Specify whether the system should print the standard JD Edwards EnterpriseOne report header or the through date header. Values are:

Blank: Print the standard report header.

1: Print the through date report header. If you select this processing option, the system prints the words, Payment Vat Report thru and then prints the date that you entered in the Thru date processing option.

2. Enter the Year that should be printed with page numbers of the report.

Specify whether you want the system to print the year along with the page numbers on the report. Enter the last two digits of the fiscal year that you want to print on the report. If you leave this processing option blank, the system prints runtime page numbers.

3. Enter the Number to be used as the first page number of the report.

Specify the number from which you want to start the page numbering of the report. If you leave this option blank, the system prints runtime page numbers.

4. Suppress negative sign

Specify whether to suppress the printing of the negative sign. Values are:

Blank: Do not suppress.

1: Suppress.

1. Enter the Currency Code for as-if currency reporting.

Specify the currency code for as-if currency reporting. This option enables you to print amounts in a currency other than the currency in which they are stored. Enter a valid currency code from the Designate Currency Codes program (P0013). The system converts and prints the amounts in this as-if currency. If you leave this processing option blank, the system prints amounts in the currency in which they are stored.

2. Enter the As-of date for processing the exchange rate for the as-if currency.

Specify the as-of date for processing the exchange rate for the as-if currency. If you leave this processing option blank, the system uses the exchange rate that is valid for the system date.

R7503420

Draft Receivable Report

Prints a list of processed drafts, including the bank-assigned draft number.

No processing options exist for this report.

Japanese Localization (G75J), Draft Receivable Report

R75402

A/P Draft Payable List

Use this report to list all of the outstanding draft payables, including the bank name and value date.

No processing options exist for this report.

Japanese Localization (G75J), A/P Draft Payable List

R74P03B61

AR Trial Balance Report

Lists all accounts receivable transactions by currency, company, account, and supplier.

General Ledger (G74P09), AR Trial Balance

R74P0450

AP Trial Balance

This report lists all accounts payable transactions by currency, company, account, and supplier or customer. You use this report to verify data in offset and vendor accounts. You can print the report in summary or detail mode.

General Ledger (G74P09), A/P Trail Balance.

R74P9010

GL Trial Balance by Object

Lists information about transaction posted to the general ledger.

General Ledger (G74P09), GL Trial Balance by Obj

R74P9015

GL Trial Balance by Category Code

Prints the same information as the General Ledger by Object report, but it presents information by category code instead of object account. For example, the General Ledger by Category Code report has three level breaks (one for each category code) instead of one level break like the General Ledger by Object report.

The system prints the information for account category codes 21, 22, and 23, as applicable.

General Accounting (G74P09), GL Trial Balance by Category Code

R74P9020

Transaction Journal

Lists all journal entries and assigns a register number to them by company and fiscal year.

General Ledger (G74P09), GL Transaction Journal

R74P9030

Bank Register

Lists bank transactions.

General Ledger (G74P09), Bank Register

Fiscal Year

Specify the fiscal year for which the system selects records to process.

Fiscal Period From

Specify the first period in a range of periods that the system uses to select records to process.

Fiscal Period Thru

Specify the end period in a range of periods that the system uses to select records to process.

Company Number

Specify the company number for which the system selects records to process.

Date From

Specify the first date in a range of dates that the system uses to select records to process. The system uses this processing option if you leave the Fiscal Period From and the Fiscal Period Thru processing options blank.

Date Thru

Specify the last date in a range of dates that the system uses to select records to process. The system uses this processing option if you leave the Fiscal Period From and the Fiscal Period Thru processing options blank.

Report Appearance

Enter 1 to print all detail lines for the accounts. Leave this processing option blank to print account totals.

Rebuild Work Table

Enter 1 to clear the table before writing new records to the table. Leave this processing option blank to append new records to the table.

Account Print Format

Specify the format in which the system prints account numbers on the report. Values are:

1: Account number

2: Short Account ID

3: Unstructured account

Account Suppress Mode

Enter 1 to suppress printing accounts which have no transactions since the beginning of the current year. Enter 2 to suppress printing accounts which have no transactions in the current period. Leave this processing option blank to print information for all accounts.

Fiscal Year

Specify the fiscal year for which the system selects records to process.

Fiscal Period From

Specify the first period in a range of periods that the system uses to select records to process.

Fiscal Date Thru

Specify the end period in a range of periods that the system uses to select records to process.

Company Number

Specify the company number for which the system selects records to process.

Date From

Specify the first date in a range of dates that the system uses to select records to process. The system uses this processing option if you leave the Fiscal Period From and the Fiscal Period Thru processing options blank.

Date Thru

Specify the last date in a range of dates that the system uses to select records to process. The system uses this processing option if you leave the Fiscal Period From and the Fiscal Period Thru processing options blank.

Report Appearance

Leave this processing option blank to print account totals. Enter 1 to print all detail lines for the accounts.

Rebuild Work Table

Leave this processing option blank to append new records to the table. Enter 1 to clear the table before writing new records to the table.

Account Print Format

Specify the format in which the system prints account numbers on the report. Values are:

1: Account number

2: Short Account ID

3: Unstructured account

Account Suppress Mode

Enter 1 to suppress printing accounts which have no transactions since the beginning of the current year. Enter 2 to suppress printing accounts which have no transactions in the current period. Leave this processing option blank to print information for all accounts.

1. From Period

Specify how the system determines the balances included in the report.

Enter 0 or leave this option blank to use the first period of the current fiscal year as the beginning period for balances. The system prints all current year transactions for all accounts plus debit and credit totals by period for the current fiscal year. The balance forward totals for balance sheet accounts are from inception through the end of the previous fiscal year.

Enter 1 to use the current period as the beginning period. The system prints a balance forward total of the previous activity for the current fiscal year and transactions for the current period only for each account. The report does not print all account activity for the year. The balance forward total reflects the year-to-date amounts through the end of the previous period for profit-and-loss accounts. For balance sheet accounts, the report reflects the inception-to-date amounts through the end of the previous period.

2. From Date

Specify the beginning date in a range of dates that the system uses to select records to process. If you leave this processing option blank, the system uses the date of the period specified in the From Period processing option.

3. Thru Fiscal Year

Specify the ending fiscal year in a range of years. The system uses the range to select records for the report. Enter the last two digits of the fiscal year, for example, enter 07 for the year 2007.

If you enter 0 for the From Period processing option, the year that you enter for this processing option must be the same as the year specified for the Beginning of Fiscal Year field in the Company Names & Numbers program (P0010). If the year you specify is not the same, the report does not include a line item for balance forward amounts.

4. Period Number

Specify the period number that the system uses to select records to process.

5. Thru Date

Specify the end date in a range of dates that the system uses to select records to process. If you leave this processing option blank, the system uses the date of the period specified in the From Period processing option.

6. Subledger

Specify the subledger for which the system processes records. Enter a specific subledger, or enter * to processes records for all subledgers. Leave this processing option blank to process records that do not have subledgers.

7. Subledger Type

Specify the subledger type that the system uses when selecting records to process. The value that you enter must exist in UDC table 00/ST. You must complete this processing option if you entered a specific subledger in the Subledger processing option.

8. Ledger Type

Specify the ledger type that the system uses to select records to process. The value that you enter must exist in UDC table 09/LT. If you leave this processing option blank, the system selects records with a ledger type of AA.

1. Account Number Format

Specify the format in which the system prints account numbers on the report. Values are:

1: Account number.

2: Short account ID.

3: Unstructured account.

2. Accounts with Zero Balances

Leave this processing option blank to print information for all accounts. Enter 1 to omit accounts with a zero balance.

1. Currency Code

Specify the currency code of the records that the system selects for processing. Enter a specific currency codes to select only records with the specified currency code. Leave this processing option blank to select records for all currency codes.

2. Currency Code From

Specify an as if currency code. The currency code must exist in the F0013 table. The system prints amounts on the report in the currency you specify, instead of the currency in which the records are stored.

Leave this processing option blank to print amounts in the currency in which they are stored.

3. As-of Date

Specify the date that the system uses when processing records in an as-if currency. If you leave this processing option blank, the system uses the date in the Thru Date processing option.

1. Report Title

Enter a title that the system prints on the report. You can enter as many as 60 characters. If you leave this processing option blank, the system does not print a title.

2. Report Title Continuation

Enter additional text for the title of the report. You can enter as many as 60 characters.

3. Company Number

Specify a company number to print the company name and number on the report.

4. Accounts Detail

Leave this processing option blank to print all detail lines for the account. Enter 1 to print a summary with a total for the account.

5. Category Code for Trial Balance

Specify the category code that the system uses to select records to process. Values are 21, 22, or 23.

Processing Mode

Leave this processing option blank to run the report in proof mode. Enter 1 to run the report in final mode without titles and headers. Enter 2 to run the report in final mode and print titles and headers.

Registration Number

Enter 1 to have the system assign a registration number to each individual line entry. Leave this processing option blank to have the system assign a registration number to each document.

Adjustment Registration Date

Specify the adjustment registration date. If you leave this processing option blank, the system assigns the GL date of the adjustment.

Next Available Registration Number

Specify how the system assigns the next available registration number for adjustments entered in the prior year. Enter 1 to use the next available registration number from the fiscal year of the general ledger adjustment date, which is the next available registration number from the previous year.

Note. You should not use this processing option. Instead, leave this processing option blank to use the next available registration number from the current year.

From Date

Specify the first date of a range of dates that the system uses to select records for the report.

Thru Date

Specify the end date for a range of dates that the system uses to select records for the report.

Company Number

Specify the company for which the system retrieves general ledger records. If you leave this processing option blank, the system uses company 00000.

Account Number

Specify whether the system includes account numbers from an alternate chart of accounts on the report. Values are:

Blank: Use account numbers from the standard chart of accounts and prints them in the BU.OBJ.SUB format.

21: Use account numbers from the chart of accounts set up in category code 21.

22: Use account numbers from the chart of accounts set up in category code 22.

23: Use account numbers from the chart of accounts set up in category code 23.

Currency Code

Specify a currency code for as if processing. Enter a valid currency code from the F0013 table. The system processes all records in the currency you specify instead of in the currency in which the records are stored.

If you leave this processing option blank, the system uses the currency code in which the records are stored.

As-of Date

Specify the date that the system uses to retrieve the exchange rate for as if processing. If you leave this processing option blank, the system uses the date in the Thru Date processing option.

Report Title

Enter the title that you want the system to print on the report. The maximum number of characters you can enter is 60. If you need additional characters, complete the Report Title (continuation) processing option.

Report Title (continuation)

Enter additional text for the report title. You can enter as many as 60 characters.

Ledger Type

Specify a ledger type that the system uses to select records. Enter a valid code from UDC table 09/LT. If you leave this processing option blank, the system uses the AA ledger type.

1. From Period

Specify the balances that the system includes in the report.

0: Use the first period of the current fiscal year as the beginning period. This is the default value. The report prints all current year transactions for all accounts plus debit and credit totals by period for the current fiscal year. The balance forward totals for balance sheet accounts are from inception through the end of the previous fiscal year.

1: Use the current period as the beginning period. The report prints a balance forward total of the previous activity for the current fiscal year and transactions for the current period only for each account. The report does not print all account activity for the year. The balance forward total reflects the year-to-date amounts through the end of the previous period for profit and loss accounts. For balance sheet accounts, the report reflects the inception-to-date amounts through the end of the previous period.

2:Use the first period of the first fiscal year (when General Accounting processing began) as the beginning period. If you enter 2, the report prints transaction information from the date when General Accounting processing began through the current period.

2. From Date

Specify a beginning date in a range of dates for the system to use when selecting records to print on this report. If you leave this processing option blank, the system uses the value specified in the From Period processing option.

3. Thru Fiscal Year

Specify the ending fiscal year in a range of years that the system uses to select records for this report. Enter the last two digits of the fiscal year. For example, enter 07 for the year 2007.

If you enter 0 (for year-to-date balances) for the From Period processing option and you enter a year for this processing option, the year must be the same as the year specified in the Beginning of Fiscal Year field in the Company Names & Numbers program (P0010). Otherwise, the report does not include a line item for balance forward amounts.

4. Period Number

Specify a period number for the system to use to select records for this report.

5. Thru Date

Specify an ending date in a range of dates for the system to use to select records to print on this report. If you leave this processing option blank, the system uses the value specified in the From Period processing option.

6. Subledger and 7. Subledger Type

Specify the subledger for which the system processes records. Enter a specific subledger or enter * to process records for all subledgers, including blank subledgers. Leave this processing option blank to process records that do not have subledgers.

Specify a subledger type from UDC table 00/ST. If you specify a value in the Subledger processing option, you must enter a subledger type for this processing option.

8. Ledger Type

Specify a ledger type from UDC table 09/LT. If you leave this processing option blank, the system uses ledger type AA.

9. Document Type

Complete this processing option in conjunction with the Ledger Type processing option to specify a document type from UDC table 00/DT. If you leave this processing option blank, the system selects all document types.

If you do not specify a ledger type for the Ledger Type processing option, the system ignores the value in this processing option.

1. Account Number Format

Specify the format in which the system prints the account number. Values are:

1: Print the account number in business unit.object.subsidiary format.

2: Print the short account ID.

3: Print the third (unstructured) account number.

2. Accounts with zero balance

Leave this processing option blank to print information for all accounts. Enter 1 to suppress printing for accounts with a zero balance.

3. Posted Transactions

Leave this processing option blank to print posted transactions only. Enter 1 to print both posted and unposted transactions.

1. Currency Code

Specify the currency code of the records that the system selects for processing. Enter a specific currency codes to select only records with the specified currency code. Leave this processing option blank to select records for all currency codes.

2. Currency Code From

Specify an as if currency code. The system prints amounts on the report in the currency you specify, instead of the currency in which the records are stored. Leave this processing option blank to print amounts in the currency in which they are stored.

3. As-of date

Specify the date that the system uses when processing records in an as if currency. If you leave this processing option blank, the system uses the date in the Thru Date processing option.

1. Report Title

Enter a title that the system prints on the report. You can enter as many as 60 characters. If you leave this processing option blank, the system does not print a title.

2. Report Title (continuation)

Enter additional text for the title of the report. You can enter as many as 60 characters.

3. Bank Register Number

Specify the bank register number that the system prints in the header area of the report. If you leave this processing option blank, the system does not print a register number.

R74R41003

Print Transfer Item Note

Use this program when you transfer inventory between two business units within the same company.

Select Inventory (G74R41), Print Transfer Item Note

R74R5003

Cash Issue Note Print