Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

WHS and inventory adjustment journals

Posted on by Microsoft Employee

Hi there,
my colleague wants to transfer on-hand inventory from AX 2009 to AX 2012 R3 via inventory adjustment journals (Inventory management).

This seems to be special with R3. When we set the inventory status we cannot create InventJournalTrans because there are several key conflicts in table WHSInventReserveDelta. This problem is caused by method WHSInventOnhand::insertReserveDelta(). In this method InventDims are created for every Reservation-hierarchy-Level (Line 69-88). When it comes to "Inventory status" the InventDim::findOrCreate()-method returns a wrong InventDim instead of creating a new one because the Hash-Key is not set. This results in a key conflict in WHSInventReserveDelta. This is all system code.

If we don't set the inventory status the creation of InventJournalTrans works out but if we try to post the journal AX claims an inventory status. So we are stuck at this point :-).

Now the question is:

1. Is it even possible to create on-hand inventory via InventJournalTables (Type: Loss&Profit) in R3?

2. Is there a better way to "create" on-hand inventory in R3 than via InventJournalTables (Type: Loss&Profit)?

Greetings

Nils

*This post is locked for comments

  • Guy Terry Profile Picture
    Guy Terry 28,621 Super User 2024 Season 2 on at
    RE: WHS and inventory adjustment journals

    Hi Atis,

    If you look at the method 'hashKey' on the table InventDim, you'll see the inventory dimensions that are handled by the 'Inventory dimension extensibility' config key.

    In AX 2012 R2, none of the standard dimensions are mentioned in this method. i.e. there are 13 inventory dimensions in standard R2, so Inventory dimension extensibility is not needed for these.

    In AX 2012 R3, you find Licence plate and Inventory status in the 'hashKey' method.

    If you have a Product, Storage or Tracking dimension group which has any of the dimensions mentioned in 'hashKey' as 'Active', you need to enable Inventory dimension extensibility. It's not so much as a workaround as mandatory. If you don't use either of these dimensions I wouldn't have thought you need to enable it. Since you run R2, I wonder why MS Support think it will help in your scenario. Do you have any custom inventory dimensions?

  • DimanC Profile Picture
    DimanC 113 on at
    RE: WHS and inventory adjustment journals

    Hi

    I was told by MS Support to turn on this configuration key - as a workaround. Otherwise i got error when refresh (f5) was done in inventory transaction form (in some specifict conditions, though - when opened from On-hand inventory form, and when dimension Configuration is being displayed). A pity, that I can't find any more information, how this key will affect the AX.

    I'll try to follow up whether this affects performance or not.

    2012 R2 CU7, (6.2.1000.4051)

  • Suggested answer
    RE: WHS and inventory adjustment journals

    Well, if you are have less than 14 inventory dimensions (the index is limited by 16 columns, which also include DataAreaId and Partition), you would be better of turning that configuration key off.

    That is of course much better for performance, in an area which is already a cause of worry from a perf standpoint.

    But if you are running CU8 or the like, and especially if you need the new WHS or the Russian dimensions, or God forbid both, you MUST use that config.key

    I don't know if there's an actual document describing the thing, but there's some info on MSDN, for example:

    msdn.microsoft.com/.../dn495386.aspx

  • Carlos B Profile Picture
    Carlos B on at
    RE: WHS and inventory adjustment journals

    Hi Vanya,

    I have read some post about the problem of the inventdim index (16 fields in the SQL) and this config key seems related to this issue but I guess the recommendation is to turn it off by default, right?

    Do you know where we could find any documentation about "InventDimExtensibility" configuration key?

    Best Regards,

    Carlos B.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: WHS and inventory adjustment journals

    Hi Ivan,

    thanks for the hint!

    Actually it was the missing Config-Key " Inventory dimension extensibility "

    Greetings

    Nils

  • Verified answer
    RE: WHS and inventory adjustment journals

    1. Sure

    2. There are a few mobile device menu items, one of which is specifically targeted for getting data into the system.

    but that's not your problem. You should figure out your issues with the inventory dimensions, because that's the root cause of your issues.

    Check the configuration keys that are enabled. Is the Inventory dimension extensibility (InventDimExtensibility) one turned on?

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans