Sage 100

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…

Hi All, I am very new to VB Scripting and BOI in Sage scripting, Is there any training material or certification which is recommended for the newbies, please advise and recommend. Thanks AJ

Hi I have a business requirement, where we have a Date Field1 and Date Field2 , while entry of the details data, Field1 will get the date auto defaulted from the header date field. And Field2 will be blank . Later when there is an update on the Date…

I am trying to make a custom report in Business Insights Explorer that shows: Item Code Item Description Product Line Quantity on Sales Order Total Quantity on Hand But I cannot link a "Qty. on Sales Order" column to the rest of the report…

Is it possible to write data into different company within some Sage 100 company. For Example add a button on Sales Order Entry to copy order to secondary company. I know how to do it outside of Sage with a script but not sure if session to different…

Hi Folks, my company has to changes prices on a number of items on a somewhat regular basis, every month or so. having someone open each sales order that those items are on to hit the "recalc" button is a huge time spend. is there a way to create…

We are looking to utilize AR Customer Memos as a way to convey what special requirements a customer regularly has when they order. Ideally we want this on Sales Orders and Packing Lists. The issue is that when linking to the AR Customer Memo table, it…

I located KB 19387 which describes how to create a batch file to run a VI import program. The routine requires the name of the the VI job which is readily available on the job listing and panel. I'm thinking I could use the same/similar batch file format…

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'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…

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?

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…

I've created a script to add line items to a Sales Order, but adding a kit using the same method does not explode the kit as it should. Should Kit items still be added to the line item (oLines) array on the SalesOrder object, or should some other function…

Hi, We have a script on Invoice detail which sets the Extension Amount on the line, the current trigger for this script is "Column-Post Validate" on "ItemCode". But when we generate invoices using AR Repetitive Invoice Selection, the script doesn't…

Without going in to the whole story we are trying to update some fields for auditing purposes and don't want the user to have the option to not save the changes to the order thus not having a record of the auditing information we are looking for. I have…