Sage 100

I've noticed that we have just over 14,000 records in the SO_SalesOrderHistoryDetail table where the SalesOrderNo field is null. This is causing some issues with trying to do a copy into a MySQL database due to the Primary Key not accepting null values…

Hi, I want to read and write data in sage100 database, so after some research I found out this course for reference. But just need to validate that is this course really guides on how to read and write back data to Sage100 database or not? This…

Hi, I am new to Sage100 and customer is using Sage100 advanced which comes with ProvideX ODBC driver which only allows to read data from Sage100. I did some research on the functionality to write back the data in Sage100 but was not able to find any…

Looking to have Sage Alerts and Workflow create a PO in Sage 100. It's my understanding that the Sage Alerts Workflow module has collection of API's that can update a database but Sage 100 Providex is difficult to write to and that Sage 100 does not have…

I'm using "sage 100 Standard 2019" and Version "6.10.0.0" I tried to get "Item Maintenance details" from I nventory Management - > Item Maintenance . I'm able to get 'Item code value' and 'Qty values(pl refer screenshot1)', but I need to get values…

Hello, We recently ran into a problem while importing AP invoices as a batch. Here is a summary of our code in C#: // Loop though AP invoices a batch foreach (var invoice in batch.NonInventoryInvoices) { try { service.Call("nCLEAR"); service…

HELP Any reason this is not writing back to the lines? It thinks it writing. oSEC = oSS.nSetProgram(oSS.nLookupTask("SO_SalesOrder_ui_ui")) Set o = oScript.NewObject("SO_SalesOrder_bus", oSS) r = o.oLines.nMoveFirst() Do Until o.oLines.nEOF = 1…

Is it possible to write a "/C" comment line item to a sales order using BOI? If so how? The VB code I am currently using is more or less this modulo checking response codes and logging: Dim oSOrder As Object Dim sItemCode As String Dim sQuantityOrdered…

Hi, I got this "The Records is not in editable state" Error while delete details from SO_SalesOrderDetail_bus object. Please anyone give hint to solve this issue. Given below is my code int TaskID = (int)oSS.GetType().InvokeMember("nLookupTask…

Hello I am trying to read data from SO_SalesOrderDetial i tried setting key value to read data for a given sales order i am able to get data using GetResultSet but i am not able to read values like price , ordered etc and when i am trying to use…

Hello i am trying to read data for each line in sales order and i am getting a error , i am not sure why i am getting this error cause the same code is working for few lines but not for few this is my code ##################################################################################################…

hello i am trying to override tax of a sales order ,, i have used the following code ************************************************************************************************************************* Public Function sales_details() dim xx…

Hello, I am new to sage100 BOI and i am trying to understand the workflow of BOI, i am able to read data of a customer from sage but when i am trying to change a value i am getting error's This is a sample code that i tried: '****************…

Hello Everyone, I am trying to build a 3rd party C# application for my client on sage 100, i read several things but was not able to achieve this, i have been trying few sample codes to connect with sage using BOI but i am not able to read data from…

Is Company ID from ODBC login available?

We're currently on Sage 100 2014 (Non SQL) and we're currently running into the issues where we are being sent names containing certain ranges of extended ascii characters. For now, we are going to limit ourselves to the first 127 in the ascii table…