Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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…
Using Sage 100 Advanced 2023 and the Production Management Module, I am trying to use BOI to update the Quantity Ordered on a Work Ticket but want it to automatically trigger the rescaling of labor and materials like it asks when you change the quantity…
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…
I've noticed that we have just over 14,000 records in the SO_SalesOrderHistoryDetail table where the SalesOrderNo field is null. This is causing some issues with trying to do a copy into a MySQL database due to the Primary Key not accepting null values…
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…
I started working here 3 years ago, and there was an existing Sage 2016 installation. I've been meaning to upgrade it since I started here, but just haven't taken the time to do it. Yesterday I received a threatening email from Sage about TLS, and there…
I am writing an API in C#.net, that POSTs sales order entries to Sage 100, using BOI. I am using much of the same code that I've used for other integration projects with success. The client for this project is upgrading to Sage 100 2022 Premium- and testing…
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…
I am on Sage 100c Standard 2016 (Version 5.30.5.0) (yes, I know it is very old, and have plans to upgrade to a supported version). I am attempting to create a program in C# that creates a sales invoice from a sales order.
When my program executes the…
Is there a way to get a list of all the business object names for a table from the Sage 100 BOI? The SY_File object from the FileObj property on the session object seems to have methods to get a list of all the table names. Looking to expand on that where…
{solved}
The error was in my KeySet() line. Instead of:
var retval = Core.SageObject.Process(pcObject.InvokeMethod("nSetKey", ""), pcObject).ReturnCode; It should have been:
var retval = Core.SageObject.Process(pcObject.InvokeMethod("nSetKey"…
Hi everyone, would you please have a look at this and see why this is running erratically? I've seen some sample scripts here and there, and the bulk of my script is from the other posts on this forum. I must be misunderstanding what objects and what…
I see that there are lots of questions about this in the past, but I can't seem to find a concrete answer on how to move forward with it. I realize it has something to do with DCOM, registering the DLL, running client side verse server side.... But I…
Experts,
I am able to create Sales Order, Sales Order Invoices, and AP Invoices via BOI without any issues. I am missing something about the order of things for PO Receipt of Invoice. Here is an excerpt of my code (it's in Powershell, but the methods…
I created a button on the Vendor Maintenance screen that runs the AP Aging report. I pass in the AP Division and Vendor numbers, but I can't get the report to filter by those values. (Want to run the Aging for the Vendor displayed, like the Sage button…
Hello,
We recently ran into a problem while importing AP invoices as a batch. Here is a summary of our code in C#:
// Loop though AP invoices a batch
foreach (var invoice in batch.NonInventoryInvoices) { try {
service.Call("nCLEAR"); service…
Hello
I am trying to find any doc on "oScript.Execute", i am facing an issue i want to call a 3rd party app and want the script to wait till the exe completes its execution. Thanks
Hello Every one
I am running a script to get line level values in sales order,
I am getting a "OLE error 424" error, can any one please help
Code:
******************************************************************
Dim taxReqXML Dim intx dim…
Hello Everyone,
I am trying to run a 3rd party exe on a button click using VB Script ,
The code is trowing (OLE ERROR -2147024894)
i have added the code and also the error message i got
********************************************************…
Hello Everyone
I am trying to update UDF in sales order line using script, i am not getting any error but it's not working
i am adding the the code that i am using
any kind of help will be really great
Thanks
____________________________________________________________________________________________________________…
I am hoping there is someone out there with an ability and willingness to help me.
As a Master Developer with have not really had much need to develop things using BOI since we can always modify the code if needed. We have taken the class and we are…
Hello
I am trying to read data from SO_SalesOrderDetial
i tried setting key value to read data for a given sales order
i am able to get data using GetResultSet but i am not able to read values like price , ordered etc
and when i am trying to use…
Hello
i am trying to read data for each line in sales order and i am getting a error , i am not sure why i am getting this error cause the same code is working for few lines but not for few
this is my code ##################################################################################################…
Hello
I am trying to edit a existing sales order using BOI,... i am able to make header level changes but when i am trying to change line level data ( ie: item code) a new line is getting created....
And when i am trying to add a new line and over…
hello
i am trying to override tax of a sales order ,, i have used the following code
*************************************************************************************************************************
Public Function sales_details() dim xx…
