web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Cleanup Expired Invent...
Supply chain | Supply Chain Management, Commerce
Suggested Answer

Cleanup Expired Inventory Batches with no Quantities

(0) ShareShare
ReportReport
Posted on by Zeeshan.Rahim 151

Hi,

I want to delete all expired inventory batches with no open transactions/quantities, is there any way to do the bulk cleanup for batches with no quantities.

pastedimage1617016034126v1.png

I have the same question (0)
  • Suggested answer
    AR-01121610-0 Profile Picture
    AR-01121610-0 4,967 Moderator on at

    Hy Zeeshan,

    yes there is a function inside the inventory counting journal, here you can Create lines using "Expired batches". 

    This makes a selection in the desired warehouse and inserts the lines with expired date into the journal. Then you can correct the quantities inside the list or "open in export" to bulk edit the lines.

      

  • Zeeshan.Rahim Profile Picture
    Zeeshan.Rahim 151 on at

    Hi Andreas,

    I follow the same steps as per your suggestion, I am able to insert lines in the counting journal by selecting Expired batches however I am not able to delete batches. I can only count from this screen but not able to delete expired batches.

  • Suggested answer
    AR-01121610-0 Profile Picture
    AR-01121610-0 4,967 Moderator on at

    Hy Zeeshan,

    as you want to delete the expired batches the financial value needs to set to zero. This is done by die counting journal (set counted qty = 0) as it is posted as defined in journal setup.

    The onhand sum should be 0 now after posting the journal. If there are still lines for this batch in inventory onhand list with qty=0 may by the periodic inventory batch "Onhand entries cleanup" could remove this, but I'm not complete sure at this point.

  • Zeeshan.Rahim Profile Picture
    Zeeshan.Rahim 151 on at

    Hi Andreas,

    Inventory on hand list already contains 0 quantity in batches, I just need to bulk delete them instead of deleting them 1 by 1. I already checked "Onhand entries clean up" but the results are not the same as expected.

  • ToddB Profile Picture
    ToddB on at

    Hi Zeeshan,

    In checking, it appears there is not a way to bulk delete these.

    If you get a chance, would you be able to submit this on the Ideas portal; and post a link here for others to vote for this?

    experience.dynamics.com/.../

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 299 Super User 2025 Season 2

#2
Siv Sagar Profile Picture

Siv Sagar 183 Super User 2025 Season 2

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 117 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Quality order uses default receipt location instead of actual physical receipt location

Product updates

Dynamics 365 release plans