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 237,679 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,827 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,565 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