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
