Sage 100

I'm getting this error if I leave off the sales order number. I want to be able to enter the sales order invoice without a preexisting sales order. All the code seems to work and the data is being input into Sage, however the tax fields never populate…

Hello, I have taken over an existing installation that does not have any documentation or support on it. Our website uses a custom sync tool to push orders into Sage. Everyone once in awhile (10% of orders or so), I will see an error, "The column is not…

{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 I am trying to create an order using C# but I get an error with the "invoke" as below An unhandled exception of type 'System.Reflection.TargetInvocationException' occurred in mscorlib.dll Exception has been thrown by the target of an invocation…

Experts, I have a small app that writes to CI_Item. It has been working with no issues in Sage 100 v2017 Premium for my client in a Sage Server / Terminal Server setting. Now they are on v2020 Premium in the same setup (new servers), but we are running…

Hi All I am facing this error while running BOI "Error 65 in program SO_commonentry detail.pvc". can anyone please help to solve it?

Environment: IIS, .net CORE ASP.net web API, ProvideX.Script COM object (Sage 100/ MAS90 2018 v4.5), Server 2012 R2. Starting with the workaround first: so far my workaround has been to allow my IIS identity pool ID full access to the DCOM computer…

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…

I see some older threads discussing some in-progress ideas people were working with, as well as some libraries on the nuget packages out there - but there is no documentation on them that I can see. Does anyone have a recommended usage for them? Have…

Earlier this year I created a mobile application for pulling orders. To integrate, I made a rather barbaric implementation: when the mobile application backorders an item, update SO_SalesOrderDetail.QuantityBackordered = External.QuantityBackordered.…

Hi, I've been encountering the error "ProvideX object has been released" on posting production entries. Im using BM_Production_bus and BM_Bill_bus, and dropping those objects if there's any error/component mismatch on the BOM. Thanks!

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?

Hi, i've been constantly getting the error "System.Exception: <NewObject Error: 200>" when I register the BM production entries. here's what I have coded: oSS2.nSetProgram(oSS2.nLookupTask("BM_ProductionRegister_UI")) objTransactionRegister =…

How to get PurchaseOrderNo using PurchaseOrder Details & LineItems data from Sage 100 desktop application using C#? I have using DispatchObject and done login and select company functionality. Can you please help me to get PO detail using C#?

Hi all, I'm experiencing issues trying to new up a AR_Customer_bus object, my eventual aim is to be able to create a new customer using the BOI. The error I'm getting is a 200 error. This is my code so far, also note that I've written this off the…

Hello, I am having difficulty getting some code to work. I have found examples, but translating it to C# is making it harder to solve the problem. I am trying to export a sales order through the SO_SalesOrderPrinting_UI BOI. the following settings…

I am working on a C# .net desktop application that needs to be able to connect to Sage 100 2017 and retrieve available inventory quantities for all products. I've run into a complete brick wall trying to figure out how to do this. I have several questions…

Hi All, I have a custom module installed in Sage 100, I need to do insert in it using BOI script. Is anyone has any Idea how I can achieve it? your reply will be Appreciated Thanks, SF

I'm trying to read from AP_VendorElectronicPayment and not having a whole lot of luck. I've verified that electronic payments are enabled for the vendor, and I can access electronic payments settings using the same credentials as this code runs under…

We have been using Sage 100 along with the Scanco and JobOps modules for quite some time. We recently purchased a module from another ISV which requires some integration work to be completed to ensure they operate together without conflicts. We’ve tried…

Does anyone have any suggestions on the best way to use Microsoft SSIS (SQL Server Integration Services) to connect to SAGE 100 Business Objects API? We came across this product, but were curious to know what recommendations the community had. https:…

Hi All, I am getting this error "Missing record to calculate taxes." while trying to import Sales order in Sage using BOI. Has anybody faced this issue before? OR anyone has some idea how to solve this. Appreciated your help Thanks, SF

Hello, I am a developer, and we have purchased Sage 100 partner account. We want to integrate it with our app. Where we will fetch products related data to our system. However, I am unable to see any help regarding the REST API or integration tool. I…

Hi Everyone! We are going to be using Concur Standard to handle our company credit card expenses. The Concur rep told me to contact Sage and ask for a sample input file so she can customize our upload file to Sage's specification. I contacted Sage…

Hello Everyone I am New to the sage and looking for the C# integration with sage to read inventory data for the client. Our client have the SAGE 100 ERP software . Can anyone help me this and provide the some links for the same.