WHS and inventory adjustment journals

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Ivan (Vanya) Kashperuk Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Ivan,

thanks for the hint!

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

Greetings

Nils

Was this reply helpful? Yes No
Carlos B on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Ivan (Vanya) Kashperuk Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
DimanC 113 on at

Like (0)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No
Guy Terry 28,944 Moderator on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No