on 12-16-2013 4:43 AM
Hi,
The requirement is more of Consolidation report for a
Company (including manufacturing and marketing).
The manufacturing company produces FG and sales it to its Marketing
Company.
Each company has its own G&A expenses.
The requirement is to draw a Consolidation report excluding
the intercompany sales and revenue and including G&A expenses from both.
Sales Qty XXX
Sales Revenue YYY
Less COGS ZZZZ (This COGS corresponds to the Sales Qty. but valuation in Manufacturing Company)
Less G&A expenses AAA (for both Companies)
How can it be achieved through COPA.
Kindly help.
Kami
Hi Kami,
As Waman right suggested, the report is prepared at operating concern level. If all your company codes are indirectly linked to one operating concern through controlling area, you can have consolidated report as you wish. Further more you can see the values at each company code, plant wise based on the parameter selections you make (this is the sweetest part of COPA reporting).
Don't worry, go ahead as Waman rightly suggested.
Regards..
Jose
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Kami,
You need to use tcode KE31 to create your own report in COPA.
But first check via tcode KE24 that the data you need is available.
I assume that sales QTY (XXX), sakes revenue (YYY), COGS (ZZZ) and G&A expenses (AAA) would all be available in COPA value fields. Then its just a matter of creating your own keyfigures (formulas) to calculate the value in the KE30 report.
regards
Waman
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Waman,
Thanks for your reply. Yes the data might be available in KE24. But my worry is, Whether in report painter, the data from two separate company codes and separate plants can be clubbed or not.
Because we have to add lets say G&A expenses from two separate company codes to make the consolidation report.
Your view on this.
Regards
Kami
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.