M
Muriukis
I have this program that am testing. I have three tables
1. tblSales with these fields(SaleID,SaleDate,SalesPerson)
2. tblSalesDetails with the fields(ProductID,SalePrice,QtySold)
3. Payments (PaymentID,PaymentMode,SaleId,)
I have used these tables to generate a pos interface which the user uses to
input sales and generate a receipt which is working very well.
But now I need to include invoices because previously we were not using
invoices but now we do.How do I go about it .
The normal receipting will continue but now customers can either pay cash or
we give an invoice.My biggest handle is when the customer pays how do I tally
the information any help?
1. tblSales with these fields(SaleID,SaleDate,SalesPerson)
2. tblSalesDetails with the fields(ProductID,SalePrice,QtySold)
3. Payments (PaymentID,PaymentMode,SaleId,)
I have used these tables to generate a pos interface which the user uses to
input sales and generate a receipt which is working very well.
But now I need to include invoices because previously we were not using
invoices but now we do.How do I go about it .
The normal receipting will continue but now customers can either pay cash or
we give an invoice.My biggest handle is when the customer pays how do I tally
the information any help?