Sage 100

Hello everyone, I'm stuck on a problem. I wrote a script to run from a button on the address tab of Purchase Order Entry. I made a field to collect a Sales Order number that the user types in the clicks the button to generate the ship to address from…

I created the following script to populate ShipWeight$ in the CI_Item table when either of 2 UDF's are changed. I am now receiving an error 88 type mismatch (error window below). Any thoughts? START OF CODE Dim retVal Dim cpwgt Dim cpwgtstr Dim…

New to this forum, and new to using the Business Object Interface. Scenerio: I'm on Sage 100 2022 Standard, and am about to implement Sage Alerts & Workflow. One of the tasks I will be creating will periodically look at all open Sales Orders and automatically…

I have a formula in my SO picking sheet it puts different words on the header depending on the number of days between the order date and the ship expire date. I want to edit this formula that the < 4 is actually 0 to 3 Business days. before the wording…

Apologies for the large block of text but this is a strange one. I have a script that recalculates the Unit Price of a parent Kit item based on the component items' standard prices, and recalculates whenever a Quantity Ordered is changed for any component…

I am trying to warn the user with a message when entering an A/P invoice and selecting a Job that is no longer active. Since there is no Active/Inactive jobs in J/C ,module, the customer is using the Sort field for this purpose. For jobs that are active…

I am trying to get an event trigger when an item quantity changes so I can perform a real time update in a UI. I have tried setting Post Write Events on IM_ItemWarehouse and IM_ItemTransactionHistory, but although I can see the DB Tables changing/updating…

Hello, I am in the process of building a "Change Tracking" system for Sales orders which tracks any changes to a specified list of fields. To do this, on a Table Pre-Write script I simply gather the information from the So History record and compare…

I'm working on a button script ("Execute on Server" selected, MAS 200) that will export a PDF of a Sales Order to a specific location without prompting the user. I'm running into some strange issues and was hoping someone has seen some of these things…