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.
Best answer by wfilipiak67
View original