Author: websyd | Posted on: 5/11/2009 3:11:05 AM | Views : 235

Hi,
Please i have written an e-Commerce application that includes features such as Invoicing, Inventry, CashPayments etc.
Now i need to prepare a statement of account for each customer.
Below are details of the Tables related to the Customer

CustomerTable :
CustomerID,FirstName,LastName........

InvoiceTable
InvoiceID,CustomerID,InvoiceDate........

InvoiceDetailsTable
InvoiceID,ProductID,Quantity,Price.......

Reciepts
RecieptsID,CustomerID,Amount..........

Invoice & InvoiceDetails Tables are related through InvoiceID. My problem now is how to generate a statement for each customer.

Please help out.
...

Go to the complete details ...