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.
Good Day,
I hope this message finds you well. I am currently facing an issue with a control I've created in MS Access that interacts with Sage100 (Standard 2020 v6.20.4). I'm reaching out to seek your assistance in resolving this matter.
The control…
Hi,
I would like to extract the customer data from customer master using business objects. Can someone let me know, how to do the same.
We are planning to integrate the customer master from Sage to Odoo
On sales order invoice items can successfully use BOI to retrieve the SO_Invoice items, and for each item access the lines, however have not been able to collect item serial numbers for each line. For reference a screen capture showing these serial numbers…
Hi, having a c# app to connect to Sage100 via BOI.
Was working well till my password expired and login was not possible due to this error message in oSS:
The password for this user has expired. Do you want to change your password now?
What I did…
Will 32 bit COM/OLE interfaces work with Sage's 64 bit version of ProvideX?
Will the 32 bit version of ProvideX be deprecated and no longer supported once the 64 bit version becomes the standard?
Is there any plans for a SQL version of 100 as a Standard…
I understand this is an issue going back to version 2013. We are creating Sales Order from Shopify using BOI scripting and randomly receiving the error. Has a resolution and additional information been made available.
Hi all!
Not following how to get list invoices for selected sales order. Was checking AR_InvoiceHistoryInquiry_bus - InvoiceNo is laways a part of the key... Same for SO_ARInvoiceHistoryLink_bus
Can't go with SO_InvoiceHeader because its already…
We're currently using the Sage100 C# NuGet package noted below.
We've run into a situation whereby a miscellaneous item (CI_Item) is visible in the UI and via OBDC connection however, we're unable to find the item using the MASRecordset utilities…
Hi Experts,
I created an integration that pulls CSV files with AP Bills from an FTP server and imports those into Sage 100. Every time the script runs it imports 20 to 50 AP Bills. The bills are often for different company codes, so the integration…
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…
Background: We're using the C# NuGet package.
When I have a session object (Sage100.ObjectManagement.MasSession), I'm able to do the following (though, actual creation inevitably fails because of needed line items).
var createObject = session.CreateObject…
I have a C# dotNet 4.8 web application providing API services into Sage 100, working fine at multiple sites. At one customer, the Sales Order BOI seems to ignore the ShipToAddress fields on the sales order. Avatax and Scanforce are installed on this site…
Hello,
We just recently upgraded to Sage 2018 to 2021 and our third-party web service(Deposco) sale order imports are now having issues after migration.
Error response: FAILED : Exception: Error trying to set property BillToZipCode$ with value 46550…
I am new to this so please bear with me. I have the following script ( i can only post a portion of the code. The SPAM blocker flagged it as malicious) that is used to update two UDF fields from a .csv file. It is called via a custom application. I am…
Using the BOI and trying to loop through all Sales Orders and, for each Sales Order, loop through all lines. Have it working however some orders are in a state such that, if opened from the Sage UI, a popup is shown with text like:
In the UI, I can…
Hi All,
I am having an issue running PO_ReceiptRegister_upd. I am trying to run the Receipt of Goods Register from BOI.
oSS.InvokeMethod("nSetDate", "P/O", date);
oSS.InvokeMethod("nSetModule", "P/O");
//DispatchObject security = new DispatchObject…
I am tring to write multiline extended description of product but not able to write it using description. i used \r\n and \n for carrige return or line break but it ignored and description come with single line.
We have a python (3.10) application that we want to use to create a sales order in Sage 100.
I have installed pywin32 so the python script can access win32/COM.
This code works up to the point where I try to call a method on the SY_Session object…
Wondering if there are some flags/properties in the BOI object that can be used to determine if an update (CI_Item in this case) are
coming from a Sage Application user or from a BOI program within a Pre-Write script.
psuedo=allow spaces when coming…
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…
I have a C# code that integrates with Sage 100 2021 Standard.
After performing some action I want to clean and close the session I opened. for this I'm using:
session.nCleanup();
session.DropObject();
for some reason the nCleanup() returns null…
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…
Hi Forum,
I need to write a BOI script to update a PO Line UDF from an external Data Source.
My question is, how can i get the line to update the UDF, i wrote a little script to update the line but i get the message that the o.oLines is in read…
Hi Forum,
I am importing SO Invoices with a BOI script, imports fine but i cannot get the Sales Order Number to update.
I have 2 scripts, one to import invoices (I cannot set the SO # here, no error just no SO value in the Invoice Header).
the second…
Hi,
I want to loop through all my not-registered invoices.
What I do (in general) is:
dynamic obj = pvx.NewObject("AP_ManualCheck_bus", oSession);
obj.nMoveFirst(); //To get to the first record
//Rest of code
The problem is that I have…