EAP: Voucher Build Recycle Error " Decimal Precision for Payments Record Amount Fields Does Not Match Currency Setting" When Processing Foreign Currency Transactions With Decimal Amounts. (Doc ID 2985406.1)

Last updated on NOVEMBER 16, 2023

Applies to:

Symptoms

An accounts payable business unit has a base currency as JPY( the currency setting has 0 decimal values), for this business unit the invoice information is stagged into voucher staging tables.

These invoices include the transactions that have a transaction amount in USD and with 2 decimals also the transaction in JPY currency.

When these invoices are processed through voucher together with other accounts payable business unit as given below example, one of these vouchers are placed in recycle status with the following error:

ERROR Message
(7220, 32) - Decimal precision for payments record amount fields does not match currency setting.
 

For example the following data is in the staging tables, the supplier is same for all these transactions:

Data 1 : BU: JPN01 (Base Currency JPY) ,Transaction Currency: USD , Gross Amount : Decimal number.
Data 2 : BU: JPN01 (Base Currency JPY) ,Transaction Currency: USD , Gross Amount : Whole number.
Data 3 : BU: US001 (Base currency  USD) ,Transaction Currency: JPY [Bank and currency defined under Supplier Payment setup is Japan Bank and JPY currency] , Gross Amount : Whole number.

Steps to replicate
1. Load invoice information into voucher staging tables.

2. Run voucher build process( for all applicable business units).
     Menu > Accounts Payable > Batch processes > Vouchers > Voucher Build.

3. Review the errors on the vouchers created.
      Menu > accounts Payable > Vouchers > Add/Update > Regular Entry( Search for the vouchers ) > Go to Error summary tab.

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.