Get Sales Representative Personnel Number from Store Number

This X++ method retrieves the personnel number of the sales representative associated with a specified retail store. It identifies the related RetailStoreTable and RetailChannelTable records, then follows the store address book and party relationship to locate the corresponding HcmWorker. The method returns the worker's PersonnelNumber.

X++ Code

public static Name getSalesrep(str _storeNum)

{

    RetailStoreTable        retailStoreTable;

    HcmWorker               hcmWorker;

    RetailChannelTable      retailChannelTable;

    RetailStoreAddressBook  retailStoreAddressBook;

    DirAddressBookParty     dirAddressBookParty;

    str                     personalNum;

    select firstonly retailStoreTable

        join retailChannelTable

        where retailChannelTable.RecId     == retailStoreTable.RecId

           && retailStoreTable.StoreNumber == _storeNum

        join retailStoreAddressBook

        where retailChannelTable.RecId == retailStoreAddressBook.StoreRecId

        join dirAddressBookParty

        where dirAddressBookParty.AddressBook  == retailStoreAddressBook.AddressBook

        join hcmWorker

        where hcmWorker.Person == dirAddressBookParty.Party;

    {

        personalNum = hcmWorker.PersonnelNumber;

    }

    return personalNum;

}

Process Flow

1. 
   The method receives the retail store number through _storeNum and selects the matching RetailStoreTable record.
   

2. 
   It joins RetailChannelTable, RetailStoreAddressBook, and DirAddressBookParty to follow the store's address book and party relationships.
   

3. 
   The related HcmWorker is identified through the party relationship.
   

4. 
   The worker's PersonnelNumber is assigned to personalNum and returned.

   

Figure: Flow of retrieving the sales representative personnel number from a retail store.