Big Business 8.7 fixes a problem with Middleware that Sales Orders, Invoice, or Items may not appear in MySQL if they contain newer, longer entries.
This Solution provides details. (6316)
This problem occurs where Big Business fields have been increased in size in an Update and new entries using the new size cause an error saving to MySQL, so the record is missing. This problem is fixed in Big Business 8.7 by updating MySQL to accomodate the new size.