There are a few reasons why a customers cash up may have a variance. Most will have straight forward common sense solutions, other might require a little more detective work.
Cashup is Down
- Money has been stolen from till
- Money is under till tray and has not been counted
- Money is in safe
- Float has been miscounted at beginning of shift
- Items have been rung on but not paid for
Cashup is Up
- Money has been put in till but items not rung on
- Customer cashed up in offline mode, this processes ALL transactions that havent been cashed up in the local database into the cashup. So you have to look into all the transactions that are included in that cashupID and extract the ones that were not valid.
First of all make sure ROSS has sychronised everything from the remote DB to the server (otherwise you might be missing the info)
On the server, do a cash totals report, find out the cash up ID that you need to search on.
You will need to use the some SQL to discover which tender lines where cashed up on the local DB, and which werent.
Since tender lines done on local DB’s have a thing called a REMTENDERLINEID then its pretty easy to seperate them
SELECT a.TENDERLINEID, a.TENDERLINEAMOUNT, a.TENDERLINETIP, a.TENDERID, a.CASHUPID, a.TENDERLINECHANGE, a.REMTENDERLINEID, a.EFTPOSTXNREF
FROM TENLINE a
where a.CASHUPID = 12279 (or whatever your actual cashupid is)
and a.REMTENDERLINEID is NULL
This will give you your actual cashup tenders lines that were not created on the local DB
Now export that from Flamerobin and open it in excel.