FRxBuzz

This post is another that comes from Jeff Cutting, a lead developer of FRx. It was originally posted as an answer to a question about FRx Security, Solomon and SP10 (in my SP10 post), but there is plenty of non-Solomon specific information. I thought it valuable enough to have its own post! Thank you Jeff. —Jan

I’m going to give an overall explanation of FRx security to help anyone that might be interested (for any GL), and then I will drill into the specifics for Solomon. More »

Earlier this week, I wrote about how to divide headcount by the period number. This post can be found at How To Divide Headcount by the Period Number. In the realm of “there’s more than one way to get downtown”, today I’ll revisit using the period number in calculations. Today’s method uses a link to Excel to pull in the period number.

This writeup is provided compliments of Jeff Cutting, a lead developer of FRx and its successor, Management Reporter. THANK YOU, Jeff! More »

This post is also compliments of Rick Tenorio, moderator of the newsgroup at microsoft.public.frx. Normally in departmental reporting, a P&L calculates percentage of sales by using the sales for that department. For instance, the Welding department calculates percent of sales by using Welding revenue. In this report, however, Rick’s client wanted every department to calculate percent of total sales.

This is a “% of Sales” report.  Per Rick, “This report was requested by a client who wanted a report that would show the % of Sales amount exactly the same for each branch of the tree.  (So no rollup for the balance.)  I did not have this written up in detail, so I included the FRD file and the TDB file.  (The tdb file is from FRx 6.7 sp10.)”

More »

Today’s post is compliments of Rick Tenorio. Rick is the moderator at the newsgroup at microsoft.public.frx, and he has collected a number of helpful and practical documents on using FRx. This initial post covers how to divide a headcount statistic by the period number in order to arrive at an average headcount.

Note that you can also use this technique to calculate average sales per period (use YTD revenue divided by the period number). I know a number of my clients do this in order to get an initial sense of whether their MTD revenue looks right. More »

I’ve been asking around and really hadn’t heard of any issues with FRx’s latest service pack, SP10. It was released in March of this year. But here’s what I’ve personally found with SP10. More »

Today I’ll show how to create a binder of PDFs from FRx reports. The binder will be a collection of several different FRx reports, each in PDF format. This is what the finished product will look like:

Here’s how:

More »

I’ve designed FRx financials for a few hotels over the years—a couple quite recently. Thought I’d take this opportunity to post on some items specific to hotels like ADR and RevPAR, but many of the concepts will be valid for anyone using FRx.

A good number of these definitions come from the Uniform System of Accounts For The Lodging Industry, the 10th Revised Edition.

I’ve divided this post into 3 sections:

• Statement of Income for a Hotel
• Hotel Operating Statements
• Hotel Operating Ratios: Average Daily Rate and RevPAR  More »

You should know that IF THEN calculations are not only possible in FRx, you can use them in both the row and the column.

In the Row, use a CAL format code, then place your IF THEN statement in column D Related Rows.

In the column, use a CALC column type, then place your IF THEN statement in the Calc Formula cell. More »

I’ve just finished writing FRx in 8 Hours—Introduction. It is a downloadable self-study tutorial, so you can begin learning immediately. For more information and cost, see FRx Training Manuals.

Try the F3 key in the Fmt Code dropdown box in a row:

The F3 key works the same as clicking the dropdown box with the mouse. While I’d really encourage you to memorize Format Codes and not use the dropdown box at all, you can use F3 throughout FRx to save time when you don’t have the values memorized.

While I’m at it, F1 brings up FRx Help, such that it is. F2 allows you to Edit, just like in Excel. Alas, F4 does not repeat the edit as it does in Excel. I’ve been asking for it for years but given FRx’s future, I’d say my hopes are toast.

Other keyboard shortcuts are the ones you may use in other Windows applications: Ctrl S to Save, Ctrl C to Copy, Ctrl V to Paste…but no Ctrl Z to Undo!