web
You’re offline. This is a read only version of the page.
close
Skip to main content
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
    RE: How to change logic for TransactionID in retail transaction

    Hi Galia,

    Where you able to solve your problem?

  • Galia Handjieva Profile Picture
    Galia Handjieva 725 on at
    RE: How to change logic for TransactionID in retail transaction

    No.

  • Galia Handjieva Profile Picture
    Galia Handjieva 725 on at
    RE: How to change logic for TransactionID in retail transaction

    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
    RE: How to change logic for TransactionID in retail transaction

    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
    RE: How to change logic for TransactionID in retail transaction

    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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

#2
Guy Terry Profile Picture

Guy Terry 2 Moderator

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans