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)

Sort by

Verified answer

Martin Dráb 241,515 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Join DirPartyTable with CustTable and take Name field from there.
Verified answer

GirishS 27,845 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.
Suggested answer

Mohit Rampal 12,573 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi, You can check CustAccountName view. It has already implemented the table joins and exposed AccountNum and Name field.
Prem sai 25 on at

Like (0)

Report
Copy link

Link copied!

Thank You all