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 RMS (Archived) / Transaction Number in RMS
Microsoft Dynamics RMS (Archived)

Transaction Number in RMS

(0) ShareShare
ReportReport
Posted on by Gene Palomar 885

Hi guys,

I just want to clarify the transaction number in RMS. With regards to the concern of one of our partners, they asked if the following are possible in RMS:

1.) Is it possible to edit the transaction number in RMS from let's say, '4' digits to '6' digits?

2.) If OR# (Official Receipt #) could be visible also in the receipt not just the transaction number?

I know that those are possible in RMS, and will undergo customization. I have checked all tables in SQL Server with my dummy database, the column field “TransactionNumber” and noticed that it is '4' in size. How will they change it to '6'?  They cannot just alter the data type size in SQL, since that field may be called on the rest of the source code, and as well as the other objects it is dependent to. Also, in determining the “OR#” (Official Receipt #), I know that this is customizable, but they have asked me where to made these customizations? Here in the Philippines, all receipts have an OR# and transaction numbers mostly begin at 5 digits.

I can only view all the receipt template codes but not the whole RMS code as well.

Let me know if there’s a work around resolution and please if somebody could advise me on this.

Any feedback is duly appreciated!

Thank you.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: Transaction Number in RMS

    First of all, the size "4" of the TransactionNumber doesn't mean that it's 4 digits, it just means that the field size is integer which consumes 4 bytes of storage whether the value is 3 or 30000000.

    So forget about trying to change the field size cause it's not recommended at all and it won't do what you need anyway.

    I think u should consider contacting Retail Realm as I think they have an add-on that can create a custom transaction number and print it on receipts as well

    A Hassan

    RMS Leaders

  • Suggested answer
    Antonijo Todorovik Profile Picture
    Antonijo Todorovik 4,025 on at
    RE: Transaction Number in RMS

    Hi Gene.

    OK, let me try to help You... First, it is not recomended to alter the tables in RMS, I'm not saying it wont work, but could give You problems...and in the moment You update the version, it could return the original values of the table properties... On the other side, You will never see the original code of RMS, as Microsoft wont let You...

    So, first, give me some answers, where do you need the "6 digit" transaction number and OR#, only on the printed receipt?? Do You need to save this number somewhere in the database or it is enough to print it on the ticket/receipt? Are transaction number and OR# in Philippines somehow related, is there any dependence between this two values? And, at the end, on the Transaction Number issue, if the ticket/receipt number is let sey 333, in Philippines You need to print "000333", correct??

    Waiting for your reply... Regards, A.

  • Suggested answer
    Antonijo Todorovik Profile Picture
    Antonijo Todorovik 4,025 on at
    RE: Transaction Number in RMS

    Hi Gene.

    OK, let me try to help You... First, it is not recomended to alter the tables in RMS, I'm not saying it wont work, but could give You problems...and in the moment You update the version, it could return the original values of the table properties... On the other side, You will never see the original code of RMS, as Microsoft wont let You...

    So, first, give me some answers, where do you need the "6 digit" transaction number and OR#, only on the printed receipt?? Do You need to save this number somewhere in the database or it is enough to print it on the ticket/receipt? Are transaction number and OR# in Philippines somehow related, is there any dependence between this two values? And, at the end, on the Transaction Number issue, if the ticket/receipt number is let sey 333, in Philippines You need to print "000333", correct??

    Waiting for your reply... Regards, A.

  • Gene Palomar Profile Picture
    Gene Palomar 885 on at
    RE: Transaction Number in RMS

    Hi Antonijo,

    I've tried to set it in SO Administrator, Database>>Set Next Transaction Number.. and process a transaction in SO POS, and it worked. As for your questions, please see my response:

    1) Where do you need the "6 digit" transaction number and OR#, only on the printed receipt??

    -In the receipt and also in the Reports. This is case to case basis depending on what the store requires. I've noticed that some receipts has only OR#, and some have both OR# and Transaction #.

    2) Do You need to save this number somewhere in the database or it is enough to print it on the ticket/receipt?

    -If there's a way it could be stored in the database without altering any tables or stored procedures, it's better. But if not, printing on the ticket is enough.

    3) Are transaction number and OR# in Philippines somehow related, is there any dependence between this two values?

    -Yes. Transaction number is like a "quote" or a "reference number", wherein you order the item but is not yet paid. While OR# (Official Receipt) is the invoice number itself, when payment happened.

    4) And, at the end, on the Transaction Number issue, if the ticket/receipt number is let say 333, in Philippines You need to print "000333", correct??

    -Yes. That is correct.

    Any feedback on this is greatly appreciated.

    Thank you.

  • Community Member Profile Picture
    Community Member on at
    RE: Transaction Number in RMS

    Hi Gene,

    2.) If OR# (Official Receipt #) could be visible also in the receipt not just the transaction number?

    Yes, this is possible.  We customized this to one of our clients in the Philippines.  As mentioned before it is not recommended to alter tables of RMS. I suggest your own custom table to store OR# series.

    Thanks.

  • Gene Palomar Profile Picture
    Gene Palomar 885 on at
    RE: Transaction Number in RMS

    Hi Hotrod,

    If this is possible, could you give some advice on how the OR# (Official Receipt #) and the Transaction number be printed in the receipt? Did you created a custom table for this?

    Also, for the accumulated sales to be seen also in the receipt? Is this possible?

    Any feedback is greatly appreciated.

    Thank you.

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Transaction Number in RMS

    Hi Gene,

    My comments below.

    1. If this is possible, could you give some advice on how the OR# (Official Receipt #) and the Transaction   number be printed in the receipt? Did you created a custom table for this?

    Yes, you need to create a custom table to store your own series of OR#.

    2. Also, for the accumulated sales to be seen also in the receipt? Is this possible?

    I think you mean to show accumulated sales in the Z Report.  Yes, it's possible. You need to create an add-in recreate the Z-Report printing of RMS.

    I hope this helps.

  • Gene Palomar Profile Picture
    Gene Palomar 885 on at
    RE: Transaction Number in RMS

    Hi Hotrod,

    With regards to the custom table, could you help me with the query? This might be inter-related to the other tables in RMS.

    and as for the accumulated sales in the report (whether Z report or the detailed sales report), how did you show the "OR#" in that report? Did you also customize it?

    I hope for your response or could we discuss this thru email?

    Thank you very much.

  • Community Member Profile Picture
    Community Member on at
    RE: Transaction Number in RMS

    Hi Gene,

    Let's discuss this thru email instead.  What's your email address?

    Thanks.

  • Gene Palomar Profile Picture
    Gene Palomar 885 on at
    RE: Transaction Number in RMS

    Hi Hotrod,

    Gladly, here it is: gene.palomar@pospartners.com

    Thanks!

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 RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans