Payment & partial payment agains invoice

[naveedkandohi]

I have created a database with Invoice & Payment issue, but having issue with I If i have recieved a payment which cleared three invoice or cleared some partial how could i manage that

Purchase Bill Table:

1)Invoice Date
3) Supplier
2) Invoice ID
3) Item
4) Rate
5) Amount


CUstomer Bill Table:

1)Invoice Date
3) Customer
2) Invoice ID
3) Item
4) Rate
5) Amount


Payment:

1)Chq Date
2) Party Name
3) Invoice ID (Supplier Table)
4) Amount



Recieve Table:

1)Chq Date
2) Party Name
3) Invoice ID (CustomerTable)
4) Amount

 

[rzw0wr]

I had this problem a few times.
It does take some code to do this.
I started with the oldest invoice, applied all payment to that, any remainder went to the next one and so on until the balance was zero.
The math is not as bad as it first appears.

Dale

 

[naveedkandohi]

Having problem is that i can't pay one cheque to multiple in, the amount just settle on one invoice