Sage 100

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?

I'm having issue trying to get into Customer Maintenance from Script. This was working before, but has become an issue over the last week or so. I don't remember changing anything. Maybe you can spot check me to see what i am doing wrong. Shell (…

Hi, I've been wondering for a couple of days now. it seems that the Distribution line is adding a bunch of numbers on my Lot. retVal = oProduction.oLines.oDistribution.nAddDistributionLine("B456") oProduction.oLines.oDistribution.sLastErrorMsg says…

Hi, So i've been trying to put an entry on BOM Produciton entry, it seems to be having an error with the Distribution part. (im using an item with Lot Valuation) retVal = oProduction.oLines.oDistribution.nAddDistributionLine("B456") retVal = oProduction…

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#?

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 took the BOI class, but that seems to be intended as a high-level overview, not so much a function-by-function breakdown. I checked the documentation, but it just says "Set module date". Not exactly helpful. So, what's the effect of setting the module…

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…

I want to lookup clients ship to address and give the user choice to select a exiting ship to address. Looking for example or more information about SO_ShipToAddressInquiry? Morris

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

Hello Everyone, I am trying to figure out how to know what is the cause of an error that will not let my software create a payment record for an incoming Sales Order. The error I got from the business object is: "Error Creating record from table…

Hi All, I am very new to Sage products. However, my agency is very interested I developing a bridge between sage 100 and Magento 2 product. Can you please give me some more information about from where I should start this journey of developing this…

Hi all! I'm working with the new BOI capable PR module and having trouble sorting out how to add detail lines. I seem to have worked out creating a transaction, at least the batch I create does end up with an entry for the employee I am adding to…

I am just starting out on my Sage 100 journey to help our Sage admin automate a few processes. So, please bear with me as my knowledge is limited... We are on Sage 100c Premium 2018 (Version 6.00.3.0) I took the Intro to BOI class in SageU which was…

I have built an API that can insert orders into Sage 100. API will not work on when deployed to any IIS the web server, with a NewObject Error: 200 error. This happens when I try to invoke SY_Session I realized that this error occurs even on my local…

Verify the application is installed and running. Contact Sage 100 Customer Support if the problem persists Has anyone seen this error before? It is happening when I try to write a sales order with SO_SalesOrder. It happens on the nWrite. It actually…

I have a client who I am building a new website for and they are asking me to integrate with the Sage 100 API, in February 2019 they will be moving to Sage X3. My question is how similar are the APIs. This is just going to be inputting sales info into…

I'm doing preliminary research on what kind of API we can use to integrate with Sage 100 ERP. I've discovered Sage_Certified_Solution_Requirements.pdf with several statements about automation: Automation: Certified applications must offer automated…

Hello, I'm inserting invoices for a client and they have requested that they all go into the same batch. I can't figure out how to create a new batch and keep using it. The best I can come up with is creating a new batch for each invoice. I pull…

I am fairly new to Sage, went through the Object Interface class at SageU.com. While running the example I am getting an error <NewObject: 200> whenever there is a call to Invoke Method on "AR_Customer_svc". Using Win 2012 Server, Sage 100 - 2014 with…

Sage 100 ERP Version 5.00.8.0 The following code fails at the call to nProcessReport returning 0 and LastErrorMessage is blank. using (DispatchObject pvx = new DispatchObject("ProvideX.Script")) { pvx.InvokeMethod("Init", @"C:\Sage\Sage 100 Advanced…