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 ...