on 09-21-2014 12:30 PM
Dears
I am trying to create a Cost Centre report to show the Cost element posting period wise in vertical columns.
I am not able to get the required output. I am not sure whether I am mistaken anywhere.
General Data selection : Controlling area, Cost Centre
In the GL Code : Cost element
Period 14-Jan : Version, Actual Cost, Fiscal year, Period from (001), period to (001)
Period 14-Feb : Version, ACtual Cost, Fiscal year, period from (002) , period to (002)
etc. etc.
still I am not able to execute the report.
Please advise whether I am doing right ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI ,
please see below .
Your form should look like as below ( Please ignore Plan cloumn )
General data selection
NOw as left and side you see I have debit and credit as lead column .
Now click double click on lead column .for debitand define as per below screen shot
After this double click on next line and define credit elements I have included A creditas well coz we have settlements as well.
NOw you need to define the Actual Periods as per my First screenshot
I have Plan periods as well Please ignore them . YOu can just define 12 Actual mnths only as below
NOw you this exercide for 12 time for each periods . Just change Period filed like from2 to 2 , from3 to 3 etc.....
Please let me know if you need more help.
Many Thanks
Hi Nikita ,
Please go to transaction RPC0 and you will get below Screen ,
NOw if you to Second last tab which Report currency . Please choose the Object currency and you will get this report in Company code currency .
Generally You run Coontrolling report in Controlling Area currency . untill you make these setting . Object currency is always a company code currency . These settings are User specific . So you may need to tell each users to change this .
Once you change these setting . they will be applicable to all controlling report like other cost centre report ( in Standard one) , project system reporting etc .
Many Thanks
Dears
Is it possible to include the fiscal year and period in the selection screen as well as include it in the report display screen ?
Selection :
Controlling Area
Fiscal year
Period : from ___to ____
Report Output:
Once I select the Fiscal year and period in the General data section, I am not able to get those fileds in the characteristic rows and columns.
Dear Preeti
If the user wants to select data to a particular year and period, he can do if we can include the FY and period in the selection, right ?
Also, please tell me if we can make the report in the format with Cost Centre, Cost Element, Data from 1-2 ?
Now the cost centres are coming in another section in the left side of the output. When the user wants to download this data to an excel, he wants it in the regular format :
Is it possible to do like in the format layout ?
HI,
If the user wants to select data to a particular year and period, he can do if we can include the FY and period in the selection, right ?
Ans: Each column you can incorporate the period. But year you need to mention in general data selection. But if you keep the period in every column then in selections you will not get the period option you can get only year Option.
Also, please tell me if we can make the report in the format with Cost Centre, Cost Element, Data from 1-2 ?
Ans: Cost center and Cost lements you can not get as you shown above.. cost center will get in seperate column only.
Regards,
Ram
User | Count |
---|---|
90 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.