Invoice number in full statement
Posted: 13 Apr 2021, 14:39
Hi.
I've been trying to get the invoice number to show on a full statement next to a sales receipt entry.
On the Day Books Customer Receipt (Detailed) report, receipts are shown with the invoice number they are allocated to to the left, which uses AUDIT_USAGE.REFERENCE
I want to add something like this to my statement but can't work out what join I need to make. (I can get the transaction number but I want the actual invoice number.)
AUDIT_HEADER.TYPE = "SR" ? AUDIT_USAGE.REFERENCE + AUDIT_HEADER.DETAILS : AUDIT_HEADER.DETAILS
Is it even possible? What fields do I join to make it work? Anything I've tried just leaves the report stuck processing at '4 of 6'.
Thanks in advance,
Annie
Sage v 26.3.245.0
Windows 10 Pro (64)
Report Designer v 4.0.179.0
I've been trying to get the invoice number to show on a full statement next to a sales receipt entry.
On the Day Books Customer Receipt (Detailed) report, receipts are shown with the invoice number they are allocated to to the left, which uses AUDIT_USAGE.REFERENCE
I want to add something like this to my statement but can't work out what join I need to make. (I can get the transaction number but I want the actual invoice number.)
AUDIT_HEADER.TYPE = "SR" ? AUDIT_USAGE.REFERENCE + AUDIT_HEADER.DETAILS : AUDIT_HEADER.DETAILS
Is it even possible? What fields do I join to make it work? Anything I've tried just leaves the report stuck processing at '4 of 6'.
Thanks in advance,
Annie
Sage v 26.3.245.0
Windows 10 Pro (64)
Report Designer v 4.0.179.0