Supply Chain Management - PSFT (MOSC)

MOSC Banner

MONETARY AND FOREIGN AMOUNT VARIANCE IN PS_RECV_LN_ACCTG

edited Aug 27, 2020 11:35AM in Supply Chain Management - PSFT (MOSC) 7 commentsAnswered

Hi there,

We have an issue where the PO receipt accrual generates transaction lines that do not balance. We've traced to the MONETARY and FOREIGN AMOUNT not being the same even though we use one currency USD.Rate 1, CURRT, We've tried to replicate the issue but cannot - it appears to occur randomly. We prefer not to fix with SQL - but perhaps are we missing something in config? or  processing?

SELECT * FROM PS_RECV_LN_ACCTG WHERE FOREIGN_CURRENCY = CURRENCY_CD AND FOREIGN_AMOUNT <> MONETARY_AMOUNT

Any help will be greatly appreciated

Thanks

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center