Friday, July 18, 2014

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

 

3d man holding stop sign

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

2 comments:

Chris Williamson said...

Thank you, thank you !!!!!!!

Steve Endow said...

Hi Leslie,

Thank you very much for this. A customer was having several SOP Invoice batches fail to post, and the edit list just showed the very unclear error about "missing or invalid date", without indicating which date was the issue.

After reviewing your post, we saw that the invoices did not have a payment terms ID assigned. After assigning payment terms to an invoice, that eliminated the error and allowed the client to research the cause.

Thanks,

Steve Endow