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”
Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.
View products that this article applies to.
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”
There is a field mapped in the configurator with a table, in which the field does not exist in that table
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.
Keywords: kb, gp, kbmbsmigrate, kbmbspartner