URGENT - Cannot Close Inventory Error

(1) Share

Report

Posted on by Jsabanovski

344

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?

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Kevin Xia Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Judy Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi, please check if the issue is related to the old data from previous systems that did not get marked as closed/settled.

Was this reply helpful? Yes No
Jsabanovski 344 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
André Arnaud de Cal... 306,442 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No