Sage 100

I've seen some tools mentioned: Web Services (eBM) and sData; would these tools allow to retrieve information (i.e. items) from sage100Advanced and export it and also importing to sage; is BOI appropriate for this? and do I need to be a partner to use…

I have a script that I wrote and installed on the server remotely. Worked fine. It was attached to the CustomerNo field in Sales Order Entry. When the user attempted to create a sales order, as soon as they selected a Customer it locked up Sage 100 and…

Experts, I am able to create Sales Order, Sales Order Invoices, and AP Invoices via BOI without any issues. I am missing something about the order of things for PO Receipt of Invoice. Here is an excerpt of my code (it's in Powershell, but the methods…

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

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…

I have general question about writing button scripts in AR_Customer where I can write data to the fields. My goal is to update and address Customer Maintenance Main 1: menu with a button that fetches data. What I have working is the pulling data from…

I'm getting the error m essage=<NewObject Error: 200> Source=ProvideX.Script.1 when accessing a UDT. I just installed the client on this workstation for the first time, though I suppose I can try reinstalling. I'm hoping I just have a small syntax error…

Hi all, I'm experiencing issues trying to new up a AR_Customer_bus object, my eventual aim is to be able to create a new customer using the BOI. The error I'm getting is a 200 error. This is my code so far, also note that I've written this off the…

I'm trying to set invoice object to a single record and not having much luck. What I'm trying: oSS.nSetProgram(oSS.nLookupTask("AR_InvoiceHistoryInquiry_ui")) Dim oInvoices As Object = oScript.NewObject("AR_InvoiceHistoryInquiry_svc", oSS) oInvoices…

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…

I have a button script that I am using to preview a custom crystal report from the IM Item Transaction screen. Everything works fine when I run it on my Sage 100 Standard environment, but when I put it on the clients Sage 100 Advanced system I get an…

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…

I was wondering if it is possible to add JT_Employee as a data source under Business Objects when creating a UDF for SO_SalesOrderDetail.

I have a client using Sage 100 v2016. They have multiple report settings for the GL Detail Report that wish print automatically monthly BUT each report setting needs to be saved in a different network location. In total it's probably 150 different reports…

Hello Everyone, I am trying to figure out how to know what is the cause of an error that will not let my software create a payment record for an incoming Sales Order. The error I got from the business object is: "Error Creating record from table…

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…

Here is my problem. I have a trigger set when an order number is entered when doing Sales Order Invoicing which works fine. I don't want it trigger when using Shipping Data entry. Any suggestions?

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…

Hi all, First script first post. Task is simple for one customer set freight amount field to negotiated amount that is based on the sales order total amount. Script is attached to pre-total event and it always works BUT only if sales order has more…

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…

Not sure how to word this, but I'm trying to pull some values from PO_PurchaseOrderHistoryInqDetail_bus. The script runs with no errors (button script), but no data is returned. I have a working script that pulls from SO_SalesOrderHistoryInquiryDetail_bus…

Hi everyone I'm trying to write a script that will mimic the quick pick sheet printing (ask if to save the changes & bring up the pick sheet dialog for the order selected). I'm using a new button for that on the sales order. The reason being, I need…

I have a list of items I need to freeze and add to the IM_Physical table. Once added, I have another process that will need to perform the physical count entry at a later date. I'm having trouble finding the correct process needed to perform these actions…

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