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 48 matches
- 15 Feb 2018, 12:14
- Forum: Sage 50 Report Designer
- Topic: Pick Lists How can i omit Non-Stock items from showing
- Replies: 4
- Views: 4047
Pick Lists How can i omit Non-Stock items from showing
Hi Bruce, I'm looking to see if i can omit Non-Stock items from appearing on the Sales Order Picking List and just show the inventory Stock items we need to pick. I've tried to set up a conditional format filter to look at LOCATION, which we use for bin locations, and in my head i want the filter to...
- 15 Feb 2018, 11:40
- Forum: Sage 50 Report Designer
- Topic: Could not load file o
- Replies: 8
- Views: 4847
Re: Could not load file o
Hi Bruce, thought i would just update with how the issue was resolved. Several reinstallations of sage, with updates,didn't work. We reinstalled the .NET framework, along with sage - didn't work So, my PC was basically backed up, wiped and rebuilt (extreme) worked. Straight after taking delivery of ...
- 12 Feb 2018, 12:33
- Forum: Sage 50 Report Designer
- Topic: Expression to pull alternate Supplier Part nos
- Replies: 2
- Views: 3077
Re: Expression to pull alternate Supplier Part nos
Think i worked out the logic PURCHASE_ORDER.ACCOUNT_REF = STOCK.WEB_CATEGORY_2 ? STOCK.WEB_CATEGORY_3 : POP_ITEM.COMMENT_1 = "" ? STOCK.SUPPLIER_PART_NUMBER : POP_ITEM.COMMENT_1 So, because the 1st Alternate Supplier (Web Category fields) could be blank or filled with information, then the...
- 12 Feb 2018, 11:30
- Forum: Sage 50 Report Designer
- Topic: Expression to pull alternate Supplier Part nos
- Replies: 2
- Views: 3077
Re: Expression to pull alternate Supplier Part nos
Just a little update - that expression seems to be working, but i'm getting mixed results on orders where the primary supplier and part number are being ordered, on some test orders for stock items, the correct part is showing, and then on another stock item it isnt (?) the only real difference i ca...
- 12 Feb 2018, 08:17
- Forum: Sage 50 Report Designer
- Topic: Expression to pull alternate Supplier Part nos
- Replies: 2
- Views: 3077
Expression to pull alternate Supplier Part nos
<r>Hi Bruce, <br/> <br/> I've just been reading this post from a while back<br/> <URL url="https://forum.makingithappen.co.uk/viewtopic.php?f=14&t=3073&hilit=ALTERNATE+SUPPLIER"><LINK_TEXT text="viewtopic.php?f=14&t=3073&hilit=ALTERNATE+SUPPLIER">https://forum.mak...
- 05 Feb 2018, 12:43
- Forum: Sage 50 Report Designer
- Topic: Removing Time stamp from Email Filenames
- Replies: 4
- Views: 3508
Re: Removing Time stamp from Email Filenames
Think i'm on the right track now "DN-" + GDN_ITEM.GDN_NUMBER + "-" + SALES_ORDER.NAME + "-" + DateTimeToFormattedString(GDN_ITEM.DATE, "ddMMyy") has gotten rid of the time portion, the separators came out a little differently so " /" were replaced wi...
- 05 Feb 2018, 12:19
- Forum: Sage 50 Report Designer
- Topic: Removing Time stamp from Email Filenames
- Replies: 4
- Views: 3508
Re: Removing Time stamp from Email Filenames
to add - would it be something like this ?
DateTimeToFormattedString(date,format)
i need to be looking at ?
DateTimeToFormattedString(date,format)
i need to be looking at ?
- 05 Feb 2018, 12:11
- Forum: Sage 50 Report Designer
- Topic: Removing Time stamp from Email Filenames
- Replies: 4
- Views: 3508
Removing Time stamp from Email Filenames
Hi Bruce, I am emailing a GDN note in PDF format and have customised the filename thus "DN-" + GDN_ITEM.GDN_NUMBER + "-" + SALES_ORDER.NAME + "-" + GDN_ITEM.DATE this works fine until i go to my outlook and see that the filename date portion includes the date as dd_MM_y...
- 26 Jan 2018, 09:45
- Forum: Sage 50 UK version General Help
- Topic: User Defined Payment Field - Supplier
- Replies: 4
- Views: 3294
Re: User Defined Payment Field - Supplier
Hi Bruce,
Thanks you so much for this work, you've helped me with Joins before, so it was good to know how to do this again.
This is perfect .
thanks
Paul
Thanks you so much for this work, you've helped me with Joins before, so it was good to know how to do this again.
This is perfect .
thanks
Paul
- 25 Jan 2018, 15:41
- Forum: Sage 50 UK version General Help
- Topic: User Defined Payment Field - Supplier
- Replies: 4
- Views: 3294
Re: User Defined Payment Field - Supplier
Hi,
Is there anyway to show these methods on a report ?
i can find the payment method ID on the purchase ledger, but not the actually the method name.
I'm using v24
Thanks
Paul
Is there anyway to show these methods on a report ?
i can find the payment method ID on the purchase ledger, but not the actually the method name.
I'm using v24
Thanks
Paul
- 19 Jan 2018, 13:34
- Forum: Sage 50 Report Designer
- Topic: Could not load file o
- Replies: 8
- Views: 4847
Re: Could not load file o
Hi Bruce , While i fully don't understand what the error is, i followed the file path the error is throwing up to this point: C:\Users\PJ\AppData\Local\Apps\2.0\2OVAH5HM.443\6KGKPOV8.Y3O and then the next part stan..tion etc is not in the folder at all (?) So , it can't call something that's not the...
- 19 Jan 2018, 12:38
- Forum: Sage 50 Report Designer
- Topic: Could not load file o
- Replies: 8
- Views: 4847
Re: Could not load file o
Printer selections and some driver settings eg the tray or the number of copies can be saved in reports. If you reference a non existant printer that can cause issues, however you should be able to run to preview and select/reselect a valid printer (when you do so and close the preview it asks if y...
- 19 Jan 2018, 12:36
- Forum: Sage 50 Report Designer
- Topic: Could not load file o
- Replies: 8
- Views: 4847
Re: Could not load file o
Hi Bruce,brucedenney wrote: ↑18 Jan 2018, 16:24 Do you get an issue if you run one of the standard reports that you have not copied into the practice data set?
I've just run my first non imported standard report and have had the error straight away. As i mentioned, i would usually only get this after i'd run my new imports.
- 18 Jan 2018, 15:34
- Forum: Sage 50 Report Designer
- Topic: Could not load file o
- Replies: 8
- Views: 4847
Could not load file o
Hi Bruce, Just wondered if you have come across this error? I'm running Windows 10 Pro 64bit, and now running v24 of Sage 50. (error existed before the upgrade) So, I'm in the Practice Company and have been testing new layouts and reports. I have copied all my required documents to the new 2018 fold...
- 11 Jul 2017, 14:34
- Forum: Sage 50 UK version General Help
- Topic: Reconcile Bank will not run on USD dollar account but will for GBP
- Replies: 5
- Views: 3441
Re: Reconcile Bank will not run on USD dollar account but will for GBP
Hi Sorry, yes i wasn't clear there. manager is our sage admin logon, i meant to say i logged into our server, then logged into sage using manager access on that machine as opposed to a local machine, I've reset all the permissions that i can, following the sage help advice on their site. It's so pec...