adding Deposit to invoice
i do a lot of 2 job trips, i added a deposit field which is located in the invoices table. i often go to a house, collect a deposit and then go back and collect the rest, so the second invoice needs to reflect the deposit they paid and minus it off their total.
so what would be the best way to do this, i still don't understand the summary fields much although i used them in lines a few times. do i need a summary field here? is the deposit field even suppose to be in Invoices rather then lines?
just to clarify, this is how i did it, we can see if i was on the right track….i made a field in lines called total_balance and made it a calculation field that took my total_invoice and subtracted the deposit from it…then i put the total_balance from lines on the print report layout…i mean it seems straight forward but i just want to make sure i don't have to do a major over haul like I've been through once already lol…slow and steady.
thanks in advance !