Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How Can I split the Se...
Small and medium business | Business Central, N...
Suggested answer

How Can I split the Sell-to Customer name field into first and last name

(1) ShareShare
ReportReport
Posted on by MA-22070947-0 85
Hi all,
 
There is field in my Posted Sales Invoice, where I'm getting the Text field named Sell-to Customer Name, now I want to split this field into first and last name field, then use them into my page. How can I achieve it?
 
Thanks.
Categories:
Dynamics 365 Business Central
Dynamics 365 Business Central
Dynamics 365 Business Central
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 75,723 Super User 2024 Season 2 on at
    How Can I split the Sell-to Customer name field into first and last name
    If this is a new field you created, sure. Do you want to know how to split it?
    If they are separated by fixed symbols, such as spaces, the following method will be relatively simple.
    Text.Split Method: Splits a string into a maximum number of substrings based on a collection of separators.
    List Data Type: Represents a strongly typed list of ordered objects that can be accessed by index.
     
     
    Hope this help.
    Thanks.
    ZHU
     
     
     
  • MA-22070947-0 Profile Picture
    MA-22070947-0 85 on at
    How Can I split the Sell-to Customer name field into first and last name
    Hi Yasas,
     
    I don't want to modify my existing page 😞
     
    Thank you. 
  • MA-22070947-0 Profile Picture
    MA-22070947-0 85 on at
    How Can I split the Sell-to Customer name field into first and last name
    Thank you Valentin for your response, but my Names are fully stored on first Name. Can I split that specific field. 
  • Yasas Profile Picture
    Yasas 55 on at
    How Can I split the Sell-to Customer name field into first and last name
    Hi,
     
    On the customer page, add two new fields: one for the first name and one for the last name. Name them appropriately, such as "Sell-to First Name" and "Sell-to Last Name". Then, incorporate these fields into the posted sales invoice page and table. For this modification, you need to have AL development knowledge.On the customer page, add two new fields: one for the first name and one for the last name. Name them appropriately, such as "Sell-to First Name" and "Sell-to Last Name". Then, incorporate these fields into the posted sales invoice page and table. For this modification, you need to have AL development knowledge.
     
    BR,
    Yasas.
  • MA-22070947-0 Profile Picture
    MA-22070947-0 85 on at
    How Can I split the Sell-to Customer name field into first and last name
    And folks I am a developer so you can tell me the line of code also 😁
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 25,066 Super User 2024 Season 2 on at
    How Can I split the Sell-to Customer name field into first and last name
    The customer card has two fields:
     
    • Name
    • Name 2
     
    Both of these are in the posted sales invoice as well. You could use these.
     
     
    Valentin Castravet
    Zander ERP Services

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,414 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans