[MICROS RES] - Menu Item Report by BusinessDate on QUERY or SCRIPT

[Mauriciose]

Hi everyone... I'm looking for a query report that can giveme the Menu Ítem report by business date. I need to export everyday this data:

. Business_Date
. Check_Number
. Menu_Item_ID
. Menu_Item_Name
. Menu_Item_Quantity
. Menu_Item_Individual_Price
. Total_Price_for_the_Check
. Fiscal_Number_INVOICE

Now, If someone have this, please share with me, or more better, If someone have the data dictionary to know the organization data.

Thanks to all.

Mauro

 

[hosehead78]

Where are you Doing the Query from and What version of Micros?

Here's one for Micros 9700 v3.20/v3.60 through MS SQL Server Management Studio (Query)

SELECT 
	rvc.revenueCenterPOSRef as RVCNUM
	,rvc.name
	,midt.businessDate
	,midt.menuItemID
	,mi.menuItemPOSRef as MI_NUM
	,mi.menuItemName1 as Name1
	,mi.menuItemName2 as Name2
	,mip.price as PricePer
	,midt.salesTotal
	,midt.salesCount
	,midt.returnCount
	,midt.discountTotal

FROM LOCATION_ACTIVITY_DB.dbo.MENU_ITEM_DAILY_TOTAL midt

Join LOCATION_ACTIVITY_DB.dbo.MENU_ITEM mi on mi.menuItemID = midt.menuItemID
Join LOCATION_ACTIVITY_DB.dbo.MENU_ITEM_PRICE mip on mip.menuItemID = mi.menuItemID
Join LOCATION_ACTIVITY_DB.dbo.REVENUE_CENTER rvc on rvc.revenueCenterID = midt.revenueCenterID

Where midt.businessDate between '2015-04-20 03:00:00.000' and '2015-04-21 02:59:59.999'		-- Business Date Start to End
And rvc.revenueCenterPOSRef = 1     -- RVC Number to Look through
--And rvc.revenueCenterPOSRef in ('1','2','3','5')      -- Use this one if you want to look through Mutliple RVC's
--And mi.menuItemPOSRef between '330100' and '330500'   -- Use if you want to Only look through a Range of Menu Items

Order by midt.businessDate, rvc.revenueCenterPOSRef ASC     -- Orders by BusinessDate then by RVC Number

 

[hosehead78]

However, no Check information. I would have to look through the actual Guest Check History and show only the checks and maybe journals with it.

 

[Mauriciose]

Thanks hosehead78, but this query it's for RES 4.0, not MICROS 9700. Location_Activity table is not available in RES 4.0

Do you have somthing to RES 4.0?.

Thanks again.

Mauro

 

[hosehead78]

Not that I can think of. Let me get back to you on this.