Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
Greetings all,
I was wondering if there is a way of updating a UDT whenever a Sales Order is printing via script.
I have a customer that would like to keep track of the time between when the SO is printed and when the order is shipped. I figured I…
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…
When viewing a multi-line field within DFDM I noticed that one of the UDF fields within the current table (AR_Customer) had a Nomads Tag that suggested I may be able to possibly manipulate a different multiline field to perform a lookup within a UDT.…
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…
My goal is on a new PO, update the SOs PO number and PO required Date values that are referenced in the PO. I have been able to go through the PO lines and find the SOs, but I can't seem to update the SO lines. I do not seem to be getting any failures…
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
Looking for a way to generate an alert during data entry when a pay rate is keyed that is greater than X amount over employee's pay rate 1. The alert is just for confirmation and would display the employee pay rate 1 and the value that was keyed. We frequently…
Hi all,
First script first post. Task is simple for one customer set freight amount field to negotiated amount that is based on the sales order total amount. Script is attached to pre-total event and it always works BUT only if sales order has more…
I have a simple test script that I wrote based on a script that Elliott posted a couple of years ago
oTest = 0 Set oTest = oSession.AsObject(oSession.GetObject("CM_UDTMaint_bus", "SY_UDT_SY_TEST")) dateStamp = "" timeStamp = "" userKey = "" retVal …
Hello:
I have an issue where the client needs the ship weight and the freight to carry over to the Totals tab in Sales order data entry. It will not due to the line item setting in sales order options. I believe my options are to write a script to…
Hi All,
I was going through some old Sage Summit presentations and thought that these 2 sessions had a lot of great information that is still very useful. Enjoy!
UsingBusinessObjectInterface_Begginer.pptx UsingBusinessObjectInterface_Advanced.pptx…