Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2022 Release Wave 1 PlanDynamics 365 release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
2022 release wave 1 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
Hi. I have a question. Is it possible to add a field to the Items List from another table?. For instance: I am retrieving the stock from the column "Remaining Quantity" (Item Ledger Entry ) and I want to be able to add a field or fields for each location I have ( I just have 5 locations ) and being able to filter by these fields. Is it possible?. I have searched but I can't find a way to do it. Thanks in advance.
You can use the "Location filter" field by providing the desire location code on Item list page, it will give the total inventory of that particular location.
If you want to see the qty. on hand for 5 different location you can customize a lookup function that lets you display the qty for each location when you execute the lookup function.
Adding a field for each location is also possible but can have a performance impact because the inventory will be calculated every time you pull up the item list.
The advantage of the lookup is that the code behind it will only be executed when requested.
Hi, I think you can try Location Filter in Limit totals.
Or try Items by Location in Item list.
Hope this helps.
Thanks for the reply. I have come up with something like this. Having the available items display for each location. I'm geting this info from the Item Ledger Entry. I am using the location filter and it works fine, however I would like by the time I click on the stock, I want it to take me to the stock by location of that specific item, like when you click in the item available by location. I have try table relation but I don't know which table those values are stored. Thanks a lot for your help.
You can ask your Partner to add the fields to the Page, with a filtering ability. You could also consider a Jet Report to do the same thing, via Excel, real time.
Business Applications communities