BeyondERP.Newsletter
Menu

Inquiry page · Retail and Commerce

Store transactions

An inquiry page in Commerce headquarters that lists the transactions recorded at store point of sale (POS) registers after they are uploaded from the channel.

Used by
Retail merchandising manager, Retail operations manager, Retail service and 1 more role
Business process
Post store end-of-day financial statements in Dynamics 365 Commerce
Menu item
RetailRetailStoreTransactionTable
Main table
RetailTransactionTable
Data entity
RetailTransactionEntity
Show what matters for
PAGE GUIDEWhat the page does and how to use it6 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isAn inquiry page in Commerce headquarters that lists the transactions recorded at store point of sale (POS) registers after they are uploaded from the channel.
What you do hereUse this page to find a POS transaction by receipt number or customer account, check its validation status before statement posting, and review its details.
ExampleFor example, if a POS customer order is missing in headquarters, filter Store transactions by the receipt number to see whether the transaction has arrived.
Store transactions page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processManage sales orders › Manage store operations › Post store end-of-day financial statements in Dynamics 365 Commerce
Menu pathRetail and Commerce › Inquiries and reports › Store transactions
Set up firstDistribution schedule (P-0001 job) Microsoft Learn POS posting (Validate store transactions) Microsoft Learn
Used next byStatements Microsoft Learn
Related pagesStore financials workspace (Cash and carry validation failures) Microsoft Learn
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Steps from Microsoft

  1. Go to Retail and Commerce > Inquiries and reports > Store transactions.
  2. Filter the list by receipt number or customer account number.
  3. Select the transaction to review its details and validation status.
  4. If the transaction is not found, run the P-0001 channel transactions job and check again.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Validation statusResult of the Validate store transactions job for the transaction: Successful, Error or None.Microsoft Learn ValidationStatus
Last validation timeDate of the last validation run for the transaction.Microsoft Learn ValidationDateTime
Receipt numberUnique identifier of the receipt.Microsoft Learn receiptId
Store numberThe store where the transaction occurred.Microsoft Learn
Register numberThe POS register that recorded the transaction.Microsoft Learn
TypeThe kind of transaction, such as sale, logon, logoff, end of shift or end of day.Microsoft Learn type
Entry statusPosting status of the transaction, such as None, Voided, Posted, Concluded, Cancelled or On Hold.Microsoft Learn
Statement numberThe statement that includes the transaction.Microsoft Learn statementId
Technical architect

4Technical

Menu itemRetailRetailStoreTransactionTable Checked in Dynamics 365
FormRetailTransactionTable Checked in Dynamics 365
TableRetailTransactionTableShown as “TRANSACTIONS” in Record infoKey field: Channel_OMOperatingUnit_Name, store, terminal, transactionIdChecked in Dynamics 365
Data entitiesRetailTransactionEntityTransactions Microsoft data model
Who can open itPrivilegesView retail sales reports RetailSalesReportsViewDutiesInquire into retail sales reports RetailIntoSalesReportsInquireInquire into sales reports for retail trial. RetailTrialIntoSalesReportsInquire
4 security rolesRetail merchandising manager RetailMerchandisingManagerRetail operations manager RetailOperationsManagerRetail service RetailServiceRetail store manager RetailStoreManager
Checked in Dynamics 365
Roles to set it up and use itTo use itRetail service RetailServiceRetail operations manager RetailOperationsManagerRetail store manager RetailStoreManagerRetail merchandising manager RetailMerchandisingManagerGive people one of these roles. On this system, 4 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): Transactions, Reports, Functions, Report parameters, Retail attributes, Validation errors, Synchronize order, Validate transaction, View audit trailChecked in Dynamics 365
Developer

5Developer

Open it by URLhttps://<your-environment>/?mi=RetailRetailStoreTransactionTable
Integrate withRetailTransactionEntity data entity Microsoft data model
Table definitionRetailTransactionTable columns and relations Microsoft data model
Everyone

6Sources