Sage 100

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…

I have a UDF on SO_Detail table I'm attempting to populate with a BOI script (written in C#). This field is set to datetime type, the data I'm sending is being parsed from string to datetime format in the script. I'm sending the SalesOrderNo, user credentials…

I see that there are lots of questions about this in the past, but I can't seem to find a concrete answer on how to move forward with it. I realize it has something to do with DCOM, registering the DLL, running client side verse server side.... But I…

Earlier this year I created a mobile application for pulling orders. To integrate, I made a rather barbaric implementation: when the mobile application backorders an item, update SO_SalesOrderDetail.QuantityBackordered = External.QuantityBackordered.…

Hello, I am having difficulty getting some code to work. I have found examples, but translating it to C# is making it harder to solve the problem. I am trying to export a sales order through the SO_SalesOrderPrinting_UI BOI. the following settings…

I took the BOI class, but that seems to be intended as a high-level overview, not so much a function-by-function breakdown. I checked the documentation, but it just says "Set module date". Not exactly helpful. So, what's the effect of setting the module…

Experts, I created BOI script that pulls picked orders from a SQL server and creates Shipping Data Entries for these orders. The data originates from the Sage Sales Orders and I have all necessary information available. Here is the issue that I am running…

I created a button on the Vendor Maintenance screen that runs the AP Aging report. I pass in the AP Division and Vendor numbers, but I can't get the report to filter by those values. (Want to run the Aging for the Vendor displayed, like the Sage button…

Hi All, Getting this funky error in method movenext. This script runs through SOs and deletes the ones in a particular range for a particular customer. This is the snippet in question. Any idea what I might have goofed? it seems to work sometimes…

I have 2 sets of GetResultSets that produce different results. Could some please explain to me why these 2 examples of GetResultSet methods return different result sets? I've read some examples, including Advanced GetResultSets() by a Sage developoer…

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…

We are on Sage 100 Advanced v2017 and I have a VBScript that prints Sales Orders using the SO_SalesOrderPrinting_UI object. Does anyone know if this object requires an active Windows session in order to run? The script runs perfectly when I run it…

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'm working with the new BOI capable PR module and having trouble sorting out how to add detail lines. I seem to have worked out creating a transaction, at least the batch I create does end up with an entry for the employee I am adding to…

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…

I get an error "Module J/C is not on file" when attempting to reverse an electronic payment. Here is my code using (DispatchObject mCheck = new DispatchObject(pvx.InvokeMethod("NewObject", "AP_ManualCheck_bus", oSS.GetObject()))) { // Perfrom Check…

We have an in-house built application that pre-authorizes a credit cards with external CC processor and updates SO_SalesOrder_bus with CreditCardAuthorizationNo$, CreditCardTransactionID$ and also sets CreditCardPreAuthorizationAmt. We have recently…

We have an in-house built application. The application uses BOI to integrate with SAGE. One of the forms inside the application needs to present the user with the list of customer's credit cards. Is there a way to find all the customer's credit cards…

I recently took the BOI course on SageU and have been educating myself in how to use the BOI COM interface. I'm finding that there seems to be a real need for a .NET (or CLR) library that abstracts away the COM implementation so that we can just work…

Hey all, I’d like to look up a Sale Order using C#, any clues would be greatly appreciated. Thanks!

Hello I am trying to find any doc on "oScript.Execute", i am facing an issue i want to call a 3rd party app and want the script to wait till the exe completes its execution. Thanks

Hello Every one I am running a script to get line level values in sales order, I am getting a "OLE error 424" error, can any one please help Code: ****************************************************************** Dim taxReqXML Dim intx dim…

Hello Everyone, I am trying to run a 3rd party exe on a button click using VB Script , The code is trowing (OLE ERROR -2147024894) i have added the code and also the error message i got ********************************************************…

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