This chapter contains the following topics:
Section 4.1, "Assigning Control Numbers to Invoices for Venezuela"
Section 4.2, "Add Exportation Numbers to Invoices for Foreign Transactions"
Section 4.4, "Entering Credit Notes and Debit Notes for Venezuela"
Section 4.5, "Processing National and Municipal Withholding for Venezuela"
Section 4.7, "Understanding Additional Reports for Venezuela"
Invoice control numbers are used by the Sales Book program (R76VLV01) to meet legal reporting requirements for Venezuela.
This section provides discusses how to assign invoice control numbers.
Access the Invoice Control Number Revision form.
Figure 4-1 Invoice Control Number Revision
Enter the control number to assign to the invoice.
This section provides an overview of exportation numbers and lists the forms used to add exportation numbers to invoices.
When you report VAT for sales transactions, you must include the exportation number for each sales transaction for exported goods. The exportation number is a legal number that is unique to each transaction.
You can add an exportation number to your accounts receivable invoices by using the Exportation Number program (P76V0311). The system writes the exportation number that you enter to the Exportation Number table (F76V0311). When you run the Sales Book program (R76VLV01) to generate the VAT report for sales transactions, the system reads the data in the F76V0311 table and writes the exportation number to the VAT report.
This section provides an overview of vouchers for Venezuela and discusses how to enter additional information for Venezuela.
After you use the standard voucher entry programs to enter vouchers for Venezuela, the system displays the Withholding Additional Information form on which you enter information about income, municipal, and value-added taxes. The system stores the information that you enter in the A/P Ledger Tag File - VEN table (F76V4011).
When you enter a value in the Pay Status field when entering vouchers in the Standard Invoice Entry program (P0411), enter the payment status that you defined in the UDC 00/PS to indicate when vouchers are ready for the calculation of ISLR (Impuesto sobre la Renta), IM (municipal taxes), and VAT.
Vouchers for imported goods must be entered using a document type that you set up in the 00/DT and 00/DV UDC tables specifically for these transactions. When entering these vouchers, enter the customs statement (Form C) number and the import file number in the Invoice Control Number field, separated by a special character.
When you use the Standard Voucher Entry program to enter vouchers for Venezuela, the system launches the F0411 Tag File Maintenance program (P76V4011) when you click OK after entering a voucher. You can also access this program from the Regional Info option on the Form menu. You use this program to add codes that identify VAT, municipal, and income tax withholdings for each pay item. You also relate a control number or the import file number to the invoice.
When you add a voucher, the system accesses the tax withholding codes for the supplier that exists in the A/B Additional Info. Tag File (F76V1001) table and displays them in the Withholding Additional Information form. You can accept these default values or change the values. The system saves the default values or the values that you enter in the A/P Ledger Tag File - VEN (F76V0411) table when you click OK on the Withholding Additional Information form.
Additionally, the systems launches the F0411 Tag File Maintenance program when you work with logged vouchers and voucher match.
When you delete a voucher for which withholding records exist, the system deletes the withholding information from the F76V4011 table and the Withholding Historical File - VEN table (F76V4581).
Form Name | FormID | Navigation | Usage |
---|---|---|---|
Enter Voucher - Payment Information | W0411A | Supplier & Voucher Entry (G0411), Standard Voucher Entry
Click Add on the Supplier Ledger Inquiry form. |
Enter information for the voucher on the standard software entry form. |
Withholding Additional Information | W76V4011A | Click OK on the Enter Voucher - Payment Information form. | Enter the withholding information for the voucher. |
Access the Withholding Additional Information form.
Figure 4-2 Withholding Additional Information form
Enter the invoice number from the supplier's invoice, or the importation number from the Form C for imported goods.
Enter a code that exists in the VAT Withholding Concept (76V/IV) UDC table.
Enter a code that exists in the ISLR Withholding Concepts (76V/IS) UDC table.
Enter a code that exists in the IM Withholding Concepts (76V/IM) UDC table.
This section provides an overview of credit notes and debit notes for Venezuela, lists prerequisites, lists forms used to select a related voucher for a credit or debit note, and discusses how to set processing options for PO - Voucher Entry (P0411) - VEN (P76V4047).
A debit note, also called a debit memo, is a voucher that you enter when a supplier issues you a credit for a transaction. Similarly, a credit note (credit memo) is a voucher that you enter when you issue a credit to a customer. In Venezuela, companies often choose to associate the credit or debit note to the original voucher to assist with accounting practices.
Use the Credit and Debit Note Inquiry program (P76V4015) to select the voucher to which you associate a credit or debit note.
Before you complete the tasks in this section:
Set up corresponding versions of the Voucher Entry (P0411) program and the PO - Voucher Entry (P0411) program (P76V4047).
Verify that appropriate values exist for credit notes and debit notes in the Credit Note Document Types (76V/NC) and the Debit Note Document Types (76V/DC) UDC tables.
Select Credit and Debit Note Relationship (G76V046), PO - Voucher Entry (P0411) - VEN.
Note: You must select the version to use and then click Select to access the processing option. |
Enter 1 to specify that the voucher is for a credit or debit note.
This section provides overviews of national and municipal withholding, the ISLR Withholding report for Venezuela, and the withholding integrity report; and discusses how to:
Run the ISLR Withholding Calculation program.
Set processing options for ISLR Withholding Calculation (R76V4580A).
Run the ISRL Withholding - XML File Generation program.
Set data selection for the ISRL Withholding - XML File Generation program.
Set processing options for ISRL Withholding - XML File Generation (R76V4581).
Run the ISLR Withholding Certificate program.
Set processing options for ISLR Withholding Certificate (R76VCRNP).
Run the IM Withholding Calculation program.
Set processing options for IM Withholding Calculation (R76V4590A).
Run the WH - Integrity Report program.
Set processing options for WH - Integrity Report (R8976V6E).
JD Edwards EnterpriseOne software provides country-specific programs to process the withholding of national and municipal taxes.
Run the ISLR Withholding Calculation program (R76V4580A) to calculate the withholding of Venezuelan income taxes (Impuesto sobre la Renta [ISLR]). The system calculates the withholding according to the fee code that you assign to the supplier.
When the fee code for a suppler is 1, the system calculates the withholding amount based on the calculated base amount of a single transaction. When the fee code is 1, the system:
Converts the voucher's gross amount to tributary units by multiplying the gross amount of the voucher by the tributary unit.
Uses the result of Step 1 to retrieve the base percentage, withholding percentage, and withholding factor from the F76V4020 table.
The system searches for the line for the supplier that has a minimum amount that is less than the result and a maximum amount that is greater than the result, and retrieves the withholding percentage and withholding factor for that line.
For example, if the gross amount of the voucher is 7000 and the tributary unit is 37.632, the result is 186. The system accesses the line in the F76V4020 table that includes 186 between the minimum and maximum amounts, and uses the base percent, withholding percent, and withholding factor for that line.
Multiplies the gross amount of the voucher by the base percentage to obtain the base amount.
Uses this formula to calculate the tax amount:
(base amount × withholding percentage) − (withholding factor × tributary unit)
For example, if the base amount is 7000, the withholding percentage is 22 percent, the withholding factor is 14, and the tributary amount is 37.632, the system performs this calculation: (7000 × .22) − (14 × 37.632) = 1013.15
Updates the Withholdings Historical table (F76V4581) with the new amount.
When the fee code is 2, the system calculates the withholding amount based on accumulated base and withholding amounts. When your supplier is set up to use fee code 2, the system accesses the I.S.L.R. Fee Code 2 File (F76V4583), F76V410, and F76V4020 tables to get the data used for calculating withholding.
When the fee code is 2, the system:
Retrieves data from the historical and setup tables, using the voucher's gross amount converted to tributary units:
Retrieves the accumulated base and withholding amounts from the F76V4583 table.
Retrieves the base percentage, withholding percentage, and withholding factor from the F76V4020 table.
Retrieves the tributary unit from the F76V410 table.
Applies the base percentage to the gross voucher amount to calculate the base amount for the voucher.
Adds the base amount for the voucher to the accumulated base amount from the F76V4583 table.
Multiplies the new accumulated base amount (accumulated base amount from the F76V4583 table and the base amount from the voucher) by the tributary unit.
Uses the result of the calculation in Step 4 to determine the line in the F76V4020 table from which to obtain the withholding percentage and withholding factor.
The system searches for the line for the supplier that has a minimum amount that is less than the result and a maximum amount that is greater than the result, and retrieves the withholding percentage and withholding factor for that line.
Uses this formula to calculate the tax amount:
(accumulated base amount × withholding percentage) − (withholding factor × tributary unit) − accumulated withholding amount
For example, if the accumulated base amount is 7000, the accumulated withholding amount is 500, the withholding percentage is 22 percent, the withholding factor is 14, and the tributary amount is 37.632, the system performs this calculation: (7000 × .22) − (14 × 37.632) − 500 = 513.15
Updates the F76V4581 and F76V4583 tables with the new accumulated amounts.
Run the IM Withholding Calculation program (R76V4590A) to calculate the withholding for municipal taxes.
When you run the IM Withholding Calculation program, the system:
Accumulates the taxable amounts by document or by supplier and by withholding concept, depending on the processing option values, and by withholding codes and currency.
Calculates the basis amount according to the values that you set up in the IM Withholding Setup program (P76V4025) for municipal taxes.
Calculates in the local currency the withholding amount according to the rate.
If related documents are in a foreign currency, the system makes the currency conversion at the rate that is in effect on the date that is specified in the processing options.
Changes the payment status to the status specified in the processing options.
Generates a report that lists the processed vouchers, the withholding documents, and the batch.
Other notes about the ISLR Withholding Calculation and IM Withholding Calculation programs:
If the invoice has VAT, the amount for the withholding calculation is the amount of the invoice without tax.
If the withholding is for the total amount to be paid by the supplier, the program calculates the amount that is subject to withholding by adding all of the vouchers with the payment status that is indicated in the processing option and with the same withholding code and currency, without considering any other field selection value.
Therefore, the Payment Status field is the key field to determine whether a document must be considered for the withholding calculation.
For the invoices that are entered in a foreign currency, the system uses the amount in the foreign currency as the basis for the withholding calculation.
The system calculates the amount in the local currency according to the exchange rate that is in effect for the date that appears in the processing option, unless the processing option item for the exchange rate is active. If the exchange rate is active, the system uses the exchange rate that was in effect when the invoice was entered.
The withholding document is created with the same GL offset account to which the withholding is being applied.
In the event that there are several accounts payable transactions, the withholding calculation must be made by GL offset.
When creating each withholding document, the system updates the Withholding Historical File - VEN table (F76V4581).
JD Edwards EnterpriseOne software provides these reports:
ISLR Withholding Affidavit (R76VDJRN).
IM Withholding Affidavit (R76VDJRM).
AR-CV Withholding Certificate (R76VCRVP).
Annual Withholding Affidavit - Diskette (R76VPART).
Withholding Integrity - Create Historical (R76VIR02C).
Withholding Integrity - Erase Historical (R76VIR01B).
You calculate the withholding of Venezuelan income taxes (Impuesto sobre la Renta [ISLR]) by running the ISLR Withholding Calculation program (R74U4580A). After you run the withholding calculation, you run the ISRL Withholding - XML File Generation report to generate the XML file that you submit each month to the Venezuela fiscal authority (SENIAT). The XML file consists of the details of salary and other ISLR withholdings. The ISRL Withholding - XML File Generation program also generates a PDF file.
Note: The solution provided by the JD Edwards EnterpriseOne software generates the XML file for withholdings for salary only. It does not generate records for withholding for stocks and dividends. |
The income tax types known as ISLR withholdings concepts are stored in the A/P Ledger Tag File - VEN (F76V4011). You must create the relationship between the ISLR withholding concept and a VAT withholding type known as ISLR withholding legal concept using the ISLR Relation Concept program (P76V4022) so that ISRL Withholding - XML File includes the legal concept. Generally, you create the relationships only once, or when you add a new concept. The legal concepts are provided by SENIAT.
The ISRL Withholding - XML File Generation report contains the following ISLR withholding information:
Company Fiscal ID: Fiscal ID of the company, which is specified in the processing option of the report. The system uses the company number to obtain the fiscal ID (F0101.TAX) from the address book record.
Month Reported: Month for which the XML file is generated. The system determines the month from the values that you specify in the From Date and To Date processing options.
Supplier Fiscal ID: Tax ID of the address number of the transaction record stored in the F0411 table.
Invoice Legal Number: Number stored in the VINV field of the F0411 table for the transaction.
Control Invoice Number: Number stored in the 76ICNV field of the F76V4011 table for the transaction.
Legal ISLR Withholding Concept: Withholding legal concept (V76ISLC), which the system obtains by using the concept in the voucher to find the related legal withholding concept that you set up in the ISLR Withholding Concepts Relationship program.
Amount Operation: Total amount specified in the transaction record.
Total amount = Gross amount - tax amount for each line of the transaction record.
Withholding Percentage: Withholding percentage stored in the Percentage - Withholding Tax (IRPR) field of the Retention History - VEN table (F76V4581). If the documents with ISRL withholding legal concepts do not have a withholding calculated, then the XML is generated with a withholding percentage equal to zero.
The ISRL Withholding - XML File Generation report includes all documents that have ISLR withholding concepts even if there is no tax detail in the transaction record. However, voided transactions or transactions without an associated legal concept are not included in the report.
The WH - Integrity Report program recalculates the following amounts in the Withholding Historical File (F76V4581) and Withholding I.S.L.R. Fee 2 (F76V4583) tables:
Base Amount Subject to W/T (IRBI).
Foreign Base Amount Subject to W/T (IRBF).
Withholding Tax Amount (IRRI).
Foreign Withholding Tax Amount (IRRF).
Amount - ICMS Reduced Taxable (BBIR).
User Reserved Amount (URAT).
The WH - Integrity Report program also deletes from the Withholding Historical File table all records that do not exist in the Accounts Payable Ledger table (F0411).
Before you run these programs:
Verify that the appropriate values for income tax and municipal taxes exist in the ISLR Withholdings Setup - VEN (F76V4020), F76V4581, and F76V4583 tables.
See Setting Up Withholding for ISLR Taxes for Venezuela.
See Setting Up Withholding for Municipal Taxes for Venezuela.
Verify that appropriate codes exist in these UDC tables:
I.M. Withholding Concept (76V/IM).
ISLR Withholding Concept (76V/IS).
Fee Codes (76V/CT).
Select General WH Calculation Process (G76V045), ISLR Withholding Calculation
Processing options enable you to specify the default processing for programs and reports.
Enter the date that the withholding tax is remitted to the fiscal authority. If you leave this processing option blank, the system uses the current date. If the voucher is entered in a foreign currency, the system uses this date to determine the exchange rate.
Enter 1 to calculate withholding by the total of each invoice. Leave this processing option blank to calculate withholding by the total of the invoices for the supplier.
Enter the payment status that the system uses to select records to process. If you leave this processing option blank, the system selects records with a payment status of A (approved).
Enter the document type that the system assigns to the withholding voucher.
Enter the short account number for the withholding.
Enter a value that exists in the Payment Status Codes (00/PS) UDC table to identify the payment status for the ISLR withholding document.
Enter the version of the Voucher Entry MBF Processing Options program (P0400047) that the system uses when you run the ISLR Withholding Calculation program. If you leave this processing option blank, the system uses version ZJDE0001.
Enter the version of the Journal Entry MBF Processing Options program (P0900049) that the system uses when you run the ISLR Withholding Calculation program. If you leave this processing option blank, the system uses version ZJDE0001.
Enter 1 to use the exchange rate of the invoice. Leave this processing option blank to use the exchange rate in effect at the time the withholding voucher is created.
The system uses this processing option to control the payment term mode. This processing option prevents errors when you calculate withholding, for example discounts taken on withholding documents. If you set up this processing option as Blank, the system retrieves the payment term from the default value you set up in the supplier master. If you enter 1, the system uses the payment term defined in processing option Withholding Payment Term.
This processing option enables you to enter a payment term value. This processing option prevents errors when you calculate withholding, for example discounts taken on withholding documents. The system uses this value when retrieving payment terms if you set up the Payment Term Mode processing option with a value of 1. To comply with legal requirements, you must use a payment term with no discounts considered.
You must run the ISLR Withholding Calculation program before you run the ISRL Withholding - XML File Generation program.
Select Monthly Reports (G76V047), ISLR Withholding – XML File Generation.
To accurately report your tax data, your data selection must include the correct documents. Verify that your data selection and processing options are set to:
Select the correct status.
Select the document types to select documents with amounts greater than zero, including vouchers, debit notes, and so on.
Select dates that are within the date range you want to report.
Select the company for which you need to generate the XML file.
Not select voided documents.
Processing options enable you to specify the default processing for programs and reports.
Specify whether to update the payment status of the document. Values are:
Blank: Proof mode.
1: Final mode. The payment status of the document is updated in this mode.
Specify the company number for which you generate the XML file for SENIAT.
Specify the period for which you generate the report. The dates specified in the From Date and To Date fields must be of the same month. You can generate the XML file with the transactions of an entire month or for a range of dates within a month.
Specify the payment status code that the system assigns to the documents after you run the report. The payment status code (00/PS) indicates the current payment status for a voucher or an invoice.
Note: The system changes the payment status of the document only when the Process Mode processing option is set as 1. |
Specify the path to the location to which the system writes the XML file.
Select Monthly Reports (G76V047), ISLR Withholding Certificate.
Processing options enable you to specify the default processing for programs and reports.
Enter the first date in a range of dates to select records to process.
Enter the last date in a range of dates to select records to process.
Select General WH Calculation Process (G76V045), IM Withholding Calculation.
Processing options enable you to specify the default processing for programs and reports.
Enter the date on which the withholding date is calculated. If you leave this processing option blank, the system uses the system date.
Enter 1 to calculate withholding by the total of each invoice. Leave this processing option blank to calculate withholding by the total of the invoices for the supplier.
Enter the payment status to select records to process. If you leave this processing option blank, the system select records with a payment status of A (approved).
Enter the document type that the system assigns to the withholding voucher.
Enter the short account number for the withholding.
Enter the payment status that the system uses to select records to process. If you leave this processing option blank, the system select records with a payment status of A (approved).
Enter the version of the Voucher Entry MBF Processing Options program (P0400047) that the system uses when you run the IM Withholding Calculation program. If you leave this processing option blank, the system uses version ZJDE0001.
Enter the version of the Journal Entry MBF Processing Options program (P04000479) that the system uses when you run the IM Withholding Calculation program. If you leave this processing option blank, the system uses version ZJDE0001.
Enter 1 to use the exchange rate of the invoice. Leave this processing option blank to use the exchange rate in effect at the time the withholding voucher is created.
The system uses this processing option to control the payment term mode. This processing option prevents errors when you calculate withholding, for example discounts taken on withholding documents. If you set up this processing option as Blank, the system retrieves the payment term from the default value you set up in the supplier master. If you enter 1, the system uses the payment term defined in processing option Withholding Payment Term.
This processing option enables you to enter a payment term value. This processing option prevents errors when you calculate withholding, for example discounts taken on withholding documents. The system uses this value when retrieving payment terms if you set up the Payment Term Mode processing option with a value of 1. To comply with legal requirements, you must use a payment term with no discounts considered.
Select Withholding Integrity Reports (G76V049), WH - Integrity Report.
Processing options enable you to specify default processing values.
Enter a value that exists in the Document Type (00/DT) UDC table to specify the type of ISLR document to select.
Enter a value that exists in the Document Type (00/DT) UDC table to specify the type of municipal tax document to select.
Specify the company for which you run the report.
This section provides an overview of VAT for Venezuela, lists prerequisites, and discusses how to:
Run the VAT Withholding Calculation program.
Set processing options for VAT Withholding Calculation (R76V04570).
Run the VAT Withholding - TXT File Generation program.
Set processing options for VAT Withholding - TXT File Generation (R76VLO01).
Run the VAT Withholding Certificate program.
Set processing options for VAT Withholding Certificate (R76VLO03).
When you process VAT for Venezuela, you:
Use the VAT Withholding Calculation program to calculate VAT withholding.
Use the VAT Withholding Certificate program to generate vouchers for the withholding of VAT.
Use the VAT Withholding - TXT File Generation 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 the flat file for tax reporting.
When you run the VAT Withholding Calculation program, the system:
Selects all vouchers that have a payment status defined as VAT withholding.
Applies to the total tax amount the withholding percentage that is assigned to the supplier in the VAT Withholdings Setup - VEN table (F76V4030).
Changes the payment status of payment items to the payment status that is specified in the processing options.
Creates the VAT withholding document with a negative amount so that the amount is deducted from the voucher payment.
Creates the withholding record in the foreign currency when the voucher is in a foreign currency.
Generates a report that lists the processed vouchers and shows the withholding document and the batch number.
Changes only the document payment status if the withholding is not calculated.
Leaves the payment status unchanged if the program runs with an error.
You run the VAT Withholding - TXT File Generation program to write flat file data to the Text Processor Header (F007101) and Text Processor Detail (F007111) tables. When you run this report for imported goods, only the information that you entered for Form C is reported. The system does not report the supplier purchasing transactions for imports.
The system includes import transactions only when you:
Set up tax rate areas for imported goods to show the goods as VAT exempt.
Define document types in UDCs 00/DT and 00/DV for imported goods.
Enter the supplier invoices as VAT exempt.
Before you complete the tasks in this section, verify that appropriate codes exist in these UDC tables:
Codes for VAT withholding in the Document Type - All Documents (00/DT) and Document Type - Vouchers Only (00/DV) UDC tables.
Codes for type of VAT in the VAT Legal Concept (76V/LC) UDC table.
Payment status code to calculate VAT withholding in the Payment Status Codes (00/PS) UDC table.
Codes for VAT Withholding Concept VE (76V/IV).
Select General WH Calculation Process (G76V045), VAT Withholding Calculation.
Processing options enable you to specify the default processing for programs and reports.
Enter 1 to calculate VAT as of the document date. If you leave this processing option blank and complete the Payment Date processing option, the system uses the date that you enter in the Payment Date processing option. If you leave this processing option and the Payment Date processing option blank, the system uses the current date.
Enter the date on which the system calculates VAT. If you complete both this processing option and the Withholding Document Date processing option, the system uses the document date. If you leave this processing option blank and the Withholding Document Date processing option blank, the system uses the current date.
Enter the document type that the system assigns to the VAT withholding voucher.
Enter the short account ID.
Enter the payment status that the system uses to select records to process.
Enter the payment status that identifies payments for which VAT applies.
Enter the payment status that the system assigns to the vouchers created. If you leave this processing option blank, the system assigns a payment status of A (approved).
Enter the version of the Voucher Entry MBF Processing Options program (P0400047) that the system uses when you run the VAT Withholding Calculation program. If you leave this processing option blank, the system uses version ZJDE0001.
Enter the version of the Journal Entry MBF Processing Options program (P04000479) that the system uses when you run the VAT Withholding Calculation program. If you leave this processing option blank, the system uses version ZJDE0001.
The system uses this processing option to control the payment term mode. This processing option prevents errors when you calculate withholding, for example discounts taken on withholding documents. If you set up this processing option as Blank, the system retrieves the payment term from the default value you set up in the supplier master. If you enter 1, the system uses the payment term defined in processing option Withholding Payment Term.
This processing option enables you to enter a payment term value. This processing option prevents errors when you calculate withholding, for example discounts taken on withholding documents. The system uses this value when retrieving payment terms if you set up the Payment Term Mode processing option with a value of 1. To comply with legal requirements, you must use a payment term with no discounts considered.
Select Monthly Reports (G76V047), VAT Withholding Certificate.
Processing options enable you to specify the default processing for programs and reports.
Enter the first date in a range of dates that the system uses to select records to process.
Enter the last date in a range of dates that the system uses to select records to process.
Enter the special character that separates the invoice number from the control number in the Invoice Number field of the Additional Information - Venezuela form.
Enter the company for which the report is run.
Enter the document type that the system uses to select records to process.
Enter the address book number of the company that is withholding the VAT.
Enter the date that the process assigns to the certificate. This can be either the date of the withholding creation or the date when certificate is printed. Values are:
Blank: System date. This is the date that the certificate is printed.
1: Witholding Creation Date.
Select Monthly Reports (G76V047), VAT Withholding - TXT File Generation.
Processing options enable you to specify the default processing for programs and reports.
Enter the first date in a range of dates that the system uses to select records to process.
Enter the last date in a range of dates that the system uses to select records to process.
Enter the tax ID number of the RIF contributor. Enter the number without spaces or special characters.
Enter the special character that separates the invoice number from the control number in the Invoice Number field of the Additional Information - Venezuela form.
Enter 1 to save records in the sales history record.
Enter the company for which the report is run.
This processing option is not used. The system writes write flat file data to the Text Processor Header (F007101) and Text Processor Detail (F007111) tables.
Enter the document type from UDC 00/DT that identifies records for which an import form (Form C) exists.
Enter a code from the Reason Code (03B/RC) UDC table that identifies the retained VAT for sales.
Enter a tax rate area for the tax.
Enter 1 to save records in the sales history record.
Some reports in the JD Edwards EnterpriseOne system are part of a process. Those reports are included in the sections that describe the process. The software for Venezuela includes additional reports that are not part of a process. Those reports are described in this table:
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.
Enter the first date in a range of dates that the system uses to select records to process.
Enter the last date in a range of dates that the system uses to select records to process.
Enter the company number of the company for which you generate the report.
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.
Enter 1 to summarize the report by supplier. Leave this processing option blank to print in detail.
Enter the first date in a range of dates that the system uses to select records to process.
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.
Enter Y to delete historical records.
Processing options enable you to specify the default processing for programs and reports.
Enter the document type from UDC 00/DT that identifies ISRL records.
Enter the document type from UDC 00/DT that identifies records with municipal taxes.
Enter the company for which you process records.
Processing options enable you to specify the default processing for programs and reports.
Enter the document type from UDC 00/DT that identifies vouchers for national withholding.
Enter the document type from UDC 00/DT that identifies vouchers for municipal withholding.
Enter the name of the company which processed the withholding.
Enter the address book number of the person in charge of processing withholding.
Enter the fiscal year for which you process records.
Processing options enable you to specify the default processing for programs and reports.
Enter 1 to summarize the report by supplier. Leave this processing option blank to print in detail.
Enter the first date in a range of dates that the system uses to select records to process.
Enter the last date in a range of dates that the system uses to select records to process.