on 10-27-2009 4:43 AM
Dear all,
I have one issue needs your help. I consulted this issue to a FI consultant but he don't have a solution too.
Most appreciated and of course point will be granted if you can give me a suggestion.
When I post an sales IDOC to create a Billing (billing type FP), the Billing will be auto released to FI and created these documents: Accounting document, Profitab. Analysis, Controlling Document.
In the Controlling Document the object type is always "REO" (CO object name = "Profitability Analysis").
For example:
DocumentNo Doc. Date Document Header Text RT RefDocNo User Rev RvD
PRw OTy Object CO object name Cost Elem. Cost element name Value COCurr
100001721 15.10.2009 R 1000000023 KEVINCHAN
1 REO Profit. analysis//H Profitability Analysis 631001 Shipping Income 12.30-
2 REO Profit. analysis//H Profitability Analysis 400000 R-Gross Sales 18.70-
Now I want for a particular material accounting group (group 13), a particular G/L acct (631001) is used, and the Controlling Doc will be posting to cost element 631001 and cost center 1000140.
However, I found that I cannot disable the "REO" post in the Controlling Doc. As a result I got this:
DocumentNo Doc. Date Document Header Text RT RefDocNo User Rev RvD
PRw OTy Object CO object name Cost Elem. Cost element name Value COCurr
100001721 15.10.2009 R 1000000023 KEVINCHAN
1 CTR 1000140 CMPD 631001 Shipping Income 12.30-
2 REO Profit. analysis//H Profitability Analysis 631001 Shipping Income 12.30-
3 REO Profit. analysis//H Profitability Analysis 400000 R-Gross Sales 18.70-
In above Controlling Doc, item 1 is what I want (Controlling doc post to cost center 1000140, cost element 631001). But I want to DISABLE item 2 posting.
Do you have any idea?
Thanks.
ps. COPA already activated, Running SAP Retail
Hi
Actually if you are working with EPOS then functional module will take care of this automatically it will create both the documents GI (Article document) and SD billing document same moment.
But if no EPOS is in place and your document is not coming through interface then you need to perform delivery and post goods issue activity before SD billing document to generate COGS document.
In Case of Account-based COPA, At the time of delivery it will create a delivery number and you need to perform 'Post goods issue' to show your sales consumption. For this you need to do VL02N, you need to select your delivery number and have to click on 'Post goods issue',It will create GI document for COGS postings.
COGS A/C Dr
To Inventory Cr
In Costing based COPA, the value for COGS is transferred to COPA through the condition type VPRS when the billing document is released to accounting. There is no posting into COPA at the time of 'post goods issue'.
Hope this helps!
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Dublin,
We are using costing-based COPA, and the POS sales were uploaded to SAP via IDOC. The IDOC type is WPUTAB (POS interface: Upload day-end closing POS).
Once the IDOC inbound completed, Billing doc, Accounting document, Profitab. Analysis, Controlling Document will be created automatically. No need to do any PGI (actually no delivery note is created).
Now the problem I am facing is that in I don't want the "REO" posting from FI to the Controlling Doc for a particular material acct group.
Regs.,
Kevin
Dear Dublin,
Thanks for your prompt reply. Sorry that I missed some information.
At this moment all the account determination and posting are correct. But I just want if the material in billing item has material accounting group 13, it will not post to Controlling doc from FI.
In details, in VKOA, already setup KOFI condition type account determination that points to G/L 631001.
Only in the Controlling Doc, now has 3 items:
Item / Object Type / Object / CO Object Name / Cost Element / Value
1 CTR 1000140 CMPD 631001 Shipping Income 12.30-
2 REO Profit. analysis//H Profitability Analysis 631001 Shipping Income 12.30-
3 REO Profit. analysis//H Profitability Analysis 400000 R-Gross Sales 18.70-
I don't want to have item 2.
Thanks,
Kevin
Hi
You can't post actual values simultaneously to Profitability Segment and Cost Center. PSG will have priority, so Cost Center will get statistical value only. Note: you may have separate account assignment objects in financial document, but only 1 object gets real value, all other will be posted with statistical value.
Please check your account then should it flow to PSG or not? if yes default this to PSG in OKB9.
Regards
Dear Dublin,
No, for this material acct group I don't want to post to PA. I want to post to Cost Center.
That's why I don't want the 2nd item in the controlling doc.
In OKB9, I already had below default account assignment, after this entry I have the 1st item of the controlling doc.
Company code = 1000
Cost element = 631001
Cost center = 1000140
Item ObjType Object CO Object Name Cost Element Value
1 CTR 1000140 CMPD 631001 Shipping Income 12.30-
2 REO Profit. analysis//H Profitability Analysis 631001 Shipping Income 12.30- <-- DON'T WANT THIS
3 REO Profit. analysis//H Profitability Analysis 400000 R-Gross Sales 18.70-
Thanks,
Kevin
Hi
Cost center cannot be used as cost object for revenue. Revenue can only be posted to the cost center as statistically. CO will always need a CO- object if there is a cost element defined. Since no 'real' cost object was assigned to the posting the system used the default object REO (reconciliation object - I guess like a dummy assignment). In CO-PA(Account based) the system would use the profitability segment as the cost object for your revenue.
Regards
Dear Eric,
I had an user requirement:
1. check every billing item in the billing document
2. if the material belongs to material account group 13, no posting to COPA but post to Cost Center.
The config I done currently is to post to Cost Center, but I cannot disable the posting to COPA.
As you mentioned I cannot disable REO item, then can I disable the posting to COPA?
If disabled the posting to COPA, then will this REO item exist?
Thanks.
Tell me a little more - what's the cost element category of that account? Is it defined as a revenue account / deduction account (type 11 or 12?)
If so, you can't hit CCA by itself - CCA can only carry revenue statistically, and any CO posting needs at least one real receiver. Hence, the CO-PA posting.
Dear Eric,
The cost element category is 11 (Revenues).
There's a requirement from the account department user that, for material account group 13, he wants the Controlling Doc look like
Item ObjType Object CO Object Name Cost Element Value
1 CTR 1000140 CMPD 631001 Shipping Income 12.30-
2 REO Profit. analysis//H Profitability Analysis 631001 Shipping Income 12.30- <-- DON'T WANT THIS
3 REO Profit. analysis//H Profitability Analysis 400000 R-Gross Sales 18.70-
I have another suggestion from others that using User-exit (enhancement COPA0005, function module EXIT_SAPLKEII_002) to set the value to zero when for material account group is 13.
But I found that this user-exit only affects the data to be posted to PA doc, not the controlling doc.
Eg.
** Invoice
Item 1: Qty =1 PC, Value = 12.30 (This item belongs to material account group 13)
Item 2: Qty =2 PC, Value = 18.70
** PA doc before user-exit
Qty = 3 PC, Gross Sales = 31.00 .
** PA doc after user-exit
Qty = 2 PC, Gross Sales = 18.70 (excluded item for material account group 13)
However, the _Controlling Doc_ will always be
Item ObjType Object CO Object Name Cost Element Value
1 CTR 1000140 CMPD 631001 Shipping Income 12.30-
2 REO Profit. analysis//H Profitability Analysis 631001 Shipping Income 12.30-
3 REO Profit. analysis//H Profitability Analysis 400000 R-Gross Sales 18.70-
If I cleared all value in the user-exit, SAP does not generate a PA doc, but still I have the same Controlling Doc.
It seems the Controlling Doc is not related the to PA doc. Is that a way to make exclude the material account group 13 item in both PA doc and CO doc?
Thanks,
Kevin
Edited by: Kevin Chan on Nov 2, 2009 8:52 AM
Why?
How your user wants to do it, is not going to work. If you let the forum know why/ what he is trying to do, we can maybe come up with suggestion. Even uif you are posting that entry to a cost centre now, it is only statitical.
This is exactly correct - in CO, at least one object must be "real" in a posting. And, since CCtrs can't carry revenue as real postings, the system is hitting CO-PA. This can't really be suppressed w/o using another object to receive the real posting.
You could collect the revenue on an internal order, perhaps one that is simply never settled. This would prevent a posting to CO-PA, if the order type allows revenue postings. This is a pretty strange scenario, though.
One other thought - what's the actual business use of the G/L account? Is it really revenue, or an offset to expense? It is possible that the account has been set up with an incorrect cost element category.
Can you describe the business scenario? What's driving the user to want this account recorded in CCA, not CO-PA?
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.