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

Notifications

Announcements

No record found.

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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans