One thing I would try first in a test company might be to export all of the non null records for all fields into a text file, and then rename the file and import only the non-null records.  Be aware that if you have quotes, single quotes and commas in your descriptions this could be a problem on the import.

Depending on how you are inserting into MySQL, you could also filter out those records where the SalesOrderNo is null, if it is in fact null.

I could easily fix it by stripping those entries out of a text file, but that is not how the import is being done.  It is also not a one off, it runs multiple times a day so having to interact with it every time would not be feasible.  I just need a way to clean them out of Sage completely since their broken records without a header anyways.

I could easily fix it by stripping those entries out of a text file, but that is not how the import is being done.  It is also not a one off, it runs multiple times a day so having to interact with it every time would not be feasible.  I just need a way to clean them out of Sage completely since their broken records without a header anyways.

I am actually suggesting that you correct the Sage table in a test company by exporting all the records, renaming and manually reinitializing the table again in the test company and then reimporting it back into Sage without the null records.   If this fixes this in a test environment and you have a good backup if it doesn't this could be a work around in a non SQL environment.