• Update UDT whenever Sales Orders are printed

    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…
  • Script access to SO_PackageTrackingByItem from SO_InvoiceDetail script

    I need to access values in a UDF added to Item Packaging Maintenance (Shipping Data Entry), from a header or detail script, but I can't figure out how to open that object. Trying the command Window to list methods / properties for the Lines object…
  • Update a UDF in purchase order header from sales order not change the value

    we add a UDF UDF_STATUS_UPDATE in both SO_SalesOrderHeader and PO_PurchaseOrderHeader table to track order fulfill status. when change this order fulfill status in sales order, we want all PO generated from this sales order same UDF fulfill status get…
  • which event trigger when add one sales order line and want unit price change follow a specific rule

    when add one sales order line, we want some item default unit price automatically changes according to a price type defined in order header, which event should we use to trigger a script to get that price, I tried column pre-validate and post-validate…
  • In Sage 100 2023, why does the HandleScriptUI method now get Error #88 after InvokeButton?

    To reproduce, in either 32-Bit or 64-Bit Sage 100, create an "Execute Script on Server" button in either Customer Maintenance or Item Maintenance (maybe any panel) that runs a simple two line script: retVal = oScript.InvokeButton("BT_LINK_2") retVal…
  • VB script function and sub raise OLE Error Number: 1002 when click Check Script

    When I using a function or sub in event Column Post-Validate, and click Check Script button to check the VB script, get this OLE Error Number: 1002 error, however if I use same function in button click script where no Check Script, it works. looks like…
  • User Defined Script Method "InvokeButton" Fails with "Cannot create Windows Script OCX object" in 2023 64-Bit!

    The identical script works in every other version, but 2023 64-Bit. I get this error at the point the oScript.InvokeButton(<<button name>>) method is used:
  • Has anyone been able to trigger a script on the Ar_CustomerMemo or other Memo tables?

    I'm trying to trigger a script that will set the "Auto Display" value to "Always" as a default on the AR_CustomerMemo. I've tested triggering a script with a simple message box on various events like, on Table Set Default Values, Table Pre-Write, and…
  • Troubleshooting Loop in SODetail

    My script is on a table-pre-write on the PO_ReceiptDetail table. I've used the debug window to identify the area where the script is giving trouble, sometimes the script does not write and update the sales order. From what I can see the script should…
  • Scripting References

    Hey does anyone know where to get the objectreference.chm file? In the object training and here in Sage City it is referenced quite a bit but I'm unable to find it anywhere incuding the portal.
  • How to Manipulate the Grid UI in VBScript ?

    I want to perform a operation through VBScript , after that I want the cursor to be focused on a specific grid cell. How do I do That ?
  • Kit Components Table Pre-Write

    I have a simple table pre-write to populate an UDF_QTY_PULLED column based on the order qty, if the line is a kit component. I ran into a problem when we have to go and adjust the UDF manually, the script keeps on firing to change the UDF back to the…
  • Add On to Script

    I have a script looking at misc items, item type =5, any item with this type the qty ordered is populated into an UDF with the equal amount. One exception is if the item code is /SMISC, then nothing is populated, the UDF stays = 0. I need to enter another…
  • Button script to update a UDF on SO History Header

    Hello: I'm trying to create a button script to update a UDF field on the SO History Header table. It seems like a simple task, but I can't seem to figure it out. I need to prompt for the date and then update the SO_SalesOrderHistoryInquiry_bus_UDF_RMA_CLOSED_DATE…
  • Error 88 on Sales Order Entry Lines

    We are experiencing an error 88 on Sales Order Lines. The error occurs only on large orders with numerous lines, especially when adding inventory items to the order on the fly. The line prewrite script is failing and referencing different UDT objects…
  • Script Troubleshooting

    I have multiple scripts on the SO details, 3 on the quantity ordered column as a post val and 9 on table-pre-writes. I am finding some SO's in the system that seem to not have the scripts firing, when I go to that SO and enter another line with all the…
  • Kit Components Triggering Scripts

    Has anyone had any issues when a kit is exploded on an SO to have the components trigger SO details scripts? The kit item triggers the scripts however when the item is exploded the components seem to bypass any scripts attached to the lines.
  • Best Way to Source SODetail UDF from SOHeader UDF

    Is there an easy way to source an UDF from the SOHeader to the SODetail without a script? Thought there might be a work around but can't find it, so cam up with this script to test but will have to wait until I can get everyone out of the system. If…
  • Button Script on Customer Maintenance to open UDT maintenance UI for a particular AR_UDT. The second step would be to pass the Customer Number to the CM_UDTMaintSelect_UI

    We would like a Button Script on Customer Maintenance to open UDT maintenance UI for a particular AR_UDT. The second step would be to pass the Customer Number to the CM_UDTMaintSelect_UI. This would work great as t here are multiple records in the UDT…
  • SO Picking Sheet Work Table

    I have an UDF on the SO Details and also created the same UDF on the SO Picking Sheet Work table and linked it to the SO Details. I can't get that UDF to show up on the crystal reports to add it to the form? Other UDF's in the same tables show up, am…
  • System Date

    I leave SAGE up to keep a program up and running to import orders (Insynch), I have a script looking at the system date to populate a UDF date field when a sales order is put into process. I am noticing that I haven't had to restart the SAGE application…
  • Sage 100c 2022 Operations Management Work Ticket Printing

    We have Sage 100c 2022 with Operations Management. I would like to add a button to the Work Ticket Printing screen that replaces the Print button, launches a script to cycle through the JT_WorkTicketAttachments file for all attachments for the current…
  • Sage - 100 Item Search on multiple Fields

    Our Item Masters contain 130k plus items. Typically I tell our sales people to enter a "z" in the item code field, then press F2. This quickly brings up the items in the item master which start with "z". Otherwise Sage attempts to bring in the entire…
  • How to validate posting date

    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.
  • Passing parameters to Bm_inquiry_ui

    client has requested to have a button link in the sales order entry screen that will pull up the bill of materials inquiry for the item selected. I've done this before to launch item inquiry which requires a single parameter, but I'm having difficulties…