Hi Joe,

Thanks for using Sage City.

The join you would need to do this would be AUDIT_HEADER.INV_REF_NUMERIC to INVOICE.INVOICE_NUMBER

It needs to be set to parent outter

This join only works if you update the audit trail with the invoice numbers rather than order numbers.

If this has answered your question please click More > Verify Answer.

Ian

Hi Joe,

Thanks for using Sage City.

The join you would need to do this would be AUDIT_HEADER.INV_REF_NUMERIC to INVOICE.INVOICE_NUMBER

It needs to be set to parent outter

This join only works if you update the audit trail with the invoice numbers rather than order numbers.

If this has answered your question please click More > Verify Answer.

Ian

Hi Ian, 

When I flip the join around like your answer it comes up as no data found so that doesn't work. I've checked and the ref does get updated with the invoice number

Thanks

Hi Joe,

That information comes from our Joins article which shows how to do joins in Report Designer.

Report Designer - Common data joins for Sage Accounts

Could you try editing a standard statement and see if it works?

Also if this condition isn't met it won't work regardless of the join - This join only works if you update the audit trail with the invoice numbers rather than order numbers.

If you had to turn it on it'll only show invoices going forward rather than ones from the past.

Ian