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.
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…
Hello, getting an error: Invalid or missing header on the code below- can anyone provide a working example of creating a purchase order in BOI? using (var sySession = new MasSession(homePath))
{
sySession.InitSession(sessionLogon);
CI.ColumnNames…
Hello, I am trying to setup BOI (first time trying this) we are running Sage 100 Premium 2021 (ps. this hasn't been tried done before this). I am following along with the Object Interface course from Sage. Im entering the Path to our Sage Folder as stated…
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 Team, Please, help me with this scenario.
Scenario:
Order is already created in the ERP
Using BOI, write an Invoice to ERP that Integrates into an Order (The invoice will contain the Order document number(DO_Piece)). a) This invoice can also…
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…
We are encountering an issue where CIM Cloud web orders are successfully pushing to the ERP Driver but is failing to create a BOI session. Any suggestions on what other pieces we can troubleshoot before reinstalling the ERP Driver?
What we have tried…
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…
When attempting to create line items for a Inventory Transaction Receipt batch I'm having issues when I attempt to update the distribution. my code was working on Sage 2018 but they are upgrading to Sage 2021 and it now throws an
System.Runtime.InteropServices…
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 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…
Looking for a Microsoft Power App expert who can develop a power app application that will fetch data from the SQL database in bulk and then send that data to Sage 100 ERP via Sage 100 API connector which is already installed. Data to be picked and sent…
I'm currently trying to integrate SO_Invoice using BOI and needing to override pricing on the line item,
below is snippet of the code on the line level
retVal = oSOInvoice.oLines.nAddLine()
retVal = oSOInvoice.oLines.nSetValue("ItemCode$", "XX"…
We are looking at a Third-Party software called Master Control for our QA/QC documentation processing. With that, we want to be able to extract data out of Sage 100c Advanced v2019.2 (upgrading to v2021 shortly) from Scanco's Manufacturing module, as…
Hi,
We are looking for consultant to help in installation of Sage API into our sage 100 2020.
Please check below link for understanding:
www.sagecity.com/.../getting-started-with-the-sage-100cloud-custom-connector-for-the-microsoft-power-…
Hi, I'm trying to write a code to create a new invoice from PO
set the key ReceiptType$
set the key ReceiptNo$
call setKey()
set PurchaseOrderNo$
set InvoiceNo$
Now i want to add the lines of the po to the receipt. In addition, i want…
Experts,
I need to establish an object handle in PowerShell to a UDT. I know how to do it in VBScript. Does anyone know the proper syntax in PS? If not C# would be helpful as well because I could try to figure it out from there.
For regular object…
My apologies if I'm not in the correct forum for this. (It seemed to match the best from the list I was presented with.)
I'm looking for documentation on building modules to run from the Sage 100 desktop. I've taken a number of the courses (including…
{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"…