Sage 100

I would like to limit users to only be able to enter the numbers 0 to 9 or a decimal in the CI_Item.ShipWeight field. What would be the easiest way to do this? Thanks,

I have nearly 30 UDFs in PO Receipt of Goods Detail file and linked to posting/update files, work files and history files. These are working great. Staff wants these same UDFs to appear in IM Transaction Entry for Receipts for those items without a…

I am trying to create a script that writes the current user key when the user prints the picking sheet. Has anyone done this before? My script doesn't appear to work and I am unsure which event I should use to accomplish. My code is below: retVal…

Hi I am trying to see if someone can point me in the right direction to find out how to add an existing column to the data entry screen. I am currently using PO Entry and i would like for the the quantity on hand field to be displayed when an…

I need to be able to calculate a UDF Field. I want, for starters, to add two UDF fields together (numeric) and populate the third UDF field with that value in Item Maintenance. This is my first attempt at writing a VB Script. So any help would be appreciated…

I have a script that works unless the field "UDF_EXCH_RATE" is zero. (default value is .000000) Where do I place the "if" statement to get it to work? tmpAmt = 0 : tmpExchange = 0 retVal = oBusObj.GetValue("ExtensionAmt",tmpAmt) retVal = oBusObj…

Greetings, We are running an older release of Sage 100 (4.50.40) and we have a third party extended solution called M9-SO-1099 'On Demand' Sales Order Fill Report which was provided by Blytheco. The manual for the add-on is here. https://wiki.blythecodev…

Hello, I am trying to create a custom report that would show customer details relating to items sold. I am looking to include: Customer Name and associated purchase history of a given item #, item description, standard cost, standard price,…