A client, in Canada, needs to have some TaxIds grouped together on the printed AR Invoice
I created a subreport to do the calculations & return the calculated total.
This is what the calculation is: =$GST + IIF ( [ARTaxTran.TaxID]='FREIGHT13' OR [ARTaxTran.TaxID]='FREIGHT15' OR [ARTaxTran.TaxID]= 'FREIGHT5' OR [ARTaxTran.TaxID]='GST' OR [ARTaxTran.TaxID]='GSTNOPST' OR [ARTaxTran.TaxID]='HST13' OR [ARTaxTran.TaxID]='HST15', [ARTaxTran.TaxAmt] , 0)
This works perfectly for Invoices.
When a Credit Memo is printed the result returns zero.
I set the subreport up in the site map & ran it & the totals appeared as expected.
I have no idea why the Credit Memo is not returning the results.
Any assistance would be great!
The 2 reports are attached.
Solved
Subreport works for type INV but not CRM
Best answer by wfilipiak67
The solution turned out to be using ARInvoice.DocType.Raw instead of ARInvoice.DocType.
I am not sure why the latter worked for Invoices & not Credit Memos.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.