Sage 100

I want to improve error handling in a script I have. How do I remove a unposted invoice using BOI. I couldn't seem to get the Delete function to work.

I have built an order importer that automatically creates sales orders based off of an EDI file from our customers. It works great. We are currently upgrading Sage 100 to include Production Management Plus and I want to be able to add in the ability to…

Sage 100c Advanced SQL 2018 6.00.5.0 So I think this is happening because of me... Before last year, when we pulled orders on paper, we would take the sales order and move it to invoicing, then key punch all of the backorders on the Sales Order Invoice…

I am running the following VB scripting: do while not RS3.eof ARDiv=trim(cstr(rs3("Field1"))) strCustNo=trim(cstr(rs3("Field2"))) strContNo=trim(cstr(rs3("Field3"))) If strContNo="" Then strContNo=" " End If retVAL = oSS.nSetProgram(oSS.nLookupTask…

I am trying to use PowerShell instead of VBScript to access Sage via BOI. I am able to login, set the company, set the module and get a handle to the table I want. But I am not able to retrieve values when looping through the table. I tried multiple variations…

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…

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

I have finished the "100E - Sage 100 - Object Interface Course" on the Sage University site. With this I was able to send items and sales orders from my C# application to Sage. But I also need to send work orders and work order lines to Sage. …

Hello all! First post so I'm pretty new to this. My first foray into BOI programming is trying to create a warehouse transfer from one warehouse to another. It looks like the process completes without errors and that when I look at the Quantity in Item…

Running what should be a simple Transaction Entry test for BOI. I can create all the object I need, test for and create the Batch. Set Key values. But the call to SetKey is continually returning 0. Last Error Text is 'Missing or invalid Header' and…