Hi everyone,
A big call for help, if you know a good answer :), as I have spent many days on this to no avail. My guess is that the answer is a lot simpler than what I have been doing.
I am building an invoices module, and currently it’s shaping up handsomely. A user can add items, right descriptions, choose qty/rate, etc. In another module, the user can build and edit taxes. Now in the invoicing module, a user can choose GST for 2 items, PST for 3 and No Tax for 1. How can I make this work in such a way that we only see GST (totals), PST (totals) and the No tax at $0? I’m not referring to the display only method as I can use :group by, but I want all records to register in the database so that I can retrieve, generate PDF, audit, yada yada.
Thanks in advance.
Khalid