Hi,
is there a way to only bring the total amount of tax on an invoice through in a baq, instead of it line by line.
as you can see below it’s doing it line by line.
What information do you want to display in the BAQ besides Invoice Num and Total Tax for the Invoice?
Check the group by box on InvcHead field, and add a calculated field
sum( InvcDtl.TotalTaxAmount ) (field name might be wrong)