SageForum for UK versions of Sage 50- Help and support.

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

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

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

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

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

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

to add - would it be something like this ?

DateTimeToFormattedString(date,format)

i need to be looking at ?

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

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

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

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

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

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?

Hi Bruce,

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.

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

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