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
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 7 matches
- 20 Aug 2020, 17:08
- Forum: Sage 50 Report Designer
- Topic: Splitting text
- Replies: 3
- Views: 6909
- 20 Aug 2020, 10:05
- Forum: Sage 50 Report Designer
- Topic: Splitting text
- Replies: 3
- Views: 6909
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...
- 15 Dec 2016, 20:25
- Forum: Sage 50 Report Designer
- Topic: Label location customer/invoices
- Replies: 3
- Views: 3102
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...
- 15 Dec 2016, 15:15
- Forum: Sage 50 Report Designer
- Topic: Label location customer/invoices
- Replies: 3
- Views: 3102
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...
- 14 Dec 2016, 21:02
- Forum: Sage 50 Report Designer
- Topic: Printer driver settings.
- Replies: 4
- Views: 3338
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.
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.
- 14 Dec 2016, 17:20
- Forum: Sage 50 Report Designer
- Topic: Printer driver settings.
- Replies: 4
- Views: 3338
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...
- 14 Dec 2016, 15:46
- Forum: Sage 50 Report Designer
- Topic: Printer driver settings.
- Replies: 4
- Views: 3338
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 ...