Different MERCH_AMT_BSE Values on RECV_LN_SHIP And RECV_LN_DISTRIB
Last updated on JULY 17, 2017
Applies to:PeopleSoft Enterprise SCM eProcurement - Version 9.2 and later
Information in this document applies to any platform.
When a Purchase Order has a different Currency than the base currency it produces different merchandise amount when a Receipt is created causing tables RECV_LN_SHIP and RECV_LN_DISTRIB to have data discrepancies on prices.
Steps to reproduce the issue:
1. Created a PO with Different base amount and Merchandise amount.
2. Make sure that the exchange rate has decimal.
3. Dispatch the PO
4. Change the exchange rate
5. create receipt.
6. Query the Tables RECV_LN_SHIP and RECV_LN_DISTRIB and check for the ff. fields (Merchandise Amount Base,Merchandise Amt PO Base)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms