This appendix includes reports for these countries:
Argentina
Brazil
Canada
Chile
Colombia
Peru
Venezuela
United States
In addition to the reports specified as part of a process in other sections of this implementation guide, these reports exist for Argentina:
Processing options enable you to specify the default processing for programs and reports.
Default
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. |
In addition to the reports specified as part of a process in other sections of this implementation guide, these reports exist for Brazil.
To comply with specific Brazilian legal requirements and business practices, companies must keep detailed records of all transactions. The Brazilian government can audit companies at any time to verify that commercial transactions are being performed within legal requirements.
The General Ledger (Livro Razo) and the Transaction Journal (Dirio Geral da Contabilidade) are two of the basic elements that companies are required to maintain and submit for auditing.
You print the Brazilian Transaction Journal to list and total 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.
The Brazilian Transaction Journal report includes an opening statement (Termo de Abertura) for the first page and a closing statement (Termo de Encerramento) for the last page. The opening and closing statements include this company information:
Purpose of the book.
Number of the book.
Number of pages.
Business to which the book pertains.
Business name.
Business address.
Number assigned to the business by the Junta Comercial.
Taxpayer identification number.
Company administrator and accountant authorization of the closing of the accounting period.
The statements also include information about the journal, such as the fiscal book number and the total number of pages.
Processing options enable you to specify the default processing for reports.
Print Options
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. |
Dates
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. |
Company
1. Company |
Enter the company to print in the report header. This processing option is required. |
Book Code
1. Book Code |
Enter the book code or leave this processing option blank for DG. |
The Four Column Trial Balance report is a balance report that prints debit and credit total amounts for each account. The debit/credit format is a legal requirement in Brazil and allows accountants and auditors to quickly locate the source of any discrepancies within a company's accounts.
The Four Column Trial Balance report uses information from the F0902 table, which includes fields for Amount Net Debit Posting 01 - Amount Net Debit Posting 14. The report includes these columns:
Beginning Balance
Total Debits
Total Credits
Actual Balance
You cannot change the data sequencing for this program.
The processing options for the Four Column Trial Balance report are similar to those for other trial balance reports.
Period
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. |
|
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. |
LOD
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
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
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. |
To comply with specific Brazilian legal requirements and business practices, companies must keep detailed records of all transactions. The Brazilian government can audit companies at any time to verify that commercial transactions are being performed within legal requirements.
The General Ledger (Livro Razo) and the Transaction Journal (Dirio Geral da Contabilidade) are two of the basic elements that companies are required to maintain and submit for auditing.
You can print the General Ledger report to list all transactions by company and general ledger account for a specific accounting period. The report includes all general ledger accounts with a posting edit code, even if the amount for the account is zero. In addition, the report includes totals by transaction, period, account, and company. If the list of transactions for an account is interrupted by a page break, the system prints an ending balance on the page and continues on the next page with a balance carried forward amount.
Processing options enable you to specify the default processing for reports.
From/Thru Date
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. |
Document
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. |
Subledger
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. |
Currency
1. Currency Code (FUTURE) |
Reserved for future use. |
Summary
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. |
Date Order
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. |
Company
1. Company Number |
Enter a company number to print for each page heading. |
In addition to the reports specified as part of a process in other sections of this implementation guide, these reports exist for Canada.
Report ID and Report Name |
Description |
Navigation |
R0018P8 |
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 |
The GST/ PST Tax report is specifically designed to meet Canadian reporting needs. For each address book number, the report lists GST and PST and subdivides PST into seller-assessed PST and self-assessed PST.
This report lists information by company and tax explanation code. Within each tax explanation code, the report separates taxes into categories such as taxable, nontaxable, GST, seller-assessed PST, and self-assessed PST.
Amounts for these fields are positive for vouchers and negative for invoices:
Taxable Amount
Non-Taxable
Tax
This is the sum of GST, self-assessed PST, and seller-assessed PST.
GST
Self-Assessment Tax
This is the total payable to provincial governments for self-assessed PST. A processing option enables you to display the amount with the sign reversed.
Sales Tax
This is the total payable to provincial governments for seller-assessed PST.
Processing options enable you to specify the default processing for programs and reports.
Update Options
1. Detail Records |
Enter a 1 to flag the detail records as having been printed. |
Display
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. |
In addition to the reports specified as part of a process in other sections of this implementation guide, these reports exist for Chile and Peru.
Report ID and Report Name |
Description |
Navigation |
R76H4020 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Processing options for reports enable you to specify the information that appears on the reports.
General
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. |
Dates
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. |
Processing options for reports enable you to specify the information that appears on the reports.
General
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. |
Use these processing options to specify how to print cost centers, the level of detail in which to summarize balances, the process method, and so on.
Process
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. |
Print Options
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. |
Dates
Period Number |
Specify the tax period to print on the report. |
Fiscal Year |
Specify the fiscal year to print on the report. |
Before you print this report, you can access the information online. Select General Accounting (G76H09) or General Accounting (G76P09), Journal Entries Inquiry by Legal. Number.
This form displays the initial legal number for the company by fiscal year. When you run the General Journal report, this number appears on the report. The Debit and Credit balances that appear on the form are the accumulated balances for the corresponding period. When you run the General Journal report, these amounts appear on the report. You can modify them manually on the form, if necessary.
Use these processing options to specify the processing mode, the document type to use for page numbers on the report, and so on.
Mode
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 |
Print Options
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. |
Dates
1. From Date and 2. Thru Date |
Specify the beginning and ending dates in which to print detailed journal entries for this report. |
Company
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. |
Options
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. |
Adjustments
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. |
Currency
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. |
Use these processing options to specify information such as company, from where to retrieve the initial page number, and information to include in the report heading.
General
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. |
Printing
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. |
These processing options are specific for localizations.
Localization options
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 |
These processing options are specific for localizations.
Localization
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. |
The IGV Withholding Ledger report lists transactions for which IGV tax was withheld. For the Payments section of the report, the system selects the payments affected by IGV tax within the range of dates defined in the processing options. For the Purchasing section, the total amount corresponds to the total amount of the paid invoices. The Adjustment section of the report includes information relating to currency exchange difference. The Withholding section includes the total amount for the income tax withheld.
Processing options for reports enable you to specify the information that appears on the reports.
Processing
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. |
Dates
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. |
Processing options for reports enable you to specify the information that appears on the reports.
General
Legal Company |
Enter the legal company for which you run the report. |
Dates
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. |
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.
Processing options for reports enable you to specify the information that appears on the reports.
General
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. |
Processing options for reports enable you to specify the information that appears on the reports. For example, you set a processing option to include the fiscal year or the number of aging days on a report.
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. |
In addition to the reports specified as part of a process in other sections of this implementation guide, these reports exist for Colombia.
These processing options apply to:
Version ZJDE0001 (Rent Withholding by Account) of R76C0001.
Version ZJDE0002 (Rent Withholding by G/L Offset) of R76C0001.
Version ZJDE0003 (Rent Withholding by Tax Area) of R76C0001.
Version ZJDE0001 (VAT Withholding by Account) of R76C0003.
Version ZJDE00002 (VAT Withholding by G/L Offset) of R76C0003.
Version ZJDE0003 (VAT Withholding by Tax Area) of R76C0003.
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 and Company
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. |
Responsible
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. |
Display
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. |
Third Party
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. |
Reprocess
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
Title |
Enter the title to print on the certificate. |
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. |
IVA Withheld
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. |
These processing options apply to version ZJDE0001 (Withholdings Report Detailed by Document) and version ZJDE0002 (Withholdings Report Summarized - 3rd Party).
Date
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. |
Display
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. |
Display and Company
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. |
Total
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. |
Reprocess
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
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. |
The processing options for this program as the same as for R76C0001.
See Processing Options for R76C0001 and R76C0003.
Processing options for reports enable you to specify the information that appears on the reports.
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
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. |
Responsible
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. |
Display
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. |
Third Party
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. |
Reprocess
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
Title |
Enter the title to print on the certificate. |
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. |
VAT Withheld
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. |
Set the processing options for the General Journal by Category Code 21, General Journal by Category Code 22, or General Journal by Category Code 23.
Dates
Dates From and Dates To |
Enter the date range in which to print transactions. |
Cat. Code
Category Code |
Enter the category code 21, 22, or 23in which the PUC is specified. |
Set these processing options for the General Ledger with Total by Object Account.
Dates
Dates From and Dates To |
Enter the date range in which to print transactions. |
To ensure that accounts without balances do not print on the Inventory and Balance Sheet by Object Account report, enter N(inactive PUC accounts) in the Description 02 field of the code in UDC tables 09/21, 09/22, and 09/23.
Before you run this report, run these required programs from Fiscal Books by Category Code (G76C151):
Update Level in Category Code program (R76C0907) from Fiscal Books by Category Code (G76C151).
This program updates the detail level of the accounts in category code 13 from UDC table 09/13 to generate reports by category code. Running the update program makes the Inventory and Balance Sheet by Object Account report process faster. This update program might take several hours to process records.
Data File Generation A/P program (R04901A).
In the processing options, enter the as of date in which you will run the Inventory and Balance Sheet by Object Account report.
Data File Generation A/R program (R76C03B11).
In the processing options, enter the as of date in which you will run the Inventory and Balance Sheet by Object Account report.
Set these processing options for the Inventory and Balance Sheet by Object Account report.
The Inventory and Balance Sheet by Object Account (R76C094B) report also use these processing options.
Period
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. |
Print Options
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. |
Level
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. |
Ledger
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. |
Cat Code
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. |
The processing options for this report are the same as those for the Inventory and Balance Sheet by Category Code report.
See Processing Options for Inventory and Balance Sheet by Category Code (R76C094).
Set these processing options for the Trial Balance by Category Code report.
Period
1. Fiscal Year and Period Number |
Enter the fiscal year and period number in which to generate the report. |
1. Level
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. |
Ledger
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. |
Cat Code
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. |
The processing options for this report are the same as those for the Trial Balance Report (R09410), except for the additional processing options described in this section.
See Processing Options for Trial Balance Report (R09410).
Process
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. |
Group
1. Group |
Specify how to group the report. Values are: 1: Group by business unit 2: Group by company 3: Group all companies |
Title
1. Optional Report Title |
Enter a title for the report in the processing options for Line 1 and Line 2. |
Version
1. Version |
Enter the version for the R76C0902A |
Set these processing options for the G/L with Subledger Totals report.
Ledger Type
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
Subledger |
Specify the general ledger subledger. If you leave this processing option blank, the system uses * for all subledgers. |
This report prints a general ledger that includes all accounting transactions with matching documents.
When you run this report, the system stores the selected data from the F0911 table to a temporary table (F76C9415), then sorts the data by company, document type, batch type, and account number. The system uses these fields as level breaks in the report. The report includes three columns: Account Number and Description, Debits, and Credits.
Note. Use Data Selection to limit the records selected from the F0911 table. For example, you might specify the dates of the records to select. If you do not use limit the data selection, the processing time might be excessive.
Set these processing options for the G/L by Object Account with Subledger Total report.
Content
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. |
Dates
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. |
Document
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. |
Currency
1. Currency Code |
Enter a specific currency code or enter * for all currency codes. |
Ledger Type
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. |
In addition to the reports specified as part of a process in other sections of this implementation guide, these reports exist for Venezuela.
Report ID and Report Name |
Description |
Navigation |
R76VCRVP |
Run the AR-CV Withholding Certificate program to generate a report that lists the suppliers for which withholdings are calculated. The report also lists the amounts of the withholding and the percentage. |
Monthly Reports (G76V07), AR-CV Withholding Certificate |
R76VDJRM |
Run the IM Withholding Affidavit program to print a report that list the withholdings for municipal taxes. The reports group the amounts withheld by withholding type. |
Monthly Reports (G76V07), IM Withholding Affidavit |
R76VDJRN |
Run the ISLR Withholding Affidavit program to print a report that lists the withholdings for income taxes for a specified period. |
Monthly Reports (G76V07), ISLR Withholding Affidavit |
R76VIR01B |
Run the Withholding Integrity - Erases Historical program to maintain data consistency between the F0411 table and the Withholding Historical File - VEN (F76V4581) table. |
Withholding Integrity Reports (G76V049), Withholding Integrity - Erases Historical |
R76VIR02C |
Run the Withholding Integrity - Create Historical program to maintain data consistency between the F0411 table and the F76V4581 table. |
Withholding Integrity Reports (G76V049), Withholding Integrity - Create Historical |
R76VPART |
Run the Annual Withholding Affidavit - Diskette program to write flat file data 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 data and generate a flat file that includes the withholdings for a specified period. |
Annual Reports (G76V048), Annual Withholding Affidavit (Disquette) |
Processing options enable you to specify the default processing for programs and reports.
AR-CV Withholding
Date From |
Enter the first date in a range of dates that the system uses to select records to process. |
Date To |
Enter the last date in a range of dates that the system uses to select records to process. |
Company |
Enter the company number of the company for which you generate the report. |
Withholding Document Type |
Enter the document type that the system uses to select records to process. |
Processing options enable you to specify the default processing for programs and reports.
ISLR Declaration
Summarize by Supplier |
Enter 1 to summarize the report by supplier. Leave this processing option blank to print in detail. |
Date From |
Enter the first date in a range of dates that the system uses to select records to process. |
Date To |
Enter the last date in a range of dates that the system uses to select records to process. |
Processing options enable you to specify the default processing for programs and reports.
IM Withholding Affidavit
Summarize by Supplier |
Enter 1 to summarize the report by supplier. Leave this processing option blank to print in detail. |
Date From |
Enter the first date in a range of dates that the system uses to select records to process. |
Date To |
Enter the last date in a range of dates that the system uses to select records to process. |
You run the Withholding Integrity - Create Historical (R76VIR02C) and the Withholding Integrity - Erases Historical (R76VIR01B) programs to maintain data consistency between the F0411 table and the Withholding Historical File - VEN (F76V4581) table.
When you run Withholding Integrity - Erase Historical program, the system deletes records from the F76V4581 table when no record exists in the F0411 table for a transaction which includes:
A document type of PV (paid voucher).
A document type of PW (paid national withholding).
The Withholding Integrity- Erase Historical program produces a report that lists the records deleted from the F76V4581 table.
You run the Withholding Integrity - Create Historical program to update table F76V4581 with data about the municipal taxes withheld.
Processing options enable you to specify the default processing for programs and reports.
Delete
Delete |
Enter Y to delete historical records. |
Processing options enable you to specify the default processing for programs and reports.
Document
I.S.R.L. Document Type |
Enter the document type from UDC 00/DT that identifies ISRL records. |
I.M Document Type |
Enter the document type from UDC 00/DT that identifies records with municipal taxes. |
Company |
Enter the company for which you process records. |
Processing options enable you to specify the default processing for programs and reports.
Withholding
Document Type of Withholding (Country) |
Enter the document type from UDC 00/DT that identifies vouchers for national withholding. |
Document Type of Withholding (City) |
Enter the document type from UDC 00/DT that identifies vouchers for municipal withholding. |
Company
Withholding Agent Name |
Enter the name of the company which processed the withholding. |
Address Number |
Enter the address book number of the person in charge of processing withholding. |
Fiscal Year
Fiscal Year |
Enter the fiscal year for which you process records. |
In addition to the reports specified as part of a process in other sections of this implementation guide, the Debit/Credit T/B by Object report (R09473) is available for the United States and other countries.
See R09473 - (DEU, FRA, ITA, USA) Debit/Credit T/B by Object.
See Processing Options for Debit/Credit T/B by Object (R09473).