Checking Cash register activity from Back Office

(0) Share

Report

Posted on by TheNeos

1,347

Hello,

I have RMS Dynamics v2.0.0105 on single store 2 cash registers. I want to know if is possible to check cashier activity from back office and record it. I can hook with VCN and have a view but I want to record. Is it possible?

TheNeos, Australia

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (1)

Suggested answer

Antonijo Todorovik 4,025 on at

Like (0)

Report

Hi there,

What exactly you want to track, what activities?

Regards, A.

Was this reply helpful? Yes No
TheNeos 1,347 on at

Like (0)

Report

Hello Antonijo,

I want to check if cashiers ringing up sales and then deleting without issuing receipt and completing the sale.

TheNeos

Was this reply helpful? Yes No
Suggested answer

Antonijo Todorovik 4,025 on at

Like (0)

Report

Hi again.

I'm not sure if this can be done, I will have to play with SQL Profiler, to view whats going on with the RMS data and tables, when creating a new sale. Until the transaction it's not posted, the inventory onhand is not changed, but maybe while doing the transaction it's reserved... I'm positive RMS is creating some temporary tables, with the transaction entries data, maybe that can be captured and the compared to see if the transaction is converted into a standard transaction...

What I have done once, was a small development, that controls the price changes of the transaction entries, and saves it in a separate RMS table, on each "refresh" of the transaction. that way the customer knew what have been changed, by whom and when, and there was a historic record of whats happening... If that was done on price, I'm sure it can be done over quantity column of the transaction entry... or to whole transaction lines when they are deleted from the pos screen...

Interesting question, I must have a look at it...and come back to You...

Regards, A.

Was this reply helpful? Yes No
TheNeos 1,347 on at

Like (0)

Report

Thanks in advance. I am surprised that this has not looked at before. Cheers, T.

Was this reply helpful? Yes No
Suggested answer

Antonijo Todorovik 4,025 on at

Like (0)

Report

Well, it have been looked before for sure, the thing is that there are few RMS standard options to block Cashiers deleting lines from the POS, also security levels for who can do what, also the option of the Quantity can't be changed at POS... Many options, and customers adopt to some of them... What you want is to "know" what the cashier is doing at POS...

Anyway, let's talk over this...

Regards, A.

Was this reply helpful? Yes No
TheNeos 1,347 on at

Like (0)

Report

Exactly, I want to know and able to have historicals. We allow cashiers to change price and also we do not prevent them to delete items from sales in case of errors by purchaser or otherwise.

Was this reply helpful? Yes No
RMS Wizard 1,205 on at

Like (0)

Report

If by "activity" you mean who sold what today, that is available in Manager, Reports, Sales, Detailed Sales, OK to run report. Right-click and select Show/Hide to determine what transaction data is displayed on report. You can drag and drop the columns and group data such as by Cashier or Register number or both. When you run the report it shows a live snapshot of today's sales. Press F5 to refresh the data at any time.

Once you have the report looking the way you want, click the diskette icon in the report toolbar to save it for future use (Memorize).

Was this reply helpful? Yes No
Suggested answer

arishi 740 on at

Like (0)

Report

there is another way if you just want to keep an eye on register screen and record, not as informed as having cashier activity report

if you have a Security camera system, use VGA to PC convertor device on each register, this will show live screen of the cashier on DVR and record, I would also suggest to have 1 camera on checkout counter, which will give more visual of transaction

if you want to go even further with accuracy and in depth details add Text inserter on checkout counter camera, which will show you every item as it's scan and also if it is deleted, it's like having receipt printed on camera

Was this reply helpful? Yes No
Verified answer

Antonijo Todorovik 4,025 on at

Like (1)

Report

Text inserter is good, but could be expensive solution... If you want a "free" solution, I would go with a SQL profiler, get some info from there and compare it with the transactions done after that (in SQL Profiler you will exactly know when the item is added to the pos and in SQL when exactly there is a sale done, for both who did it!!).

Kind regards, A.

Was this reply helpful? Yes No
TheNeos 1,347 on at

Like (0)

Report

This sound promising. I am not familiar with Profiler but I will try. Is it part of the SQL server installation or download?

Was this reply helpful? Yes No