AP -Prepayment -How to get the balance details
Hi
Our Version is :R12.1.3
In AP - a prepayment invoice is generated and paid for 1000 $ to supplier X. (table is -AP_Invoices_all)
There are many such payments against many suppliers available in AP.
And..
- Payment is not linked any invoices.
- Transferred to GL
- In GL Trial Balance such balance is shows under 'Advance to Supplier' -say 25000$
Now we need to know - supplier wise balance for this 25000$.
Is there any standard report available in GL or can someone refer the document which provides table link./Queries.
Thanks