[Lori Holmes]

Hey all!  Some help from you guys, please!

1. I am trying to determine a way to identify all worker/employee address records and which of those address records are checked as private.  Would this effort encompass multiple tables (entity and global)?

2. I know there are GAB settings which restrict who can view private addresses via entity and role.  Is one setting the master?  Or can (should) both settings be used together?  

We are running AX 2012 RTM.

Thank you so much in advance!

——————————
Lori Holmes
Hamamatsu Corporation
LHOLMES@hamamatsu.com
732-537-3619
——————————

[Jason Carter]

Hi Lori,

There’s a IsPrivate field in DirPartyPostalAddressView. You may be able to get what you need by linking HCMWorker to the postal address view and filtering for the private addresses.

I’ll email you the report. Refresh it on your data, and let me know if it works.

Thanks,

Jason

——————————
Jason Carter
Solutions Enablement – Atlas
Global Software Inc.
Fargo ND
——————————
——————————————-

[Rick Pierson]

?
As for your first question, the following X++ ‘SQL’ should do the trick if all you want are counts.

static void jobWorkerAddressCounts(Args _args)
{
    LogisticsPostalAddress  logisticsPostalAddress;
    LogisticsLocation       logisticsLocation;
    DirPartyLocation        dirPartyLocation;
    DirPartyTable           dirPartyTable;
    HcmWorker               hcmWorker;
   
    int64 countAddresses;
    int64 countPrivateAddresses;
   
    select count(RecId)
        from logisticsPostalAddress
      join RecId
        from logisticsLocation
        where LogisticsLocation.RecId == logisticsPostalAddress.Location
      join RecId
        from dirPartyLocation
        where dirPartyLocation.Location == LogisticsLocation.RecId
      join RecId
        from dirPartyTable
        where DirPartyTable.RecId == DirPartyLocation.Party
      join RecId
        from hcmWorker
        where HcmWorker.Person == dirPartyTable.RecId;
    countAddresses = logisticsPostalAddress.RecId;   
   
    select count(RecId)
        from logisticsPostalAddress
        where logisticsPostalAddress.IsPrivate
      join RecId
        from logisticsLocation
        where LogisticsLocation.RecId == logisticsPostalAddress.Location
      join RecId
        from dirPartyLocation
        where dirPartyLocation.Location == LogisticsLocation.RecId
      join RecId
        from dirPartyTable
        where DirPartyTable.RecId == DirPartyLocation.Party
      join RecId
        from hcmWorker
        where HcmWorker.Person == dirPartyTable.RecId;
    countPrivateAddresses = logisticsPostalAddress.RecId;       
   
    info(strFmt(‘Number of Addresses = %1; Number of Private Addresses = %2’,
        countAddresses, countPrivateAddresses));
}

——————————
Rick Pierson
Braun Intertec
Bloomington MN
——————————
——————————————-