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 / On hand View - show on...
Supply chain | Supply Chain Management, Commerce
Answered

On hand View - show only lines with Available physical >0

(0) ShareShare
ReportReport
Posted on by Indiguna 317

Hello everyone,

Is there any way that I can show only the lines with an available physical quantity in On-hand list while all the dimensions are turned on to display?

Please see screen shot below. I have chosen to show all Site, WH but only want to see the lines without a blank Available physical by default.

Thanks!

Indiguna

pastedimage1630637195408v1.png

I have the same question (0)
  • jannawangD365 Profile Picture
    jannawangD365 on at

    HI Indiguna,

    there is one option if you click on 'display dimensions' qty <>0

  • Indiguna Profile Picture
    Indiguna 317 on at

    Thank you for your response, I did turn that flag on but it still shows me the lines with Available physical blank. I am on the D365FO Version 10.0.19

  • jannawangD365 Profile Picture
    jannawangD365 on at

    try run the cleanup jobs : On-hand entries cleanup and  Warehouse management on-hand entries cleanup (if you have WMS enabled items) under inventory module->periodic0>clean up 

  • Verified answer
    Tom Berry Profile Picture
    Tom Berry 93 on at

    Hi Indgiuna,

    I believe this may work for you.

    If you "Insert a column" and then choose insert the "Available physical", this will give you to the ability to sort and filter the column.

    Once you can sort and filter, you should be able to filter "greater than or equal to" 1

    pastedimage1631214652089v1.png

    Hope this helps.

  • Indiguna Profile Picture
    Indiguna 317 on at

    Thanks Berry! This works.

    Any idea if there is a way to keep this filter saved? I tried saving with a view. It keeps the new field. But not the filter.

  • Tom Berry Profile Picture
    Tom Berry 93 on at

    My only thought would be to create a WorkSpace tile or list.

  • Indiguna Profile Picture
    Indiguna 317 on at

    Appreciate the quick response,  I will try that.

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
Siv Sagar Profile Picture

Siv Sagar 283 Super User 2025 Season 2

#2
Laurens vd Tang Profile Picture

Laurens vd Tang 213 Super User 2025 Season 2

#3
André Arnaud de Calavon Profile Picture

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

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans