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

I'm writing a BOI script to create Inventory Adjustment Transactions. I want to use the next available entry number so I have the GetNextEntryNo(refNo$) function in my script. What I can't figure out is what the "refNo$" needs to be. Does anyone have…

With Sales Order history enabled, lines that are deleted by an event script (Pre-Totals) are not reflected as CancelledLine="Y" in SO History. Thus, there is no way to differentiate deleted lines from lines that remain in the order. This results in overstated…

Is there any way to populate the BM_ComponentReportSelection.M4T without manually keying it in the Gross Requirements Report? It is not an available table to import into for Bill of Materials. https://solitaire.onl/ https://9apps.ooo/ https://bluestacks…

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…

Hi i am trying to read item code, item description,and item price of all the items, i am able to read both item code and item description in an object but i am getting item price as null or empty string . can any one help me out on how to read a…

Is Company ID from ODBC login available?