URGENT - Cannot Close Inventory Error

(1) Share

Report

Posted on by Jsabanovski

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?

All responses (4)

Answers (0)

André Arnaud de Cal... 291,391 Super User 2024 Season 2 on at

Like (0)

Report

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

Like (0)

Report

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

Like (0)

Report

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

Like (0)

Report

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