Sage 100

Sage 100 Code: CI_ValGrpPORequired, Message: A purchase order number is required. when calling nSetValue with parameters InvoiceNo$, {InvoiceNumber} Could anyone please help me with the meaning of the error code CI_ValGrpPORequired. I have made…

I'm trying to create a production entry. It works fine if I add lines but if I don't add any lines I get an error message saying I need at least one line. In the Sage UI you can select a Bill Number and it pre-populates the lines, I'd like to do the same…

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…

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…

I've been working with the Sage 100 BOI for some time now and have done a lot of C# applications that interact with the BOI for all sorts of Sage 100 integrations. As we all know the "API" is pretty clunky. I thought about creating a class Library that…

We have an intranet page we'd like to write to Sage with via BOI. For years we have used BOI in .NET desktop applications (using a dll containing 'wrapper' classes written in VB.NET) and its worked great. However when attempting to use it from a web page…

We have no issues creating AR invoices in the ProvideX library with Sage 100 Advanced. We have several clients using our integration (all with Advanced). We were told our code would not need to change to support Premium (SQL). After setting up Premium…

We have no issues loading the ProvideX library with Sage 100 Advanced, however we're having an issue with Sage 100 Premium (SQL). We use the following c# code. It appears we're getting an error when it tries to invoke the Init method. Stack trace is…

Can anyone please help me with the business object for Credit card information and the tables in which it is stored.

Can anyone please help me in creating purchase order in sage. I tried creating it but the line items are not getting inserted and getting the following error "This Purchase Order has no lines and has zero total amounts". ARDivisionNo = WScript…

Hi Team, Can anyone please help me in getting the business object interface for creating Vendor purchase order in sage. Thanks

Hi, I'm trying to use vbs script to insert an entry into the AR_InvoiceHistory table using AR_InvoiceHistoryInquiry_bus object but I'm getting the following error: Can anybody please help.

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…

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…

I am getting this error when trying to add miscellaneous item of charge type for sales order in sage100c 2021 int TaskID = (int)oSS.InvokeMethod("nLookupTask", "CI_ItemCode_UI"); oSS.InvokeMethod("nSetProgram", TaskID); using (DispatchObject oCIItemCode…

Hello Team, I have an application and want to integrate it with Sage 100 cloud. I found the following specification: help-sage100.na.sage.com/.../index.htm As I understood, this API allows receiving all Account Receivables documents from Sage 100…

Hello Team, Could you please help me with the following questions? 1) Is it possible to integrate data from Sage 100 via web API? 2) Does Sage 100 have a cloud version? or it is just an On-Premise version?

is there any way by which we can achieve integration between ACT! and Sage 100?

Client upgraded from 2018 to 2020 and now can't import CAN (Canada) orders due to default Zip Code issue. Creating customer and importing sales order via Web Services. AR_Customer_bus column ZipCode$ is adding the default country code from Company…

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…

We have a customer that just upgraded their Sage 100 product to the 2020 version and are seeing some issues with integrating to our product. They migrating from Sage 2016. Below is a code snippet of where the issue is coming from. The error is “CI_NOF…

Is anyone out there utilizing HubSpot? And if so, are you transferring data both to and from Sage 100? Or just transferring data from HubSpot to Sage? Any problems with the integration?