Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Different Inventory Status on same Item\License Plate

Posted on by Microsoft Employee

Hello,

I'm facing the following Scenario (AX 2012 R3 CU 11):

we normally have On-Hand in Inventory Status Available (two warehouse types: WHS managed internally and WMS with Logistic Provider and interface).

For some items it happens periodically that stock get short and we need to block the automatic release process for These items. A user must release manually the corresponding sales order line. After some time the item will be fully covered again and the normal automatic release process can take place.

My solution would be:

By standard we should use for all the stock and sales line the Inventory Status 'Available'. If we go short we update the status of all the stock of the Item two a second Status 'Short' (not blocked as well). The user will have to update the Inventory Status on the sales line manually from Available to Short in order to relesase and reserve the stock.

Now the Problem is that AX doesn't allow to have on the same license plate two different Status. So if I try to update the Status from Available to Short, and on a license plate there is a picking work, the update will fail for the whole License plate.

Does a Workaround exist? Or do I need here a modification?

Thanks

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Different Inventory Status on same Item\License Plate

    Thanks for the answers. I think as well a modification would be riskful. Probably the best option is a manual process on the open works (as suggested from Guy Terry)

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Different Inventory Status on same Item\License Plate

    Hi Federico,

    if you want to store mixed inventory statuses for the same item on one license plate, there is no real work around thats handy. I think a modification is the best solution.

    BR Thomas

    dynamics-for-operations.com

  • Guy Terry Profile Picture
    Guy Terry 28,621 Super User 2024 Season 2 on at
    RE: Different Inventory Status on same Item\License Plate

    I don't know of a workaround for the mixed-statuses-on-lp problem, but for a workaround you could, when setting an item to 'Short' status, check for open sales work for the item.

    If there is open work, cancel the work and delete the shipment/load line. Change the status of the lines on the sales orders to 'Short'. Change the status of the stock to 'Short'. Re-release the sales orders.

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans