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'm trying to add an MS Script button to the SO Invoice Data Entry panel. In the script I need to access the LOCAL cCurrentPaymentTypeMethod$ property inherited from Class SO_CommonEntry_UI. Can this be done and, if so, how would it be coded?

I need an executable to run when the client Posts AP Batch to the Invoice Register. I cant add a user defined script to the AP Invoice Registry screen because i cant get to it with Customizer. Is there a way to get around this?

We have just switched to 100c. I, as administrator, can change to the new ribbon, themes, etc. When my employees try to use the "settings" at log in, it says: You do not have permission. Where is the security to turn this on? I have tried searching for…

Hello, I am trying to write a script for lookup button in order to pull the salesperson data. I only want to pull the salesperson data whose division number is “00”. How can I pass ARDivisionNo as parameter? Here is the script which I am working on…

Hello all, I have a button script on repetitive invoice header which will pulls out a UDT. But what I want to do is not just pulls out the UDT, (cause it will show all the datas) but also filter the UDT values that shows only for this particular customer…

Hello, I have a script on cash receipt header table, post-write, will bring cash receipt header and detail to a UDT. It is working fine, EXCEPT, If there is more than one lines in the detail, it will only return the last line to the UDT. Only showing…

Hello, I have create a UDF called Item code in Cash Receipt detail table and add it on the Grid. I want to create a Button script using the invokelookup which will fire off the item code list and can select the item code from the list, then set the…

Hi All, Is there a list of the properties for the various control types? I am trying to work with Text labels using oUIObj.SetControlProperty(ctlName, propertyName, value),. I would like to hide labels based upon data on the screen to display the…

I would like to customize the Summary Package Tracking panel but the right-click customization option is not available. I am trying to ensure the user enters tracking information into this panel before Accepting the shipment. Any suggestions are appreciated…

We have upgraded to 2016 and was trying to show the end user how to change the desktop theme, and the user settings window would not display from file or from the launcher. I understand that theme maintenance is not available to Sage 100 users that do…

Have created two UDFs Manufacturer and Manufacturer Item Code that are on the Item Alias. They are there because they are accessible via the Alias Item Lookup. We have added these fields to the Alias Maintenance screen. User pointed out that the use…

I have a script that is triggering on table pre-write of the SO_SalesOrderHeader. The script is triggering during invoicing, since the table is updated. Is there a way to make an exception and prevent the script from triggering during the sales journal…

Hello All, I've written a script where I'm creating new customer accounts. I'm also looking for a method that will allow me to add these newly created customers as Sold To customers, but can't seem to find the answer in the materials. Anyone have…

I have an MS Script that runs when a button is clicked inside Invoice Data Entry. When the script is completed I want it to click a hidden button for me to finish up the Invoice. This used to work just fine when the script was run on the client, but now…