lookup contactperson

Finance and Operations/AX Developer Forum
1

Hi everybody,

I need to lookup contact person (AX 2012), but it only shows up the contacts who have primary address.

I just used contactperson::lookupcustcontactperson() method .

can anybody help? thank in advance!

Rosa

2

Hi,

https://hellodax.com/2015/03/26/create-simple-form-lookup-for-edt-example-vendaccount/

See this and create ur own lookup…

3

Have a look at the sales order and see how the contact person look up has been implemented.

4

Hi Gopinath, I have created my own query, but it only show contactperson id , i need to show the name instead

5

Hi Kranthi, i am going to check. thanks

6

do you know how to use recid as query range value? or cannot use it at all.

7

the contact person on sales order does not match my requirement, it shows only the contact who has primary address. I need to show all of tem

8

Hi,
can u show the code…?

9

It should be showing the contact irrespective of the primary address and i don’t even see any such code in the related lookup form \Forms\ContactPersonLookup. Please try to debug.

10

void lookup()
{
Query query;
QueryRun queryRun;
QueryBuildDataSource qbdContact;
QueryBuildDataSource qbdDirPerson;
QueryBuildDataSource qbdcust;
QueryBuildDataSource qbdLogAddress;
DirPartyRecId custParty;

SysTableLookup sysTableLookup;

query = new Query(queryStr(smmContacts_NoFilter));

qbdContact = query.dataSourceTable(tableNum(ContactPerson));//.findRange(fieldNum(ContactPerson, CustAccount));
qbdContact.addRange(fieldNum(ContactPerson, CustAccount)).value(BFFProjWizTable.CustAccount);

qbdDirPerson = qbdContact.addDataSource(tableNum(DirPerson));
qbdDirPerson.fetchMode(JoinMode::InnerJoin);
qbdDirPerson.relations(false);
qbdDirPerson.addLink(fieldNum(ContactPerson, Party), fieldNum(DirPerson, RecId));

sysTableLookup = SysTableLookup::newParameters(tableNum(ContactPerson),this);
sysTableLookup.addLookupfield(fieldNum(ContactPerson,ContactPersonId));

sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();

}

11

but i have two contacts for a customer, it shows only the one who has primary address

12

Are you using \Data Dictionary\Tables\ContactPerson\Methods\lookupCustContactPerson or the above code(code you mentioned)?

13

the above code

14

Do you have the same issue with \Data Dictionary\Tables\ContactPerson\Methods\lookupCustContactPerson?

15

Hi Kranthi, sorry the salesorder contact person’s lookup works fine. I need to use the same funcation on a form which has not datasource has contactpersonid, how can i make it work as salesorder

16

What does that mean?

17

Hi Kranthi, I need to show all the contacts for this customer when i use lookup, I have found very strange thing which when i add one more contact to this customer (there are 3 contacts only one of them has primary address), then the lookup shows all three, but if there are two one with primary address the other without, then the lookup only show one with primary address

18

Hi, i don’t see any such issue. how you are calling that method?

19

Hi,

this may helpful to you…

http://kunaldynamicsax.blogspot.in/2014/08/lookup-on-form-control-using-temporary.html

20

Hi,

this may helpful to you…

http://kunaldynamicsax.blogspot.in/2014/08/lookup-on-form-control-using-temporary.html