cancel
Showing results for 
Search instead for 
Did you mean: 

Stop BIlling posting to Controlling Doc

kevin_chan5
Explorer
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

kevin_chan5
Explorer
0 Kudos

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

Former Member
0 Kudos

Hi

At sales order level,depending on the billing type

1.If costing is required then it requires KOFK condition type is used for account determination.

2.If costing is non required then it requires KOFI condition type is used for account determination.

Regards

kevin_chan5
Explorer
0 Kudos

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

Former Member
0 Kudos

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

kevin_chan5
Explorer
0 Kudos

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

Former Member
0 Kudos

You have to post to a cost element type 11 or 12 from a SD invoice. You cannot post an 11 or 12 to a cost centre.

The alternative you have is to post to a billing enabled Internal Order, or a WBS, and then settle that to the cost centre required.

Former Member
0 Kudos

You can't suppress the REO posting; REO = reconciliation object. This is how the system is recording the transfer into costing-based CO-PA. Most of the discussion in this thread is off-topic.

What problem, exactly, is the REO posting causing?

Former Member
0 Kudos

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

kevin_chan5
Explorer
0 Kudos

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.

Former Member
0 Kudos

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.

kevin_chan5
Explorer
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

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.

Former Member
0 Kudos

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?

kevin_chan5
Explorer
0 Kudos

Dear Dublin / Piet / Eric,

Thanks very much for your kindly help.

I had passing your replies to the user and asking to clarify the requirement. Will update after clarification.

Thank very much!

Kevin

Answers (0)