Is there an accounted equivalent to AMOUNT_DUE_ORIGINAL field of AR_PAYMENT_SCHEDULES_ALL table?
We need a field that captures the accounted amount equivalent of the AMOUNT_DUE_ORIGINAL field from AR_PAYMENT_SCHEDULES_ALL table.
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.