On several D365 FO tables, inventory dimensions exist. Each inventory dimension is expressed in a RecId that refers to the Inventory dimensions (InventDim) table. So, it does not reflect the inventory dimension name and value. You can use the Inventory dimension option to get or set the inventory dimension value based on the RecId and the dimension name as defined for the field option.

  • On import, you receive the dimension value. Based on the RecId in the target field and the selected inventory dimension, the value is set in the InventDim table.
  • On export, based on the RecId in the source field and the selected inventory dimension, the dimension value is gotten from the inventory dimensions table. Note: On export, the source field type must be int64.

Note: 

  • Only use the Inventory dimension field option if the InventDimId field is the target field of the field mapping.
  • For each used inventory dimension, add a separate field mapping. For example, if you use five inventory dimensions on a sales line, add five field mappings for the sales line target record. Each of these field mappings has the InventDimId field as target field. For each InventDimId field mapping, select the Inventory dimension field option and select the applicable inventory dimension.


Standard procedure

1. Click Connectivity studio Integration Design.
2. On the Message tab, in the list, find and select the desired message.
3. Click Edit.
4. In the Mapping section, in the Target record pane, in the list, find and select the desired target record.
5. On the Mapping tab, on the Field mapping tab, in the list, find and select the desired field mapping.
6. Click the Field options tab.
7. Select the Inventory dimension check box.
8. Define the name of the inventory dimension which value you want to set.
  In the Inventory dimension field, enter or select a value.
9. Close the page.

Notes

Instead of using the Inventory dimension field option, you can also apply inventory dimensions in another way. To do so:

  1. Add the InventDim table with the desired fields to your document.
  2. Add the InventDim document record to your message mapping and map the desired fields. Make sure that, in the mapping, the InventDim document record is added before the line to which you want to apply the inventory dimensions.
  3. In the line mapping to which you want to apply an inventory dimension, add the InventDimId field.

 

Provide feedback