How to Remove Duplicate Transactions

(0) Share

Report

Posted on by pleb

Hello All,

We are having an issue from time to time in RMS where our remote cashers run into a network issue(they are connected via DS0s) that causes GP to have a little hiccup where they can not print a receipt and redo the transaction.

We're ending up with batches that do not balance. The amount when you sum the totals of the transactions from the batch by selecting from the transaction table is different from the amount in the batch table by the amount of the tansaction that had to be redone.

Can I just delete the duplicate transaction from the transaction and transactionentry tables?

Sorry if this is a basic question, but I'm not a GP person, just an DBD attempting to help out. FYI, we are running GP 9 on SQL Server 2000.

Thanks!

*This post is locked for comments

All responses (1)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

Re: How to Remove Duplicate Transactions

Hi pleb,

I am supprised to hear about the duplicates in an ERP like GP. is that due to customizations? if not, we can escalate it to microsoft so that they can come out with a solution.

Any way you can take a backup of the database and try deleting the transaction that are duplicated, and then process and check, if it does not match, you have to restore the database. and check the other possiblity of mismatch

You can try it when no users are online.

Try and Let me know, you can write me to krishna.prakash@adea.com

Cheers

KrishnaPrakash