Announcements
No record found.
Hi,
I need all items that has available physical > 0 in specified warehouse.
Can You Tell me how to get this information from database ?
*This post is locked for comments
there are many forms and reports do that
1-inventory management / common /on-hand inventory as Crispin John Augustine mention you
2-inventory management / inquires /on-hand
3- 1-inventory management / reports /on-hand /on-hand inventory
4- 1-inventory management / reports /status / inventory by inventory dimension aging
5- 1-inventory management / reports /status / inventory by inventory item group aging
inventSum has method physicalInventCalculated which returns
this.PostedQty + this.Received - this.Deducted + this.Registered - this.Picked - this.ReservPhysical.
I am just interested , what is the difference just sum one row compare to this.
Hi David,
Did you get the answer to this?
I am having the same requirement, can you help?
Hi David Vayne,
I think it's quick a bit long time ago this question has not been answered. I hope you have the answer of it. If not, please check On-hand stock report by adding Warehouse & Physical available > 0 filter criteria in the report parameters.
Thanks,
Ajit Ranjan Dhal
Hi Ajit,
If you can help it by code?
I have following requirement
community.dynamics.com/.../1067124
Thanks in advance
Hi Jasdeep,
I believe a SQL expert would be able to helps you on writing the query. I have asked my Team member (SQL expert) to help you with the query...
We will update on the following requirement -community.dynamics.com/.../1067124
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CP04-islander 39
Michel ROY 14
imran ul haq 8
