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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Upgrade from AX 2012 C...
Microsoft Dynamics AX (Archived)

Upgrade from AX 2012 CU3 to AX 2012 R3

(0) ShareShare
ReportReport
Posted on by Vanda Zou 260

Hi,

I am trying to upgrade from AX 2012 CU3 to AX 2012 R3, when going through the code upgrade checklist for in-place upgrade, I found our "var" layer has conflicts with sys layer. We have some custom enum value in  LedgerTransType occupied, now the R3 version added some new types (Writeoff - enumvalue 35, GeneralJournal - enumvalue 36) with the occupied values. Can I just change those new type values to something not used? Will that cause problem? Thank you.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 239,035 Most Valuable Professional on at

    You have to do something with your data. Let's say you have LedgerTransType::YourType with value 35 (which will be Writeoff in AX 2012). You have some data with YourType, which means that number 35 is stored in database.

    Now you go and change YourType to 200. There is no record in DB with value 200, therefore you won't see any transactions with YourType anymore. And all records with type 35 will be interpreted as Writeoff instead of YourType, which is clearly wrong.

    What you have to do is to change 35 to 200 in all fields in the whole database that are based on enum LedgerTransType.

  • Vanda Zou Profile Picture
    Vanda Zou 260 on at

    Hi Martin,

    Thank you for the reply. I don't mean to change my type value since we may have data stored in database. I mean I will change the Writeoff value to 200 in my "var" layer, I guess this writeoff type hasn't been used in our database as it is new in this upgraded version. Thanks.

  • Martin Dráb Profile Picture
    Martin Dráb 239,035 Most Valuable Professional on at

    It looks like an easy solution, but it means that you would keep the conflict with the standard AX forever and you would get into troubles every time when Microsoft ships you a new version of the enum.

    You will do a data upgrade anyway, so adding one more script to update the enum shouldn't be a huge problem.

    Nevertheless if you decide to change the standard enum element anyway, I can't currently think about any issue except problems with upgrades and that you would see wrong data if you used any data set for "normal" AX (such as demo data from Microsoft). But I would be afraid that unexpected troubles might occur at some time...

  • Vanda Zou Profile Picture
    Vanda Zou 260 on at

    If updating my type enum value in the database, I am not quite sure how many tables have reference to this field. If I miss some tables it may cause data inconsistent. Do you know a secure way or document to retrieve this information? Thank you.

  • Martin Dráb Profile Picture
    Martin Dráb 239,035 Most Valuable Professional on at

    It can be completely automated.

    You can use reflection (e.g. DictTable and DictField classes) to identify all fields with the given enum. Look at the source code of my old DataReferenceSearcher tool, for example.

  • Vanda Zou Profile Picture
    Vanda Zou 260 on at

    Thank you for the information.

  • Tomasz Dudek Profile Picture
    Tomasz Dudek on at

    Hello Martin,

    Axaptapedia site is broken and following link is not accessible http://www.axaptapedia.com/DataReferenceSearcher

    Could you publish your usefull tools on other site?

  • Martin Dráb Profile Picture
    Martin Dráb 239,035 Most Valuable Professional on at

    Well, I'll see what I can do. Unfortunately I'm extremely busy right now (that's also why this response is so late) and I'll probably have it on NAS at home, where I can't get this week.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans