My Oracle Support Banner

E1: 43: VMA Automation Rule 05 “MATCH NOT FOUND” On Foreign Invoice With Multiple PO Lines and Taxes (Doc ID 2793589.1)

Last updated on AUGUST 09, 2021

Applies to:

JD Edwards EnterpriseOne Procurement and Subcontract Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to match a 1-line Taxable Foreign invoice to 2 line PO Receipt Document using Automation Rule 05, and with a rounding tolerance set, Voucher Match Automation UBE for Automation Rule 02,03,04,05 (R4304020) is returning a “Match Not Found” message and not creating the voucher.

The issue was reproduced at with the following steps:

  1. Create a 2-line Foreign Purchase Order as follows:
    1. Branch and Company use MXN (Mexican Peso) Currency
    2. Supplier uses USD Currency
    3. Line 1 has Item #1, Order Quantity 6, Foreign Unit Cost 82.80 USD, Foreign Extended Cost 496.80 USD
    4. Line 2 has Item #2, Order Quantity 6, Foreign Unit Cost 127.02 USD, Foreign Extended Cost 762.12 USD
  2. The sum of the two lines Extended Amounts is a taxable amount of 25,402.24 MXN (Domestic Currency) and 1,258.92 USD (Foreign Currency). Taxes and Gross Amounts will be calculated at Voucher match.
  3. Receive both lines of the PO for the full PO Quantity and Amount with no changes
  4. Use Batch Voucher Entry (P0411Z1) to enter the invoice in the Supplier's Currency (USD) manually
    1. The invoice has 1 line as opposed to the PO which has 2 lines
    2. Automation Rule 05 is used
    3. Foreign Taxable Amount of 1,258.92 USD is manually entered
    4. Taxes are calculated as 205.75 (16%)
    5. Foreign Gross Amount is calculated as 1,491.67
    6. Amounts on the Invoice match line match the sum of amounts on the two Purchase Order lines.
    7. Purchase Order Number and Type are populated on invoice but Line Number and Item are not populated.
    8. Client is wanting to match two purchase order lines to one invoice line.
  5. Setup Voucher Match Automation UBE for Automation Rule 02,03,04,05 (c) Processing Options
    1. Default Tab Option #8 (Rounding Tolerance for Rule 05) = 1
    2. Standard Tolerance processing options are blank. Assumed to be not needed since sum of PO lines equal the one invoice line.
  6. In Rounding Tolerance Rules Revisions (P43221) setup a tolerance of + and - .99 MXN for the Mexican Company but the USD Supplier is not defined.
  7. Run the VMA Driver Program (R4304010) XJDE0001 (without logged voucher) which calls the Rule 05 Processor (R4304020) program.
  8. Output from the Rule 05 Processor (R4304020) program shows the Amount to Match in domestic currency 25,947.05 MXN and returns a "Match Not Found" error.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.