Micros Discount Report

[jrahma]

Hi,

I have the attached report from MyMicros.

When clicking each check, I will get the staff name who got the discount (because the waiter will enter it in the check).

I would like to ask how can I have a query to do the same but also adding the name column in the attached report?


Thanks,
Jassim


Jassim Rahma

 

[hosehead78]

Do you want an SQL Query or MyMicros (NetVu Point) query?

 

[jrahma]

I have no idea about NetVu Point.

I am looking to have the same result using SQL query.



Jassim Rahma

 

[hosehead78]

Ok, what version of Micros are you running?

 

[hosehead78]

Here's a Query for Micros 9700 v3.6.

SELECT 
	rc.revenueCenterPOSRef as RVCNUM
	,rc.name
	,GCH.openDatetime
	,GCH.PostingTime
	,GCH.employeeID
	,EMP.posRef as EmpNum
	,firstName
	,lastName
	,GCH.guestCheckPOSRef
	,GCH.checkNum
	,GCH.checkRef
	,GCH.numItems
	,GCH.discountTotal
	,GCH.checkTotal
	,GCH.serviceChargeTotal
	,GCH.tipTotal
	,GCH.subtotal
	,GCH.taxTotal
	,GCH.taxExempt
	,GCH.voidTotal
	,GCH.returnTotal

FROM LOCATION_ACTIVITY_DB.dbo.GUEST_CHECK_HIST GCH

-- Pull Revenue Center Info
Join LOCATION_ACTIVITY_DB.dbo.REVENUE_CENTER RC on RC.revenueCenterID = GCH.revenueCenterID
-- Pull Employee Name Info
Join LOCATION_ACTIVITY_DB.dbo.EMPLOYEE EMP on EMP.employeeID = GCH.employeeID

-- Change the Between Dates for the Range you need
Where openBusinessDate between '2014-10-31 00:00:00' and '2014-11-01 00:00:00'
And discountTotal <> '0'

Order by rc.revenueCenterPOSRef, GCH.openDatetime, GCH.checkNum ASC

 

[hosehead78]

Correction on the Query, it should work, but I forgot to add the EMP. for firstname and lastname.
Should be EMP.firstName and EMP.lastName.