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

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

(1) Share

Report

Posted on by MA-22070947-0

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

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Valentin Castravet 31,396 Super User 2025 Season 2 on at

Like (0)

Report
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

Was this reply helpful? Yes No
MA-22070947-0 85 on at

Like (0)

Report

And folks I am a developer so you can tell me the line of code also 😁

Was this reply helpful? Yes No
Yasas 55 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
MA-22070947-0 85 on at

Like (0)

Report

Thank you Valentin for your response, but my Names are fully stored on first Name. Can I split that specific field.

Was this reply helpful? Yes No
MA-22070947-0 85 on at

Like (0)

Report

Hi Yasas,

I don't want to modify my existing page 😞

Thank you.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,595 Super User 2025 Season 2 on at

Like (0)

Report

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.

https://yzhums.com/9273/

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

Was this reply helpful? Yes No