Rounding

This is an excerpt from my new training manual Creating Reports in Management Reporter I—How to Create 4 Foundation Reports. Be careful when rounding a balance sheet!

Background—earlier in this chapter, I had rounded a balance sheet to whole dollars (in the report definition on the Settings tab). As you know, that often throws the balance sheet out of balance by a dollar or two. Fixing that is what Lesson 6 is about. Here’s the excerpt:

Chapter 3 Lesson 6 Rounding Adjustments on a Balance Sheet

Rounding to whole dollars will often throw the balance sheet off by a dollar. Here’s how to create a rounding adjustment—and what to watch out for.

From the BS report definition, open the row definition:

media_1300214651052.png

1. Click the Open Row Definition icon—this will open the row that’s used by the BS report definition [click to continue…]

{ 1 comment }

Nov.

22

2008

FRx SP10 and CS Currency Rounding on the First Row

by Jan Harrigan CPA

I just found this workaround for the CS currency rounding issue.

Found it on the FRx forum at microsoft.public.com. By default, FRx adds the currency format to the 1st row of every report. SP10 has not been allowing the rows with CS to round properly.

The commenter was wondering why some of her reports rounded on the 1st row and some did not. I have wondered the same thing! I haven’t tested this yet but wanted to get it out. Here you go:

“I discovered one difference that apparently changes how the 1st row currency symbol and the whole dollar rounding from the catalog affects the report.  If the 1st line of the row is blank or has a DES format code, the 1st row of data rounds correctly with the currency symbol.  If the 1st line of the row contains data it gives the decimal places and needs the workaround and will show $0 even if “Display blanks for zero amounts” is checked. 

So I just added a blank NP line in the row and my first line now includes the $ and rounds to the whole dollar.  Don’t know why that works but I’m thankful it does!”

I’m thankful that the commenter shared her discovery!

If you want to know more about the currency rounding issue, please see my post at FRx SP10: The Good, The Bad, and the Ugly.

{ 4 comments }