Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Unanswered

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

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.

Categories:
  • GirishS Profile Picture
    GirishS 27,803 Super User on at
    RE: How do I get the customer number that selected by user through customer name

    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.

  • richard man Profile Picture
    richard man 20 on at
    RE: How do I get the customer number that selected by user through customer name

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

  • richard man Profile Picture
    richard man 20 on at
    RE: How do I get the customer number that selected by user through customer name

    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.

  • GirishS Profile Picture
    GirishS 27,803 Super User on at
    RE: How do I get the customer number that selected by user through customer name

    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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans