Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Inventory Availability...
Microsoft Dynamics NAV (Archived)

Inventory Availability Affected by Closed/Archived Sales Orders

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hello. I have several instances where very old, closed and/or delted sales orders are affecting my inventory availability. The product has sufficient on-hand quantity, but when I try to include it on a sales order, I get an alert saying that inventory availability in insufficient. I went to the inventory item card, and checked open sale orders and it shows a very old sales order, that does not even show up when I go to the Sale Order History file.

Any suggestions?

*This post is locked for comments

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Inventory Availability Affected by Closed/Archived Sales Orders

    Open the Sales Line table from development environment and filter for those sales lines and delete those orphaned sales lines from there or you could add a report to find all the sales lines where there is no associated sales header and if you find those you can add the code in the report to delete those lines.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory Availability Affected by Closed/Archived Sales Orders

    Amol, I believe that in order for me to check inventory reservations, I need to go to the specific sales order. The thing is that these orders are not in the open orders. These are basically orphaned sales lines form deleted and/or completely shipped orders.  Any other suggestions?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory Availability Affected by Closed/Archived Sales Orders

    How can I check that in NAV 2009 R2 classic client?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory Availability Affected by Closed/Archived Sales Orders

    Yeah. That would be the obvious. The thing is these orders don't show up anywhere, dead or alive. They're not in the open orders and they're not in the sales order history file. Basically these are orphaned sales lines... very old. From when we first implemented NAV back in 2012.  

    Apparently it had not been an issue until now, because we always had high inventory levels of those items, so there wasn't a problem when you tried to invoice. Now that those items are at very low inventory levels, it's affecting our ability to invoice whats remaining.

    Any ideas?

  • Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Inventory Availability Affected by Closed/Archived Sales Orders

    Hi Eddie,

    Check if you are reserved inventory against those old orders. If yes then unreserved the same and you can use that inventory for other sales orders to ship

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Inventory Availability Affected by Closed/Archived Sales Orders

    So, if you have open sales order, why can't you delete that? Search in the open 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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,354 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans