topic Physical Inventory report in Application Development and Automation Discussions

Physical Inventory report

Former Member — Mon, 18 Jul 2005 20:57:11 GMT

I have done a physical inventory report using table LINV. Now, after clearing the documents , I am trying to compare the counted totals through my report and adjusted stock(using report MB52 executed just after the adjustments). But there are many differences b/w the reports.

Are there any other tables for counting totals ?

What can be the possible reason for the discrepencies ?

Re: Physical Inventory report

Former Member — Tue, 19 Jul 2005 04:32:46 GMT

I had faced similar problems, it is mainly due to price being maintained differently for different material quantities. Since the price varies for material on a day to day basis u need to check the latest material price and do the effective price calculation. You can debug MB5T to find out how it is getting the latest price.

Hope this helps.

Sharath.

Re: Physical Inventory report

Former Member — Tue, 19 Jul 2005 12:34:57 GMT

Sharath,

I am right now just looking at the quantities, not the values.

Re: Physical Inventory report

Former Member — Tue, 19 Jul 2005 13:10:14 GMT

if you are trying to display all the quantities using 'EA' for field MEINS then u may have to convert the values from other MEINS to 'EA'.

I think its better to check whether there is any conversion required inorder to determine the quantity in terms of 'EA'.

Hope this helps.

Sharath.

Re: Physical Inventory report

Former Member — Tue, 19 Jul 2005 15:46:42 GMT

I am looking at the differences material by material. They are all in EA. No conversion is required.

Actually I know there can be many reasons logically.May be few of the bins have not been counted. I just wanted to confirm if LINV is the right table to look at.

Thanks,

Re: Physical Inventory report

Former Member — Fri, 22 Jul 2005 16:02:39 GMT

Some bins were not counted.

There is no error in my report.

Thanks for your help