SAP : Problem with Material Ledger and ICP

I have a Russia based client where by it is decided to implement actual
costing and material ledger for dual valuations. I am facing a related
problem that I cannot find the answer on.

Situation
Now in Material Ledger, in Russia we have an obligation to valuate all
extra costs on stock. In a cost of goods flow with third parties, it seems
that we have no issues with the material ledger. But in a flow where we
procure goods from our own factories in Europe – the agreement is that the
Russian M&S unit pays the cost price + 5% ICP to the factory.

Problem
It seems that the 5% ICP markup on the cost price doesn't get reflected in
the material ledger – and hence will not be consider when we run the final
closing entry for actual costing which valuates the stock at periodic unit
price. For example, if at GR goods receipt of PO xxxxxxx the system only
posts 5500 RUB which is 55 RUB / EUR * 100 EUR. Whereas I want to post 5500
* 1.05 = 5775 RUB to the material ledger.

Possibility
I tried to create accruals / condition type ZA13 in the MM calculation
schema to influence the costprice with some success, but that affected the
way the system accrues for ICP. So I want to post the ICP to the material
ledger, whereas at the same time in the goods receipt I want to post the
normal posting schema for US GAAP which is:



Debit Credit
Stock recon acct - Stock qty * Std GRIR acct - Net purchase price + ICP
price US GAAP 5% of net purchase price
ICP to pay account – 5% of net Price diff acct - Price difference
purchase price between standard price and net
purchase price



Kindly provide suggestions based on your expertise if some one has exposure
to Material Ledger.

We encountered a similar situation with our client. Ours is a US based
client that procures Slab/Raw Material from its Trading Company in
Brazil . As per the agreement with the Trading Company, Inventory is

supposed to valued at Market Price (Cost + MarkUp) though the Standard
Cost ( SC) should reflect only the Material Cost will remains the fixed
for one financial year.

We created Info Record for the Slab which excludes Mark Up .The PO's
Base Condition (PB00) (copied from Info Record ) includes Markup . Hence
when GR is executed , the difference btw SC and PB00 hit the Price

Difference Account (PD) to be part of ML .As a part Month End Activity,
the PD is considered for Inventory Revaluation and Periodic Price
Calculation-

Below is small example to illustrate the flow:-

Material Management Info Record

PB00 - $ 600
ZMUP -$(150)


Cost Roll Up(CK11N)

SCE - $ 450

PO -XXXX
PB00- $600

Good Receipt Documents

FI

Dr Inventory Ac - $ 450
Dr Price Difference - $150 -This gets captured in ML , considered for Inv Revaluation n Periodic Unit Price Calculation in AC.
Cr GRIR Clearing - $600


3 comments:

  1. Communiquez-moi une adresse-mail et je vous ferai parvenir des informations sur notre solution "GEDIA Audit pour SAP" qui (notamment) solutionne la problématique des écarts entre le Coût Moyen Pondéré (PMP chez SAP) "GEDIA" (procédés brevetés) et les coûts des stocks calculés par SAP (standard ou PMP) y compris les transactions issues du Material Ledger ou Ledger Article.
    Nous avons aussi réalisé une "étude comparative de l’axe de valorisation du stock Ledger Article versus Gédia Audit".
    Mon adresse-mail : mheck@gedia.fr
    Michel HECK - TCI - Strasbourg

    ReplyDelete
  2. Good post and Smart Blog
    Thanks for your good information and i hope to subscribe and visit my blog STD Symptoms and more Tuskegee Syphilis Study thanks again admin

    ReplyDelete
  3. Hi folks, I think I saw it too late, but here it goes.
    Let´s consider the scenario of US at std cost and local company at act cost.
    Let´s go more and consider you have NewGL + FIN_CO_COGM activated + ML post only to local ledger.
    Constraints: You have to keep the condition ZMUP that post the markup account and does not flow to ML. At same time, for local ledger, it must hit MPV account.

    Workaround: At month end run a MR22 only for local ledger with the amounts from markup account. So ML in local ledger will get it. Then FB50L to offset markup account and UMB key only in local ledger.

    Not the best, but it will work.

    BEST Way
    This I´m about to implement based on your tips.

    BSX - 450
    PB00 WRX - (600)
    PRD 150 => you must keep due local ledger/ML
    ZMUP 150 => you must keep due US Gaap
    ZRD (150) => you create to offset the PRD only in accountancy, not material level



    ReplyDelete