FRx Statistical & Financial Book Code 1

[Shipley]

I am trying to finalize an income statement needs to display both financial and statistical information. When I set up book codes in the row format of my report, the column book code is ignored. This makes the report display the same figures in each column for the row with the book code specified. This affects financial and statistical data alike.

Any ideas?

 

[barbola]

In the report catalog under Advanced Report Options you can select to calculate Rows first, or calculate Columns first. Try the opposite of what was selected and see if that works.

Thanks!
Barb E.

 

[Shipley]

no dice, any other ideas?

 

[barbola]

what book codes are you using in your rows and in your columns? What results are you expecting?


Thanks!
Barb E.

 

[Shipley]

Column format has a column for actual financials, one for the budget, and one for calculating the difference. Book codes are "actual" & "budget". This report is for a convenience store which records sales and gallons under the same account, differentiating by the units (financial vs statistical entries).

In FRx, the two different units are summed together unless told not to, so they must be split by going into the appropriate row in the row format... "Link to GL" (dropdown box) -> row modifier -> book code -> "statistical" for gallons & "actual" for financials.

Although this does break out the two, it negates my actual vs budget comparison... the actual figures now appear in the actual and budget column of that particular row, and the variance is, of course, 0. This problem continues throughout the entire report where I must specify to only include sales dollars (no gallons) like with TOTAL SALES, EBITDA, NET INCOME.

I really do appreciate your help. Thanks a million.

 

[barbola]

What version of FRx are you using? I have 6.5 but there is no such book code as "statistical". All we have is actual and budget (shows budget names).

I'm thinking maybe you have a budget called "statistical" that is used for your gallons. If so, FRx does not distinguish this from financial.

Also if you are using unit accounts, FRx does not distinguish these either.

Your Total row will need to exclude the rows with your "gallons".

I hope this helps.

Thanks!
Barb E.

 

[Shipley]

yeah, this problem is stumping everyone... even tech support. The only budget we have is in our budget book code. Gallons and sales dollars are in that budget under the same accounts, seperated by subaccounts and unit types (which is where the statistical/actual book codes comes in to exclude dollars or gallons respectively).

This problem seems to not want to go away. If any possible solution comes up, dont hesitate to post it. I know I've tried just about everything.

 

[barbola]

It seems obvious to me that someone set up a budget code to use for the units. Even if unit accounts as opposed to posting accounts are being used, it doesn't matter what the figures represent, FRx treats everything as a dollar figure and will include it in the totals.

Can you move them to a different area of your row format so as not to include them in the totals? Either that or change your formula to total all the rows excluding the statistical ones.

Another option is maybe to put these numbers in a different column and not include them in the same column or totals as the financials.

Thanks!
Barb E.