ISSUE
When trying to get generate a Payables or Receivables EFT file in Microsoft Dynamics GP, this error happens:
“Unhandled script exception:
Bad Datatype detected for operation
EXCEPTION_CLASS_SCRIPT_BAD_TYPE
SCRIPT_CMD_COLUMNOFTABLE”
CAUSE
There is a field mapped in the configurator with a table, in which the field does not exist in that table
RESOLUTION
You must go to the configurator file, and line by line, re-select each FIELD from the pick list. You will eventually come across one that is not available in the pick list (ie. not available in the table selected). Either change the table or change the field as needed.