Start a conversation

Changing the positive/negative signs on Revenue Report

Question:

I am trying to change the positive/negative signs when producing a revenue report in report writer for the last column "over/-under budget" column. How can I go about changing the signs for this column?

 

Resolution:

Based on the attached report, it appears that this type of report is using the "F/A FORMAT" report writer definition. You can reverse a dollar value field sign via the Vertical P&L Skeleton Maint., option 11 from the G/L Report Writer Menu (please see screen example below.) PLEASE NOTE: This will change the sign for all reports using this definition. You can use the on-line help (press F1 when cursor is on the field) for more detailed field descriptions. Regards, PF

GWIA02 Vertical Skeleton Maintenance 2/11/13
HEAD1 11:02:11
Anal#: 11 TEST CLONE
Line# Seq# Description
1 10000 Gross Sales
2 10500 Sales Discounts
3 11000 Net Sales
4 11200
5 12500 Cost of Goods Sold
6 12700
7 13000 Gross Profit (Loss)
8 14000
9 15000 Operating Expenses

Seq# 10000 Description. . Gross Sales
Seq# to be added to. 11000 13000 24000 30000 35000
Subtracted from . . .
Pg Break (detail). . N Pg Break (summ) . . . N
Reverse sign . . . . Y Enclose in (-) . . . Y Underline $ col . . . N
Net Rev. Line . . . . N Beginning of Inv . . N Ending of Inv . . . . N
Don't print if 0 . . Y Dollars/Qtys($/Q) . . $ PerQty% Cur/Cum(R/M).
D=Delete
F6=GL Accts F9=Add GL# By Range F12=Previous Roll Keys (C)FirstOption 2011

Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Paul Fuller

  2. Posted

Comments