COPA - FI Reconciliation

[former_member731305]

Hi,

I am using CO based COPA. In the Sales Order, I have a condition type to consider the freight costs (approximate value). Say, my revenue is $1000; so I am taking my freight costs as 10% ($100) which makes my net revenue as $ 900. Both $1000 & $100 flows into COPA and revenue in COPA is $900.

Now, when the frieght vendor sends the invoice, the amount is $150 instead of $100 which I post against a CC. So, in FI my net revenue is $1000 - $150 = $850 but in COPA it is $900. How do I reconcile COPA with FI under such circumstances?

Any help would be appreciated and points awarded.

Thanks,

Deb

[ajaycwa1981 · Accepted solution]

Hi deb

I guess your freight condition is a statistical cond.

In such case post both freights to separate val Fields. One vf will have estimated amount and the other will have actual

Br. Ajay M

[Former Member]

Hi Saha,

Repost the  accounting document number with difference amount i.e. 50.

Regards

Ravi Polampalli

[former_member731305]

This message was moderated.

[former_member731305]

Thanks everyone. Points has been awarded. Unfortunately, could not tag multiple replies as correct.

[Former Member]

Hello Debayan,

I implemented this scenario last year with three North american companies, so I know the scenario quite well. I think Julie Phan is correct with her answer, if only FI reconciliation is the issue.

Think about what happens, when the freigt invoice is captured in Financial Accounting. If your SD freight condition is a proper accrual condition (which I assume), the posting is $100 freight accrual account against freight expense account. The $100 was not posted on cost center, but on a COPA profitablity segment (as desired). So for the $150 freight invoice, $100 can be matched in a first line item against the open accrual line item, while $50 still need to be expensed in a second line item. If you expense the $50 against a cost center, Accounting might be happy (freight invoice is successfully posted), but you loose the context of the sales order/delivery with the cost center assessment. In this situation I would recommend to assign the $50 to the correct COPA profitability segment by adding the sales order (position) in the posting block of the second line item. SAP can then derive all the characteristics by itself. You have to adjust the field status group of the freight expense account to work properly.

This whole procedure is extra work for Accounting though. It depends on whether the freight expense deviations warrant the extra effort. I implemented the solution as described, but 2 out of 3 companies decided later it was not worth the extra effort and returned to simple cost center expensing, which is Julie's solution.

Regards,

Steffen

[Former Member]

Hi Debayan,

Because when you post freigh again to CC,the amount cannot go to COPA automatically.

You have to run Assessment via tcode KEU5,create cycle to transfer data from CC to COPA.

Julie

[chandra_sekhar08]

Hi Deba,

I am not getting understand you have made condition type to consider the freight costs 10% and your revenue is $1000 so the freight cost would be $100 only,how it would be %150? is there any change in revenue? in case of revenue change to %1500 then only freight cost would be $150 that time $ 150 is getting updated to COPA too through condition.

Thanks,

chandrasekhar