Sage 100

It looks like you may have a bad or null record in either SO_SalesOrderHeader or SO_SalesOrderDetail.

Try opening the SO_SalesOrderDetail table in the MAS_TST database in SQL Management Studio. Add "ORDER BY SalesOrderNo" to the end of the SELECT query and look for a record that has null or zeroes in the SalesOrderNo. If that doesn't find anything, try "ORDER BY LineKey" and look for any Line Keys with "000000" or "NULL" values. Unlike most sequence fields in Sage, 000000 is not a valid LineKey in this table. NULL values are also prohibited. If you don't see any issues in those two fields, check and see if there are any SalesOrderNo values in SO_SalesOrderDetail that do not exist in SO_SalesOrderHeader. You can use this query to check that:

SELECT        dbo.SO_SalesOrderDetail.SalesOrderNo AS DetailSONumber, dbo.SO_SalesOrderHeader.SalesOrderNo AS HeaderSONumber

FROM            dbo.SO_SalesOrderDetail LEFT OUTER JOIN

                         dbo.SO_SalesOrderHeader ON dbo.SO_SalesOrderDetail.SalesOrderNo = dbo.SO_SalesOrderHeader.SalesOrderNo

WHERE        (dbo.SO_SalesOrderHeader.SalesOrderNo IS NULL)

If that doesn't find anything, try calling Sage.