How to get Customer Phone number (telephone) from LogisticsElectronicAddress Table in SMASalesOrderTable form (Service Order in service Management Module)

(0) Share

Report

Posted on by Arif Hussain

206

Hello experts,

I need to display customer phone number in SMAServiceOrderTable. I have checked that customer phone number is coming from LogisticsElectronicAddress Table in smmContactPerson form. But I do not get any relation between LogisticsElectronicAddress and SMAServiceOrderTable Table.

Your suggestions would highly be appreciated.

Here are the screenshots:

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

nunomaia 23 Moderator on at

Like (1)

Report

RE: How to get Customer Phone number (telephone) from LogisticsElectronicAddress Table in SMASalesOrderTable form (Service Order in service Management Module)

SMAServiceOrderTable is related to table named ContactPerson

Contact Person is related to PartyTable.

If you can relationship between PartyTable and LogisticsElectronicAddress in mtehod phone of ContactPerson

Was this reply helpful? Yes No
Arif Hussain 206 on at

Like (0)

Report

RE: How to get Customer Phone number (telephone) from LogisticsElectronicAddress Table in SMASalesOrderTable form (Service Order in service Management Module)

Hi nunomaia ,

Thank you for your response. Yes you are right I have checked it. But still I am confused how to display the ContactPersonPhone in SMAServiceOrderTable. Can you please provide your suggestion on this?

Was this reply helpful? Yes No
GirishS 27,825 Moderator on at

Like (1)

Report

RE: How to get Customer Phone number (telephone) from LogisticsElectronicAddress Table in SMASalesOrderTable form (Service Order in service Management Module)

Hi Arif,

As Nuno Maia mentioned the table relations, You can create a display method based on the relation in the service order form to display contact person phone number.

Thanks,

Girish S.

Was this reply helpful? Yes No
Arif Hussain 206 on at

Like (1)

Report
RE: How to get Customer Phone number (telephone) from LogisticsElectronicAddress Table in SMASalesOrderTable form (Service Order in service Management Module)

[ExtensionOf(tablestr(SMAServiceOrderTable))] final class SMAServiceOrderTable_Extension { public display ContactPersonPhone phone() { return ContactPerson::find(this.ContactPersonId).phone(); } }

Thank you nunomaia , GirishS

I really appreciate your response. Above is the code which display's the ContactPersonPhone in SMAServiceOrderTable form.

Was this reply helpful? Yes No