ERROR: The Date is Missing or Invalid

TechKnowledge Content


After running a SQL Optimized SOP Transaction integration an edit list for the Batch was printed and the following error was before each transaction: 'ERROR: The Date is Missing or Invalid.' What could be causing this especially when there were not any errors running the integration?


In this case, SOP Payments were being integrated and under the Payment Terms folder inside of Destination Mapping, the Due Date was not being specified. After mapping to the field the error went away.

This article was TechKnowledge Document ID: 25889


Microsoft Dynamics GP 9.0

Microsoft Business Solutions–Great Plains 8.0

Microsoft Business Solutions–Great Plains 7.5

Microsoft Great Plains Dynamics 7.0

Microsoft Great Plains eEnterprise 7.0

Great Plains Dynamics 6.0

Great Plains eEnterprise 6.0

Integration Manager

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.