Browse By Tags

I'm using the line of code below, but I'm getting an error stating: "The Description is greater than 30 character(s)." No doubt this is because the step description is stored in the JT_WorkTicketText table (much like the CI_ExtendedDescription table)…

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…

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…

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…

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…

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…

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…

hi all, I am following example on this link https://www.sagecity.com/us/sage300/b/sage_300_erp_r_and_d/posts/launching-non-sdk-programs-from-the-desktop to create a screen using C#. I am able to create and working fine. However, the details is not looking…

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…

Hi Everyone! I try to edit Column Type Input and chose Enter but after saving error will goes like this Does anyone know if I am doing this correctly? Thanks!

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…

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…

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…

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…

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…

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…

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…

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

Hi SageCity, which framework can I use to have the same user interface as Sage 300, Border Size, Title bar color Example Sage Interface : My Interface :

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…

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…

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…

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…

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…

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…