on 10-26-2012 6:05 AM
Hi Techies,
I want to know whether their is any standard report in Ps where we can have feilds like Billing/Cost Price/Sales Price/Invoice/Margin.We are using at present
CN41 & S_ALR_87013531 for reporting but client want one report that too month wise which will have all above mentioned things for month wise reporting.
If not how can we develope it.
Awaiting Reply,
Ajey D.Chavan
Hi
As our friends state thta either you can develop using report painter or go for custom report which will have all the fields inoformation. Coming to periodic reporting you have to introduce field selection input year and month.
Reports are dynamic and output depends on how and what is your selection parameter.
Regarding your output
Billing - this could be your actual billed - you will get in CN42N and S_ALR reports
Cost Price - either planned or actual costs - you will get in CN42N and S_ALR reports.
Sales Price - this could be your planned revenue on SO and get in CN42N and S_ALR
Invoice/Margin - this is calculated value and you have to go for development. This you can get in tac KP24 after performing RA analsys.
As suggested by Mahendra use report painter or Z report which will suffice your requirement.
Regards,
Sudhakar
Message was edited by: Sudhakar Pappu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ajey,
Also have a look on Note 43493 - Project information system: New fields in structures
Regards
Tushar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can use report painter functionality for the same.
For more information or assistant, please check with CO consultant in your team how to create report using report painter.
Regards,
Mahendra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mahendra,
Means we have to make some custom devlopment right?
But can we have months wise.Their are month wise reports for actual/commitment/planned cost month wise thats is .Can we add Billing/Cost Price/Sales Price/Invoice/Margin in one of this report in report painter.
Thanks & Regrads,
Ajey D.Chavan
In Report painter report, it is not custom development but more of a functional tool.
This report can be designed as you wish to have.
For example: The output can be Year On Year or Month on Month. One of the most simple way is to first copy a standard report(starting S_ALR_*) which is near to your requirement and then modify the columns and rows as you require.
If you check CO consultant, how to go about it he/she can guide you how to achieve it.
Regards,
Mahendra
User | Count |
---|---|
91 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
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.