Home » Developer & Programmer » Reports & Discoverer » AP Invoice Aging Report
icon14.gif  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.


Previous Topic: viewing reports in Discoverer
Next Topic: Reports
Goto Forum:
  


Current Time: Tue Nov 26 12:23:30 CST 2024