This chapter contains the following topics:
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.
These processing options apply only to the Rent Wittholding report (R76C0001).
Enter the date from which you generate the certificate.
Enter the date through which you need to generate the certificate.
Enter the date based on which you want to generate the certificate. Values are:
1: Print the certificate based on the G/L date range specified in the Date From and Date Thru processing options.
2: Print the certificate based on the service date range specified in the Date From and Date Thru processing options.
Enter the period for which you run the report. You must enter a range of dates in the data selection.
Enter the issue date to be printed on the certificate. If you leave this processing option blank, the system uses the system date.
Enter the city where the deposit for the withholding was made.
Enter 1 to print on the certificate the city in which the withholding occurred.
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.
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.
Enter the name of the person who is responsible for the information shown in the certificate.
Enter additional information that appears on the certificate.
Enter 1 to print on the certificate the percentage of the withholding.
Enter 1 to reverse the sign for the fiscal rate and the total tax amount.
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.
Enter 1 to delete all data in the F76CT2 table.
Enter the first day of the range of dates that the system uses to select records from the F76CT2 table to delete.
Enter the last day of the range of dates that the system uses to select records from the F76CT2 table to delete.
Enter the address number that the system uses to select records to delete from the F76CT2 table.
Enter 1 to generate a certificate of IVA withholding (Print IVA Amount). Enter a different character to generate other certificates.
Enter 1 to print one certificate for all companies.
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.
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).
Enter the first day of the range of dates that the system uses to select records to process.
Enter the last day of the range of dates that the system uses to select records to process.
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. |
Enter 1 to reverse the sign in A/R transactions.
Enter 1 to skip to lines when either the document number or GL date is not sequential.
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.
Enter 1 to print totals by document. A different value will print totals by third-party.
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. |
Enter 1 to delete all data in the F76CT2 table.
Enter the first day of the range of dates that the system uses to select records from the F76CT2 table to delete.
Enter the last day of the range of dates that the system uses to select records from the F76CT2 table to delete.
Enter the address number that the system uses to select records to delete from the F76CT2 table.
The processing options for this program are the same as for R76C0001 on all tabs except the ones on the Date tab. Those processing options are applicable only for the R76C0001 report (Release 9.1 Update).
Processing options for reports enable you to specify the information that appears on the reports.
Enter the period for which you run the report. You must enter a range of dates in the data selection.
Enter the issue date to be printed on the certificate. If you leave this processing option blank, the system uses the system date.
Enter the city where the deposit for the withholding was made.
Enter 1 to print on the certificate the city in which the withholding occurred.
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.
Enter the name of the person who is responsible for the information shown in the certificate.
Enter additional information that appears on the certificate.
Enter 1 to print on the certificate the percentage of the withholding.
Enter 1 to reverse the sign for the fiscal rate and the total tax amount.
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.
Enter 1 to delete all data in the F76CT2 table.
Enter the first day of the range of dates that the system uses to select records from the F76CT2 table to delete.
Enter the last day of the range of dates that the system uses to select records from the F76CT2 table to delete.
Enter the address number that the system uses to select records to delete from the F76CT2 table.
Enter 1 to generate a certificate of VAT withholding. Enter a different character to generate other certificates.
Enter 1 to print one certificate for all companies.
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.
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. |
This processing option processes invoices from the Customer Ledger table (F03B11) that is created by the Accounts Receivable Invoice Entry application or Sales Update process.
Specifies whether the system runs this program in proof or final mode. Valid values are:
Blank: Proof mode
In proof mode, the system does not update any records.
1: Final mode
In final mode, the system updates the records that are being processed.
When the report runs on final mode, the system creates records in the F76C31T2 table with the processed invoices. Update the Auto-Withholding Calculated field with the value 1, so that these invoices are not reprocessed.
This processing option adds the tax lines to Account Payable table (F0411) and the localized Tax Detail-Workfile table (F76CUI02) for the Tax Areas defined in the Tax Area Relationship Setup program (P76C0005). The Additional Tax Calculation table (F76C0006) contains information about the additional tax calculated.
Use this processing option to specify whether the system runs this program in proof or final mode. Valid values are:
Blank: Proof Mode
In proof mode, the system does not update any records.
1: Final Mode
In final mode, the system updates the records that are being processed.
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.
Set these processing options for the General Ledger with Total by Object Account.
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.
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.
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.
Leave this processing option blank to include detailed balances by accounts payable subledger. Enter 1 to suppress printing of detailed balances.
Leave this processing option blank to include detailed balances by accounts receivable subledger. Enter 1 to suppress the printing of detailed balances.
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.
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.
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.
Enter any value from 1 through 23 as the category code from which information is retrieved for the report.
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.
Enter the fiscal year and period number in which to generate the report.
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.
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.
Enter the category code (21) from which information is retrieved for the report.
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.
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.
Specify the company in which to generate the report. If you leave this processing option blank, the report includes all companies (consolidation).
Specify whether to purge tables for the company specified in the Company processing option. Values are:
Blank: Do not purge tables
1: Purge tables.
Specify how to group the report. Values are:
1: Group by business unit
2: Group by company
3: Group all companies
Set these processing options for the G/L with Subledger Totals report.
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.
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.
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.
Enter the fiscal year and period number if the Report Content processing option is 3.
Specify the account number to print.
1: Account number.
2: Short account ID.
3: Unstructured account.
Specify whether to print units. Values are:
Blank: Do not print units. (Print amounts only.)
1: Print units.
Specify whether to include accounts that have no balance and no detail for the specified period. Values are:
Blank: Include accounts.
1: Omit accounts.
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.
Enter a specific subledger or enter * for all subledgers.
Enter the subledger type if you entered a specific subledger in the Subledger processing option.