Physical inventory stock

[Former Member]

Hi Friends,

When we have taken physical inventory book qty given by the system on 17.04.2013 was 95162.86 kg. This qty is before doing inventory posting.

But when we check MB5B report balance before taking physical inventory was 137162.862 kg ( I get arrived on this qty by taking opening balance & doing + & - for the material qty.)

Following is the MB5B report.

Below is the calculation I have done in excel.  I get arrived on this qty by taking opening balance & doing + & - for the material qty.

Thanks,

Kiran

[Former Member · Accepted solution]

Hi Kiran,

what is the actual issue as I see the stock figures before physical inventory doc and in MB5B did tally.

Amit.

[Former Member · Accepted solution]

Hi

Download complete inventory details from report MB51.

Export the same in excel, and do the manual calculation with the help of Excel.

Example:

101- Purchase (10)

601- Sales (2)

10-2 =8 Bal

Regards

Sandesh Sawant

[Former Member · Accepted solution]

Hi Amit,

Physical inventory is having book qty as 95162.86 which is correct as per MB5B report.

But if you take opening stock of Mb5B report & do + - then at the time of taking physical inventory book qty should be 137162.862 kg ( which I have calculated in excelsheet & you will see it in green in the screenshot of excelsheet provided by me.

Hi Jurgen do you have any idea on this issue.

Thanks,

Kiran

[Former Member · Accepted solution]

Hi Friends,

Is MB5B report is having some problem while referring stock as on date.

Thanks,

Kiran

[Former Member · Accepted solution]

Hi Jurgen,

Can you please help in finding out why there is difference between opening stock & valuated stock before posting. (marked in black)

Thanks,

Kiran

[BijayKumarBarik · Accepted solution]

Hi,

Stock shows for material 77592 with 702 movemnet type ONLY is 19,562.862KG with valuated stock  95,162.862 ,but the stock shows 137,162.862KG is Total Plant stock for material 77592

Regards,

Biju K

[Former Member · Accepted solution]

Hi Bijay,

Can you please explain in detail what do you want to say.

As per my understanding Valuated stock over here is the stock before doing that movement(found from F1 help) So opening stock of 17.04.2013 whould match with first line of the valuated stock.

Thanks,

Kiran

[Former Member · Accepted solution]

HI Kiran,

The physical inventory document has book qty 95162.86 which is correct and matching with MB5B. In excel As I see the physical inventory document was created on 17.04.2013. In excel sheet I can see there are two movements with qty 21000 which were entered on 26.04.2013 but having posting date as 16.04.2013. So at time of physical inventory document posting this movement were not posted and hence in your calculation in  excel sheet you should not consider this two documents. Hence if you remove this two movement qty from
137162.862 i.e. 137162.862 - 42000 = 95162.86 which is captured in physical inventory document.

Please let me know if I have not understood your query correctly.

Amit.

[Former Member · Accepted solution]

Thanks Amit.

[BijayKumarBarik]

Hi,

Cross check material stock report again with t.code: S_P00_07000139

Regards,

Biju K

[Former Member]

Hi Biju,

current stock in mb52 is correct with closing stock of MB5B report.

Thanks,

Kiran