• How to Flow a UDF from Sales Order Header to SO History Header Reliably

    With identical UDF names in both tables, the original value set into the SO Header UDF via a ColumnPostValidate script from a standard field works to flow the value to SO History Header, but subsequent successful updates directly to that SO Header UDF…
  • Sage BOI SO_PackageTrackingByItem_bus

    I am attempting to write a Sage BOI VBS program to read and write to the SO Shipping Data Entry Package Tracking By Item object and am receiving the error <NewObject Error: 200>. I am using a Sage user that has full access to Sage and have the company…
  • Sales Order lines Promis date - getting line key is read only message.

    Hi Forum, I've been trying to update Standard Sales Order line promise date from Master Order Lines with no luck. I am getting The Promised date from the last line in the Master Order updated only, all lines on Standard order with same date. Here…
  • DocumentTotal Bug?

    I should start off by saying we are still on v2020 for compatibility reasons. It appears that the `oBusObj.DocumentTotal` property (Sales Order Bus) doesn't calculate on quotes (it's value is 0). Is this intended behavior? The moment I change the order…
  • Can I write a script to show what is the error on the BI button MS Script I created

    Dear all, Is there a way to have a short script alone with the BI script to show error message on why my script doesn't work. In other word, how to trigger error message on a BI script, something related to this code - oBusObj.LastErrorMsg. Correct…
  • Update UDT from CI_Item

    After reading a few post about updating UDT's from scripts I am wondering if my events are wrong or do I need to SetKey before SetValue? In the debug I couldn't get any return values, so I am guessing my events are wrong, I've tried a PRE-WRITE and a…
  • Error 88: Invalid/Unknown property' on reference to a business object from within the same object

    'Error 88: Invalid/Unknown property' on reference to a business object from within the same object I am trying to browse the records in the 'SO_SalesOrderDetail' from within a Column Pre-Validate script on ItemCode in the same table'. This works from…
  • nFind returns 0 for AP Invoice lookup in AP_OpenInvoice

    I hope this is something easy that I'm overlooking. I'm looking up an invoice in the AP_OpenInvoice table that I know exists. I have confirmed that I'm passing the correct vendor division, number, and invoice number. But I'm getting a 0 return value.…
  • get control property list box focus not available

    Hi, The list box control property is not available, why is that?. My line of code: getCtl = oUIObj.GetControlProperty( "MyListBox", "Focus", ctlPropMyListBox ) If ctlPropMyListBox <> 0 Then Call SomeFunction End if Thank you, -SKG
  • Read validation configuration of UDF

    Hi, When creating UDF we can specify that its validated against: - none - range - list - user-defined table Im trying to find a way to get the name of the UDT. In order to get range/list values in c# its enough to do something like that…
  • get control property list box focus

    Hi, No return value for list box focus event property. How is this property trigger, by clicking on the list box control? Any information would be helpful. Regards -SKG
  • Exit Table Updates Properly?

    I have encountered a strange issue with a button script that enters data into a UDT. I have been using this script in testing for about a month now and it hasn't had any issues until yesterday - even after a server restart. The first time clicking this…
  • Change order of Sales Order Lines

    HI, I have a request from a client to sort the Sales Order Lines detail section by Item Code. I feel like I should be able to do this with a script, but not clear on what Object to reference. Can someone give me a hand, perhaps point me in the right…
  • Sales Order import bypass VB scripts

    Is there a way to determine if a Sales Order is being imported, so I can bypass VB Scripts?
  • PostLoad SetControlProperty

    I have two UDTs that are being used to manage credit releases. One contains the credit release data and the other is just used as a validation table that contains status codes and their descriptions. In SO Order Entry there is a UDF that uses the main…
  • IM_Itemwarehouse Message box

    Trying to figure out how to get a message box to pop up in SO entry when a user enters a line for warehouse '000' for example, however there is 0 available for that item in warehouse '000'. On that same item we have 2 available in warehouse '001', I would…
  • Customizer- I would like to add a UDF to the AR ship to screens

    I have been looking for the table that is linked in AR Customer maintenance/Ship to. I need to add a UDF field to the ship to screen so when the ship to codes are added and created for a customer we can add another email field we can map to Starship.…
  • Vendor Customer Purchase Report

    Morning, We have Sage 100ERP, I am looking to see if there is a way to create a report by period that shows how much in sales per vendor. So we are a distribution company and we purchase products from several vendors, and then sell those products to…
  • List Box Control.

    Hi. How do I add column headings to a listbox and set the columns so that user can resize. I'm using, ListBoxLoad(listBoxName$, value$, delimiter$) mehtod, no problems loading the data from a UDT My SetControlProperty( lbx, "FMT", "L20 L20 L20"…
  • Script to Loop through Invoice History Lines

    Hello, I was hoping to get some advice on scripting the BOI via a Button script that was placed on S/O Invoice Data Entry that would act as a "Quick Tax Credit" button. We use a third party cloud vendor to calculate our taxes but that shouldn't affect…
  • Screen Manager - Error in definition of screen item: PADDRESS 1315

    One of my users is getting this error message when trying to do SALES ORDER ENTRY. It says the Bill To Zip Code is greater than 10 characters. But it is not. Does anyone know how to fix? Its weird, cause when i log in to the account from my computer…
  • External Script to Create Cash Receipts Batch

    It's me again. Looking into using VBA or potentially a vb.net windows form app to potentially create and update Cash Receipt Batches & Deposits. External scripting documentation seems to be pretty limited and I am not sure where to even start when it…
  • Grabbing the Currently Selected Invoice from Listbox

    In Customer Maintenance's Invoice tab I am wanting to allow accounting to have the ability to edit the Comment field from the AR_OpenInvoice table. Since this isn't the history table, it wouldn't affect the comment line for invoice history reprints, so…
  • Sales Order To PO Address and lines button script

    Hello everyone, I'm stuck on a problem. I wrote a script to run from a button on the address tab of Purchase Order Entry. I made a field to collect a Sales Order number that the user types in the clicks the button to generate the ship to address from…
  • Prevent Change to Different Division

    We use divisions and sometimes the users will copy a previous sales order and change the customer. The problem comes in that items on the sale order are coded to one division and if the new customer is in the different division it creates a problem with…