Open Forum

Expand all | Collapse all

On Hand Inventory Qtys

  • 1.  On Hand Inventory Qtys

    Posted Jan 22, 2019 12:06 PM

    We are having an issue where our Qty on hand varies from the bin quantities and there shows a negative quantity sold. This is because we posted some returns through that apparently had not fulfilled the items fully, causing our quantities to get out of wack. Any suggestions on how we could resolve this would be much appreciated!

    Item Card:

    Item Inquiry:

    Bin Quantities:

    Randy Seed
    Lakeville MN

  • 2.  RE: On Hand Inventory Qtys

    Posted Jan 23, 2019 09:59 AM
    Edited by Beat Bucher Jan 23, 2019 10:06 AM
    Hi @Randy Seed,
    Two things that come to my mind:
    1. This usually happens when an RMA is posted without selecting the proper return Qty Type in the screen to put the returned quantity back into inventory On-Hand.. something that is easily missed most of the time
    2. Run an inventory reconcile (you can limit it just to this item), and if the QTY on hand isn't still correct (which it will probably not), you'll have to create a manual adjustment (either thru a cycle count or an inventory adjustment transaction)​

    Edit: Here is an excerpt of the Sales User Guide  from the help : 
    Return quantity types
    When a customer returns an item, you must enter the returned item into one or more return quantity types. Quantity types are used to track whether an item is ready for resale or whether it is damaged, being serviced, or in use.
    The return quantity types are On Hand, Returned, In Use, In Service, and Damaged. If you enter a return that increases more than one quantity type, separate purchase receipts are created to record the increase for each quantity type. For example, suppose a customer returns five telephones. Three need service before you can resell them and the other two are damaged and can’t be repaired. In this case, you’d return three to the In Service quantity type and two to Damaged. Two purchase receipts are created to track the information. For more information about purchase receipts, see the Inventory Control documentation.
    If you return an item to a return quantity type other than On Hand, you can’t resell the item. You must transfer the item to On Hand before it can be sold again. If the item was returned to the Damaged quantity type and you want to return the item to the vendor, you must transfer the item to On Hand and then enter a decrease adjustment for the item.

    Beat Bucher
    Business Analyst, Dynamics GP SME
    Montreal QC/Canada
    Montreal QC GPUG Chapter Leader
    MBS MVP (2015-2018)
    All-Star 2013

If you've found this thread useful, dive deeper into User Group community content by role