Skip to Content
0
Former Member
Dec 02, 2009 at 01:42 PM

MI20 Physical Inventory List

1037 Views

Dear Friends,

After physical invnetory count, when i generate Physical invneotory list in MI20, how to get the value of Physical Inventory difference value ? Presently it is showing all the total value as positive. Ex If the count qty is more then Book qty, it will be positive and Count qty is less then the Book qty it will be negative. BUt in MI20 , the system shows all the value as Positive.

Present output from Mi20

Material Book Qty qty counted Difference Difference amount

A 10 5 -5 15

B 0 5 5 50

Total 65

Required Output

Material Book Qty qty counted Difference Difference amount

A 10 5 -5 -15

B 0 5 5 50

Total 35

Hope the example is clear. Please provide the method to get required output

Rgds

Madhavan

Edited by: Madhavan SR on Dec 2, 2009 2:43 PM