|
Report Painter
Key Features of Report Painter
Prepare Plan/Actual/Variance Expense Report
Cost Elements Actual Plan
Variance
Salaries Xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx
xxxxxxxxxxxxxxx
Office Xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx
xxxxxxxxxxxxxxx
Travel Xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx
xxxxxxxxxxxxxxx
Supplies Xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx
xxxxxxxxxxxxxxx
Total Xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx
xxxxxxxxxxxxxxx
Use the following account numbers and
descriptions in your report:
Account number Description
430000 Salaries
470000 Office
474100 Travel
476000 Supplies
Create a new report.
Menu Path: Information Systems > Ad hoc reports >
Report Painter > Report > Create
On the Report Painter: Create Report screen,
enter:
Library – 1VK
Report RSS-A
Report Description – Report w/Total Row
Hit <Create> button to move to the next screen.
Create the Rows of the Report – The first four
rows are cost element characteristics
Screen: Report Painter: Create Report
Type ‘Cost Elements’ in the lead column cell
Double click on Row 1
In the Pop-up window 'Element definition: Row1",
enter:
Note: If Pop-up window (select element type)
appears, choose 'characteristics' and hit <Enter>.
Select 'Cost Element' as the characteristic in
the 'Available characteristics' section
Hit <Move selected to left> button to move the
characteristic 'Cost element' to the 'Selected characteristics'
section
From – 430000
Hit <Change short, middle and long texts> icon
(at the bottom of the window)
In the Pop-up for Enter Texts, Enter:
Short – Description from Table above for this
Account
Click on the <Copy short text> button to copy
this description to the other fields.
Hit <Confirm> to close the Pop-up
Hit <Confirm/Enter> to check consistency and
close.
Repeat the above steps for the other 3 accounts
Create a formula row to calculate the total of
the Cost Element rows
Screen: Report Painter: Create Report
Double click on Row 5 or the next empty row.
In the Pop-up for Select Element Type select
'Formula'
Hit <Enter> to close the Pop-up
In the Pop-up 'Enter Formula'
Use the calculator buttons to create the formula
Y001 + Y002 + Y003 + Y004
Hit <Enter> to close the Pop-up
In the Pop-up 'Enter Texts'
Short – Total
Click on the <Copy short text> button to copy
this description to the other fields.
Hit <Enter> to close the Pop-up
Make sure your cursor is in the cell containing
the word ‘Total’
Follow the Menu Path: Formatting > Row
In the Pop-up 'Row Formatting'
Overscore – checked
Underscore – checked
Hit <Enter> to close the Pop-up
Create the first column for actual costs
Screen: Report Painter: Create Report
Double click on the ‘Column 1’ cell.
In the Pop-up 'Select element type'
Select Predefined Key Figure radio button, and
press <Enter>.
In Pop-up 'Choose predefined column'
Select Actual Costs as the predefined column, and
press <Enter>.
In the Pop-up 'Element definition: Actual costs'
Press <Confirm> to check consistency and close.
Define the second column for plan costs
Screen: Report Painter: Create Report
Double click on the ‘Column 2’ cell.
In the Pop-up 'Select element type'
Select Key Figure with Characteristics as the
element type, and press <Enter>.
In the Pop-up 'Element definition: Column 2'
Value Type – 01 (Plan)
Version – 0 (Actuals)
Valuation – 0 (Legal valuation)
Hit <Change short, middle and long texts> icon
In the Pop-up for Enter Texts, Enter:
Short – Plan
Click on the <Copy short text> button to copy
this description to the other fields.
Hit <Confirm> to close Pop-up.
Hit <Confirm> to check consistency and close.
Create a formula column to calculate the variance
between actual and plan costs
Screen: Report Painter: Create Report
Double click on the ‘Column 3’ cell
In the Pop-up 'Select element type'
Select Formula as the element type, and press
<Enter>.
In the Pop-up 'Enter Formula'
Use the calculator functions to create the
formula X001 – X002.
Hit <Confirm> to close the Pop-up
Enter Variance as the text for all three fields.
Hit <Enter> to close.
Define the parameters for general data selection
Screen: Report Painter: Create Report
Follow the Menu Path: Edit > Gen. data selection
In the Pop-up 'Element definition: General data
selection'
Select Controlling Area, Cost Center, Fiscal
Year, and Period as the selection characteristics
Hit <move selected to left> icon to move the
selected characteristics to the selected characteristics section
of the window
Enter the following values for your
characteristics:
Controlling area – RSS ('from' field)
Cost center - 1000 to 2000
Fiscal year - Current year
Period - 1 to 12
Hit <Confirm> to check consistency and close.
Check the report for any errors and save it
Screen: Report Painter: Create Report
Follow the Menu Path: Report > Check or press <
Shift + F6>.
When the system comes back with a message of ‘No
errors were found’, click <Save> to end.
Assign the report to a report group using the
function in Report Painter
Screen: Report Painter: Create Report
After the system has come back with ‘Report RSS-A
was saved’
Follow Menu Path: Environment > Assign report
group
On the Insert Report in Report Group Screen:
Enter Z0#A as the group
Hit <Enter>
In the 'Create report group' pop-up window
Click <Yes> to create the group
Make sure the system has come back with ‘Report
RSS-A was saved in Report Group Z0#A’.
Execute the report
Screen: Report Painter: Create Report
Follow the Menu Path: Report > Execute
Notice that there are no selection criteria to
enter. These were hard coded in the general selection
characteristics.
Click the <Execute> icon.
It is a very basic report of plan, actual, and
variance costs for a group of predefined cost centers.
Additional Detail:
Submitted by
Dr. Ravi Surya Subrahmanyam
- answerthink India
limited
|
