Skip to main content
Post a question

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

Customer No. on sales order / search function issue

Posted on 31 Jul 2023 21:55:20 by 191
When the Customer No. is entered on the Sales Order, it searches against No., Name, Zip Code, Phone No.  This is kind of nice, however if the salesperson knows the Customer No., it does not always show up as the first /selected/ option meaning that once they hit tab/enter the number they've entered is changed.  Is there a way around this?
For example: salesperson wants to enter 4720 but if they do not tab/enter immediately after entering, the search comes up and now if they hit enter, it will change to 0138.
  • Brett F Profile Picture
    Brett F 191 on 01 Aug 2023 at 15:55:39
    Customer No. on sales order / search function issue
    HVGEEL - Yes, exactly.  For our business, it would be ideal for the search to search against the No. or the Name only.  They do not even need to see the ZIP Code or Phone No.  Do you know if it is possible to customize to that?
     
    YUN ZHU - It only happens if the number is in a different field.  In this case the zip code or phone no.  We are transitioning from Nav, and so we are used to clicking on the Column Name to search to that field specifically, so this is something users will need to adapt to. Example:
  • Suggested answer
    HVGEEL Profile Picture
    HVGEEL 288 on 01 Aug 2023 at 10:45:55
    Customer No. on sales order / search function issue
    I recognize this one.
     
    I remember having the same issue a few years ago.
    The behaviour you are seeing is a result of the 'fuzzy search' BC does in the list, while populating the dropdown.
     
    There is no simple answer to the question because the end-user will only in some cases know the CustomerNo by heart.
     
    You now have a tough decision to make, and it has to be made together with the end-users, in my opinion you cannot force it on them.
    - create a customization to force the No. when it is used: this requires that end-users know the No. UNDER ALL CIRCUMSTANCES, it breaks the fuzzy search completely
    - leave the fuzzy search as it is... all it requires is the effort from the end-users to pay attention to the data proposed in the dropdown.
     
    This in fact is more a business decision than a technical issue.
     
     
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,698 Super User 2024 Season 2 on 31 Jul 2023 at 23:38:59
    Customer No. on sales order / search function issue
    Hi, I tried it and there is no such problem. Below is my version.
    Version: W1 22.3 (Platform 22.0.59032.0 + Application 22.3.58346.58475)
     
    Hope this helps.
    Thanks.
    ZHU

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans