AGED CREDITOR REPORTS IN DISCOVERER
444724Nov 9 2005 — edited Sep 14 2006Hi...
The standard aged creditor reports in Oracle - summary and detail can only be run at this moment in time, for example, I can not do a report for outstanding creditors as at period 6 in say period 7.
The aged debtor report lets the user enter an as at of date so not sure why the creditor report does not work in the same way.
I have tried to create a discoverer report to overcome this but I am struggling with the date parameter. For example, If I run the report upto date of 31-Oct-2005 today (9-Nov-2005), what happens is that any invoices paid between 1 and 8 Nov are not showing showing as outstanding creditors as at 31-Oct-2005.
I would really appreciate some advice on what date parameter should be used to pick up outstanding creditors as at of a date entered.
Thanks.