Comments
That was one of the first remarks i made when i entered the world of Business Dynamics.
I was used to make screens and reports in MS Access, the majority was based on querys and not direct on tables.
I believe this should be a normal facility is a so called relatinal database and therefore was suprised (dissappointed) that BC does not support this.
@All,
There is a workarond with some side effects. You can add the Manager role to the private location security settings. See also my blog how to do this: https://dynamicspedia.com/2020/07/about-the-private-location-security-in-finance-operations-and-human-resources/
On the Company directory the private details are then visible, however the private phone numbers are then visible for all employees; not only the direct reports.
So for this reason, also voted on this idea to have it available for only the direct reports.
Additional idea could be overriding as a custom destination for further usage for the email destination type. Currently you cant overriding as a custom destination for further usage.
Only one email destination can be setup per report configuration! - There is no option to have different email settings per a report, which is an essential common requirement!