Have you had RMS crash on you during a transaction? I have had occurances where Transactions get "Orphaned." A Transaction record and a transactionentryrecord get written, but no tender information is recorded. Typically the cashier has not finished the transaction and simply rerings everything. This makes any report based on the transaction tables(Detailed sales report for example) show inflated sales. Then other reports that are based on Tender records show more accurate sales.
For us, accounting began seeing the discrepancy right away and I was able to track down what was causing the issues. We then put measures in place where by accounting compares the sales from Detailed sales reports and Tender reports daily. I then run a query if there are discrepancies to show me orphaned records. I research whether there is a journal entry for the record I can view and whether it is safe to delete the orphaned records. I have a trigger on the Transaction and TransactionEntry Tables that records the delete trans records in case I need to bring them back.
The queries that show me the orphaned records are:
DECLARE @STOREID INT DECLARE @BeginDate Varchar(20) SET @STOREIDa4006 SET @BeginDate='1/1/04'
select * from [TransactionEntry] where storeID=@StoreID and transactionnumber in (select T.TransactionNumber from [transaction] T left Join TenderEntry te on T.StoreID=TE.storeID and T.Transactionnumber=TE.transactionnumber where TE.[ID] is null and T.Total0 and Time >@BeginDate and t.StoreID=@StoreID)
select * from [Transaction] where storeID=@StoreID and transactionnumber in (select T.TransactionNumber from [transaction] T left Join TenderEntry te on T.StoreID=TE.storeID and T.Transactionnumber=TE.transactionnumber where TE.[ID] is null and T.Total0 and Time >@BeginDate and t.storeID=@StoreID)
I am not sayig this your issue, but it is something to look into.