You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Is there an accounted equivalent to AMOUNT_DUE_ORIGINAL field of AR_PAYMENT_SCHEDULES_ALL table?

Accepted answer
edited Jul 26, 2023 8:41AM in Receivables & Collections 1 comment


We need a field that captures the accounted amount equivalent of the AMOUNT_DUE_ORIGINAL field from AR_PAYMENT_SCHEDULES_ALL table.

Content (required):


We have a customer AR Aging report where in we get all the AR transactions which has outstanding amount as of the date parameter entered. Currently, we use the below computation to get the accounted amount:

Accounted Invoice amount = AMOUNT_DUE_ORIGINAL * EXCHANGE_RATE

This however is not accurate when we use the amount to compute for the Outstanding invoice amount. There are discrepancies in the decimal values. Part of our solution is to use the AMOUNT_DUE_REMAINING field for the Outstanding amount. But it is only applicable if the invoice is still really outstanding. If we run the report for a past date, and we get an invoice that was outstanding on that date, the outstanding amount will be zero. This is why we still need to use the computation.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!