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. 

Need more help?

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

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×