php - INVOICE NO DATE NAME TOTAL BALANCE STATUS

[nithi_30]

Customer purchased an items in different dates(eg: 12/7/2009 , 14/7/2009 ,22/7/2009 ,30/7/2009 ) (Cost may vary eg: 400,500,100 etc...)

If he pays 500 Rs/- then from the total amount of 1000 Rs/-[(ie) 400+500+100]. The 1st invoice amount's balance should be zero. And 2nd invoice amount's balance should be 400 [(ie) 500-100]

INVOICE NO DATE NAME TOTAL BALANCE STATUS

1 10/Jul/2009 Rekha 5780 5780 PENDING
2 10/Jul/2009 Rekha 109500 109500 PENDING
3 10/Jul/2009 Rekha 6750 6750 PENDING
4 14/Jul/2009 Rekha 6900 6900 PENDING
5 14/Jul/2009 Smita 3964 3964 PENDING
6 14/Jul/2009 Smita 10440 10440 PENDING
7 14/Jul/2009 Smita 254070 254070 PENDING
8 22/Jul/2009 Smita 8001140 8001140 PENDING


If u understood my question pl z reply to my query

[maneetpuri]

Hi,

I think I have understood your question, what you have to do is create a database of customers and another database of invoices, for each invoice there will be a customer ID and when any of the invoice is paid you can change its status to paid and then while totaling you can just include the invoices where the status is not paid.

Hope this make sense to you.

Cheers,