Edit financial dimensions for retail transactions

This article describes how to edit financial dimensions for retail transactions in Microsoft Dynamics 365 Commerce.

Edit financial dimensions

To edit financial dimensions for retail transactions in Commerce headquarters, follow these steps.

  1. Open the Financial dimensions configuration for integrating applications page.
  2. Select the active Default dimensions integration record.
  3. On the Financial dimensions FastTab, make sure that all the dimensions that you want to edit in the Excel worksheet are present in the Selected list. For more information, see Data entities.
  4. Download and open the Excel file from the Statements page, the Retail transactions page, or the Transaction validation failures tile in the Store financials workspace.
  5. To change the transaction financial dimension, select Design, and then select the pencil symbol next to the Transaction (auditable) row.
  6. Find and select the FinancialDimensionDisplayValue field, select a cell in the header part of the Excel worksheet, and then select Add label.
  7. Select a cell below the cell that you selected in the previous step, select Add Value, and then select Refresh. The financial dimensions are added to the Excel worksheet, and they can then be edited and published.
  8. To change the dimensions on the transaction lines, select the Sales transactions (auditable) row, select the pencil symbol, and then repeat steps 6 and 7.
  9. To change the dimensions on the payment lines, select the Payment transactions (auditable) row, select the pencil symbol, and then repeat steps 6 and 7.

Additional resources

Edit and audit cash and carry and cash management transactions

Edit and audit online order and asynchronous customer order transactions

Create an Excel workbook to edit retail transactions

Add fields to an Excel workbook to edit retail transactions