Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Management Reporter an...
Microsoft Dynamics GP (Archived)

Management Reporter and Unit Accounts

(0) ShareShare
ReportReport
Posted on by Community Member

Hi.

 

I am working on a P&L that will also report revenue per FTE.  The FTE's are calculated from unit accounts (hours, pay periods in the month, # of days per month).  The hours unit accounts are reported by department.  The pay periods and # of days are not specific to departments.  This seems to cause a problem as the P&L is for our Food and Beverage department and so I'm using a tree in the report setup.  The use of the tree somehow excludes the reporting of the unit accounts that are not specific to that tree's departments.  When I run the report without the tree, the general (ie not assigned to departments) unit accounts work/populate with correct data. 

 

Any assistance is appreciated.


Regards,

 

Rose Wysocki

Finance Controller

Snoqualmie Casino 

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    RE: Management Reporter and Unit Accounts

    I ended up modifying the tree to include 000-000 and now it works.

    Thanks!

  • EDJJR Profile Picture
    EDJJR on at
    RE: Management Reporter and Unit Accounts

    Hello,

    I would recommend to open an support case for us to take a look at the report setup to see what might be causing the issue.

  • Suggested answer
    Ian Richardson Profile Picture
    Ian Richardson 4,150 on at
    RE: Management Reporter and Unit Accounts

    hi Rose

    You are correct, by not specifying the department the tree cannot "see" that account when it restricts for that section of the tree.

    It is more data entry work but the best solution is the enter new unit accounts for each department.

    If you are considering new unit accounts why not have one that holds the number of hours?  I would imagine it would be a relatively easy figure to get from most payroll software.

    If this is too much work you could have a second link to financial dimensions in your row format.  In your tree you can then add an element to your tree that will pick up the 000-000 part of the account.  if you put that at the start you could use it for the base row calculations you already have.

    ian

  • Community Member Profile Picture
    Community Member on at
    RE: Management Reporter and Unit Accounts

    Hi.

    Our account structure is ACCT-DEPT-000.  The unit accounts that report hours are specific to the departments.  For example:  0610-200-000  Is regular hours (0610) for the Buffet department (200).  0620-200-000 is OT hours for the Buffet department.  Then, we have unit accounts that report things like the # of pay periods per month (these change each year).  For example:  0510-000-000  where 0510 = pay periods per month but the department is not specified as the unit account applies to all departments.

    So, to get regular hours for the Food and Beverage department (tree has 6 departments) divided by # of pay periods per month I have a row for each unit account setup in my report, with a CAL row to do the math.

    The 0510-000-000 data does not populate when the tree for Food and Beverage is selected.  I am thinking this is because this unit account does not specify a department.

    Hope this makes sense.

    Thanks,

    Rose

  • Ian Richardson Profile Picture
    Ian Richardson 4,150 on at
    RE: Management Reporter and Unit Accounts

    Hi Rose

    from what you describe you either need to adjust the tree to enable you to pick up the unit account, or you need to adjust the unit account so that the tree can see it.

    What about the unit account makes it specific to the food and beverage department?

    What about the account structure makes an account specific to the food and beverage department?

    Your question makes it sound like they are likely two different things.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Check out the New Agent Creator Community

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans