Skip to Content
Apr 04, 2012 at 05:02 AM

Query on invoice against incoming payments


Hi Experts

I need a query for invoice done against incoming payments nothing but outstanding

I need all invoice which are pending as on particular date .

For Example: I have done invoice on 2012/02/05 (i.e 5th feb 2012) And i have done incoming payment against this invoice on 2012/03/05

(i.e 5th Mar 2012) .

So now if take outstanding report for 2012/02/29 (i.e 29th feb 2012) that invoice has to show in my report as pending.

i need this query very urgently please do the needful .

Thanks & Regards