1. Home
  2. Point-Of-Sale Software
  3. Missing Transaction Number

Missing Transaction Number

While doing a transaction in RMS POS the application exited automatically and when i reopened it to redo the transaction, the transaction progressed to the next sequential number(It was 173 then it went to 174). When i checked the juornal transaction 173 was absent...i then checked the reports and the transaction number was skipped. There was no power surge or sag, the pc did not shut off, it was just the POS application that exited without any warning messages. it exited after i clicked ok at the tender window. Is ther any explanation why the transaction number was skipped?

Reply to
Terry
Loading thread data ...

Transaction Number is gererated as an IDENTITY Value in SQL Server (Search for SQL Server Books Online fi you would like more info about this). Even if a record is deleted, its identity value is never reused. As long as the transactionnumber does not appear anywhere, this is normal behavior.

The transaction number is just an identifier. It should not be used as a counter or for any purpose other than to identify a single transaction...

Glenn Adams Tiber Creek C> While doing a transaction in RMS POS the application exited automatically and

Reply to
Glenn Adams [MVP - Retail Mgmt

I now have 20 missing transaction numbers and no answer as to how they were skipped. The company auditors are asking for an explanation, they just cannot accept missing transactions without a report of some sort. Is there anyway in which i can get a report from SQL addressing why these numbers were skipped?

Regards, Terry

"Glenn Adams [MVP - Retail Mgmt]" wrote:

Reply to
Terry

Not any way I can think of. You could look at the transactions immediately before and after the missing ones and get a decent idea of when they occurred, but that's about it. There was probably a rather ugly error message displayed to the cashier when it happened, but you are not likely to be able to learn much more than that.

Glenn Adams Tiber Creek C> I now have 20 missing transaction numbers and no answer as to how they were

Reply to
Glenn Adams [MVP - Retail Mgmt

I now have 20 missing transaction numbers and no answer as to how they were skipped. The company auditors are asking for an explanation, they just cannot accept missing transactions without a report of some sort. Is there anyway in which i can get a report from SQL addressing why these numbers were skipped?

Regards, Terry

"Glenn Adams [MVP - Retail Mgmt]" wrote:

Reply to
CptSoft

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.