How to Write the code to get the telephone number and fax in the fetch method in ax reprots

(0) Share

Report

Posted on by srinivas pamidi

1,737

i want to display the telephone number and fax in the report, take the details from the logistics electronic address table.

i am writing the below code and test with debuugger but i am unable to get the data.

select Name from dirPartyTable where dirPartyTable.Name == 'CPIL'
    && dirPartyTable.PrimaryContactPhone == logisticsElectronicAddress.RecId;
    if(logisticsElectronicAddress.Type == LogisticsElectronicAddressMethodType::Phone)
    {
    Telephone       = logisticsElectronicAddress.Locator;
    }
    else
    {
    Fax             = logisticsElectronicAddress.Locator;
    }

can any one know about this please help me.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

telephone number and fax of whom ??

customer, vendor, employee, any other entity??? would you mind to specify???

Was this reply helpful? Yes No
srinivas pamidi 1,737 on at

Like (0)

Report

i want to display the legal entity details

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

is that ax 2012 or ax 2009?

Was this reply helpful? Yes No
Martin Dráb 237,926 Most Valuable Professional on at

Like (0)

Report

You get data from LogisticsElectronicAddress, therefore what you should have show and debug is your query for LogisticsElectronicAddress. The query above (for DirPartyTable) isn't important.

Was this reply helpful? Yes No
srinivas pamidi 1,737 on at

Like (0)

Report

ax 2012 r3

Was this reply helpful? Yes No
Suggested answer

Sohaib Cheema 49,438 User Group Leader on at

Like (1)

Report
you may get this information as under

CompanyInfo CompanyInfo; CompanyInfo = CompanyInfo::find(); info("Phone: "+CompanyInfo.phone()); info("Fax: "+CompanyInfo.teleFax());

Above code will return you Primary Phone and Fax. In case you wan to get the non-primary as well, you may use code as under. In below example I am getting phone number of HCMWorker which is party. in your case it will be a legal entity which you have to consider as party

LogisticsElectronicAddress logisticsElectronicAddress; HcmWorker HcmWorker; DirPartyLocation dirPartyLocation; DirPartyTable DirPartyTable; int64 RecIdOfParty; ; RecIdOfParty = HcmWorker::findByPersonnelNumber("000670").DirPerson().RecId; select dirPartyTable where dirPartyTable.RecId == RecIdOfParty; select firstOnly Description,Type,Locator,LocatorExtension,IsPrimary,IsPrivate,RecId from logisticsElectronicAddress order by logisticsElectronicAddress.IsPrimary desc join dirPartyLocation where dirPartyLocation.Party == dirPartyTable.RecId && dirPartyLocation.IsPostalAddress == NoYes::No && logisticsElectronicAddress.Location == dirPartyLocation.Location && logisticsElectronicAddress.Type == LogisticsElectronicAddressMethodType::Phone; { info(strFmt("%1 : %2 %3",logisticsElectronicAddress.Description,logisticsElectronicAddress.Locator,logisticsElectronicAddress.LocatorExtension)); }

Was this reply helpful? Yes No

Community site session details

How to Write the code to get the telephone number and fax in the fetch method in ax reprots

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

How to Write the code to get the telephone number and fax in the fetch method in ax reprots

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates