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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / How to change logic fo...
Microsoft Dynamics AX (Archived)

How to change logic for TransactionID in retail transaction

(0) ShareShare
ReportReport
Posted on by Galia Handjieva 725

Hi,

Is it possible to change format of TransactionID for entries in Retail Transaction.

I know there is setting in Functional profile that relates to RetailTransactionTable.ReceiptId but my question is about RetailTransactionTable.TransactionId.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi Galia,

    Where you able to solve your problem?

  • Galia Handjieva Profile Picture
    Galia Handjieva 725 on at

    No.

  • Galia Handjieva Profile Picture
    Galia Handjieva 725 on at

    Hi, Crispin,

    My question is not for properties of the field in the table, but for numbers generated in RetailTransactionTable.ReceiptId field. Is there number sequence or mask?

    How the numbers are generated?

    In CONTOSO demo database transaction numbers look like this "SEATTLE-444829". In my customer database the numbers obviously consist of 3 sections - store, register and number (example: "STORE03-STORE03REG05-33999").

  • Verified answer
    Solozmar Profile Picture
    Solozmar 796 on at

    You are correct. The transaction ID is comprised of the Store, register and transactionid.  This goes towards avoiding creating duplicate IDs in the event that multiple registers may be used for one transaction.  

    I believe that this is generated using the RetailTransactionID EDT.  

    I'm not sure how you are seeing that format for Seattle in a Contoso VM unless you're missing a dash.  I went ahead and took a look for Seattle and see that the RETAILPOSSEEDATA data shows the transactionID generated will be:

    SEATTLE-SEATTLE-1-5

    seattletransactionid.png

    You might be able to modify the/a EDT to create a variation in the transactionID or just modify the formatting, e.g., in Contoso, it doesn't need to be Seattle-1 though that has benefits.  It could be S1.

    The receipt ID has a format control within the functionality profile but without a modification, I don't believe there is standard way to change the formatting of the transaction ID.

  • Galia Handjieva Profile Picture
    Galia Handjieva 725 on at

    Hi, Solomon,

    Thank you for the replay.

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 16

#2
Nagendra Varma K Profile Picture

Nagendra Varma K 4

#2
dekion Profile Picture

dekion 4

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans