Skip to main content

Notifications

Microsoft Dynamics AX forum

Cannot change storage dimension group for item

Posted on by Microsoft Employee

When i was trying to change the storage dimension group for a specific item, I got the error message "The new dimension group cannot be assigned. Physical inventory transactions might exist and/or financial inventory transactions are not fully settled, while 'Activate closing of non-financial transfers' is set to Yes."

i check the system, and i can confirm that all the purchase order related to this item are invoiced, and all the production order related to this item are ended. on-hand inventory is zero.

item on-hand inventory in warehouse SHP001 as below:

_FE56CF50_-6.png

item on-hand inventory in warehouse W01 as below:

the financial cost amount in one is -45, and another is +45, this probably the root cause that i cannot change the storage dimension group for the item. but i have not idea how to settle these two amount into zero.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cannot change storage dimension group for item

    [quote user="André Arnaud de Calavon"]

    Hi Jianrui,

    It is all explained in a Costing whitepaper. It is written for AX2009, but in your scenario also applicable for AX 2012.

    [/quote]

    Thank you very much,  Andre

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,867 Super User 2024 Season 2 on at
    RE: Cannot change storage dimension group for item

    Hi Jianrui,

    It is all explained in a Costing whitepaper. It is written for AX2009, but in your scenario also applicable for AX 2012.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cannot change storage dimension group for item

    [quote user="André Arnaud de Calavon"]

    Hi Jianrui,

    Strange... What inventory costing model are you using?

    [/quote]

    Hi Andre

    the inventory model in the item model group is configured as "FIFO". and the close job finished with some warning information, but none of them are related to the item that we are talking about.

    Can you tell me that how the "Financial cost amount" is calculated?

    many thanks.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,867 Super User 2024 Season 2 on at
    RE: Cannot change storage dimension group for item

    Hi Jianrui,

    Strange... What inventory costing model are you using?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cannot change storage dimension group for item

    [quote user="André Arnaud de Calavon"]

    Hi Jianrui,

    Please check if you have run the inventory closing. This will settle the costs.

    [/quote]

    after executing the inventory closing, i can change the storage dimension group for the item now, but the financial cost amount in these two warehouse still insist, is there a way to settle this ?

    many thanks.

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,867 Super User 2024 Season 2 on at
    RE: Cannot change storage dimension group for item

    Hi Jianrui,

    Please check if you have run the inventory closing. This will settle the costs.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,867 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,173 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans