Integration Manager Problem

scottpdann · Nov 12, 2012

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 · Nov 13, 2012

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 · Nov 13, 2012

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 · Nov 13, 2012

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

VictoriaYudin · Nov 13, 2012

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Integration Manager Problem

scottpdann

Technical User

VictoriaYudin

IS-IT--Management

scottpdann

Technical User

scottpdann

Technical User

VictoriaYudin

IS-IT--Management

Similar threads

Part and Inventory Search

Sponsor