(VEN) Working With Country-Specific Functionality for Venezuela

This chapter discusses how to:

• Assign control numbers to invoices.

• Add exportation numbers to invoices for foreign transactions.

• Enter vouchers.

• Enter credit notes and debit notes.

• Process national and municipal withholding.

• Process value-added tax (VAT).

Assigning Control Numbers to Invoices 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.

Forms Used to Assign Control Numbers to Invoices

Assigning 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.

Add Exportation Numbers to Invoices for Foreign Transactions

This section provides an overview of exportation numbers and lists the forms used to add exportation numbers to invoices.

Understanding Exportation Numbers

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.

Forms Used to Add Exportation Numbers

Entering Vouchers for Venezuela

This section provides an overview of vouchers for Venezuela and discusses how to enter additional information for Venezuela.

Understanding Voucher Entry 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

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 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 Used to Enter Additional Information for Venezuela

Entering Additional Information

Access the Withholding Additional Information form.

Invoice Control 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.

Entering Credit Notes and Debit Notes for Venezuela

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).

Understanding Credit and Debit Notes for Venezuela

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.

Prerequisites

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.

Forms Used to Select a Related Voucher for a Credit or Debit Note

Setting Processing Option for PO - Voucher Entry (P0411) (P76V4047)

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

Processing National and Municipal Withholding for Venezuela

This section provides overviews of national and municipal withholding 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 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).

Understanding National and Municipal Withholding

JD Edwards EnterpriseOne software provides country-specific programs to process the withholding of national and municipal taxes.

Calculating National Withholding

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:

1. Converts the voucher's gross amount to tributary units by multiplying the gross amount of the voucher by the tributary unit.

2. 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.

3. Multiplies the gross amount of the voucher by the base percentage to obtain the base amount.

4. 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

5. 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:

1. 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.

2. Applies the base percentage to the gross voucher amount to calculate the base amount for the voucher.

3. Adds the base amount for the voucher to the accumulated base amount from the F76V4583 table.

4. Multiplies the new accumulated base amount (accumulated base amount from the F76V4583 table and the base amount from the voucher) by the tributary unit.

5. 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.

6. 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

7. Updates the F76V4581 and F76V4583 tables with the new accumulated amounts.

Calculating Municipal Tax

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.

Notes About Withholding Taxes

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).

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.

Understanding the Withholding Integrity 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).

Prerequisites

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.

Running the ISLR Withholding Calculation Program

Select General WH Calculation Process (G76V045), ISLR Withholding Calculation.

Setting Processing Options for ISLR Withholding Calculation (R76V4580A)

Processing options enable you to specify the default processing for programs and reports.

I.S.L.R.

Running the ISLR Withholding Certificate (R76VCRNP) Program

Select Monthly Reports (G76V047), ISLR Withholding Certificate.

Setting Processing Options for ISLR Withholding Certificate (R76VCNRP)

Processing options enable you to specify the default processing for programs and reports.

Range of Date

Running the IM Withholding Calculation (R76V4590A) Program

Select General WH Calculation Process (G76V045), IM Withholding Calculation.

Setting Processing Options for IM Withholding Calculation (R76V4590A)

Processing options enable you to specify the default processing for programs and reports.

I.M.

Running the WH - Integrity Report Program

Select Withholding Integrity Reports (G76V049), WH - Integrity Report.

Setting Processing Options for WH - Integrity Report (R8976V6E)

Processing options enable you to specify default processing values.

Default

Processing Withholding for VAT for Venezuela

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).

Understanding VAT for Venezuela

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.

See Working with the Text File Processor.

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 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.

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.

Prerequisites

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).

Running the VAT Withholding Calculation Program

Select General WH Calculation Process (G76V045), VAT Withholding Calculation.

Setting Processing Options for VAT Withholding Calculation (R76V04570)

Processing options enable you to specify the default processing for programs and reports.

VAT

Running the VAT Withholding Certificate Program

Select Monthly Reports (G76V047), VAT Withholding Certificate.

Setting Processing Options for VAT Withholding Certificate (R76VLO03)

Processing options enable you to specify the default processing for programs and reports.

Configuration

Running the VAT Withholding - TXT File Generation Program

Select Monthly Reports (G76V047), VAT Withholding - TXT File Generation.

Setting Processing Options for VAT Withholding - TXT File Generation (R76VLO01)

Processing options enable you to specify the default processing for programs and reports.

Configuration

Configuration 2