web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Update fixed allocatio...
Microsoft Dynamics GP (Archived)

Update fixed allocation accounts using Integration Manager

(0) ShareShare
ReportReport
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

I have the same question (0)
  • Suggested answer
    soma Profile Picture
    soma 24,410 on at

    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!!!

  • Dave Bosserman Profile Picture
    Dave Bosserman 980 on at

    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
    Dave Bosserman Profile Picture
    Dave Bosserman 980 on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

#2
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans