web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / FRx
Microsoft Dynamics GP (Archived)

FRx

(0) ShareShare
ReportReport
Posted on by Steve Tezcan 130

FRX question? I have 2 companies, company A and B. I want to pull the expense accounts under company A and divide by the number of units sold by both Company A & B. I tried it in changing the tree structure to @ANY company, it did not work. Any suggestions?

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi Steve,

    Have you tried column formats? 5 columns - 1. Actual figures from the expense accounts, 2. Unist from company A. 3. units from company B, 4. Calculated - Add columns 2 and 3, 5. Calculated - Divide column 4 by column 1. Use the Reporting Units restriction on columns to dictate which company the data is coming from.

    Ian.

  • Steve Tezcan Profile Picture
    Steve Tezcan 130 on at

    Ian,

    Thanks for getting back to me on this. it might work. Here are  couple more things that make this further complicated:

    1) We want to a total per unit at the bottom as a row, would that be possible with the column suggestion you laid out above?In other words, We want to see per unit in the row below the related expense item as opposed to columns.

    2) If company A has sub divisions such as 1, 2,3 and 4 and I can pull the expenses by &&&&&-000-4??? where 4??? indicates sub division code in the tree set-up, however if the units in Company A are recorded to 00100-000-4000, everytime I set a tree:&&&&&-000-41??, I will not capture those units even though I capture the expenses.In other words units are kind of sub divison by themselves. I tried to create a units tree, but I could not figure out how to make it pull just the accounts of 00100-000-4000.

    Please let me know if you have any thoughts?

    Thank you -Steve

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

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

#2
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans