Sage 100

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

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…

I'm running Sage 100 Premium 2020 version 6.2, and have Sage 100 Premium Intelligence 2015 installed. Our IT department installed office 365 yesterday, and now I'm getting an error message in excel about the BI extension. No values in cells in my intelligence…

I'm working on an integration for a client and am trying to create PO Receipts using c# and Sage 100's BOI. The end result shows the vendor when I look at all PO Receipts, but the receipt is empty when I view the full receipt Here are the current…

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…

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!

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…

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…

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

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…

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

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

I am getting the following exception while creating the sales order with SData. Same is working in Dev environment but not working in Stage environment. What could be the issue? Error in E:\Sage\Sage 100 Advanced ERP\MAS90\SY\SY_SDataServer.pvc at line…

Hello I am trying to edit a AR_invoice using BOI in VB.net i have tried to set key but no matter what i try i am getting some kind of error can anyone please help me out on how to set key for a ar_invoice that code i used : If Not (CBool(ar_invoiceObject…

Hi All, I am trying to import the Sales invoice into Sage 100, using Business object interface. using below code. using(DispatchObject oARCustomerEntry = new DispatchObject()) { object retVal = 0; object[] nextSalesOrderNumber = new object[] { …

Years ago our master developer provided us with a copy of Interop.ProvideX.dll for a .net application we have. The file is from 2009, it works with Pvxcom.exe. We are having issues with this version (leaving too many copies running, crashing in the middle…