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