When things go wrong - Missing or Invalid Date on SOP Edit List

This error kept coming up at a client whom was using the Sales Document Consolidation product from Binary Stream.

As it turned out, the problem was because the DUEDATE field in the SOP10100 table was showing a value of 1900-01-01 00:00:00.000, that is not a valid date in the Dynamics GP SOP posting world. This situation came about because (as near as we could tell), the customer did not have a default payment term assigned to them.

If you get this error on your SOP Edit List, go take a look at that field.

Kind regards,

Leslie