Tax Line Items on Invoice
Looking to get the tax breakdown onto our invoice template (alas). Currently I've looked in a LOT of tables for the information that is plainly displayed on the invoice screen. If anyone has figured out how to display not just the tax total, but also each line item I would be grateful for an explanation.
I have found the correct table to reference:
But am still having issues generating a section that will give me a tax summary of each tax being charged. Doing a generic inquiry I can link the ARInvoice table to the ARTaxTran table (and also on the report), but don't know what to do for looping over each item to display for my report. Should I just have a new section? Footer? Any tips would be much appreciated.
A Subreport would probably work well here. Since there could be multiple Tax lines for an Invoice, if you include ARTaxTran in a Join, then it will duplicate your Invoice data.
Ok thanks Tim. I'll give that a shot and let you know if it worked.
Tim! This 100% worked.
Thank you so much for the help. I've attached the basic sub-report. Keeping in mind that I will definitely be doing a bunch of formatting to match my corporate standards as you should as well. This will at least point you in the right direction.