Actual cost postings duplicated

[s_raghavan]

Hi,

I am getting the following issue

I have made PO for direct consumption(Account Assignment category P) with Freight as Header condition.(This header condition type has Accrual key assigned to it which is linked to a G/L which is a P&L account).

Now when Goods are received, the Freight cost gets added to the material cost and it reflects in CNMM Report as Actual cost.

Again when Invoice verification is done, the Freight cost gets booked as actual cost in CNMM report. Now the cost against freight is duplicated(i.e., when doing Goods Receipt and when doing Invoice verification).

But when the same thing is done with Account assignment category Q, the Actual cost does not get duplicated.

Any suggestions?

Thanks.

[former_member230675]

> Again when Invoice verification is done, the Freight cost gets booked as actual cost in CNMM report. Now the cost against freight is duplicated(i.e., when doing Goods Receipt and when doing Invoice verification).
> 

Can you double check the steps followed during MIRO.. it should not be duplicated..

[s_raghavan]

I have checked the steps. When doing Goods receipt, the actual cost for freight gets posted with material account.

When doing MIRO, separately freight cost gets posted in Freight Account.

If there is enough Budget in PS, system allows the Invoice receipt postings. If there is not enough Budget, system does not allow to make Invoice receipt at all.

Edited by: S.Raghavan on Nov 21, 2011 9:49 AM

[Former Member]

I am not sure about my answer but can you please check with FICO consultant if fright charges G/L account need to be cost element or not.

This might help you solve the problem.

thanks!

Mahendra

[former_member230675]

Normally the Postings will takes place as follows..

During MIGO

Debit Inventory a/c

Credit GRIR Clearing a/c

Credit Freight Clearing a/c

During MIRO

Freight Vendor - Credit Freight Vendor a/c, Debit Freight Clearing a/c

Goods Supplier - Credit Vendor a/c, Debit GRIR clearing a/c

Please check with your FI consultant...

If you need to avoid any of the above cost element from Budget check then please add those Cost elements in OPTK.

[s_raghavan]

But the PO is placed with Account assignment category "P"(direct consumption) and does not come to inventory.

Also the Freight GL is created as a cost element.(Also it is a P&L account).

If I use the T code OPTK to exempt the cost elements, it will not check with the Budget but the Actual cost postings will be duplicated which is not right(will be reflected in CNMM report).

Edited by: S.Raghavan on Nov 21, 2011 3:13 PM

Edited by: S.Raghavan on Nov 21, 2011 3:15 PM

[former_member230675]

Please check your accounts (check with FI consultant) and see whether cost is doubling in FI or not?

If it is only showing double in CNMM then it is the PROMAN profile issue..

also check CJI3 and verify whether the actual cost is doubling or not..

If it is doubling only in line items report and CNMM (not in FI) then it is cost element issue.

Please check all angles (not only from CNMM) and verify.

[s_raghavan]

I checked CJi3 report. Even there I find the actual cost for freight is posted in Material account and Freight account. So this is no a Proman profile issue.

I am checking in all possible angles. Is there any restriction that for account assignment category "P" that we should not assign Delivery costs in PO or should we make any modifications in the account assignment category "P" before postings?

[former_member230675]

. Is there any restriction that for account assignment category "P" that we should not assign Delivery costs in PO or should we make any modifications in the account assignment category "P" before postings?

I do not think there is any relation ship between account assignment "P" and Freight cost. Account assignment "P" and "Q" determines the consumption of material / inventory.

I have already posted earlier how the accounting flow of freight cost happens during MIGO and MIRO. If you have MM and FI consultant in your team then please check with them. Otherwise may be you can get help from those forums.

[s_raghavan]

I have checked with my FI and MM consultants and still could not arrive at a conclusion. Let me put my question this way. Is there any setting to prevent posting of actual cost during Invoice Verification.

[former_member230675]

In PO there are some settings to update actual during MIRO those are..

1) Set the GR-non-valuated indicator checkbox in the PO so that no GR valuation takes place and therefore, the actual price will be made and posted during MIRO process.

2) Set PO price as generic and treat the difference during MIRO process

I am not sure whether the above are relevant for you.

I will suggest you to post this query in FI forum and also close the thread here. you can mention the link of this thread in your new post in FI forum and also the FI forum posting link here to close the thread.

[s_raghavan]

But GR non valuated cannot be activated because it will not post the accounting entries at all.

Abdul,thanks for your suggestions.

Thanks

[former_member230675]

Please close the thread and do not cross post the same query in other forum, which is against forum rules..

http://wiki.sdn.sap.com/wiki/display/HOME/Rules%20of%20Engagement?bc=true

[s_raghavan]

Thanks.