web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Suggested Answer

Order Confirmation ID on D365 eCommerce

(0) ShareShare
ReportReport
Posted on by 20

Where does Order Confirmation ID gets saved in D365 Retail HQ after the sales order on eCommerce website is concluded. Not able to find out the order confirmation ID shown to the customer after payment is done on eCommerce website in Online Sore Transactions enquiry form available under Retail and Commerce module.

I have the same question (0)
  • Suggested answer
    OriolMachin Profile Picture
    Microsoft Employee on at

    Hello Kumar159,

    The confirmation ID gets saved to the RetailTransactionTable in HQ, Column name: ChannelReferenceID

    You can usually get a good idea of where things are saved by right clicking on the field in question and taking a look at the Form information:
    pastedimage1625266131319v1.png

    pastedimage1625266311710v2.png

    I hope this helps,

    Oriol Machin
    Support Engineer / Microsoft Dynamics 365 Commerce
    North America Customer Services and Support

  • Jritz Profile Picture
    289 on at

    I know this is an older question, but I am experiencing a similar issue to the original poster. Where can we find this channel reference id???

    If you navigate to all sales orders and pull up a sales order, the channel reference ID is not on the lines or the header. If you pull up a customer and pull up historical sales orders, the channel reference ID is not on the lines or header.

    The problem is, the channel reference ID is what a customer is going to use when calling in to a CSR. This channel reference ID needs to be front and center on all sales order headers. Where is it buried?

    Additionally, from the Customer Service screen, we have the option to search by Keyword, Sales Order, Purchase Order, Phone Number, Customer Account, Customer Name, Email Address, Check Number, RMA Number, Invoice, Business Account, or Loyalty card.... but no Channel Reference ID?! This is the main confirmation number a customer will call in with and should be the #1 item we can search by. 

  • Shafeeque P. Profile Picture
    6,533 Moderator on at

    Second you on this. Please create an idea on portal. I will definitely vote for the feature.

  • Jritz Profile Picture
    289 on at

    Hi Shafeeque,

    I have created the idea which can be voted on at the below link. Thanks for the support!

    Idea link: experience.dynamics.com/.../

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 94 Super User 2026 Season 1

#2
Sagar Suman Profile Picture

Sagar Suman 72 Super User 2026 Season 1

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 58 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans