Inventory Valuation report 1001

Dear Sir

Inventory valuation report 1001 when we run we do get quantity ZERO while the value is positive and Cost posted to GL balance is there. How to ensure that when the quantity is zero logically the balance should also be zero, How to achieve this.

Sometimes the balance is negative and the value is positive, in the first instance how the system allow messing up the value and the quantities. What steps we should take to stop this.

We are running every day the adjust cost batch and get the same posted to GL also. We are using average cost method.

Awaiting your reply.

Thanks

Kalyan