How to get Customers Name in Views as field with CustTable as DataSource.

(0) Share

Report

Posted on by Prem sai

Hello Everyone,

I have created a view with CustTable as a data source and I need Customer Name as Field in my View. Can anyone give me the X++ code of method for this.

3386.Screenshot-2023_2D00_05_2D00_15-104611.png

Thanks In advance.

Regards,

Prem Sai.

All responses (4)

Answers (2)

Prem sai 25 on at

Like (0)

Report

RE: How to get Customers Name in Views as field with CustTable as DataSource.

Thank You all
Suggested answer

Mohit Rampal 12,552 Super User 2024 Season 1 on at

Like (0)

Report

RE: How to get Customers Name in Views as field with CustTable as DataSource.

Hi, You can check CustAccountName view. It has already implemented the table joins and exposed AccountNum and Name field.
Verified answer

GirishS 27,821 Super User 2024 Season 1 on at

Like (0)

Report

RE: How to get Customers Name in Views as field with CustTable as DataSource.

HI Prem,

As Martin mentioned CustTable will have field named Party. This field you can add related with DirPartyTable.RecId.

Using this relation, you can get name of the customer.

Thanks,

Girish S.
Verified answer

Martin Dráb 230,817 Most Valuable Professional on at

Like (0)

Report

RE: How to get Customers Name in Views as field with CustTable as DataSource.

Join DirPartyTable with CustTable and take Name field from there.