Invoices and payments database

[cutykamu]

i'm trying to create a database for my small business.

 

 there are 3 tables in this database for now.

invoices

payments

invoices_payments (join table)

 

i have created a relation between them through a join table and it is working nicely till here. 

now what i want to add is a new table for customers and allocate the payments manually as some of my customers send the payments together for few invoices and it might not be final amount so how shall i allocate this amount? for example if payment received from a customer for 3 invoices together then i will mention the amount received only once and there will be a portal showing the pending invoices where i can allocate the payment by hand for each invoice and the balance should keep deducting from the money received table.

 

any help would be appreciated.

 

thanks

kumar

[Ocean West]

kumar,

 

here is an ERD model that may accommodate the type of multiple payments and allocation you need. 

 

http://www.databaseanswers.org/data_models/invoices_and_payments/index.htm

[cutykamu]

i'm trying to understand this but i think it will take some time for me to go through.

i will keep trying. 

 

thanks ocean.