Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Help with Something in FRx

Help with Something in FRx

Help with Something in FRx

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!

RE: Help with Something in FRx

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.

RE: Help with Something in FRx

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.

RE: Help with Something in FRx

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.

RE: Help with Something in FRx

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.

Barb E.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close