• Non-existent items

    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…
  • Looking for a Microsoft Power App expert

    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…
  • Best option for extracting data out of Sage 100 into Third-Party software

    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…
  • Looking for consultant to help in installation of Sage API into our sage 100 2020

    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-…
  • Is there any way by which we can achieve integration between ACT! and Sage 100?

    is there any way by which we can achieve integration between ACT! and Sage 100?
  • Documented needed to help create new modules

    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…
  • Hubspot

    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?
  • Invalid or missing posting date encountered on Bill of Materials transaction update

    Hi, I've been working on automatic registration of transactions for Bill of materials. but I've been encoutering this issue for a couple of days now. its been throwing me an error that says "Invalid or missing posting date encountered" I opted…
  • BM Production register Error "The register must be printed prior to posting"

    Hi, I've been wondering if someone else encountered or might have a solution for this. Im getting the error "The register must be printed prior to posting" oSS2.nSetProgram(oSS2.nLookupTask("BM_ProductionRegister_UI")) objTransactionRegister…
  • BM ProductionRegister - New object error:200

    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 =…
  • Getting Available Inventory Quantities

    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…
  • Ar Cash Receipts using BOI

    Hi community! I need some help. I have an almost perfect code here in C# posting a payment in cash receipts. The only problem is that the batch amount is duplicated. The batch total is $520.00 instead of $260.00. What am I doing wrong? Here…
  • SSIS (SQL Server Integration Services) Connector to Sage Business Object Interface (API)

    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:…
  • Integration of Sage 100 to my rails application

    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…
  • NewObject Error: 200 error when deploy BOI insert order API, works fine on visual studio. However when deployed to web server, even local IIS, COMException (0x80020009): :<NewObject Error: 200>

    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…
  • The Database and WorkStation are on different server, How to connect Provide X using BOI?

    Hi All, I will have to use BOI to import customers into Sage 100, Normally the Database and the Workstation are on the same machine, so it will easy to connect ProvideX using BOI and import the records. But the problem is we have the database and…
  • pvxcom.exe becomes unresponsive to BOI

    I am running a set of business object commands to print a report. Sometimes the commands run without any problems and my report gets printed. If I run the report over and over, about 1 out of 5 times I make it through to the step where I call NewObject…
  • Create a Credit Card Sales Order in Sage 100 ProvideX, C# using SO_SalesOrderPayment_bus business object?

    I have recently found how to add a new credit card to Sage100 and the exchange vault without using the exchange vault’s extra UI, screen. I insert new cards into the system behind the scenes using my own custom windows software written in C#. I now need…
  • nProcessReport returns 0 and blank last error message

    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…