Sage 100

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…

Hi, Below is my script to Prompt user a warning that when user entering invoice data entry, it will check a udt for blanket PO is out of fund. I've create User Define Table to keep track of a listed PO and Billed Amount. The script is reading invoice…

I'm receiving the error: Message=<NewObject Error: 200> Source=ProvideX.Script.1 on a new Windows 2016 server (remote desktop server). This script was running on an older server and is still running on workstations running Windows 7. The line referenced…

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 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?

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…

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…

Hi All, I know I must be missing some basic concept here. I have a client that wants to insure that all items have an extended description. Here is what I have: sType = "" retVal = oBusObj.GetValue("ItemType$", sType) If sType <> "1" Then Exit Sub…

Hi All, I am working on what should be a pretty simple script. Got it to work but then changed the trigger for it and now I cannot get it to fire off. I have setup one of the categories in inventory as "Raw". I will enter Y in the items that I want…