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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

conditional lookup

(0) ShareShare
ReportReport
Posted on by 1,536

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.

I have the same question (0)
  • Gunjan Bhattachayya Profile Picture
    35,423 on at

    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?

  • Martin Dráb Profile Picture
    237,908 Most Valuable Professional on at

    Implementing such a logic possible, but consider if it's not work for data security. The answer depends on your actual requirements.

  • munsif Profile Picture
    1,536 on at

    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.

  • Gunjan Bhattachayya Profile Picture
    35,423 on at

    Hi Munsif,

    On which field are you trying to add the range for filtering based on user Id?

  • munsif Profile Picture
    1,536 on at

    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.

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…

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

#1
Martin Dráb Profile Picture

Martin Dráb 544 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans