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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How to add 2 drop-down...
Finance | Project Operations, Human Resources, ...
Answered

How to add 2 drop-downs of warehouses and sites linked to selected-warehouse to a form (SalesPool)

(1) ShareShare
ReportReport
Posted on by TapiwaLouis 29
Good day,
 
I'm kindly seeking assistance on how to add 2 drop downs on the Sales Pool form (Sales & Marketing >Setup > Sales Orders > Order pools).
 
The drop-downs should have:
  1. list of warehouses
  2. list of related sites of the selected warehouse
I have managed to add a drop down with a list of warehouses by adding table relation between SalesPool table and InventLocation table.
I also did the same for sites but it is not filtering to show only the site/s related to selected warehouse.  
 
Please assist.
Categories:
Dynamics 365 Finance
Microsoft Dynamics AX
I have the same question (0)
  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 235,966 Most Valuable Professional on at
    How to add 2 drop-downs of warehouses and sites linked to selected-warehouse to a form (SalesPool)
    A warehouse belongs to a single site; it's the site who can have multiple warehouses.
     
    If you have InventLocationId on SalesPool, you don't need any field for a site, because it's already uniquely identified by the warehouse (InventLocation.InvensSiteId).
     
    If you really want both the site and the warehouse, you can create a relation for warehouses that links both InventLocationId and InventSiteId. And alternative is overriding the lookup() method for warehouses and adding a query range with the value of the site.
     
     

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 823 User Group Leader

#2
André Arnaud de Calavon Profile Picture

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

#3
Martin Dráb Profile Picture

Martin Dráb 491 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans