Post#40: DIEF – Importing Fixed Asset Masters

First post for 2020!!! Happy new year everyone.

Let us get started on how to create fixed assets in the fixed asset module via the DIEF/DIXF in AX 2012 R3.

This post does not include how to create the acquisition journals or the depreciation, it is just to show how to create the masters which have no financial impact in AX.

Follow the below steps:

1) Make sure you have the fixed asset entity already existing in
Data import export framework>Setup > Target Entities

Else you need to create the same.

Entity typeEntityEntity nameApplication moduleStaging tableEntity classTarget entity
EntityAssetTableAsset MasterFixed assetsDMFAssetEntityDMFAssetEntityClassDMFAssetTargetEntity

2) Create a New processing group with this entity. Enter any group name and a description.

Now click on the Entities button. Make sure to select the correct Entity name. Enter a source data format and always have the checkboxes ticked for extra safety.

3) Now click on the “Generate Source File” to select the required columns.

4) Now click on the “Generate sample file” button to save the file of type .csv then click on the Finish button.

5) Now Fill in the data via excel and select the file in the processing group field.

6) Click on the “Generate source mapping” button to have the system automatically map the fields in the csv to the staging table.

7) Click on the “Modify source mapping” button to check if the columns are mapped correctly. In CU10 and below you will find that one of the columns is not mapped and funny enough it is the most import the “Name” Column.

Issue Cause: The name field is in the field group exclusion list (AOT). You can view this from the AOT when you lookup the DMFAssetEntity table.

There are 2 ways to resolve this.

Resolution 1: This is the easiest method. It just involves manually mapping the two columns by dragging the source column to the staging column.

Resolution 2: Open AOT and navigate to the table DMFAssetEntity. Check the fieldgroups and you can delete the name field from the exclusion list. Then when you generate source mapping the name column will be mapped automatically.

8) Click on the “Modify the source mapping” button and then on the “Mapping details” button. This screen shows additional details on the mapping. When working with text fields I like to make sure we don’t have any special characters in some of the text fields such as asset name that could mess up the import. So I setup these columns in excel as text type and in AX set the mapping as “Text qualifiers” using the checkbox. Remember to click on the Save button to save your changes, then you can close this window.

9) Now you are ready to click the “Validate” button to see if everything is in order.

10) Click on the “Preview Source File” button to make sure that the file is being read correctly.

11) Now close the entity form and you should be back in the “Processing group” form . Now select the FA processing group and click on the “Get Staging Data” button to import the file to the staging table.

12) Click OK

13) Now click “Run”

14) Now click “Ok”

15) You should see the info log on how many records have been imported to staging.

16) Now let us go back to the processing group and click on the “Execution History” button

17) Click on the “View Staging Data” button

18) Check the data and click on ” Validate all” to make sure all records are ok.

19) You should see no error messages but if errors obviously you need to fix the same in the excel/csv file and re-upload to staging.

20) Click on the “Copy data to target” in the previous screen.

20) Click on the “Ok” button

21) Click on the “Run” button

22) Click on the “Ok” button

22) Verify the same number of records in the info log have been created as expected

Navigate to “Fixed assets>Common>Fixed assets>Fixed assets” to see the new Fixed assets.

That is it. Quite simple.

Happy DAXing…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s