Data Management EXPORT, Validate your D365 Chart of Accounts
Updated: Aug 29
Microsoft Office Export to Excel usually only shows a few of the fields, but you want to validate all of your Main Account settings.
This is a good idea, as the Main Accounts control several things, like Year End Close, Currency Exchange, Posting Profiles, and Financial Reporting.
Using the D365 Data Management Workspace makes short work of getting all the information about Main Accounts at your finger tips.
1. Create an Export
Choose the Export tile.
D365 \ Workspaces > Data Mangement > Export (tile)
2. Create your export definition
After selecting "Export" (step one above), you will be shown a export definition, just create a new export definition:
(1) Click New
(2) Enter a Group Name
(3) Enter a Description
(4) Clicl Add Entity
A pop up window will appear.
(5) Choose Main Account as your Entity Name.
(6) Choose Excel as your Target Data Format
(7) Click Add
another pop up window looking similar to the 5,6,7 pop up will appear
(8) Just click close to get rid of the 2nd pop up window and create the Entity (as exhibited with yellow highlight).
3. Export your Main Accounts
Click Export now.
When the big success check mark appears (2), choose Download file (3).
In the bottom left corner, wait for the Excel icon to stop flashing, and then click on the the drop down arrow next to the Excel Icon to open your file.
4. Review and Validate your Chart of Accounts
You may have more than one Chart of Accounts. All Chart of Accounts are exported.
There are several Chart of Accounts in the CONTOSO data, so I like to Wrap row1 and filter for a specific Chart of Accounts [set of Main Accounts] in column A.
Note: Chart of Accounts for "Brazil" is displayed. Filter for your desired Chart of Accounts.
You can choose to filter accounts in many different ways to validate to your heart's content.
I filter MAINACCOUNTTYPE (Column U) by type i.e. "Asset" and verify all the MAINACCOUNTID (Column B) have the proper numbering.
I like all Assets to start with the digit "1" when building a USA Chart of Accounts.
Some countries, such as FRANCE have a statutory Chart of Accounts that does not follow the above USA numbering convention.
And vice versa,
I next filter MAINACCOUNTID (Column B) to make sure all accounts that start with "1" are also classified as "Asset" in the MAINACCOUNTTYPE (Column U)
I use this filtering technique for all the other MAINACCOUNTTYPES, and then move on to validate other fields, like the Categories, and Currency fields.
We have successfully exported our Main Accounts via Data Management.
All the fields are now at our fingertips. Hurray !