Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

FRx to MR 2012 Migration Fails due to account categories

Posted on by 75,730
I was performing an FRx to MR 2012 migration and noticed all the values were wrong when comparing FRx vs MR versions. What I discovered was that this client used GL account categories(account types in FRx) to layout the reports. Is it true that reports designed this way will not migrate or at least will required a great deal of manual correction to get them to work?

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: FRx to MR 2012 Migration Fails due to account categories

    I left a comment on this link as it appears that whatever this bug was it has not been fixed.

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: FRx to MR 2012 Migration Fails due to account categories

    Have a look on below link.

    community.dynamics.com/.../120646.aspx

    Hope this helps!!!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: FRx to MR 2012 Migration Fails due to account categories

    I have found that an & within the last few characters of the maximum defined field length acts up when passing through an xml translation because & may get expanded to & and then the code may truncate the string to the defined length before converting back, chopping off part of '&' and throwing an error.  I make a pass and substitute a '-'.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: FRx to MR 2012 Migration Fails due to account categories

    Nick, it does not appear to like the ampersand '&'

  • Nick Gilbert Profile Picture
    Nick Gilbert 25 on at
    RE: FRx to MR 2012 Migration Fails due to account categories

    Are you referring to the account category descriptions which can be selected in the "Link to Dimensions" column (column J)?  If yes, I am unaware of any character limitations as my current client uses account category descriptions with ( , () \ /) type values.

    I apologize if I misinterpreted your question.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: FRx to MR 2012 Migration Fails due to account categories

    By the way, I just noticed also that MR 2012 does not like special characters in the category descriptions. Is there a list of what characters it accepts?

  • Nick Gilbert Profile Picture
    Nick Gilbert 25 on at
    RE: FRx to MR 2012 Migration Fails due to account categories

    Hi Richard,

    You are correct in that "Account Types" used in row formats will NOT migrate over to MR 2012.  I ran into this issue during my last FRx to MR migration and ended up having to reconfigure the row format (without account types) prior to running the migration process.  Sorry to confirm the bad news.  Hope the remainder of the migration goes well.

    Nick

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans