Total Pageviews

March 24, 2017

3/24/2017 11:06:00 AM

 Payables Prepayment Status report
Oracle Payables -Prepayment Status Report

Is there any standard Report in Payable where to get the balance of Prepaid Account that is used in invoice distribution for the deferred option enabled invoices?


There is a report called Prepayment Status Report.


Common issues:

Available Prepayment is not appearing in the Prepayment Status Report output

Solution:

Conditions to be considered for prepayment invoice to appear in the prepayment status report output
  • Prepayment invoice  should not be fully applied to any invoice
  • Check whether prepay_amount_remaning is populated with correct amount ,if it is not applied to any invoice then the prepay amount should be same as the invoice amount
  • If the Tax is applicable ,Check whether prepay_amount_remaning is correctly populated for the tax lines of the prepayment 
  • Check whether reversal_flag is correctly populated for the reversed lines