AP Invoice Aging Report [message #172850] |
Thu, 18 May 2006 06:06 |
ramakrishna.y
Messages: 1 Registered: May 2006 Location: Chennai
|
Junior Member |
|
|
the standard AP INvoice Aging report we dont have date as the parameter
so it gives us all invoices which are due from the report run date and puts them in appropriate aging period
but our requirement is that it should pick the invoices on which ever date we mention and not as per the system date that
is the report run date(as in the standard report).
is it clear to u
Requirement:
On the specified date the report should pick up all open invoices , ie any liabiity as of the date mentioned
EG. Invoice 1
Invoice Date 01-03-06
Payment Date 01-08-06
Invoice 2
Invoice date 01-05-06
Not Paid
If the report is run as of date ...Invoice 2 should be picked up and Invoce 1 should not (Working)
If the report is run as of 01-09-06 Invoice 2 should be picked up and Invoice 1 should not (Working)
If the report is run as of 01-06-05 both Invoice 1 and Invoice 2 should be picked up , but only Invoice 2 is being picked
since that is the only one with outsatnding balance as of today.---- THIS NEED TO BE FIXED --- Invoice 1 was open as of the
6th of Jan so it should show up in the report.
|
|
|