Notifications
Announcements
No record found.
Hi Everyone,
i have simple question , i need to filter inventory location on purchtable form by following condition
1. if user A is login then at PO creation time inventory dimension should showing in drop down list invent-1 & invent-2.
2. if user B is login then at PO creation time inventory dimension should showing in drop down list invent-3 & invent-4.
Hi Munsif,
You can override the lookup method for inventory location to filter based current logged in user. Do you have user id records saved in the Inventory location main table, based on which you want to filter the records?
Implementing such a logic possible, but consider if it's not work for data security. The answer depends on your actual requirements.
Thanks for your reply, but in override method we can add only one range like for user A invent-1 showing, but we need for user A two ranges for same fields. secondly there is no user id in main table because i think you are talking about version Ax 2012 R3, and we are using 2012 R2, not advance WMS.
On which field are you trying to add the range for filtering based on user Id?
I want to filter on inventlocationid when user creating PO.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 544 Most Valuable Professional
André Arnaud de Cal... 450 Super User 2025 Season 2
Sohaib Cheema 250 User Group Leader