Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Unanswered

Personnel number need to update from excel templates fromfor customer in AX 2012 R3

Posted on by 5,885

Hi all,

I have excel template. It contained Customer Account no and Personnel number.

I needs to update personnel number based on the customer account 

For example-

Suppose I have customer C0001 and Personnel number 900

In AX. 

In excel templates,  suppose C0001  ,Personnel number 300

So, I have to update 300 for customer C0001.

Kindly send me the query please. 

Please give me more shed on this 

  • ergun sahin Profile Picture
    ergun sahin 8,812 Super User on at
    RE: Personnel number need to update from excel templates fromfor customer in AX 2012 R3

    Customer can have a responsible personnel (CustTable.MainContactWorker)

    If you are talking about this field then You can check if new Personnel Number exists at HcmWorker and you can update MainContactWorker with HcmWorker.RecId

  • Komi Siabi Profile Picture
    Komi Siabi 12,407 Super User on at
    RE: Personnel number need to update from excel templates fromfor customer in AX 2012 R3

    Your requirement seem not to be clear. On which table are trying to update personnel number?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans