Invoicing Problem

[heinc1]

Wow! Works like a charm.
Thanks so much!

 

[pbaldy]

Happy to help!

 

[slogie]

Hi Guys, me again. I did get the cash invoice to work but now after a while of not working on the program, I am trying to create a credit invoice in much the same way as I did the cash invoice putting in the code for the combo box, but the previous records still change after I update the records. Also, Is there a way to see the table from which I took the fields to create the cash invoice form. Thanks

 

[Simon_MT]

You should be creating New Records and tag them with Invoice or Credit. How treat the Credit transactions (negative values) is up to you. I store them as positive values and in Invoice Type Table have a field: 1 for Invoice and -1 for Credit Note and then multiply the transaction values to get the correct values for reporting.

Simon