Item Duplicates

I've seen some weird ones, but never what you describe. This has happened more than once? Can you recreate the problem intentionally or is it always a surprise?

RMS Version? OS? MSDE or SQL 2K5E?

Cautionary tale:

I hope you aren't running Small Business Server. I am, and when we had a transaction weirdness (a transaction total was incorrect by hundreds of dollars) and called MS for support, we were informed that SBS 2003 was no longer a supported OS for MS RMS v1.3 and that is we wanted help, we had to...

1. Stop using SBS 2003 Effectively, this means buy Windows Server Std. 2003 + SQL Server, migrate AD, etc. to the new OS, re-install RMS, etc. Since there's no upgrade path from SBS to Windows Server Std Ed, we're talking about THOUSANDS of dollars + loads of time and effort.

1. Duplicate the problem. Yeah, right.

Keep in mind that when we bought RMS v1.2, SBS 2003 was a *recommended OS* and apparently we didn't get the memo when MS discontinued support for RMS on SBS.

With the recent release of Vista, I expect to lose all support for WIndows XP Pro pretty much any day now...

I hope you find an answer.

Are you talking about looking at the journaled receipts? If so, those are images that are created at the time of the transaction and they are not editable. If you are talking about something like a detailed sales report, have you edited the report somehow? For example, if you added the tender to the report, it would be possible to duplicate items in the case of a split tender (half cash half credit for example).

Can you describe exactly what you are looking at in more detail?

Glenn Adams Tiber Creek C> Occasionally we have encountered a problem with an item being sold, then

Occasionally we have encountered a problem with an item being sold, then showing up on the Z report as not having been paid .

Looking at all the receipts one by one for the day, and matching them with the visa/interact/mastercard receipts, we can find a receipt that shows an item being seemingly duplicated on the customers receipt.

This duplication doesn't show up at the time of the transaction

So somewhere between the customer's transaction and the evening close off and the z report being produced the item gets duplicated, and shows up on the file report of the customer receipts.

Has anyone selse encountered this problem?

Thanks for any input you may have

HI Marwat,

Check the database indexs, specially check the table Journal, I remember I had the problem this also and it was fault where by mistake some triggers were created and wrong indexes in journal table.

Do you run the query against the [transaction] and [transactionentry] tables to check the particualr transaction i.e.

select * from [TransactionEntry] where TransactionNumber=XX (Replace XX with your Transaction Number which appearing during the view of Journal)

If it is not duplicate then it means something wrong with Journal table then check the tables all triggers, indexs etc.

"marwat" wrote:

I got this from our software provider, and it makes sense:

In the transaction screen, the item on which the cursor is, would duplicate itself if the cashier presses ?+? key. As you know, the same key is used with entering the exact amount into the Tender screen (usually with Debit or Credit card, rarely with cash for there?s change involved). So there?s room for human error. Please verify that most of the receipts with duplicates entries would be debit or credit card. If so, the possible scenario is as following:

1. The Cashier finishes the transaction and looks at Total on the screen

1. Cashier enters Total in the card processing machine. The amount is successfully processed

2. The cashier intends to press F12 to bring up the Tender screen and then press ?+? to enter the exact amount. Instead they press ?+? first and that duplicates the last item in the transaction

"marwat" wrote: