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

  • Sage 100 BOI Script to Create Inventory Transactions

    I'm writing a BOI script to create Inventory Adjustment Transactions.  I want to use the next available entry number so I have the GetNextEntryNo(refNo$) function in my script.  What I can't figure out is what the "refNo$" needs to be.…

  • Sage 100 SQL - Use Script Tied to Button on Production Entry Header to Open UDT Screen and Return Data From UDT to Production Header

    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…

  • Populate Object (e.g. BM Production Entry) and open UI

    I am looking for a way to use a script in Sage to create an entry, e.g. a Bill of Materials Production entry, and then open the UI for this entry to have the user complete it. I know how to open the UI for a specific program, and  I know that I can open…

  • User Defined Script - Problems Getting Child Handle

    I'm trying to accumulate the quantities of all the detail lines in an AR invoice, but only if the item is of a certain type.  I defined a UDF for that checkbox, and put it in the Item Maintenance screen.

    I would like the total to update whenever a user…

  • Creating PO via BOI Write Issue

    Hello All! I have an issue with creating a PO via BOI that I was hoping someone can help me with. We're using  Sage 100cloud Premium 2019 Version 6.10.4.0. Here's my code:

    using (DispatchObject poObject = new DispatchObject(pvx.InvokeMethod("NewObject…

  • Bill of Materials InvokeProgram Script

    I am trying to launch either BOM Inquiry or Maintenance using an InvokeProgram or Process User Defined Script, but any time I add the Bill I get the error "You do not have security rights to create the record" but I am not trying to create a record. Any…

  • Paperless Office Email from AR Invoice History Printing Report through BOI

    Experts,

    I have an issue with automating invoice emails through Paperless from the AR Invoice History Printing report. The code below works fine in my test environment but fails (without an error) in the target environment.

    My test environment is v20…

  • Access the Lines on Transaction Tab in Item Maintenance

    Experts, 

    I got a tricky one here. I have a UDF in IM_ItemTransactionHistory that contains a file path. Now I would like to be able to place a button in Item Maintenance on the Transactions tab that allows me to open the file.

    The code to open the file…

  • Script to add CC Fee to Invoice - getting an error!

    I know there are several posts about adding a line to an invoice to charge a fee.  I've modified a script I found either here or in a Sage scripting class, but for some reason, I can't get it to work this time.

    When I put it on the Pre-Write event…

  • UDS event trigger when an existing order is brought up and the Cancel button is hit.

    I have scripts that show or hide a button added to the screen depending on certain conditions.  When an order is brought up the button shows/hides correctly.  The issue I am having is if a user brings up an order when the condition is met and the button…

  • Paperless Office Email Button script - Show Electronic Delivery for Forms Window

    I created a button script that sends out a Sales Order Form via Paperless Office. We are not using the regular printing interface because the users don't have to select the form code, and we are also writing the print/send date to UDF.

    I built the…

  • Can't figure out Event hook

    I have a script for Item Maintenance that is connecting to Item Warehouse, summing up QtyOnHand and then writing it to a UDF on the Main Panel.  The script works when I can get it to run, but I am having trouble figuring out which Event I can associate…

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

  • Upgrade to Version 2020 with IM ItemCost UDF's Causes Button Script Failure

    A button script has been working for 8 years that writes 4 string UDF's and the TransactionDate started failing immediately after upgrading to 2020. After getting successful returns on all the SetValue statements, the Write fails (retVal = 0). The IM…

  • 2016 - 2020 First oScript.SetError Method doesn't trigger an error message in Lot/Serial Number Distribution

    This UDS is a Column Pre-Validate on QuantityShipped against the SO Sales Order Tier Distribution table at version 2016 Std through 2020 Advanced. The SetError doesn't always trigger the error message, but it does fail (i.e. clear) the distribution number…

  • UDS sub and functions

    Hi all,

    Does anyone have any suggestions on how to incorporate user-defined functions and additional sub routines in UDS?

    I have a working (pseudo-codes below), intended to be assigned to Table_Post-Write event for AR_Customer_bus.  

    Basically, there are…

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

  • Get ExtendedItemDescription for a Sales Order line (Sales Order has not been saved yet)

    Experts,

    I am looking for a way to retrieve the ExtendedItemDescription for a line item on a Sales Order before the SO is actually saved. The Extended Description gets put together by JobOps, and I need to grab it to extract some data from there.

    I can…

  • Changing a date field on a new line with an unrelated Pre-Write script also changes that date's format - confuses customer

    I discovered that if a date field (e.g. PromiseDate or ExpirationDate) is changed on a new SO or PO line with a Pre-Write event that also sets any other value in that line, the screen format of the changed date for that line also automatically changes…

  • Strange Behaviour when Setting a Date UDF from Button Script

    Hi,

    I am setting a Date UDF from a Button Script for the line that currently has the Focus in the GD_Lines. I tried setting through SetValue as well as InvokeChange. With both methods the date shows as YYYYMMDD in the UI until I refresh the grid or move…

  • Forcing Cancellation Code when deleting Sales Orders into history through BOI

    Good morning all,

    So I figured this would have been a relatively easy script but I can't seem to find a way of accomplishing what I need.

    I have a customer that would like to force a cancellation reason whenever you delete a Sales Order into history…

  • UI Script drops first line

    Experts,

    I have a complex script that fires on the Panel PostLoad event of PLINES in SO Entry. The script colors lines based on some conditions and works great. It is based on a script that I got from a ScriptingClass a few years ago. The issue with my…

  • GetChildObject Method Works Differently in Button Script and in UI Script

    My A/R CashReceiptsEntry button script works from the DMAIN panel and the PLINES panel, but as an OnExit script on the PLINES panel it does not work.

    The symptom is that a GetChildObject method doesn't return the related record (from AR Open Invoice table…