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.
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…
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'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…
I am trying to warn the user with a message when entering an A/P invoice and selecting a Job that is no longer active. Since there is no Active/Inactive jobs in J/C ,module, the customer is using the Sort field for this purpose. For jobs that are active…
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…
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…
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.…
I'm having issue trying to get into Customer Maintenance from Script. This was working before, but has become an issue over the last week or so. I don't remember changing anything.
Maybe you can spot check me to see what i am doing wrong.
Shell (…
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 stuck and can't quite figure out why. Below is a script I wrote to add a new line item to the CI module (I copied and pasted from several places).
If SetSession("C/I", "CI_ItemCode_UI") Then writeLog("Connection Complete - Item Maintenance") Try…
Hi all,
First script first post. Task is simple for one customer set freight amount field to negotiated amount that is based on the sales order total amount. Script is attached to pre-total event and it always works BUT only if sales order has more…
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…
Hello
i am trying to read data for each line in sales order and i am getting a error , i am not sure why i am getting this error cause the same code is working for few lines but not for few
this is my code ##################################################################################################…
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…
I have a simple test script that I wrote based on a script that Elliott posted a couple of years ago
oTest = 0 Set oTest = oSession.AsObject(oSession.GetObject("CM_UDTMaint_bus", "SY_UDT_SY_TEST")) dateStamp = "" timeStamp = "" userKey = "" retVal …
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…
I have been searching the BOI forum for the keys to making a button launch a custom report (label) and pass in the bill production number. I have not found a good resolution that appears to work yet so I was wondering if anyone has been able to accomplish…
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…
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…