Revenue Report EOD

List of Revenue from Accommodation, Food, Beverage, Telephone and Miscellaneous at the end of the day. It displays the Revenue by Day/Month/Year, Budget by Day/Month/Year, Margin and the comparison by Day/Month/Year to the same period from Last Year and Margin for each Transaction Account & Group. The total of each category is summarised by TAA Group and overall.

Report Image

Report Image

Report Name: revhist.rpt

Report Module Setup

Report Module Setup

Crystal Queries

SetFormula(FDateEnd,FDATEEND());

SetFormula(ActDate,YESTERDAY());

SetFormula(IsNet,1);

{revhist.date} in {@FDateStartLJ} to {@ActDate} and {hgruppen.dontshow}<1 and {revhist.mpehotel} = MPEHOTEL()

SQL Script

Execute Unconditionally

Have more questions? Submit a request

Comments

Powered by Zendesk