WHS and inventory adjustment journals

(0) Share

Report

Posted on by Community Member 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

All responses (6)

Answers (1)

Guy Terry 28,626 Super User 2024 Season 2 on at

Like (0)

Report

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 113 on at

Like (0)

Report

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

Ivan (Vanya) Kashperuk on at

Like (0)

Report

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 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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

Ivan (Vanya) Kashperuk on at

Like (1)

Report

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?