Item Total Quantity does not equal net of Qty In And Qty Out

• 08-21-2008 12:30 AM

  Reem Jacob Joined on 03-24-2008 Posts 6

  Item Total Quantity does not equal net of Qty In And Qty Out Reply Contact Hi I am using GP8. I am looking at the Item Stock Inquiry window. If I do the net of Qty In and Qty out, I get a figure which is different from the Total Stock Value. I can see for the first transaction the "Qty in " is 2. But the Balance column is showing -8. I dont understand how the Balance figure is calculated. But I think the total figure is the sum of the Balance column. Can you help me to find out why the Item Total Quantity does not equal net of Qty in And Qty Out? Regards Reem

• 09-03-2008 10:50 AM

  In reply to

  Ron Draganowski Joined on 10-04-2007 St. Paul, MN Posts 41

  Re: Item Total Quantity does not equal net of Qty In And Qty Out Reply Contact It is possible for inventory values to get out of wack in GP due to any number of anomolies.  What I would recommend you do is run the Inventory Reconcile process, which is located under Tools>>Utilities>>Inventory>>Reconcile.  Choose the option "Include History" when reconciling.  This may fix your issue.   Ron Draganowski Senior Solution Developer Olsen Thielen Technologies, Inc.St Paul, Minnesota rdrag@ottechnologies.com http://www.ottechnologies.com    Find me on LinkedIn: http://www.linkedin.com/in/rondraganowski

  Tags: Microsoft Dynamics GP, Inventory

• 09-04-2008 2:18 AM

  In reply to

  Reem Jacob Joined on 03-24-2008 Posts 6	Re: Item Total Quantity does not equal net of Qty In And Qty Out Reply Contact   Thank you for responding. I had tried the Reconcile Option, but did not fix the issue.  Reem