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 7 matches

Go to advanced search

by tomvassie
20 Aug 2020, 17:08
Forum: Sage 50 Report Designer
Topic: Splitting text
Replies: 3
Views: 6819

Re: Splitting text

Hi Bruce,
Thank you, that’s absolutely brilliant.
I have been trying to workout substring all day but haven’t succeeded... will try later.

Is there any documentation regarding the operators and exactly to use them??

Thanks again
by tomvassie
20 Aug 2020, 10:05
Forum: Sage 50 Report Designer
Topic: Splitting text
Replies: 3
Views: 6819

Splitting text

Hello all, I use the line information(JobNumber) field to record some information on an invoice, The numbers could be as follow 1-1-1 ~ 1 up to 14-10-99 ~ 3000 Is there a way in the report to split these at the ~ and remove the ~ Leaving me with two parts to the JobNumber field on the report? Thanks...
by tomvassie
15 Dec 2016, 20:25
Forum: Sage 50 Report Designer
Topic: Label location customer/invoices
Replies: 3
Views: 3083

Re: Label location customer/invoices

Hard work never killed anyone! That would be a great idea if we were chucking out hundreds of invoices a week I guess! But we don't so printing a few envelopes is quicker than writing them. I thought that might be the case with this one, on the plus side of things we only use one size of envelope so...
by tomvassie
15 Dec 2016, 15:15
Forum: Sage 50 Report Designer
Topic: Label location customer/invoices
Replies: 3
Views: 3083

Label location customer/invoices

Hi, I have another little problem... I have a changed a couple of label reports under customer labels to use for printing envelopes, they work great, I can select the customers I want and hit lablels, pick the one I want and they print. I would like to add the same label report into the label option...
by tomvassie
14 Dec 2016, 21:02
Forum: Sage 50 Report Designer
Topic: Printer driver settings.
Replies: 4
Views: 3313

Re: Printer driver settings.

Ahh yes!
I think I have changed this, I'll have a read through your post and see what I've changed in the morning!

Thanks for your help and great forum. Great to see people willing to help even when it may be something obvious to everyone else!
Cheers Tom.
by tomvassie
14 Dec 2016, 17:20
Forum: Sage 50 Report Designer
Topic: Printer driver settings.
Replies: 4
Views: 3313

Re: Printer driver settings.

Thanks for a quick reply, That's a bit of a pain! I thought that would be case though. One other little problem I have is this: When I use the email invoice option (not the one in the print list) to attach multiple invoices to emails (all different customers) my report pdfs all the invoice as one an...
by tomvassie
14 Dec 2016, 15:46
Forum: Sage 50 Report Designer
Topic: Printer driver settings.
Replies: 4
Views: 3313

Printer driver settings.

Hi Everyone, I'm fairly new to Sage and the report designer but it's going well so far! I have a slight issue that's bugging me. In report designer, I have my own invoice (modified the A4 inv/crd Discount - Plain Paper) In Page Setup/Printer I can change the paper source, weight and size and when I ...

Go to advanced search