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.
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 am trying to copy a header field (PO_PurchaseOrderHeader - UDF_REQ_SHIP_DATE) to a field in (PO_PurchaseOrderDetail - UDF_HEADERSHIPDATE)
I tried the following script:
retVal = 0 headershipdate = "" retVal = GetValue("UDF_REQ_SHIP_DATE$",headershipdate…
I'm creating a script to auto-populate an SO_Detail UDF (UDF_SHIP_REF1) so that I can pass data to StarShip. The goal is to concatenate the item number with the Customer PO Number (i.e. "3131000 / 123456789" )
I have developed a more detailed script…
Hi Everyone,
I created the following Script and there are no errors. I am trying to figure out how many packages are needed by dividing the Quantity Shipped / Pack Qty. The issue is I do not know how to ROUNDUP in the Sage 100 Scripts.
Example #1…
I am trying to check to see if a sales order has been completed from an external VbScript. I'm guessing I'm not hitting the right object. Any suggestions would be appreciated.
Public Function IsSalesOrderComplete(strOrderNo) Dim so, rtnVal, status…
Hello, I am having some issues with making a script to change the output setting for paperless office inside of sales order printing. I have some code below that I found searching the forum. The way it is now I do not get an error message and nothing…
Hello,
I am a bit new to scripting on Sage and would like some assistance if anyone is willing. I am writing a script to update a UDF date field based on any change on the specifications Tab in Item Maintenance. I have attached my script below. I am…
I know I can create a field in the SO detail and total it in the header, but they have hundreds of existing orders and we are changing the calculation which would then go to zero. I have it on the SalesOrderHeader Table Pre-totals.
So I want to read…