MC.1 value is different

[Former Member]

Dear Expert,  When I have genereted Report on 31.03.2012 that time indian value is 100000.00 but when i generated report 12.04.2012 for the same period stock value is 50000.00 different (Increase) but not stock.  When i have checked that PO is Import and usd $ is changed at time of MIRO entry. But entery was happen on 31.03.2012.  what will be the reason? Please guide me.  Regards,  PK.

[Former Member · Accepted solution]

Dear Expert,  When i check the MC.1 report and double click on value detail window pop up. Please tell me about "Val.stock rev. value" this amount is showing different.  regards,  PK.

[former_member182379 · Accepted solution]

Hi,

  Have you done the MIRO posting  after taking the first report,  check is there any price difference as per PO price and in MIRO, when user make the GR as per PO price inventory is updated,  but at the time of MIRO if there is price differecne and if stock is present then that differecne amount hit the material account  or if stock is not present at the time of MIRO that amount is posted to the price difference account.

regards,

zafar

[Former Member · Accepted solution]

Dear Zafer,  you are right. I have found the different amount is store in "Valuated stock receipts value" column.   Please tell me about "Valuated stock receipts value" which is store the amount.  Regards,  PK.

[former_member182379 · Accepted solution]

Hi,

Check the accounting document of GR and compare the amount with MIRO  for the same material and check the difference in both.

regards,

zafar

[Former Member · Accepted solution]

Dear Zafar,  Please provide me T-Code for compare the document against Material.  Regards, PK.

[Former Member · Accepted solution]

"Valuated stock receipts value" is the value of all the stocks received on that particular period and this is not total stock value.. So check the total stock and also check in the layout there are many useful fields are there.

[Former Member · Accepted solution]

Dear S.Kumar,  I have changed the conversion date as 31.03.2012, but value still amount showing as on today not 31.03.2012. But when i have check all key figures,   as "Valuated stock receipts value" amount is same as different amount.    And also i have check the layout but some of columns need to understand of calculation like unplanned consumption, unplanned usage qty, val stck cover value etc.  Thanx for your explanation neatly. Please, what will be caused of different amount?  Regards, PK.

[Former Member]

MC.1 gets information from Logistics Information System (LIS) info structures. Thats the reason for difference in value.

[Former Member]

MC.1 and all LIS reports takes the exchange rate maintained and displays the value. If you want to report to show in current price, in the input screen you have an option "current price" or in the ouput screen you can check the currency conversion rate and the date. you can also modify the same.

[Former Member]

Dear Expert,  Thnx for your Prompt replay,  But i would like to know about change of Stock value. When i run the report from 01.03.2012 to 31.03.2012 (period to analyse date) on 01.04.2012 the value and today value is different. If exchanged rate type is 'M' means it will take current avarage rate.  But i want previous stock value which is on 31.03.2012. How do i will capture Previous value.  Regards,  PK.

[Former Member]

did you try to change the conversion date as 31.03.2012 ? If you do so, you will the get stock value as per 31.03.2012, as system checks stock on that date with that date exchange rate.

[Former Member]

Hi Pravin

There is a difference in Stock vakue, because the conversion rate/value might be changed at time of MIRO. Even thought the entry happened on 31.03.12, the changed MIRO price only will be accounted in system. This price difference will hit a separate G/L account.

-S Kumar