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.

KB - 'COLUMNOFTABLE' error when trying to generate EFT file in Microsoft Dynamics GP


View products that this article applies to.

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”

↑ Back to the top


CAUSE

There is a field mapped in the configurator with a table, in which the field does not exist in that table

↑ Back to the top


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. 

↑ Back to the top


Keywords: kb, gp, kbmbsmigrate, kbmbspartner

↑ Back to the top

Article Info
Article ID : 4464976
Revision : 2
Created on : 9/20/2018
Published on : 9/20/2018
Exists online : False
Views : 296