Sage 100

I have a script for Item Maintenance that is connecting to Item Warehouse, summing up QtyOnHand and then writing it to a UDF on the Main Panel. The script works when I can get it to run, but I am having trouble figuring out which Event I can associate…

I have used this code for years me and a handful of others, but we have a few new users that are having issues and can't appear to use my app to open Sage Sales Order. The only indicator they get is SO_SalesOrder_UI in a message box. Here is the…

I have most of this script working but am hung up on the part reading from the line detail object. I have created a button on the AR Invoice History Inquiry panel so that the end user can find the invoice they want to copy, press the button, and the flat…

We sell valves for oil and gas pipelines and installations. We use one short description for sales orders and then very long detailed descriptions for purchase orders on how the valves are to be built. As Sage 100 only has one item description field we…

I would like to read through the lines of an invoice in ascending ItemCode order during a SO_InvoiceHeader Pre-Write script, but they seem to be unaffected by a SetBrowseFilter and appear in entry order. Any ideas? Here's my 5 line test case: sItemCode…

Hi Sage City and Happy Friday! I have been working on a button script to launch Sales Order Entry from AR Customer Maintenance. The goal is to click on the button and open SO Entry, automatically select the next Order Number and pass the Customer Number…

Good morning all, So I figured this would have been a relatively easy script but I can't seem to find a way of accomplishing what I need. I have a customer that would like to force a cancellation reason whenever you delete a Sales Order into history…

Hi forum folks and Happy Friday! I have a customer that would like to CC a specific inbox any time we send SO Invoices and orders via Paperless Office. We have been doing this by adding this CC email to the "To Additional Email Addresses" Field under…

Is there any ways to enable Sage 100 auto send email notification to a certain group of recipients upon SO is entered / invoiced? I assume this has to involve scripting, right? Thanks, Haibo

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 trying to recreate PO Receipt of Goods from history. I can't seem to import to a PO where 10 lines are lot distributed and 1 line is not. What field can i add to distinguish between them?

I see that there are lots of questions about this in the past, but I can't seem to find a concrete answer on how to move forward with it. I realize it has something to do with DCOM, registering the DLL, running client side verse server side.... But I…

Hi, I am trying to write a script that zero's out a Sales Order UDF during Invoice Data Entry. This is what I have, but it is not zeroing in on the exact sales order in my lines and it doesn't seem to be writing back to the sales order, although I have…

Earlier this year I created a mobile application for pulling orders. To integrate, I made a rather barbaric implementation: when the mobile application backorders an item, update SO_SalesOrderDetail.QuantityBackordered = External.QuantityBackordered.…

We have a WMS integration that relies on the field PickingSheetPrinted = Y and was wondering how I could create a button to set that field to Y, without having to go through the print preview process when you use the actual button?

Hello, In Sage 100, I've added a UDT with a list of items, and a UDF onto Sales Order Header which enables user to select an item from the UDT. After selection, I also want to pop up other fields (also UDF) based on the selected item. Basically, pop…

Does Sage support silent removal and deployment for client installs? We are using Sage 100 v2016 and moving to a new server with Sage 100c v2019. Is there a way to deploy a script to uninstall the client on all the machines and reinstall a new client…

Hi, I have the code below for automatic registration/update of the production transactions. I've been getting an error on the UpdateInit method. oSS2.nSetProgram(oSS2.nLookupTask("BM_ProductionRegister_UI")) objTransactionRegister = oScript2.NewObject…

Hello everyone, apologies if this has been asked before but I wasn't able to find something quite like this. We're on SAGE 100c 2018 v6.00.6.0 I have a script I want to run on a table to update the batch comments based on a few conditions. I have…

Experts, I am able to create Sales Order, Sales Order Invoices, and AP Invoices via BOI without any issues. I am missing something about the order of things for PO Receipt of Invoice. Here is an excerpt of my code (it's in Powershell, but the methods…

Hi All, I need to display a message box on Shipping Data Entry interface. I can get data from "SO Sales Order Header" and "SO Shipping Data Entry" and "Customer....". On Custom Office using trigger of " "SO Shipping Data Entry" " and Pre-Write. …

I have a VI Job that imports sales order invoices into a batch. I have scripting that does some zip code validations and then uses scripting to interact with 3rd party integration buttons that are installed (Vertex tax software). The scripts work perfectly…

Hello everyone, I'm trying to populate 3 UDFs based off a button click to approve a Receipt of Goods. Here is the UI script I have linked to the button 'Triggered to write the date/time/name to receiver UDFs approved=PO_ReceiptOfGoodsHeader_bus_UDF_RECEIVER_APPROVED…

Hi We have a requirement, where when a new invoice is getting entered in AP, using a VBScript copy the Invoice Date to a new UDF. I did try to put the same using the Post Validate event on the Invoice Date, but it's not copying the data into the new…

I'm getting the error m essage=<NewObject Error: 200> Source=ProvideX.Script.1 when accessing a UDT. I just installed the client on this workstation for the first time, though I suppose I can try reinstalling. I'm hoping I just have a small syntax error…