www.webdeveloper.com
Results 1 to 2 of 2

Thread: php - INVOICE NO DATE NAME TOTAL BALANCE STATUS

  1. #1
    Join Date
    Apr 2009
    Location
    Petersburg, NY
    Posts
    59

    Arrow php - INVOICE NO DATE NAME TOTAL BALANCE STATUS

    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

  2. #2
    Join Date
    Jul 2007
    Posts
    58
    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,
    Maneet Puri

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles