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,



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.


Steve Endow

Anonymous said...

Hi Leslie,

I tried to assign the payment term ID to the customer in customer maintenance window but it did not eliminate the error that I was getting in Edit List for missing or invalid date.
Am I missing something here or is it something that I am not doing right?

Will much appreciate your quick response.


Dynamics Confessor said...

Putting the payment terms on the customer card will work for future documents, but not those already in the queue. Take a look at Steve Endow's comment above. The payment term ID needs to be assigned to your unposted SOP Invoices.