Exporting and table related to Employees

(0) Share

Report

Posted on by Ibakordor Kharmih

111

Hi team,

I have two questions on Business Central. I was doing my research and was having difficulty exporting employees table with all of the fields available in the Employee card. Also, I want to check where can I find if the employees have any relation or data on the other tables like Assets linked to it, before I delete an Employee .

How to export Employees table or any table for data migration in Business Central? I
How to know an employee is related to what?

You help is much appreciated!

Categories:

Data Migrations

Administration and permissions

All responses (3)

Answers (0)

Ibakordor Kharmih 111 on at

Like (0)

Report

Exporting and table related to Employees

Thank-you Ben and Yun Zhu.. These are helpful!
Suggested answer

YUN ZHU 68,242 Super User 2024 Season 2 on at

Like (1)

Report

Exporting and table related to Employees

Hi, just adding some information.

Microsoft Dynamics 365 Business Central: How to Export and Import Data (Using Configuration Packages)

https://yzhums.com/4286/

If you just want to confirm the data, it is recommended to use the Table Information page. Click No. of Records to open the table directly.

As for checking the releated table, as far as I know there is no easy way. Some standard functions have the following functions, but this is only checked for the specified table, there is no way to check the entire system.

Hope this helps.

Thanks.

ZHU
Suggested answer

Ben Baxter 4,445 Super User 2024 Season 2 on at

Like (1)

Report

Exporting and table related to Employees

To export data from Business Central, you would use a Configuration Package selecting the table(s) you want to export. You can also select which fields within the table(s) you want to export. Below is a list of standard Employee tables to select from:

I would not recommend deleting the Employee record. It would be better to adjust the Status, Termination Date, etc. on the record. This way you maintain a clear history of the employment and any related ledgers. If the employee is linked to a Resource, it would be a good idea to Block that Resource as well.

Best Regards,

Ben Baxter

Accent Software Inc