Sage 100

I have encountered a strange issue with a button script that enters data into a UDT. I have been using this script in testing for about a month now and it hasn't had any issues until yesterday - even after a server restart. The first time clicking this…

Hello, I was hoping to get some advice on scripting the BOI via a Button script that was placed on S/O Invoice Data Entry that would act as a "Quick Tax Credit" button. We use a third party cloud vendor to calculate our taxes but that shouldn't affect…

In Customer Maintenance's Invoice tab I am wanting to allow accounting to have the ability to edit the Comment field from the AR_OpenInvoice table. Since this isn't the history table, it wouldn't affect the comment line for invoice history reprints, so…

Hello everyone, I'm stuck on a problem. I wrote a script to run from a button on the address tab of Purchase Order Entry. I made a field to collect a Sales Order number that the user types in the clicks the button to generate the ship to address from…

I created the following script to populate ShipWeight$ in the CI_Item table when either of 2 UDF's are changed. I am now receiving an error 88 type mismatch (error window below). Any thoughts? START OF CODE Dim retVal Dim cpwgt Dim cpwgtstr Dim…

how to add script on posting Process button to validate posting date? we want the posting date in same month with all PO receipt invoice date, but some times type may happen.

I actually kind of figured that this would have been asked a few times, but my search attempt wasn't all that successful. The only somewhat related topic was Script to Select File , but the script I found here only displayed server-side files since it…

I have a UDF checkbox on the GL_Account maintenance called UDF_DONATION. What I want to do in the Table Pre-Write is to check to see if there is another GL Account record where this UDF_DONATION is already set to "Y". If there is another record with the…

Is it possible from the Production Header panel, via a script, either tied to a button click event or on one of the table events, to open an existing UDT (so that the user can see the UDT), then get a value from it and set a textbox on the Production…

I'm working on a BOI script to create Manual Check entries from a CSV. Everything can import successfully, except when the invoice was set with SeparateCheck = "Y". In regular UI, you get the popup message "The Invoice ____ is flagged for separate…

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…

Apologies for the large block of text but this is a strange one. I have a script that recalculates the Unit Price of a parent Kit item based on the component items' standard prices, and recalculates whenever a Quantity Ordered is changed for any component…

Experts, I am looking for a way to retrieve the ExtendedItemDescription for a line item on a Sales Order before the SO is actually saved. The Extended Description gets put together by JobOps, and I need to grab it to extract some data from there. …

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…

Experts, I am using the button script below to open Customer History by Period from a Sales Order line (Sage has this button in Item Maintenance on the History tab). It works. It opens properly for the item. But there is a secondary selection criterion…

We are receiving multiple "APPCRASH" messages on our server when someone closes their SAGE (Full error below). This happens for remote and local users and as far as we can tell, we are just getting the error message. No major impact on the system except…

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…

I have a dev environment setup where I am using eBusiness Web Services to communicate with Sage100 2018 on prem. I am attempting to add a payment to an existing SalesOrder however I receive the error “Payments may only be appended to an existing list…

Using the RMA module for the very first time. Tried to look for a RMA Sage University course for proper set-up and use but am having a difficult time locating one. Has anyone utilized this course and if so, where was it located? Is it under a specific…

I am trying to use code that i have used in previous versions of Sage 100 to launch into Sage Sales Order Entry from an Access Data Base. By previous version note that we were on Sage 2013 and took a huge leap to Sage 100 Advanced 2018 (Version 6.00.2…

Hello, I am working on a script to change the payment type based on the terms code that is entered in the sales order. This script fires fine for setting the field to "None" or "Check", but when the script is supposed to change the value to "Credit…

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…

I get an error "Module J/C is not on file" when attempting to reverse an electronic payment. Here is my code using (DispatchObject mCheck = new DispatchObject(pvx.InvokeMethod("NewObject", "AP_ManualCheck_bus", oSS.GetObject()))) { // Perfrom Check…

I am writing a script on the lines object in BOM. I want to check the product type of the item and do stuff if it is a kit type. However, in BOM detail that info isn't available. The product type is available in the CI table so what is the best way to…

I am attempting to write a script that will loop through all line items in a BOM and update a UDF on the header tab with a total number of lines. However my script hangs up and locks the BOM record when the script runs. Here is my script. I haven't even…