Hi Kevin,

When youâ€re in the Supplier Activity window there are two boxes (if you can only see one, select the Show Details button at the bottom right of that window).

The top box shows the Header transaction – every transaction has one header. The Header transaction holds information including the account reference, total net, total VAT, any exchange rate used and foreign values.

The Extra Ref field is held at the Split level of the transaction - every transaction has at least one split, but can consist of multiple splits if it is a grouped transaction.

A grouped transaction is created by entering multiple lines with the same reference and date. Each split holds information including a nominal code, net value, VAT value and any foreign values.

If you add a variable to a report that contains Header-type variables (e.g. AUDIT_HEADER.DETAILS) that comes from the SPLIT table, (in this instance AUDIT_SPLIT.EXTRA_REF), the mixture of variable types creates duplication.

The workaround for this is to amend all the variables on the report to be AUDIT_SPLIT. This will give a more detailed report but the duplication will stop.