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.

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Martin Dráb 236,859 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.

Was this reply helpful? Yes No
Verified answer

GirishS 27,825 Moderator 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.

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,563 Moderator 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.

Was this reply helpful? Yes No
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

Was this reply helpful? Yes No