on 10-25-2010 11:03 AM
Hi,
I have some query on the impact of Negative Stock to MAP price calculation.
If letu2019s say now I have 10 unit of stock A u2013
Stock qty = 10
Price/unit= RM10
Total stock value = RM100
Then, I goods issue 200 unit of stock A -
Stock qty = -190
Stock value = -RM1900
Then, I goods receipt 200 unit again at diff cost, & the accounting posting is :~
Dr Stock RM 2050
Cr GR/IR RM 3000
Dr Inv Adjustment RM 950
Just wondering How system calculate RM2050? Any idea? The MAP had now changed to RM15/ unit.
Hope to get feedback from SAP guru.....Thanks!
Hi,
Stock qty = 10
Price/unit= RM10
Total stock value = RM100
Then, I goods issue 200 unit of stock A
Stock qty = -190
Stock value = -RM1900,
in this case sytem takes the MAP from the material master which is available, as 10 RM,
Then, I goods receipt 200 unit again at diff cost, & the accounting posting is
Dr Stock RM 2050
Cr GR/IR RM 3000
Dr Inv Adjustment RM 950
in the above case u have received the GRN with 15RM,
means the MAP is update with the new price,
and the difference 950 is also adjusted through inventory adjusted posting,
rgds
chenna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
at the time of goods issue ( negative), there is 190 diffrence qty issued,
with the price 10 RM, as per the material mater price ,
when your doing the goods receipt , the material price is 15 RM,
so, for that 190 qty , there is a diffrence of 5 RM for each qty,
means total difference amount is 190*5=950,
after posting the goods recept receipt document system balanced the 950 RM,
and it is posted to the inv differnecs accounts,
finally MAP is updated to 15 RM, while there is no stock before the goods receipt,
rgds
chenna
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.