Hi Everybody,
I am new in using Electronic reporting.
I have a problem for retrieving some data to generate an xls file.
I have to data sources:
HcmEmployeeEntity --->tab1
HcmPersonIdentificationNumber --->tab2
From the tab2 I have to export all information related to PersonalNumber(fiscalCode), full name and e-mail, I can find this information easily with the predefined relations with people table.
From tab1 I have to extract for each row coming from tab2, the related employment start date.
There is no predefined direct relation between the 2 tables but the relation with people table can help for my purpose, now my question is:
How can I collect the information I need?
For me this is a normal lookup between 2 datasource but I can't find the right way for doing it.
Does anyone help me
Regards
Giorgio
Thank you Giorgio for the update and sharing the you resolved the issue.
Hi Everebody,
For your information I solved the problem using the relations inherited directly by the model.
Thanks
Girogio
For lookup data in other table we can use:
Hi Giorgio,
Could you please specify what are you trying to achieve by using Electronic Reporting feature for HR data?
Electronic reporting is mainly used for financial reporting purposes.
If you need to export HR data from the system you can use Data Management feature, which is design for export/import data in D365.
Here you can find more info: https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/data-entities-data-packages
If you have any questions or comments, please let know. Thank you in advance!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,782 Super User 2024 Season 2
Martin Dráb 229,067 Most Valuable Professional
nmaenpaa 101,150