AP Prepayment Balances as on previous date

[EMANUEL]

Version R12/11i? = R12
Instance PROD/TEST/VIS? = PROD
Module? = PAYABLES
OS? = N

Hi,
R12 How can I get the Prepayment available balances of Vendors for a back date or back period as the Prepayments Status Report always shows current data?

As suppose my GL Balance in the prepayment account shows **** balance as of 30-Sep-09 the Prepayments Status Report is showing me current date balance and not of 30-Sep-09, I need this for Audit purpose

Rgds
Emanuel

[karthikeyanp1981]

Prepayment Status Report has a parameter From Date and To Date .... you can make use of that to get the data pertaining to a specific period .
If you want data as on date... then enter the From Date as 01-01-1900 and in To date enter your 'As on Date' value, and run the report ..

[EMANUEL]

HI,

I think my requirement is misunderstood

My requirement is that if had a Prepayment available for application Invoice for 10000/- as on 30-Apr-09 and applied on 15-May-09 the prepayment balance as on 30-Apr-09 should show 10000/-

I have tried using the AP Prepayment Balance Report and Prepayments Status Report both reports show the data as PP available if fired before applying of the PP but after applying to Std Invoice on 15-May-09 the reports show nil balance as of 30-Apr-09


Rgds

[karthikeyanp1981]

Hi Emanuel,

i have tried many other reports also ...
Supplier paid history, invoice aging report, ap trial balance, Invoice Register etc .... no such standard report is available to satisfy your requirement.
There are very few reports in payables that have parameters with as on date ... even those reports depict the current status, than reinstating the balances as per the historic as on date...
May be you can create a custom report to display all Prepayment invoices along with applied details, and have the as on data as parameter ... not sure about the possibility of the same.

Regards
karthikeyan

[vanisri_mayya]

Hi,

Right. You should customize the report. Then you will get it as on particular date.