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

How do I get the customer number that selected by user through customer name

(0) ShareShare
ReportReport
Posted on by 20

Hi, all

When user select one row in the list, Customer name will be display on it ,and I need use the Customer Number as a condition to select data from DB, Now the problem is I can not  get the number in the contract or data provider. anyone can help me ?

pastedimage1662712043451v1.png

Best regards.

I have the same question (0)
  • GirishS Profile Picture
    27,827 Moderator on at

    Hi richard man,

    You need to get the customer number from customer name?

    You can get customer number from the customer name but the customer name wont be unique sometimes.

    So it will be better to add the customer number in the report instead of customer name.

    Thanks,

    Girish S.

  • richard man Profile Picture
    20 on at

    Hi, GirishS

    First of all, thank you for your reply, my request is that the user can see the name and number at the same time, when the user enters the customer name in the search box, search by name, when the user selects one, the page displays the customer name, and at the same time uses the customer number in the data selected by the customer as the search condition.

  • richard man Profile Picture
    20 on at

    The problem is SysTableLookup method can return  only one item at once.

  • GirishS Profile Picture
    27,827 Moderator on at

    I am still not able to understand your issue?

    Filters works only for the fields that are first added via "addLookupUpField" method.

    If you add customer name you can search by name and if you add customer number you can search by number - Both wont work at the same time.

    Is this the issue you are asking?

    Thanks,

    Girish S.

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 659 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 289 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans