cancel
Showing results for 
Search instead for 
Did you mean: 

Impact of Negative Stock to MAP calculation

Former Member
0 Kudos

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!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi chenna,

how the system calculate the GR value as RM2050 and also the difference RM950?

I thought the GR accouting posting should be :-

Dr Stock RM3000 (200* 15)

Cr GR/IR RM3000

Hope to get clarification from you. Thanks!

Former Member
0 Kudos

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

Former Member
0 Kudos

Thanks! Appreciate the clarification!

Answers (0)