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…

I previously worked with Sage 500 and was able to run a query from Sales Order lines and dump that data into excel and then manipulate it for my presentations and create pivot tables.This would brake down the sales order to the line level and provide…