Sage 100

Hi, I experiencing errors in customer maintenance on a custom tab. I'm using the debug window and found 1k+ lines on several clicks. Error:0 Error:11 Error:12 Error:13 Error:14 Error:2 Error:20 Error:23 Error:26 Error:27 Error:36 Error:65 Error…

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…

I've used DeactivateProcedure on scripts running within Sage, but not on external scripts. I'm working on a script that requires me to disable procedures in SO Entry. I've tried a few variations, but I'm getting "Object doesn't support this property or…

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 have a script that launches if a user attempts to delete a Po with a prepayment. Here is my script. It works when the user click on Delete button on an existing PO with prepayment. The problem is however, it removes lines of the PO. I have this script…

Hello, We have added many panel customizations including additional tabs, buttons with scripts, etc that are important for many of our users. I was just resizing a field in customizer, and when I went to exit the customizer an error popped up saying…

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…

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…

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'm new to scripting and having a little trouble. I'm trying to grab the primary vendor alias for an item from IM_AliasItem and put it into a UDF in CI_Item. This will probably be triggered on reading the item record, if that makes a difference, but I…

Is there a Prompt or Interactive Message Box available in a server-side script? I know that from a User Defined Script or a Customizer script that runs on the server, you can display a message box thusly: retval = oSession.AsObject(oSession.UI).MessageBox…

Hi All, I have a client that wants to prevent users from deleting a COMPLETED line on a PO. It appears that we can't do this via scripting but wanted to confirm before I send it to programming. And just a note - there are all kinds of problems with…

Hi All, I am once again stuck on a scripting issue. Seems that part of my script needs to be VB and part needs to be BOI and don't know how to do it. It is a pretty simple test. I need to test to see if a PDF file exists in a specific directory and…

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, Have an issue where this script works fine in my install but does not on the client's system & I can't figure out why. Very simple script. It is for ver 4.50 standard. The client does have IIG's CCP but I can't see that interfering. I am testing…

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…

We have some standard price level codes we use that are set up for each item, if you are a wholesaler you get X price, MSRP has its own price code, etc. The descriptions for these codes are universal, W always would be described as wholesaler for example…