• 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…
  • Sage 2022 Customer Maintenance Custom Tab List-Box

    Hi, I experiencing errors in customer maintenance on a custom tab. I'm using the debug window and found 1k+ lines on several clicks. Error:0 Error:11 Error:12 Error:13 Error:14 Error:2 Error:20 Error:23 Error:26 Error:27 Error:36 Error:65 Error…
  • 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…
  • 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…
  • 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…
  • 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…
  • 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…
  • Error printing SO using BOI

    Hello, I'm getting the error below indicating the module (S/O), company key (0000004), and the UI. I'm hoping there's something obviously amiss with the code below and that another set of eyes will spot the error. And a huge thanks to David Speck…
  • Is DeactivateProcedure usable on external scripts?

    I've used DeactivateProcedure on scripts running within Sage, but not on external scripts. I'm working on a script that requires me to disable procedures in SO Entry. I've tried a few variations, but I'm getting "Object doesn't support this property or…
  • BOI - Bypass Separate Check Popup

    I'm working on a BOI script to create Manual Check entries from a CSV. Everything can import successfully, except when the invoice was set with SeparateCheck = "Y". In regular UI, you get the popup message "The Invoice ____ is flagged for separate…
  • Copy invoice from AR_InvoiceHistory to flat file

    I have most of this script working but am hung up on the part reading from the line detail object. I have created a button on the AR Invoice History Inquiry panel so that the end user can find the invoice they want to copy, press the button, and the flat…
  • oScript.LinesAdded not working on version 2020

    Has anyone been able to use oScript.LinesAdded on a script in version 2020? I happen to be on 2020 with PU 1. I'm using it to refresh the grid on the Lines tab in SO Entry after adding lines, but it's not working. I have to go to another tab and come…
  • UDT eof error

    I'm getting an error stating " Error 20 Syntax Error. Program: SY_Commonui.pvc" when I loop through a UDT using a button script. Perhaps I have a typo or other mistake here. It appears to be crashing on the eof check (highlighted in green). Any ideas…
  • 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. …
  • 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…
  • Is it possible to create records in AR_CustomerDocuments and AR_CustomerDocumentContacts via BOI?

    Hi forum folks and Happy Friday! I have a customer that would like to CC a specific inbox any time we send SO Invoices and orders via Paperless Office. We have been doing this by adding this CC email to the "To Additional Email Addresses" Field under…
  • Accept SO MSScript Access Error

    I've got a user defined script attached to the Sales Order Header event Table Post-Write called UpdateSlxOrder. When you open a Sales Order and click the Accept button at the bottom of the window everything works fine. If you instead click the Accept…
  • 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…
  • Script will not get data from UDF

    I am trying to use a button to link to a website that is based on a number stored in my Sage Data. I know there is info in the field as I can query it from Excel. I know the script is pulling data as I can get the Order Date based on the order number…
  • Custom Panels Disappeared, need help!

    Hello, We have added many panel customizations including additional tabs, buttons with scripts, etc that are important for many of our users. I was just resizing a field in customizer, and when I went to exit the customizer an error popped up saying…
  • AR Invoice Header PreWrite script not working correctly during Repetitive Invoice Selection

    Sage 100 Advanced 2018. I have a script designed to fire on AR Invoice Header PreWrite: If a BillTo account is specified in Invoice Header it should confirm the checkbox UDF_BTST is checked in AR_Customer, and if not should displays a message reminding…
  • Script to change payment type works for all except "Credit Card" ?

    Hello, I am working on a script to change the payment type based on the terms code that is entered in the sales order. This script fires fine for setting the field to "None" or "Check", but when the script is supposed to change the value to "Credit…
  • GetChildHandle from PO Entry for IM_ItemVendor_svc?

    Hi All, I'm grabbing the value of a UDF during PO Entry on the lines, and it's working with the below code, but I was looking for a way to access it using the ChildHanlde, but I haven't figured out how to do it. Any ideas out there? What would I fill…
  • Script to transfer data to secondary company

    Is it possible to write data into different company within some Sage 100 company. For Example add a button on Sales Order Entry to copy order to secondary company. I know how to do it outside of Sage with a script but not sure if session to different…