Update fixed allocation accounts using Integration Manager

(0) Share

Report

Posted on by Dave Bosserman

980

I'm trying to update all fixed allocation accounts (several hundred) using IM. I get the error 'Distribution account xxxx-xxx has been entered already'. The integration apparently won't update if the distribution account has already been used on the allocation account. This is in GP2010, using IM 11.00.2055

However when I test the same scenario using GP2013 and IM12.00.1424 it works perfectly. Is the ability to update allocation accounts something new in GP2013? Or have I done something wrong in the integration?

*This post is locked for comments

All responses (3)

Answers (0)

Suggested answer

Dave Bosserman 980 on at

Like (1)

Report

RE: Update fixed allocation accounts using Integration Manager

For future reference: the problem is the GL account separator. With the default dash '-' as the account segment separator, the integration works. This instance had a period '.' as the account separator. Changing it or removing the separator from the source file fixed the problem.
Dave Bosserman 980 on at

Like (0)

Report

RE: Update fixed allocation accounts using Integration Manager

Thanks for the reply - this doesn't appear to be the problem. Even if I test with a single distribution account, I get the same error.
Suggested answer

soma 24,406 on at

Like (0)

Report

RE: Update fixed allocation accounts using Integration Manager

If your source file has duplicated distribution account for single fixed allocation account, the above error will occur . Please check your source file and Query Relationship in IM.

Note: Before run the integration, right click Fixed Allocation Distribution Accounts under IM source section and select preview to check your data showing unique distribution account for single fixed allocation account.

Hope this helps!!!