Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with Something in FRx

Status
Not open for further replies.
kkrebs

kkrebs

Technical User
Jul 8, 2003
37
0
0
US
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!
 
Sort by date Sort by votes
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.
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

appelq
  • Locked
  • Question
Cash Batch and Bank Fees in Dynamics GP
Replies
0
Views
298
appelq
appelq
kgeorge71
  • Locked
  • Question
Bank Recs not tying to GL in Dynamics Great Plains
Replies
0
Views
367
kgeorge71
kgeorge71
Nisly
  • Locked
  • Question
Deleting purchases from Fixed Assets Purchases in Great Plains
Replies
0
Views
250
Nisly
Nisly
Devanand0311
  • Locked
  • Question
Syntax error in date in query expression 'UCase
Replies
0
Views
234
Devanand0311
Devanand0311
moogabe
  • Locked
  • Question
ERROR WHEN ADDING CREDITOR in GP V 9
Replies
1
Views
247
moogabe
moogabe

Part and Inventory Search

Sponsor

Back
Top