Financial dimensions Hierarchy in Dynamics 365 for Commerce

I have received a few questions in the past on the hierarchy that is used to populate Financial Dimensions on Commerce transactions.

Here is a high level break down of the financial dimensions for each record and how they are set in different states of Post inventory, Statement calculate and Statement post. The dimensions are copied from the following records - Customer, Store, Terminal, Worker, Item and Payment Method, details are mentioned below.

If you want financial dimensions to populate from the Register instead of the Store, the Store should not have the dimensions populated.  Beware that you will receive a missing dimension error if all required financial dimensions are not populated.  Financial Dimensions will normally come from the Customer first.

Post Inventory

RetailTransactionTable

• Non Aggregated
  • Merge of
    • Customer, Store, Terminal, HCMWorker
  • Aggregated
    • Merge of
      • Customer, Store

RetailTransactionPaymentTrans

• Copied from RetailTransactionTable above

RetailTransactionSalesTrans

• If the item is stocked
  • Non Aggregated
    • Merge of

• • • • Customer, Store, Terminal, HCMWorker, InventTable

• Aggregated
  • Merge of

• • • • Customer, Store, InventTable

Calculate

RetailStatementTable

• Store

RetailEodTransactionTable

• Non Aggregated
  • Merge of
    • Customer, Store, Terminal, HCMWorker
  • Aggregated
    • Merge of
      • Customer, Store

RetailEodTransactionPaymentTrans

• Copied from RetailEodTransactionTable above

RetailEodTransactionSalesTrans

• Non Aggregated
  • Merge of
    • Customer, Store, Terminal, HCMWorker, InventTable
  • Aggregated
    • Merge of
      • Customer, Store, InventTable

RetailTransactionTable

• Copied from RetailEodTransactionTable above

RetailTransactionPaymentTrans

• Copied from RetailEodTransactionPaymentTrans above

RetailTransactionSalesTrans

• Copied from RetailEodTransactionSalesTrans above
• Overridden if the item is stocked and Retail Parameters reserve inventory is true
  • Non Aggregated
    • Merge of

• • • • Customer, Store, Terminal, HCMWorker, InventTable

• Aggregated
  • Merge of

• • • • Customer, Store, InventTable

Post

Create Sales Order

SalesTable

• Non Aggregated
  • Merge of
    • Customer, Store, Terminal, HCMWorker
  • Aggregated
    • Merge of
      • Customer, Store

 SalesLine

• Non Aggregated
  • Merge of
    • Customer, Store, Terminal, HCMWorker, InventTable
  • Aggregated
    • Merge of
      • Customer, Store, InventTable

Invoicing

After failure of invoicing and Retail Parameter “Recalculate Financial Dimension” is true we recalculate for the failed aggregations

• Recalculation same as in calculate for the following records of the statement
  • SalesTable,  RetailEodTransactionTable, RetailEodTransactionPaymentTrans, SalesLine, RetailEodTransactionSalesTrans
• RetailTransactionTable, RetailTransactionSalesTrans, RetailTransactionPaymentTrans have the values copied back at the end of Posting

Income Expense

BankVoucher

• Store

Tax

• Store

Payments

Default Financial Dimension for CustPayment

If Commerce payments are enabled for the sales order

               Use StoreTenderTable default dimensions as base

Add missing dimensions to base from RetailChannelTable

               Add missing dimensions to base from customer

Else

               Use default dimension as base

                               Add missing dimensions to base from customer

 Gift Card

LedgerJournalTable

• Store

LedgerJournalTrans

• Store

Fixed dimension on ledger account

If you have Fixed value of financial dimension on ledger account itself (at this time on ledger account from Payment method Cash), after the statement is posted you get:

1. All retail transactions (Sales transactions and Payment transactions) have financial dimensions from the store by default (for cash&carry transactions or customer order transactions)
2. Sales order has financial dimensions from the store by default
3. Payment voucher for this particular ledger account (where fixed value was added) has financial dimensions taken from ledger account itself (not from the store).

Setup on ledger account:

Retail transactions/Payment transaction:

Payment voucher:

Bank drop

ONLY default financial dimensions from Payment method are taken to Bank drop voucher.

When you check Retail Store transactions, Bank drop transactions have dimensions from Store and Register (either Voucher transactions are aggregated or not aggregated).

In addition to above context, related to BANK DROP transactions:

We have a parameter in Store/Tab Statement/closing / Bank drop calculation.
This parameter decides that Financial dimensions are taken from Payment method or from Store.
When Bank drop calculation is set to Last – financial dimensions to Bank drop voucher transactions are posted from the Store.
When Bank drop calculation is set to Sum – financial dimensions to Bank drop voucher transactions are posted from the Payment method.

This parameter I am talking about:

One other thing to note is that you can setup a financial dimension link to a site.  Such financial dimensions linked to Site will be posted to Inventory ledger accounts only.

Below is an example for BusinessUnit.

Inventory management > Setup > Posting > Dimension link

Edit

Select the dimension to be linked:  BusinessUnit

Click Sites to open the Sites form

Select West

Expand Financial dimensions

Select BusinessUnit: 005

Select a BusinessUnit for Central(006), DC(002) and EAST(003)

Save the Site and click X to close out of the Site

In the Dimension link click Save

Click Activate link

In the Linked dimension update form click OK

The Dimension link will now be active