Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Cannot change inventory unit

Posted on by 2,013

Hi everyone,

I forgot to put the inventory unit in AX2012, but  cannot change. The error says like this :

"The inventory unit for item XXX cannot be changed because activated cost prices exist. The cost prices can only be deleted by deleting the item."

Does it really we have to delete the items? what if we really need to change it and the transactions already exist. We can't delete items while there are transactions already, right.

thanks,

Ton

 

*This post is locked for comments

  • Weaveriski Profile Picture
    Weaveriski 23,616 on at
    RE: Cannot change inventory unit

    :-) Same message because an activated cost price is a transaction. See what you get from a clean post, more people will see it, but as stadnard this is now locked down, set the inventory parameter default as Tim says for the future.

  • Mikko Saarinen Profile Picture
    Mikko Saarinen 20 on at
    RE: Cannot change inventory unit

    Thank you.

    I have no transactions, but still ax gives me exactly the same error message that Tony had, when there are activated prices, so that's why I thought to reply to this same post. Sorry for not checking the dates. I will start a new thread for this.

  • Weaveriski Profile Picture
    Weaveriski 23,616 on at
    RE: Cannot change inventory unit

    Hi Mikko

    This is a resolved question from 5 years ago!

    Change the cost price and change the stock unit on the released product is not an issue when you have not transacted - what is it telling you when you are trying to do this? I would suggest writing a new post with your own details, Tony has his answers, he verified the post.

  • Mikko Saarinen Profile Picture
    Mikko Saarinen 20 on at
    RE: AX 2012 : Cannot change inventory unit

    I have the same situation as Tony, but we don't have any transactions yet, as we are just setting up the system. Is there not any way to change the stock unit and the cost price together, when we have already set up a unit conversion for those units? I was shocked to find that you cannot even change an item without any transactions.

  • Re: AX 2012 : Cannot change inventory unit

    The Fill utility has to be enabled by a configuration key (It's right near the top of the configuration tree). Once it's active, for main tables you can Right-click > Record info on a field (not a key) and you should see a 'Fill' button. Don't try it in PROD/LIVE unless you're really sure you know what you're doing, but it is handy for setting up data before go live, and for correcting errors (sometimes).

  • Anton Tjiptadi Profile Picture
    Anton Tjiptadi 2,013 on at
    Re: AX 2012 : Cannot change inventory unit

    Sorry guys,

    I really am new about AX 2012, what is "Fill" Utility ? :)

    Thanks in advance,

  • Verified answer
    Weaveriski Profile Picture
    Weaveriski 23,616 on at
    Re: AX 2012 : Cannot change inventory unit

    This is the best practice advocated by Microsoft.

    Tims suggestion of the default is good, but you can guarantee the one that is wrong is where it populates the default and then you realise it should have been something else.

    The fill utility is interesting, but on every sales and purchase order the system holds the quantity back as a stocking unit, so if you do this you still need to remove every transaction and stock, do not just do it :-)

  • Verified answer
    Re: AX 2012 : Cannot change inventory unit

    I know it's shutting the door after the horse has bolted but you are aware that there is a default Unit on the Inventory parameters which is applied to all new items? - so you don't get this again. Alos in this case I'd be tempted to try the 'Fill' command. It has a handy little featue that it by-passes most validation checks.

  • Anton Tjiptadi Profile Picture
    Anton Tjiptadi 2,013 on at
    Re: AX 2012 : Cannot change inventory unit

    Hi Weaveriski,

    Thanks. Is this the best practice of it ?

  • Verified answer
    Weaveriski Profile Picture
    Weaveriski 23,616 on at
    Re: AX 2012 : Cannot change inventory unit

    Where you have transactions and need to alter it you do indeed have to recreate the item, where it cannot be deleted you need to rename it then transfer the stock to the new item.

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans