Record No Sales

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 :+1:

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}
2 Likes