cancel
Showing results for 
Search instead for 
Did you mean: 

Initial Stock Upload With Value?

Former Member
0 Kudos

Hi

We need to upload the stock in SAP.

How to upload the initial stock upload for both "S" and "V" matls with qty

Wats the t code and further procedure..

Vijay

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

tcode is MIGO-

Goods reciept -


others--

mvt type ---561

If you want to set a diffrent price for valuating the material than the one in MMR,enter a value in the field amount in local currency field.

Reg,

Deepak.

Answers (3)

Answers (3)

Former Member
0 Kudos

HI,

For intial upload of stock there are two t.codes MIGO or MBIC by using M.type 561.

Material price control whether it is "s" or "v" that will be given in MMR.

Former Member
0 Kudos

If you are looking for mass upload then you can prepare a flat file. and standard program is available in sap to upload the data

Cheers

NS

Former Member
0 Kudos

Hi,

First you need the material master with accounting view & Plant data storage view. In the material master you must maintain the Price control as either "V" or "S" as per your requirement with the Value as per that.

Then for Initial upload use Transaction MB1C with Mvt type 561 for initial stock upload into SAP.

Enter the Plant, Storage location, Material no, Qty to upload.

rgds

gsc

Former Member
0 Kudos

Hi

Whr we can maintain prices for the matl master.

In MB1C thr is no option to enter the price.

Vijay

Former Member
0 Kudos

Hi,

Prices are maintianed in the Material master check in MM02/mm03 for that particualr materials.

You cann't maintaint the price in MB1C.

If you don't maintained the price in material master then in MR21 you need to maintain the correct price with the help of Finance department.

rgds

gsc

kunal_ingale
Active Contributor
0 Kudos

hi

plz check following

OPENING BALANCE

http://help.sap.com/bp_bblibrary/470/Documentation/J33_BPP_32_CHEM_EN_IN.doc

http://help.sap.com/saphelp_erp60_sp/helpdata/en/18/8e113999724854e10000000a11405a/content.htm

in this docs u will get proper idea to do the opening balalnces for quantity and value

now when u put price control S or v in ur MMR then system will pick the price u have given and multiply it with stock u have updated with movement 561

like u have given 50 inr/kg (price control S or v )

and stock will update as 100 kg then system will give u the cost as 100kg *50 inr =5000

rather than this suppose u have the stock of 100 and the total value is 50000 inr

now u have to calculate the per kg price as 500 inr ,now give this is value in MMR or change the value in MR21

then do the movement 561 u will get exact value of 50000 inr

try this inur dev server

the price for initial stock will update inspite of ur price control but with the price u have given in MMR

hope it clears

regards

kunal