• 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.

  • 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 there 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…

  • 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…

  • 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…

  • Copy UDF Values from AR_CUSTOMER.M4T to Equivalent UDFs on new Sales Orders

    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…

  • Quote to Standard Order not Firing Scripts

    I have a few scripts on column post validates, mostly watching the order quantity.  I had them only running for standard orders, however this was an issue when the order starts as a quote.  One script is a calculation to mark the udf quantity pulled (basically…

  • PO Receipt Detail

    Getting stuck on this script, I've tried a column post val on the qty received and a table post read.  Both are getting stuck at the same point, on the first "retVal=oSOLines.MoveNext()", should it be MoveFirst?

    Dim sPurchaseOrderNo
    Dim…

  • PO receipt header script triggers when it shouldn't.

    v2022.2 Standard, Column pre-validate on InvoiceNo, as the only script active on the table.

    Basically the script checks if the user is allowed to enter an InvoiceNo, and does a SetError (when a specific Role permission is active).

    The column pre-validate…

  • SO lines loop, updates only one line

    I have a script, which edits line data (conditionally) based on a header event trigger.  It works fine in v2020, but in v2022 (Standard, no enhancements) only one line is updated.  In order to get it to update all lines, I had to add a check for a changed…

  • SetBrowseFilter

    I'm trying to use the SetBrowseFilter method with an external script using the AR_Customer_ui object. and the InvokeLookup method. I need to show only Active Customers with a SortField set to a value. I can't seem to find any documentation for the SetBrowseFilter…

  • Table -Pre-Totals Script to only Run Once

    I have these two scripts on the SO Invoice Header running, one on a "table-pre-totals" and then another one on a "table-post-write" to reverse an action in the first script.  I am pretty sure when we open the batch up the "table-pre…

  • Add ship to address when a new Customer is created

    Hi Forum,

    I need to update a ship to address code "0000" when a new cusotmer is created.  I am trying to do it on a "pre-write event" is entered but I am getting an error.

    Any suggestions ?

    Regards,

    Manuel Roman

  • File Picker Dialog

    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…

  • The Script Control object could not be created

    Posting this in case it helps someone else.  Client is on SPC (new), v2022.2, and we received this error when trying to add a UDS (clicking the green check-mark button to verify syntax).

    The script host was properly installed (and Allow External Access…

  • Script Continues to Run after Deleting and Recompiling

    I had a script on a Table Pre-Write on the SO Header and I needed to turn it off for a while so I deleted it and recompiled the UDS.  However, on our SO's I still see the output from the script running? Should I add something to the script to not allow…

  • Automate/Script Available Quantity Pop Up

    Has anyone attempted to script the automatic selection of "Backorder Item" anytime the "Entry Exceeds Available Quantity" screen pops up? 

  • Date Customer Last Purchased

    Hi Guys

    I am looking for a field within sage that gives a date that the customer last made a purchase. The only date I found which was similar was LastActivityDate but this can be triggered by lots of different things. Do you guys know if this exists…