P
Peter AL
Guest
Can anybody help
I have constructed a database that is primarily for stock tracking, invoices and customer details.
On one of my forms I have the facility to record when a customer pays for something and then comes back over a period of time to pay part payment. Each Invoice then can have a number of records for part payments. This I have successfully created. However when I want to run a report to show the total paid and the total outstanding it all goes wrong.
The invoice amount of say £100.00 is ok and then for every part payment say £10.00 the query will Deduct £10.00 from £100.00 however on the next transaction of say payment of 20.00 the query that I have created Ddt 20 from £100.00 rather than £90.00. When I group the items for a report it records each record. Therefore invoice total = £200.00 and rather than £100.00
I have created a Table for invoice payment with the following fields, ID;
amount;payment date.
Does any one have any ideas. I can provide more information if necessary . Thanks.
I have constructed a database that is primarily for stock tracking, invoices and customer details.
On one of my forms I have the facility to record when a customer pays for something and then comes back over a period of time to pay part payment. Each Invoice then can have a number of records for part payments. This I have successfully created. However when I want to run a report to show the total paid and the total outstanding it all goes wrong.
The invoice amount of say £100.00 is ok and then for every part payment say £10.00 the query will Deduct £10.00 from £100.00 however on the next transaction of say payment of 20.00 the query that I have created Ddt 20 from £100.00 rather than £90.00. When I group the items for a report it records each record. Therefore invoice total = £200.00 and rather than £100.00
I have created a Table for invoice payment with the following fields, ID;
amount;payment date.
Does any one have any ideas. I can provide more information if necessary . Thanks.
