Page 1 of 1

Invoice number in full statement

Posted: 13 Apr 2021, 14:39
by AnnieW
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

Re: Invoice number in full statement

Posted: 13 Apr 2021, 14:50
by brucedenney
The issue is that you are trying to link things that are not that simply linked, the Receipts could pay, 2 invoices and a credit note, so which would it show?

The answer would need to be all of them, so you would show a receipts and then the 2/4 things that it matched against. The invoice would need to show the potentially multiple payments that paid it and so on.

You could do that but it would be confusing as anything.

Re: Invoice number in full statement

Posted: 13 Apr 2021, 15:28
by AnnieW
Hmmm, I didn't think about it that way. More thought needed. It's only for two customers so I may just include a report with their statements.

Thanks Bruce.