Integration Manager Problem

Question

Integration Manager Problem

scottpdann (TechnicalUser)

(OP)

12 Nov 12 16:37

I get the following error when running an integration. I've run it before and had no issues.

DOC 1 ERROR: Non-alphanumeric characters were found in the 'Account Number' field of the 'Entries' recordset

I can see no problems with my account numbers.

Has anyone else run into this?

Scott P. Dann
Director of Finance
Mandel Jewish Community Center of Cleveland

VictoriaYudin (IS/IT--Management) · Answer 1 · 2012-11-13 07:45:09

Scott,

I have seen this caused by extra spaces at the end of the account number.

Victoria Yudin
Dynamics GP MVP 2005 - 2012
Use Crystal Reports and SSRS with GP:
http://www.GPReportsViewer.com/gpreports.html
blog: http://victoriayudin.com

scottpdann (TechnicalUser) · Answer 2 · 2012-11-13 13:19:30

Victoria,

Thanks for weighing in. I made sure there were no extra spaces. Any other thoughts?

I wish it would tell me which account is causing the trouble. Very furstrating.

Scott

scottpdann (TechnicalUser) · Answer 3 · 2012-11-13 13:53:44

I had a dot instead of a dash in one of my accounts. I did a "Text-to-Columns" and figured it out.

VictoriaYudin (IS/IT--Management) · Answer 4 · 2012-11-13 13:56:22

Scott,

Glad you were able to figure it out. In the future, I believe if you set your logging level to Trace it will tell you what record it's failing on.

Victoria Yudin
Dynamics GP MVP 2005 - 2012
Use Crystal Reports and SSRS with GP:
http://www.GPReportsViewer.com/gpreports.html
blog: http://victoriayudin.com

Come Join Us!

Posting Guidelines

Integration Manager Problem