Sage 100

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

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…

Hoping an old timer might have a c programming example to open the sage boi. I use CodeBlocks Have working VB, VB.Net and Lazarus (Delphi) programs working. Go ahead MAKE MY DAY!!! Happy holidays

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…

I am Tying to setup BOI but when i try running any script i get this error. here is the vb scrip that i am trying to run. Set oPVX = CreateObject( "ProvideX.Script" ) oPVX.Init( "C:\Sage\Sage 100 Workstation\MAS90\Home" ) Set oSS = oPVX.NewObject…

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

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…

Hi ALL, I want to get the order item's linekeyno using BOI script, is anyone has idea? How I will achieve it? Thanks, SF

Hi All, I am trying to import Salesorder into Sage 100 Using BOI interface, But I am getting an error while import line items "CHECK is not on file". I have an issue with the BOI Integration, Can anyone help me or give me a hint to resolve the issue…

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 All, Can anyone help me in getting a single record from Sage BOI script. I am using the following code but no data is returned. int taskId = (int)oSs.InvokeMethod("nLookupTask", "AR_Customer_ui"); oSs.InvokeMethod("nSetProgram", taskId); using…

Sage 100 2014 I'm starting to see double and need a clarification. With regard to calling a vbscript from an event or a Link button script on the Sales Order. In an event script, it seems the oBusObj is natively exposed to the script. Should…

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…

Sage 100 - 2014 Looks like Sage isn't accepting "class" in a postevent vbscript: Class SalesRep Public email Public name End Class Can't find anything in my docs about why

Hi All, I am working on a task where I need to transfer stock from one warehouse to other warehouse using BOI interface script but I am getting the error "ŠA valid warehouse must be entered at the Transfer To Warehouse field". Is anybody has any idea…

I want to create a cash receipt in A/R module with SData. I have identified the required tables for it. GL_CompanyActiveBatch GL_CompanyActiveBatch is read-only for SData, so I am not able to create the record here. AR_CashReceiptsDeposit…

I'm planning on creating a data type of boi connections for performance reasons. Currently my application adds parts to each company (we have four). The application spends too much time opening and closing sessions, objects etc. My plan is to…

Sage 100 2014 Access vba front end to Sage using com interface I just completed a log routing which traps fatal/non fatal errors and messages on all boi calls. Occasionally I get the following error "Object only available in online environment…

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…