Dynamics Community Forum Thread Details

Mgmt Reporter - summary totals of unit accounts on consolidated P&L

I am using MR to report statistics on the bottom of certain P&Ls. It has been a bit tricky to get some of the stats (via unit accounts) to work as the unit account setups are not always designated to a department. But, I finally thought I had figured it out by adding department "000" to the tree. It works but unfortunately the Summary level of the consolidated P&L is totaling all the individual department stats. Is there a way to not have the statistical info total/show on the Summary report? Or not have it total from the sub-departments?
For example, we have several restaurants (Food and Beverage depts. aka F&B) and I produce a monthly P&L for each department. The F&B tree then rolls into a summary/consolidated P&L. One of the monthly stats we track is revenue per FTE. To get this stat, I have hours imported via JE from our payroll system (not GP) into unit accounts in GP. These are department specific. Then, to calculate the FTEs per month, I use another unit account for the # pay periods per month (some months have 2, some have 3 as we are bi-weekly). In MR I use CAL to get the # of FTE's for the month:
(Hours / (# pay periods * 80))
Works great for the individual department P&L as I have included department 000 in the tree setup for each restaurant to capture the # of pay periods unit account that drive the above CAL. Unfortunately, the summary/consolidated P&L for all of F&B adds all the departments # of pay periods and then the CAL is incorrect.
Hopefully this makes sense. Any help is appreciated.
Thanks,
Rose
------------------------------------------- Rose Wysocki Finance Controller Snoqualmie Casino Snoqualmie WA

Quick Links

Leaderboard