Knowledge Management

Question:
Hi All,
I would like to know the advantages/disadvantages of the following methods for uploading Inventory Balances -
We need to upload material master well in advance of cutoff date so that the other dependent objects like BoM ... are uploaded.
The process - Upload material master data with Moving average price of 1.
1) On the cutoff date, the moving average price is taken from legacy
system & update in table MBEW. We then upload the Stocks (only
Quantities) by a Batch input program.
2) Enter the Value of the material alongwith Quantity in Initial stock
upload transaction (MB1C) in the field "Ext.Amount in Local currency".
In case some materials are valuated at Std price & some others at Moving average price, what are the implications of using the 2nd method.
We have about 70000 material records for upload spread across 6 locations(Plants).
Thanks in advance,
Ganesh
Answer:
Hi Ganesh,
In case of initial stock upload it is better to go with the Value of the stock in the amount field of the transaction. It won't create any problem for materials with MAP since anyway initial stock value is zero. So after the upload stock valuation will be correct.
BUT in case of the materials with Standard price control you will have to be careful as if at all there are differences in the amount you have mentioned in the transaction differes from Standard price of the material then Price difference a/c entries will be genetated and the stock valuation will be wrong to the extent of the price difference.
So if you can clearly identify materials with the Standard price control then upload them with the separate file without mention of the amount during transaction and provided no change in the standard price set in the material price on the day of Go-Live
best luck
AMOL