• User Defined Script for Sales Order

    I am calculating a UDF (by script) on each SO Line. I need a script that will accumulate those Line amounts and save it to a header field. I'm hoping some smart guys knows how to do this.
  • 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 automatically…
  • Split Sales order with a script

    Hello everyone, I was wondering if anyone has been able to split a sales order into two separate orders based on line information using a script. Would something like that be feasible?
  • Script to Synchronize Customer Billing Address in Sales Order Data Entry

    I was attempting to create a VB Script (to be executed via an External Link button) that would update the billing address within a sales order from the customer's AR address. Currently our admins do not have the ability to manually change a customer's…
  • Sales Order Entry / Totals Tab / PaymentObj

    I believe the Deposit Payment Type on the Totals panel and other data reside in PaymentObj. What table is associated with this object? Where/how can I find the data?
  • Button Script to delete Sales order with cancel code

    Hello all, I wrote a script with the goal to delete sales orders with a specific condition. So I can delete sales orders just fine its just that when the orders are deleted the cancel reason code is not flowing to history it is staying blank. I am…
  • Script on SO Lines, Visual Bug

    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…
  • Write on Production table using script

    Are we able to write on the Production table from the Sales Order Entry UI? I have items that based on the S/O Entry need to be put on a Production Entry so was wondering if after they are entered in the SO and the Picking Sheet is printed, I can write…
  • Launch Sales Order Entry to create new order from Customer Maintenance and pass Customer Number

    Hi Sage City and Happy Friday! I have been working on a button script to launch Sales Order Entry from AR Customer Maintenance. The goal is to click on the button and open SO Entry, automatically select the next Order Number and pass the Customer Number…
  • Invoice Batching – Can't Set the Cost Account Key

    When invoicing RMA's, we use logic in a custom script to set the cost account key and the sales account key on the line items based on based on the customer division. When I go to the newly created invoice, the sales account key has the correct value…
  • Print to PDF and electronically deliver Sales Order via BOI

    I want to thank everyone in this forum in advance for the wealth of information you have posted and gathered here. With that information, I have been able to apply a script to automatically print Sales Orders once they are entered. The script below runs…
  • User defined script in AP invoice Data Entry is not working returning the Job Cost variables...

    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…
  • Can I use table IM_ItemWarehouse to trigger script?

    Hello I was just wondering If I can trigger a user defined script, with table IM Item Warehouse? I'm looking to trigger a script when there are changes on an item inventory. I see a field named Available on Item Maintenance > Quantity, I'm assuming this…
  • SO Invoice Entry - Default qty ordered and shipped to 1

    I want to have all SO Invoice lines default to an order quantity of 1 and a ship quantity of 1 (currently the default is zero). This is Sage 100 2019. I wrote the following script and attached it as a post-validation event to the Item Code column, but…
  • How to run two scripts after VI job across each invoice in batch?

    I have a VI Job that imports sales order invoices into a batch. I have scripting that does some zip code validations and then uses scripting to interact with 3rd party integration buttons that are installed (Vertex tax software). The scripts work perfectly…
  • Script to update child line

    I wrote a script sales order detail post write script that creates a child line that is a percentage of the parent line. If the updates the parent line quantity, unit price or extension the script updates the child line, BUT does not display the change…
  • SO Line Script Not working

    Wrote a simple script for client that has a pop up if when entering SO, you forget to put in qty ordered on lines page and you try to go to the next line pop up says please enter qty ordered. The script works great on my install. Tried to install on client…
  • Log who printed Picking Sheet

    I am trying to create a script that writes the current user key when the user prints the picking sheet. Has anyone done this before? My script doesn't appear to work and I am unsure which event I should use to accomplish. My code is below: retVal…
  • Script to Export SO

    I'm working on a button script ("Execute on Server" selected, MAS 200) that will export a PDF of a Sales Order to a specific location without prompting the user. I'm running into some strange issues and was hoping someone has seen some of these things…
  • Create Script to Explode a Kit on a Sales Order

    I've created a script to add line items to a Sales Order, but adding a kit using the same method does not explode the kit as it should. Should Kit items still be added to the line item (oLines) array on the SalesOrder object, or should some other function…
  • Automatically Save Changes on Event Script

    Without going in to the whole story we are trying to update some fields for auditing purposes and don't want the user to have the option to not save the changes to the order thus not having a record of the auditing information we are looking for. I have…