The forums ran from 2008-2020 and are now closed and viewable here as an archive.

Home Forums Back End sql table info needed Reply To: sql table info needed


Actually it is a bit typical and that’s why there is a balance entry.
its something like this:
1 there can be multiple plans per customer
2 he is allowed at times to do a partial payment
3 in case of partial payment i need to store date of both payments
4 customer may pay any amount in advance
5 i have to then check for advance payments and do automatic entries in bulk
6 money is only coming in not going out, hence cant really be negative
7 i have been working on “blank/no entry” means “balance” concept up till now but i need to store every months payable amount in database and calculate amount for each month accordingly
8 i have to mostly stick to the current database until i make a new software which will need time

it can be confusing, even i get confused so tell me something if you understand something