Initial Stock Upload

[cooladas_sal]

Hello all,

are the steps as shown below correct? I am not sure that in the case of materials with standard price the proposal is correct. Furthermore what other steps are to be done by FI once the goods are uploaded?

Material Types with Moving Average Price (Raw Materials):

1. Upload materials with 0 price
2. Upload stocks and values for materials that have stocks at the time of upload

Material Types with Standard Price (Finished and Semi-finished Goods):

1. Upload materials with 0 price (in order to have time for BOM creation)
2. Perform MR21 (in order to take over the price calculated in 31/10 in the old system as standard price of the initial stock upload)
3. Upload stock (only quantities, no values required, values are calculated via the standard price in the material master)
4. Perform Costing run and release the calculated standard price in April 2011. Any price difference due to stock revaluation will be posted in April.

Thank you

[JL23 · Accepted solution]

I would certainly not use your approach.

when you migrate from a legacy system to SAP, then the values of inventory have to match in both systems.

if you load with zero price, then they will certainly not match.

Releasing cost estimates based on BoMs may cause as well revaluation and you are not able to reconcile your inventory migration.

first you load the material, no matter if the price is available or not. As a material is often loaded weeks ahead of go live, the price will never match with the price at go live, so the price has to be loaded in any case at go live date before inventory take over.

In case of moving average valuated materials you can load the value together with the inventory in 561 movement and the MAP will calculate automatically and update in material master (best method to have the same values in legacy and SAP system, as you do not hit any rounding issues because you load with value instead of calculating the value based on a price)

In case of standard price you have to make sure that the cost estimate is not released, then you load the standard prices with MR21.

After that you load the batches and its classification, finally the inventory itself. if you have WM in place then you have a subsequent step to putaway the loaded inventory into the bins. (this can under some circumstances as well be combined into the 561 movement)

after you have reconciled the values you can release your cost estimate,

[cooladas_sal · Accepted solution]

excellent explanation Jurgen.Thank you.

Just before I mark the question as answered:

1.do you know what steps are to be done by FI relevant to the values of stock upload.I know that stock account will be debited and offsetting GBB-BSA will be dcredited. Have you got any idea on the cross module (MM-FI) steps?

2. When you say reconcile what exactly do you mean? I guess that the values should be fine if uploaded as suggested.

Thank you

[JL23 · Accepted solution]

not sure what exactly you refer to. But a 561 movement is a movement like any other, it gets its accounts thru the customizing of account determination which is setup together as a shared activity from MM and FI.

I usually have there an account assigned which is only used for initial stock load, this account will be locked after the inventory  load was reconciled with the legacy system.

For reconcilliation of values and accounts  I use MB5L report.

Quantity reconcilliation I usually do with with the MB52 stock list.