Hi Bruce,
Is it possible to have what is typed in the Memo section added onto the report?
I can only see the 'Notes' box as an option on the variables, but the idea of the report is so we can see who was contacted and what was said.
Thanks
Lisa
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
Search found 18 matches
- 07 Feb 2022, 13:16
- Forum: Sage 50 Report Designer
- Topic: Report on Communications
- Replies: 4
- Views: 21169
- 07 Feb 2022, 13:02
- Forum: Sage 50 Report Designer
- Topic: Report on Communications
- Replies: 4
- Views: 21169
Re: Report on Communications
Hi Bruce,
That would be great.
Thank you very much for the information.
Kind regards
That would be great.
Thank you very much for the information.
Kind regards
- 07 Feb 2022, 09:23
- Forum: Sage 50 Report Designer
- Topic: Report on Communications
- Replies: 4
- Views: 21169
Report on Communications
Hi, I am looking for a standard Report Template for the 'Communications' section within the Customer and Supplier Records. It would be nice to be able to run a report that can be sent to excel, which shows all the communications within a date range, for all the customers and again for all the suppli...
- 22 Jan 2021, 11:41
- Forum: Sage 50 Report Designer
- Topic: Stock Ageing Report
- Replies: 3
- Views: 6706
Re: Stock Ageing Report
Thanks Bruce.
Unfortunately that report doesn't seem to be very accurate at all.
Not too worry.
Thanks anyway.
Unfortunately that report doesn't seem to be very accurate at all.
Not too worry.
Thanks anyway.
- 22 Jan 2021, 11:05
- Forum: Sage 50 Report Designer
- Topic: Stock Ageing Report
- Replies: 3
- Views: 6706
Stock Ageing Report
Hi,
I just wondered if there was a Stock Ageing Report available in Sage 50? It's just something that our accountant auditors are requesting for Year End.
Thanks
I just wondered if there was a Stock Ageing Report available in Sage 50? It's just something that our accountant auditors are requesting for Year End.
Thanks
- 03 Dec 2020, 12:16
- Forum: Sage 50 Report Designer
- Topic: Report Designer Page Break
- Replies: 21
- Views: 19588
Re: Report Designer Page Break
I set the report earlier at Substring(STOCK.LOCATION, 0, 1), that is the only way I could get it to work. If I set it at Substring(STOCK.LOCATION, 0, 2), it page breaks between (A1, A11, A12 etc) and (A2....) If I set it at Substring(STOCK.LOCATION, 0, 3), it messes the page break up completely. Yes...
- 03 Dec 2020, 11:54
- Forum: Sage 50 Report Designer
- Topic: Report Designer Page Break
- Replies: 21
- Views: 19588
Re: Report Designer Page Break
They are to a certain degree in order, but it goes from (ie.) A39 to A4 and then A40. But I can live with that.
- 03 Dec 2020, 11:51
- Forum: Sage 50 Report Designer
- Topic: Report Designer Page Break
- Replies: 21
- Views: 19588
Re: Report Designer Page Break
Yes, that works.
Thanks for your help.
Thanks for your help.
- 03 Dec 2020, 11:39
- Forum: Sage 50 Report Designer
- Topic: Report Designer Page Break
- Replies: 21
- Views: 19588
Re: Report Designer Page Break
Hi, yes you're right, it does. See attached.
- 03 Dec 2020, 11:22
- Forum: Sage 50 Report Designer
- Topic: Report Designer Page Break
- Replies: 21
- Views: 19588
Re: Report Designer Page Break
It definitely needs the 'Substring' line above the 'location' line on mine, otherwise it doesn't page break properly at all. If I can't get it to run alphabetically properly, I can live with that. At least it seems to be keeping the groups together and page breaking properly now; so thank you for al...
- 03 Dec 2020, 11:09
- Forum: Sage 50 Report Designer
- Topic: Report Designer Page Break
- Replies: 21
- Views: 19588
Re: Report Designer Page Break
O'h, I might have just done it, by just changing the Substring to '0.1', instead of '0.3'!
Is there a way of getting the locations to run in alphabetical order properly. At the moment, it runs say 'A4, A40, A41, A42, A5, A51' etc., rather that 'A1, A2, A3' etc.
Is there a way of getting the locations to run in alphabetical order properly. At the moment, it runs say 'A4, A40, A41, A42, A5, A51' etc., rather that 'A1, A2, A3' etc.
- 03 Dec 2020, 10:54
- Forum: Sage 50 Report Designer
- Topic: Report Designer Page Break
- Replies: 21
- Views: 19588
Re: Report Designer Page Break
No, it is still page breaking at every different 'location'. ie. A10 (page break), A11 (page break) etc. So it's not keeping all the 'A's' together.
- 03 Dec 2020, 10:39
- Forum: Sage 50 Report Designer
- Topic: Report Designer Page Break
- Replies: 21
- Views: 19588
Re: Report Designer Page Break
Hi,
That would be great if you could review what I have done so far - see attachment.
I must be doing something wrong. The report does run, but it doesn't seem to be working correctly with the location page breaks.
I look forward to hearing from you.
Many thanks
Lisa
That would be great if you could review what I have done so far - see attachment.
I must be doing something wrong. The report does run, but it doesn't seem to be working correctly with the location page breaks.
I look forward to hearing from you.
Many thanks
Lisa
- 27 Nov 2020, 10:43
- Forum: Sage 50 Report Designer
- Topic: Report Designer Page Break
- Replies: 21
- Views: 19588
Re: Report Designer Page Break
Hi, Thank you for your response. I tried this, but unfortunately it doesn't seem to work. Our location names can go up to 16 characters and can look like this (examples): 'A1' or 'A13-A19-A25-A31' or 'A34-D6/D' or 'B1' or 'B1/B-B1/BB' or 'B5/B-B5/BB' Right up to: 'Z1' etc. I am trying to run a repor...
- 25 Nov 2020, 15:59
- Forum: Sage 50 Report Designer
- Topic: Report Designer Page Break
- Replies: 21
- Views: 19588
Re: Report Designer Page Break
How would I do this then?