This chapter discusses how to:
Assign control numbers to invoices.
Enter vouchers.
Enter credit notes and debit notes.
Process national and municipal withholding.
Process value-added tax (VAT).
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.
Form Name |
FormID |
Navigation |
Usage |
Work With Invoice Control Number |
W76VNCF1B |
Locate invoices. |
|
Invoice Control Number Revision |
W76VNCF1A |
On the Work With Invoice Control Number form, select an invoice and then click Select. |
Assign, revise, and remove invoice control numbers. |
Access the Invoice Control Number Revision form.
Invoice Ctrol.Number (invoice control number) |
Enter the control number to assign to the invoice. |
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 F76V4011 table.
When completing 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 (value-added taxes) withholding taxes.
Vouchers for Imported Goods
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.
Vouchers with Withholdings
When you use the Standard Voucher Entry program to enter vouchers for Venezuela, the system launches the F0411 Tag File Maintenance (P76V4011) program 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 exist 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 (F76V4581) table.
Form Name |
FormID |
Navigation |
Usage |
Withholding Additional Information |
W76V0411A |
On the Enter Voucher - Enter Payment form, select Row, Regional Info. |
Enter the withholding information for the voucher. |
Access the Withholding Additional Information form.
Invoice Control Number (invoice control number/file importation number) |
Enter the invoice number from the supplier's invoice, or the importation number from the Form C for imported goods. |
VAT Concept |
Enter a code that exists in the VAT Withholding Concept (76V/IV) UDC table. |
I.S.L.R. Concept (Impuesto sobre la Renta) concept |
Enter a code that exists in the ISLR Withholding Concepts (76V/IS) UDC table. |
Municipal Concept |
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, 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.
Form Name |
FormID |
Navigation |
Usage |
Work With Credit/Debit Note - Voucher Relation |
W76V4015A |
Credit and Debit Note Relationship (G76V046), Credit and Debit Note Inquiry. |
View and select existing records. |
W76V4015B |
Select a record, then click Select on the Work With Credit/Debit Note form. |
Enter the related voucher for the credit or debit note. |
|
W76V4015C |
Select Voucher from the Form menu on the Credit/Debit Note form. |
Select the related voucher. When you click Select, the system displays the voucher number in the Credit/Debit Note - Voucher Relation form. |
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.
Default Values
Credit/Debit Note |
Enter 1 to specify that the voucher is for a credit or debit note. |
This section provides an overview of withholding and discusses how to:
Run the ISLR Withholding Calculation program.
Set processing options for ISLR Withholding Calculation (R76V4580A).
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).
JD Edwards EnterpriseOne software provides country-specific programs to process the withholding of national and municipal taxes.
Withholding Calculations
Run the ISLR Withholding Calculation (R76V4580A) program to calculate the withholding of Venezuelan income taxes (Impuesto sobre la Renta [ISLR]).
Run the IM Withholding Calculation program to calculate the withholding for municipal taxes.
When you run either of these programs, 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.
For the ISLR calculation, verifies the fee code type that is established in the ISLR Withholding Percentages (P76V4020) program.
Calculates the basis amount according to the values that you set up in the ISLR Withholding Setup (P76V0420) program for income taxes and 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 these programs:
If the invoice has value-added tax (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, Payment Status 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, the withholding calculation must be made by GL offset.
When creating each withholding document, the system updates the Withholding Historical File - VEN (F76V4581) table.
This table includes the values that are used for the calculation, as well as the related voucher. The system also updates the Withholdings I.S.L.R. Fee 2 (F76V4583) table for ISLR withholding when the fee type code is 2.
Withholding Reports
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).
See (VEN) Reports for Venezuela.
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).
See Setting Up UDCs for Supplier Withholding for Venezuela.
Select General WH Calculation Process (G76V045), ISLR Withholding Calculation.
Processing options enable you to specify the default processing for programs and reports.
I.S.L.R.
1. Insert Payment Date |
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. |
2. Municipal Withholding (OBSOLETE) |
This processing option is obsolete. |
3. Withholding by Document |
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. |
4. Payment Status |
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). |
5. Document Type |
Enter the document type that the system assigns to the withholding voucher. |
6. Account ID |
Enter the short account number for the withholding. |
7. Payment Status for ISLR |
Enter a value that exists in the Payment Status Codes (00/PS) UDC table to identify the payment status for the ISLR withholding document. |
8. P0400047 Version |
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. |
9. P0900049 Version |
Enter the version of the Journal Entry MBF Processing Options program (P04000479) that the system uses when you run the ISLR Withholding Calculation program. If you leave this processing option blank, the system uses version ZJDE0001. |
10. Exchange Rate |
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. |
11. Amount Tributary Unit (OBSOLETE) |
This processing option is obsolete. |
I.M.
All of the processing options on the I.M. tab are disabled. Use the Withholding Calculation (R76V4590A) program to process municipal taxes.
Select Monthly Reports (G76V047), ISLR Withholding Certificate.
Processing options enable you to specify the default processing for programs and reports.
Range of Date
Date From |
Enter the first date in a range of dates to select records to process. |
Date To |
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.
I.M.
Insert Payment Date |
Enter the date on which the withholding date is calculated. If you leave this processing option blank, the system uses the system date. |
Withholding by Document |
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. |
Payment Status to Release |
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). |
Document Type |
Enter the document type that the system assigns to the withholding voucher. |
Account ID |
Enter the short account number for the withholding. |
Payment Status for Withholding Document |
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). |
P0400047 Version |
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. |
P0900049 Version |
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. |
Exchange Rate |
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. |
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.
VAT Withholding Calculation Program
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 (F76V4030) table.
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.
VAT Withholding - TXT File Generation
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.
VAT
Withholding Document Date |
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. |
Payment 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. |
Document Type |
Enter the document type that the system assigns to the VAT withholding voucher. |
Account ID for Withholding |
Enter the short account ID. |
Payment Status for Release |
Enter the payment status that the system uses to select records to process. |
Payment Status for VAT |
Enter the payment status that identifies payments for which VAT applies. |
Payment Status for Withholding Document |
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). |
P0400047 Version |
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. |
P0900049 Version |
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. |
Select Monthly Reports (G76V047), VAT Withholding Certificate.
Processing options enable you to specify the default processing for programs and reports.
Configuration
1. Date From |
Enter the first date in a range of dates that the system uses to select records to process. |
2. Date To |
Enter the last date in a range of dates that the system uses to select records to process. |
3. Separating Character |
Enter the special character that separates the invoice number from the control number in the Invoice Number field of the Additional Information - Venezuela form. |
4. Company |
Enter the company for which the report is run. |
5. Document Type |
Enter the document type that the system uses to select records to process. |
6. Address Number of Withholding Agent |
Enter the address book number of the company that is withholding the VAT. |
Select Monthly Reports (G76V047), VAT Withholding - TXT File Generation.
Processing options enable you to specify the default processing for programs and reports.
Configuration
1. Date From |
Enter the first date in a range of dates that the system uses to select records to process. |
2. Date To |
Enter the last date in a range of dates that the system uses to select records to process. |
3. RIF Contributor |
Enter the tax ID number of the RIF contributor. Enter the number without spaces or special characters. |
4. Separating Character |
Enter the special character that separates the invoice number from the control number in the Invoice Number field of the Additional Information - Venezuela form. |
5. Historical Sales |
Enter 1 to save records in the sales history record. |
6. Company |
Enter the company for which the report is run. |
7. Path |
This processes option is not used. The system writes write flat file data to the Text Processor Header (F007101) and Text Processor Detail (F007111) tables. |
8. Document Type of Form C |
Enter the document type from UDC 00/DT that identifies records for which an import form (Form C) exist. |
Configuration 2
Reason Code for the Retained VAT (Sales) |
Enter a code from the Reason Code (03B/RC) UDC table that identifies the retained VAT for sales. |
Code of Importation VAT 1 |
Enter a tax rate /area for the tax. |
Include Sales |
Enter 1 to save records in the sales history record. |