cancel
Showing results for 
Search instead for 
Did you mean: 

Projects/Orders Cost Settlement COPA

zainm_bashir
Participant
0 Kudos

Hi Experts,

We have a business requirement to settle (PS) projects relevant costs in COPA. we are using Costing Based Profitability Analysis.

I have followed following steps to do so but got no luck;

- Created one Value Field on which the data should be settled.

- Assigned source Cost Element Group on PA Transfer Structure (E1). The Cost Element Group includes complete P&L Gls.

- Assigned the same Value Field as Target on PA Transfer Structure (E1).

- Checked Settlement Profile (60 - Networks) which is used for Projects Settlement, PA Transfer Structure (E1) was assigned there and all indicators    were marked under Indicators tab.

Every thing seems perfect but data is not flowing to COPA.

I tried two approaches;

- Straight forward settlement to Cost Center and checked whether COPA Doc derived? the result is NO.

- Assigned PSG along with CTR under settlement rule of particular WBS and executed settlement to Cost Center and WBS and checked whether COPA Doc created? the result is YES but then no Accounting Doc (Financial Entry gets generated) which is wrong.

Can anyone please guide me where i am mistaken?

Regards,

Zain Bashir

Accepted Solutions (0)

Answers (2)

Answers (2)

zainm_bashir
Participant
0 Kudos

any input please?

miya_wang
Active Participant
0 Kudos

Hi Zain,

Have you tried to create a settlement rule for WBS element to PSG only and settle the WBS?

Best regards,
Miya

zainm_bashir
Participant
0 Kudos

Hi Miya,

Yes i already tried your suggested solution but then system only posts 2 documents;

1 - Controlling Document

2 - Profitability Document.

No Accounting Document generated!

Let me put my question in a different way;

I need system to settle WBS Cost to Cost Center and Profitability Segment and it should create Accounting Document. It should post three documents as follows;

1 - Accounting Document

2 - Controlling Document

3 - Profitability Document

How can i achieve this please guide.

Regards,

Zain Bashir

miya_wang
Active Participant
0 Kudos

Hi Zain,


When a WBS element settles to a cost center, this will only cause a CO posting to take place.
The only time an FI posting is made with the settlement to cost center is when the real time integration is active and a change to one the the fields in the customizing of the variant.

If you want an FI posting no matter if there is a change in the fields being reviewed, you can change your customizing in transaction FAGLCOFIIMG.

Therefore in this case, I suggest you check the customizing in transaction FAGLFICOIMG.

Best regards,
Miya

zainm_bashir
Participant
0 Kudos

Hi Miya,

Thanks for your message.

I already have Real Time Integration Active, please refer screen shot:

By the way,Accounting Document gets generated if i use CTR only. As soon as i include PSG with CTR or only maintain PSG as settlement receiver then system is not generating Accounting Doc.

Please suggest.

Regards,

Zain Bashir

miya_wang
Active Participant
0 Kudos

Hi Zain,


Please try changing the customizing in the 1st screenshot, from "use checkboxes" to "Update all CO LIs" and see how system works.

Best regards,
Miya

zainm_bashir
Participant
0 Kudos

Hi Miya,

Thanks again for your guidance.

After applying your guided setting, system is posting 3 documents:

1 - Accounting Document

2 - Controlling Document

3 - Profitability Document

But there is one issue still left, system is not behaving in an appropriate way.

I have defined settlement rule to settle the cost in to CTR as well as PSG but system is only posting data in to PSG. Please refer screen shots;

Settlement Profile:

3 Docs generating:

Accounting should credit Network and Debit Cost Center but not happening:


Same is the case with Controlling Doc:


Please guide !

miya_wang
Active Participant
0 Kudos

Hi Zain,

I'm considering that this issue may relate to the settlement rule customizing.

PER+FUL combination means: PER rules used for the costs in the settlement period, FUL rule for unsettled costs in previous period.

If you change the settlement rule to PER for cost center, and FUL for PSG, and test again,

will the system settle the cost to cost center?

I didn't see the chance to settle 100% of sender amount to both cost center and PSG.

Best regards,
Miya

zainm_bashir
Participant
0 Kudos

Hi Miya,

I tried your suggested solution but then system does not post Profitability Document that means again only 2 docs (Accounting & Controlling).

I am conceptually confused that If system can settle production variances caused by Production Order to PSG as well as Accounting & Controlling then why not the case in Projects Settlement?

Do we really need to maintain PSG under settlement rule? as we are not maintaining any settlement rule in case of Production Order Settlement. May be i am heading to the wrong way....

Please guide.