Share
ReportI need to display the Description Fields from LogisticsElectronicAddress table in purchase order confirmation SSrS report.
*This post is locked for comments
You’re offline. This is a read only version of the page.
97
I need to display the Description Fields from LogisticsElectronicAddress table in purchase order confirmation SSrS report.
*This post is locked for comments
Hi Palak,
Possibly you can call the phone() method from the vendTable table? This will return the primary phone setup on the vendor.
Or use it as example for your own logic.
All responses (
Answers (
display Phone phone()
{
LogisticsElectronicAddress electronicAddress = DirParty::primaryElectronicAddress(this.Party, LogisticsElectronicAddressMethodType::Phone);
return electronicAddress ? electronicAddress.Locator : '';
}
Hi
its a ssrs report (PO confirmation)
and i want to fetch the description of phone type in my purchase order confirmation report as alternate contact number
Hi Palak,
The contact information could have multiple records? Which type do you need? (email, phone,...) and for what exact purpose? Note that the locator field usually has the information about phone, mail, etc.
Out of the box there are no Morphx reports anymore. They have been replaced with SSRS reports. Do you mean to say, you created a morphx report yourself?
Currently I am Working on the Purchase order Confirmation Report(Morphx).
I need to fetch the Description in the Vendor Address Form ->contact Information->description
It is There in the Logistics Electronic Address How to get this Field in the Purchase order Report.
Hi Palak,
What is your exact question? Where do you need help? SSRS design, data provider, ...?
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
