Adding Transaction Number to Invoice Template
Posted: 03 Jul 2018, 09:33
Hi all,
Hoping for some guidance and any guidance would be much appreciated.
I need to add transaction number to a new invoice template as we tend to use this more than the invoice number, but i am struggling to do so. Having found transaction number in a report i can see it is labelled audit_header.tran_number, however i don't seem to be able to pick this from within my invoice template.
I am assuming this is due their being no join to the audit_header table when i click on 'joins', having played about trying to add one using the graphical editor and the raw editor i seem to be struggling.
Is there an easy way of adding this join to let me add the transaction number?
Thanks!
Hoping for some guidance and any guidance would be much appreciated.
I need to add transaction number to a new invoice template as we tend to use this more than the invoice number, but i am struggling to do so. Having found transaction number in a report i can see it is labelled audit_header.tran_number, however i don't seem to be able to pick this from within my invoice template.
I am assuming this is due their being no join to the audit_header table when i click on 'joins', having played about trying to add one using the graphical editor and the raw editor i seem to be struggling.
Is there an easy way of adding this join to let me add the transaction number?
Thanks!