Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

URGENT - Cannot Close Inventory Error

Posted on by 212
I cannot close inventory because of this message on a specific item, /You can't have unallocated cost on planning formula of production Id USP-B000908./
 
We haven't used this item in quite sometime and the Production # doesn't even show up on our list anymore since or AX to D365 upgrade (since it's so old).
 
Anyone have a suggestion?
 
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,240 Super User 2024 Season 2 on at
    URGENT - Cannot Close Inventory Error
    Hi Jsabanovski,
     
    Without more information, we can't tell you if this is a bug or data issue. Can you tell us how you did (data) upgrade from AX to Dynamics 365? Did you upgrade the full database or did you copy setup data, master data, and open transactions table by table?
     
    The error comes from validation in the method InventCostItemDim::calcKeyAdjustmentAllocation. In case the allocation is not 100% you will get this error. You can check the details of formula allocation on the production order. If this does not give the correct answer, it would be possible to create a copy of the environment and restore the production database. Then a developer would be able to set a breakpoint in this method and start debugging. 
     
  • Jsabanovski Profile Picture
    Jsabanovski 212 on at
    URGENT - Cannot Close Inventory Error
    Hi Kevin,
     
    I tried that already with no luck since the batch job is so old and it's not (or been deleted) from our system already.
     
    Hi Judy,
     
    I don't know how to do that as a end user.  I contacted our Partner, but was hoping to see if there's anything I can do as an Admin user to fix it. 
  • Judy Profile Picture
    Judy Microsoft Employee on at
    URGENT - Cannot Close Inventory Error
    Hi, please check if the issue is related to the old data from previous systems that did not get marked as closed/settled.
  • Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    URGENT - Cannot Close Inventory Error
    Hi,
    Similar problems have been raised before on the forum and solutions have been found, you can refer to this old thread: You can't have unallocated cost on a planning formula. (dynamics.com). There is a blog mentioned in the thread, you can follow the steps in that blog to set up.
    Best regards,
    Kevin

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!

Community AMA December 12th

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans