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:
An update will be made to IMan in a coming version to resolve this issue.