My Oracle Support Banner

E1: 76M: After Making a Partial Payment with Mexico VAT and Foreign Currency it’s Calculating the Exchange Rate Incorrectly After Posting the Payment (R09801). (Doc ID 2927479.1)

Last updated on FEBRUARY 26, 2024

Applies to:

JD Edwards EnterpriseOne Accounts Payable - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

After making a partial payment with Mexico VAT and foreign currency it’s calculating the exchange rate incorrectly after posting the payment using R09801 Version ZJDE0004 / Manual Payment with Match Post.

An example is with USD and MXN currencies and posting the partial payment. The output of the post report with document type PN/PG has the correct calculations USD * Exchange Rate = MXN, but then second output of the post report with the document type JK has the incorrect calculations MXN * Exchange Rate = USD.

Steps to Duplicate issue:

  1. Activate Mexico localization in (P0092)
  2. (P0022): select these options for both AR and AP for the Mexican company:

    a. Tax on Gross including Discount.

    b. Discount on Gross Including Tax.

  3. In Batch Versions - ZJDE004 / Manual Payment with Match Post (R09801)

    a. Make sure that the processing options on the Taxes tab of all versions of (R09801) used to post AP and AR transactions are set to 3 – 2 – 2.

    b. Set up a version of the POs Redistribute AP VAT - Mexico program (R76M1630). Version name should be the same as that of the (R09801) version used to post payments.

  4. Go into Interactive Versions: set the Service/Tax Date processing option of (P0400047) to use the GL Date.

  5. Go into AAIs: set up the following AAIs:

    a. PTxxxx – Suspense VAT Account.

    b. PIxxxx – Actual VAT Account.

  6. Go into Tax Rate/Area – (P4008): set up MX tax rate/area for 16 % tax, use the offset of the PT and PI AAIs of Step 5.

  7. Create a Voucher – (P0411): create a voucher with this tax rate for an MXN company for a Date Jan 1st 2023 for 555 USD at Exchange Rate 19.3615

  8. Post Voucher

  9. (P0413M): create a partial payment for the voucher with date 01/26/23 for USD 155 Exchange Rate is 18.8318.

  10. Post Payment using (R09801) Version ZJDE0004 / Manual Payment with Match Post

  11. Review output of Post Reports for calculations



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.