Sage 100

I need to get customer data from sage100 using .Net code. I went through https://help-sage100.na.sage.com/2018/FLOR/index.htm but could not understand the functions as there was no clear instructions. I managed to get data from two columns using a sample…

Good Afternoon Does anyone have feedback on Scanco Warehouse as a solution to automate receiving inventory transfers and shipping? If you have experience with this product would you recommend it? We are struggling with the decision as the receiving…

Has anyone done any integrations or been asked to do any integrations with Bill.com? I have had several inquiries as the Bill.com site has the Sage logo, but the integration they offer is for Intacct, not Sage 100 ERP. I have mapped it out to be able…

Hi all, We've been using Starship for years but in the last week have experienced major delays and performance problems EXCLUSIVELY with their integration (meaning other 3rd parties like ScanForce, Avalara, Paya, TrueCommerce, Insynch, etc.... are performing…

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…

Has anyone successfully been able to link there Sage 100 to email invoices from their Lotus Domino Server? If so what configuration did you use?

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…

I'm exporting column names in my Visual Integrator export. I need to rename one of the column headings, but I can't seem to find a way to do that. Anyone have any suggestions? Thanks!

Where do I start? We are a manufacturer and I purchase raw materials and sell the finished product. I currently use the sales order module for sales orders & invoicing. I need direction and recommendations.

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, We are using SAGE 100 2018 Version for the last 5 years. We would like to integrate the following records from SAGE to Odoo using API. Can anyone let me know, whether integration is possible for this records. 1. Customer 2. Work order …

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…

So I've got SData installed and working. I can ping AR_Customer to get a list of customers. However, attempting to post to this endpoint with the following body fails: Of note, I've slimmed down the payload to only what is known to be the simplest required…

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…

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…

Upgraded from Sage 100c Advanced v2019.2 to v2022.1 on new Win2022 ERP server and separate Win2019 Citrix server. When we import EDI PO's from True Commerce Transaction Manager v2 integration into Sage 100 which become SO, of course, we get duplicate…

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…

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

var sessionLogon = new SessionLogon { CompanyCode = companyCode, UserLogon = new NetworkCredential { UserName = userName, Password = password }, ModuleCode = ModuleNames.AccountsReceivable, ModuleDate = DateTime.Today }; using (var…

My team has been using desktop Sage 100 (2021) to enter purchase orders to generate sales orders, but we would like to do this via API. https://help-sage100.na.sage.com/2021/FLOR/index.htm#Program_Listings/Program_Listings_Overview.htm?TocPath=Program…

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