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
Invoice number in full statement
- brucedenney
- Site Admin
- Posts: 4631
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Invoice number in full statement
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.
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.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Re: Invoice number in full statement
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.
Thanks Bruce.
Who is online
Users browsing this forum: No registered users and 2 guests