E1: 43: Journal Entries (R09801) Incorrect for Partial 2-Way Match Voucher (P0411/P4314) of Negative Amount Foreign Purchase Order with Exchange Rate Variance (Doc ID 2902079.1)

Last updated on NOVEMBER 23, 2022

Applies to:

Symptoms

A foreign purchasing voucher for a partial amount of the PO which is 2-way voucher matched (Orders to Match) using a different exchange rate than the rate on the PO, creates incorrect journal entries when the PO line and voucher are for a negative amount.  The journal entries for a positive amount order/voucher are correct, but for the negative amount are not.  

Journal Entries (JE) for the partial voucher of the 'positive' amount line show the expected Debit to the Account on the PO line equal to the amount voucher matched (AA amount is adjusted for exchange rate).

Whereas Journal Entries (JE) for the partial voucher of the 'negative' amount line show the expected Credit to the Account on the PO line, but the AA amount credited is the full order Open Amount adjusted for exchange rate as opposed to the amount voucher matched as seen for the positive amount line.

Because the full PO amount is credited, it then also adds a Debit using Distribution & Manufacturing Automatic Accounting Instructions (DMAAI) 4330 to balance the AA debits/credits.

STEPS TO REPRODUCE

1. Create 2 Foreign, J line type purchase orders for amount only using exchange rate 1.25%.  PO 1 should be for a positive amount = 100,000.00.  PO 2 should be for a negative amount = 100,000.00-.
2. Create a partial voucher ($10,000.00) for PO 1 using exchange rate 1.35%.  Post the batch.
3. Create a partial voucher ($10,000.00) for PO 2 using exchange rate 1.35%.  Post the batch.
4. Compare the Posting reports showing the journal entries to see the differences and incorrect JEs for the negative amount voucher.

Example showing the Correct Journal Entries:

Example showing the Incorrect Journal Entries:

Changes

Cause

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