Sage 100

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…

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…

Hi everyone, would you please have a look at this and see why this is running erratically? I've seen some sample scripts here and there, and the bulk of my script is from the other posts on this forum. I must be misunderstanding what objects and what…

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

Hello I am writing script to create invoice using BOI,but it gives error when writing Line items "Missing or Invalid Header".Can someone help on this. My code snippet int TaskID = (int) oSS.InvokeMethod("nLookupTask", "SO_Invoice_Ui"); oSS.InvokeMethod…

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

Hi All, I am trying to enter a Sales order in Sage 100 using BOI with .Net program, I have the problem to handle the "Entry exceeds available quantity" pop up. I am searching for a method but I am not able to find it. Is anyone has an how I can…

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…

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…

I am trying to write good error handling for the connection to Sage 100 in VB.Net. I have the following code: Dim pvx = New COMDispatch("ProvideX.Script") Try pvx.InvokeMethod("Init", Path) Catch ex As Exception Dim lastErrorMsg = pvx.InvokeMethod…

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 have an issue to import RMAs few field, All the information get inserted but just EmailAddress and Fax Number not get inserted using BOIs, I am using COM APIs with the C#.Net Can anyone please help me to resolve this issue? Or Can give me…

Hi ALL, I am using BOI with the C#.Net code to import data into Sage 100, I tested the program in with the test company, Now I am trying to import data into the other company but it still importing data into the test company. I changed the company code…

Hi All, I need to update some details of the ReturnHeader object and Return Details object. I am trying to use "nWrite()" method to update records. But it is not working. Can anyone help me out to solve the issue, Please? Thanks, SF

Hi ALL, I want to add the TaxSchedule in SalesOrder according to the ZipCode. When I creating a Sales Order manually it works, But if I creating a sales Order entry using BOI with C#.Net code it is not working. Can anyone advice or give me hint…

Hi ALL, Can anyone please share with me RMAS import code using BOI ? It's really urgent, Please give me hint or source code. Thanks, SF

Hi ALL, I want to call a GetFirstShipToAddress$(div$, cust$) method to get the Address which has customer number, How do I pass parameters in this method using C# code? Please can anyone help me to resolve this? Thanks,

Hi ALL, There is a field called "User" on the Top right on the Sales Order Entry screen. Can we pass the values of that field from the BOI programming? And Can please tell me that it stores into which table? Please help me by giving hint to resolve…

Hi All, I am getting this exception "System.Runtime.InteropServices.COMException: <NewObject Error: 90>" on the below code line, It is working fine in 2016. but on client machine it giving me an exception. oSS = pvx.GetType().InvokeMember("NewObject…

Hi I am new in BOI integration with the C#, Can anyone share with me sample code for the delete a record from the Sage MAS 90 using C#.net? Or if you have any good reference document please, I google much about I did not find anything helpful. Please…