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 Guys So we recently upgraded to Sage 2023. Since the upgrade some users have being reporting that the Customer Last purchase history (Red Binoculars) is not populating for them on sales order. I first thought it might have been a permissions issue…

We are looking at a Third-Party software called Master Control for our QA/QC documentation processing. With that, we want to be able to extract data out of Sage 100c Advanced v2019.2 (upgrading to v2021 shortly) from Scanco's Manufacturing module, as…

Client running Sage 100 v2018. Trying to export purchase order information based on two select criteria that is outside standard fields. I'm able to create a Perform for the individual selections and when I add one of the two perform functions to the…

When exporting payment history for AP I am only getting a few years information. If I run a report I can see the system has 20 years worth of data but its only giving me 2+ years which is more like just the time frame for viewing in the system. I tried…

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

We run SAGE 100, and recently I purchased BizNet 5, but I also have BizNet 7 datasets - A/R, A/P and IM. The BizNet tool works well when I am pulling general ledger information, but for our inventory, accounts receivable and accounts payable there…

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.

Is it possible to access Sage 100c data from a Java program? Is there a JDBC driver available to connect and get data from Sage 100c?

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…

Not sure how this has happened, but we have an invoice that has doubled a line item. Sage Advanced 2018 6.00.3.0 The problem also is, it does not show up in the Lines tab, only the Totals tab, or when the invoice is printed. Our system seems to…

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…

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?