Payment Posting Creating Wrong Accounting Entries When AP Cash Clearing Is Enabled (Doc ID 2948060.1)

Last updated on MAY 10, 2023

Applies to:

Symptoms

Payment Posting creating wrong accounting entries when AP Cash Clearing is enabled
For some payments, the monetary and foreign amount are in opposite sign.

This issue occur when there are credit vouchers in the payment with similar specific values.

STEPS

1. Create a new attribute on FUND_CODE = Treasury Symbol = 2021 on
   Set Up Financials/SupplyChain > Common Definition > Desigb Chartfueld > Configure > Attributes.
2. The Fund code chartfield is renamed to Accident year in this example.
3. Selected the fund code and added the attribute to it.
   Set Up Financials/Supply Chain > Common Definitions > Design ChartFields > Define ChartField Value = FUND_CODE
4. Trying to create a voucher with federal payment enabled it will only allow when a bank payment method has the settle by option “Paycycle.”  Use FG so we have to change it to Paycycle to test this.
   Banking > Bank Accounts > External Accounts
5. Create 12 vouchers with foreign currency, different to base currency. For the test, BU = US001 - having default currency = USD.
   Each of 12 vouchers are created with foreign currency, EUR  and with amounts:
   
   Voucher 1 = 00000474 = EFT1   =        91550.38 EUR
   Voucher 2 = 00000463 = test2    =   -463086.00 EUR
   Voucher 3 = 00000464 = eft3     =      39328.63 EUR
   Voucher 4 = 00000465 = eft4     = -1289197.37 EUR
   Voucher 5 = 00000466 = eft5    =     121800.00 EUR
   Voucher 6 = 00000467 = eft6    =    -951300.00 EUR
   Voucher 7 = 00000468 = eft7    =   2193987.87 EUR
   Voucher 8 = 00000469 = eft8    =   2308950.00 EUR
   Voucher 9 = 00000470 = eft9    =     432099.79 EUR
   Voucher 10 = 00000471 = eft10    = -2257500.00 EUR
   Voucher 11 = 00000472 = eft11    =       87150.00 EUR
   Voucher 12 = 00000473 = eft12    =     951300.00 EUR
   
   
   
6. Post all 12 vouchers through batch process
7. Run Paycycle for all 12 vouchers
8. Run Payment Posting for all 12 vouchers
9. Check the Accounting Notes for all vouchers

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.