Dynamics Community Forum Thread Details

Hi Suha,

Not all transactions have financial dimensions posted from Register. See details below (I also attach the file).

Financial dimensions postings in Retail

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, HCMWorker, InventTable and RetailStoreTenderTypeTable, details are mentioned below.

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