Sage 300 Date Formatting

When setting an Date type optional field in Sage300 you may receive the following error:

Accpac API Error 1000 – Invalid input. Failed to convert string ‘<datevalue>’ to an internal Date representation.

To work around this issue you need to have the date formatted in yyyyMMdd format, achieved using the Format function:

Format(%DateField, “yyyyMMdd”)

An update will be made to IMan in a coming version to resolve this issue.