Help with Something in FRx

[kkrebs]

We are currently running GP 7.0 and FRx 6.5. I have a report currently set up in FRx and for the life of me I can't figure out how to do what I want to do. It is probably easy and I am just having a brain hic-up but...HELP.

What I want to do is, we have GL accounts for Sales, Admin & General Overhead, I want to take the total for all the accounts (listed under Sales, Admin & General Overhead) and allocate them to our 4 different branches by a percent of the Cost of Sales. Is this possible? And if so, how would I go about doing this?

Any help would be greatly appreciated.

Thank you!

 

[jymm]

If you still have the 6.5 disk around (or the pdf documentation that came with it) there are some pretty good examples in there. I actually copied them all off to our documenation folder on our Intranet so that all of my FRx users could see an example balance sheet...

If you have problems finding the pdf --- let me know and we will see what we can do.

 

[Dukester0122]

Create Row Formats using your GL Accounts. In the Row format, you must specify the 2 rows that you would like to calculate by. On a new line that you would like to see the calculation, you will want to choose the type CAL in Column C. In the related Rates/Rows/Units you will want to type in the following statement: @AAA/@BBB "0.00%" The calculation will divide row AAA by row BBB and give this calculation in a percentage format. For the branches you need to create Reporting Trees.

 

[kkrebs]

Thank you both to jymm & Dukester0122. I understand what you are both saying. However, I already have the report and we are currently using it. I am not using Reporting Trees 'cuz I don't understand them yet but I have the current report set up like this...

I have the Row Format using our GL Accounts.
I have the Column Format using the Account Filters so each branch (????-100-??, etc.) has its own separate column. We have 6 columns (1-Buffalo, 1-Rochester, 1-Pittsburgh, 1-Erie, 1-Home Office & 1-Total)

What I want to do is use the Total column for one specific row of the report for our SAG (which is all branches combined) and have that be spread out at a percentage over 4 branches (Buffalo, Rochester, Pittsburgh & Erie). We don't want it to be listed under Home Office on the report, but we do not want to change the GL Account for that particular account.

I hope I am explaining myself correctly.

 

[barbola]

Take the account filters out of your branch columns and change them to CALC columns and put the formula in to take the Total column times the percentage you want to show across each branch:

Total in GL account in Column B, then Column C for branch A will be B*.25 or whatever percent you want etc etc.

I'm assuming you don't want the actuals that are in the GL accounts for each Branch.

Trees are very easy to set up too, this might help.


Thanks!
Barb E.