Hi Team,
I have a ‘No Sale’ button that runs a print job to open the cash drawer. This works perfectly for my needs. Is there a way I can keep a record of when the 'No Sale" button is used?
TIA,
Murray
Hi Team,
I have a ‘No Sale’ button that runs a print job to open the cash drawer. This works perfectly for my needs. Is there a way I can keep a record of when the 'No Sale" button is used?
TIA,
Murray
This can help. 2.4.4.How to Record Waiter that Prints Bill or Receives Payment into Logs? – SambaPOS Knowledgebase
It’s not exactly what you need but it shows how to use ticket logs for logging events.
Cheers, I’ll give it a go and let you know how I get on
Because a no-sale can be triggered in absence of a ticket, the ticket log wasn’t working for us. So we have a separate table that logs no-sales.
table:
CREATE TABLE dbo.CashDrawerNoSales
(
Id INT IDENTITY(1, 1) PRIMARY KEY NOT NULL,
Date DATETIME
CONSTRAINT dc_CashDrawerNoSales_Date
DEFAULT GETDATE() NOT NULL,
Time NVARCHAR(50)
CONSTRAINT dc_CashDrawerNoSales_Time
DEFAULT CONVERT(TIME(0), GETDATE()) NOT NULL,
TerminalName NVARCHAR(50) NOT NULL,
UserName NVARCHAR(50) NOT NULL
);
script:
function log(terminalName,userName)
{
var q = "INSERT INTO dbo.CashDrawerNoSales (TerminalName, UserName) VALUES ('"+terminalName+"', '"+userName+"')";
sql.Query(q).First;
}
then using execute script action in the rule that opens the drawer:
drawer.log('{SETTING:CURRENTTERMINAL}','{SETTING:CURRENTUSER}')
report:
[Log:3,3,3,3]
>Date|Time|Terminal|User
{REPORT SQL DETAILS:SELECT Date, Time, TerminalName, UserName FROM dbo.CashDrawerNoSales WHERE Date BETWEEN '{Start}' AND '{End}' ORDER BY Id:F.Date,F.Time,F.TerminalName,F.UserName}