You’re offline. This is a read only version of the page.
20
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
I have the same question (0)
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
Share
Report
All responses (
Answers (
