Logging to find cause of "The column is not in the IOList."

Question

Hello, I have taken over an existing installation that does not have any documentation or support on it. Our website uses a custom sync tool to push orders into Sage. Everyone once in awhile (10% of orders or so), I will see an error, "The column is not in the IOList", and I am a little bit stuck trying to find the cause. From the searching I've done, I either have a field missing or a field that is not defined correctly (string vs. number) but that's as far as I can get. Is there any detailed logging I can turn on within Sage to export or find what table / column is throwing the error? 
 I am using Sage 100 2018, Premium. I've been watching SQL Profiler and not seeing any errors thrown from there. I've also been watching fiddler on the integration side and not seeing errors there either. Wondering if you all might be able to point me in a better direction? 
 
 Thank you!

David Speck · Answer

Usually the "Column is not in the IOList" warning is not because of trying to set a field on a specific line type, there is usually a specific warning for those instances. You will need to review your custom sync tool that is writing the data to sage 100 via the BOI and compare fields that it is using SetValue on against the file layouts for your version. Look for fields whose name may have changed or have been removed and for fields using the wrong data type (having a trailing $ for a numeric field or missing the trailing $ for a string field).

Sage 100

Logging to find cause of "The column is not in the IOList."

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING