How to get LogisticsElectronicAddress's Cellphone ?

(0) Share

Report

Posted on by ATMA-Jen

319

Hello All,

I need to get the ContactPerson's CellPhone in SalesQuotationTable.

I can't get the relation.

Please help and thank you.

I checked the table relation:

LogisticsElectronicAddress.Type=Cellphone, I need to get the Locator.

I try:

SalesQuotationTable.ContactPersonId == ContactPerson.ContactPersonId

ContactPerson.Party == DirpartyTable.RecId

LogisticsElectronicAddress.PrivateForParty == DirPartyTable.RecId

but I check the LogisticsElectronicAddress.PrivateForParty == 0 not DirPartyTable.RecId == 5637228576

Please help.

Br, Jen

I have the same question (0)

All responses (21)

Answers (2)

Sort by

Blue Wang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Jen,

LogisticsElectronicAddressMethodType::Phone for Phone Number.

You can refer this:

https://axchaitu.wordpress.com/2015/12/04/get-email-phone-from-custtable-or-dirpartytable/

Was this reply helpful? Yes No
Suggested answer

Satish Panwar 14,673 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Jen,

You can use something like below in your relations to get the data.

select CONTACTPERSONid, CUSTACCOUNT,* from SALESQUOTATIONTABLE where DATAAREAID = 'usmf' and QUOTATIONID = '000007'

select party from CONTACTPERSON where CONTACTPERSONID ='000001' and CUSTACCOUNT = 'us-008'

select b.LOCATOR, * from DIRPARTYLOCATION a inner join LOGISTICSELECTRONICADDRESS b on a.LOCATION = b.LOCATION and a.party = '22565445701' and b.TYPE = 1

Was this reply helpful? Yes No
Suggested answer

Satish Panwar 14,673 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Jen,

You can use something like below in your relations to get the data.

select CONTACTPERSONid, CUSTACCOUNT,* from SALESQUOTATIONTABLE where DATAAREAID = 'usmf' and QUOTATIONID = '000007'

select party from CONTACTPERSON where CONTACTPERSONID ='000001' and CUSTACCOUNT = 'us-008'

select b.LOCATOR, * from DIRPARTYLOCATION a inner join LOGISTICSELECTRONICADDRESS b on a.LOCATION = b.LOCATION and a.party = '22565445701' and b.TYPE = 1

Was this reply helpful? Yes No
Satish Panwar 14,673 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Jen,

Please let us know if above suggestion helped by clicking yes against the answer. If you still have open questions, please let us know.

Was this reply helpful? Yes No
Suggested answer

Ehab_altammam 150 on at

Like (0)

Report
Copy link

Link copied!

Hi ATMA-JEN

try to use something std ,will save your time and effort ,

in the sales quotation table a method called Contactperson() and in the contactperson table method phone()

so actually what you need a single line of code

salesqoutationtable.contactperson().phone()

Please mark the answer as yes if this helped

Was this reply helpful? Yes No
ATMA-Jen 319 on at

Like (0)

Report
Copy link

Link copied!

Hello All,

I still no get the solution about how to get the LogisticsLocation.Type = CellPhone's Locator, to get the SalesQuotation's contactor's cellphone.

AX Table relation:

If I know the LogisticsLocation.LocationId then

I can get LogisticsLocation.RecId == LogisticsElectronicAddress.Location

Then

I can get when LogisticsElectronicAddress.Type = cellphone, then the cellphone number is LogisticdElectronicAddress.Locator's value.

so

Could anybody tell me how to get the LogisticsLocation.LocationId from the SalesQuotationTable ??

Thank you.

Br, Jen

Was this reply helpful? Yes No
Ehab_altammam 150 on at

Like (0)

Report
Copy link

Link copied!

Hi Jen ,

why not to use the code provided above in my prev comment ,or do you need something in the SQL side ?

Was this reply helpful? Yes No
ATMA-Jen 319 on at

Like (0)

Report
Copy link

Link copied!

Hello Ehab,

salesqoutationtable.contactperson().phone(), cant get phone, but can't get the cell phone,

I check because the privateforparty is different:

if can get the location relation , that's could solved my problem:

Was this reply helpful? Yes No
ATMA-Jen 319 on at

Like (0)

Report
Copy link

Link copied!

Hello Ehab,

about the phone method code:

so I think if could know the relation between SalesQuotationTable with LogisticsElectronicAddress Table,

maybe is the best solution.

Thank you.

Br, Jen

Was this reply helpful? Yes No
Verified answer

Ehab_altammam 150 on at

Like (0)

Report
Copy link

Link copied!

Ah sorry ,

you can use these views :DirPartyContactInfoView, LogisticsEntityContactInfoView ,LogisticsContactInfoView

it has the party Id ( Entity ) and you can get the party id from the Contractperson table ... and use can filter in the flag is mobile .

Please let me know if that help

Was this reply helpful? Yes No