Stock reconciliation

[Former Member]

Hi friends I am having problem with stock reconciliation.

A customized report has been run every day to close the previous day inventory. Now There is a discrepancy when the report is run at 12.00 pm and 2.50 pm. I checked with MB5Band MB51 & there was no movement taken place between that stated time. May I know other way to find out the reason of variation when the same report run at two time for the same day.

Helpful answer will be fully rewarded.

Friendly

manickss

[Former Member]

Check production order confirmation which generally gets confirmed after 12.00 for previous shift. may be bacause of that difference in stock values.

anya

[Former Member]

hi,

i think u checked MB51 by posting date, can u check with entry date?

at the same time may i know what is the diff. u find is it qty or amount of material.

also check the subsequent debit/credit on material by FI.

[Former Member]

Hi Manipal,

I have checked by both entry date as well as posting date. the difference is in the qty in book stock whivh in turn reflect the gain/ loss amount also.

every day we have to run the report twice. first by inventory admin and second by the manager. when they run at 12.00 clock the book value is different from original inventory document( MI03 previous day inventory document). when we run at 2.50 now the value is same as the original inventory document book value.

as diffence has happened at 12.00 clock we r not able to find out the reason

[Former Member]

MB5b report contains all the stocks like quality,vendor end, transit, etc

It is better not to compare these two reports..