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

Search found 18 matches

by LisaPD
07 Feb 2022, 13:16
Forum: Sage 50 Report Designer
Topic: Report on Communications
Replies: 4
Views: 20091

Re: Report on Communications

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
by LisaPD
07 Feb 2022, 13:02
Forum: Sage 50 Report Designer
Topic: Report on Communications
Replies: 4
Views: 20091

Re: Report on Communications

Hi Bruce,

That would be great.

Thank you very much for the information.

Kind regards
by LisaPD
07 Feb 2022, 09:23
Forum: Sage 50 Report Designer
Topic: Report on Communications
Replies: 4
Views: 20091

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...
by LisaPD
22 Jan 2021, 11:41
Forum: Sage 50 Report Designer
Topic: Stock Ageing Report
Replies: 3
Views: 6335

Re: Stock Ageing Report

Thanks Bruce.

Unfortunately that report doesn't seem to be very accurate at all.

Not too worry.

Thanks anyway.
by LisaPD
22 Jan 2021, 11:05
Forum: Sage 50 Report Designer
Topic: Stock Ageing Report
Replies: 3
Views: 6335

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
by LisaPD
03 Dec 2020, 12:16
Forum: Sage 50 Report Designer
Topic: Report Designer Page Break
Replies: 21
Views: 18583

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...
by LisaPD
03 Dec 2020, 11:54
Forum: Sage 50 Report Designer
Topic: Report Designer Page Break
Replies: 21
Views: 18583

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.
by LisaPD
03 Dec 2020, 11:51
Forum: Sage 50 Report Designer
Topic: Report Designer Page Break
Replies: 21
Views: 18583

Re: Report Designer Page Break

Yes, that works.

Thanks for your help.
by LisaPD
03 Dec 2020, 11:39
Forum: Sage 50 Report Designer
Topic: Report Designer Page Break
Replies: 21
Views: 18583

Re: Report Designer Page Break

Hi, yes you're right, it does. See attached.
by LisaPD
03 Dec 2020, 11:22
Forum: Sage 50 Report Designer
Topic: Report Designer Page Break
Replies: 21
Views: 18583

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...
by LisaPD
03 Dec 2020, 11:09
Forum: Sage 50 Report Designer
Topic: Report Designer Page Break
Replies: 21
Views: 18583

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.
by LisaPD
03 Dec 2020, 10:54
Forum: Sage 50 Report Designer
Topic: Report Designer Page Break
Replies: 21
Views: 18583

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.
by LisaPD
03 Dec 2020, 10:39
Forum: Sage 50 Report Designer
Topic: Report Designer Page Break
Replies: 21
Views: 18583

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
by LisaPD
27 Nov 2020, 10:43
Forum: Sage 50 Report Designer
Topic: Report Designer Page Break
Replies: 21
Views: 18583

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...
by LisaPD
25 Nov 2020, 15:59
Forum: Sage 50 Report Designer
Topic: Report Designer Page Break
Replies: 21
Views: 18583

Re: Report Designer Page Break

How would I do this then?