Integration Manager Problem

[scottpdann]

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]

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]

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]

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

 

[VictoriaYudin]

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