Editing Existing Bulk Quantities


The Edit Bulk Quantities option is used only to correct entry errors.  In the case of a return to vendor (RTV), scrapped item, or missing item, it is best to use options in the Supervisor Menu. Otherwise, use of this option could result in bookkeeping errors.

To make changes to bulk quantities after they have been committed to inventory, i.e., to correct an error:

  1. Select Inventory > Items > Find.
  2. Enter the vendor ID and vendor style number.
  3. Select the Type & Status tab.
  4. Choose the appropriate bulk Pricing Method (or all bulk pricing methods).
  5. Select OK.
  6. Select and edit the bulk item record.
  7. Select the Quantities tab.


    This window shows all quantities received for this bulk item.  Fields and options in the Quantities tab include:

    Unit of Measure

    Specify how measure being stored (UOM, IUOM only).

    Add

    Use this button to create a new quantity row.

    Adjust

    Select an existing quantity row and use this button to edit its details.  You can also double-click on the line item to edit. 

    Remove

    Select an existing quantity row and use this button to delete it.

  8. Select the row to edit and select adjust or double-click it.  The Item Quantities window will appear.


    Fields and options in the Item Quantities window include:
     

    Invoice

    The invoice number of the shipment being altered.

    Store #

    The store number in which the quantity resides.

    Memo

    Notes concerning the reason for the edit.

    Received On

    The date the items were received.

    # Pieces Received

    The number of pieces received on the specified invoice. 

    # Pieces In Stock

    The number of pieces from that order that are still in stock.

    Cost Each

    The cost of each piece.

    Price Each

    The price of each piece.

    Total Measure Received

    The amount, for bulk sold in UOM, received.

    Total Measure In Stock

    The amount, for bulk sold in UOM, in stock after the order came.

    Cost Per Measure

    The cost, for bulk sold in units of measure, for each unit of measure.

    Price Per Measure

    The price, for bulk sold in units of measure, for each unit of measure.

    Total Cost

    The total cost for the amount entered from this invoice.

    Total Price

    The total price for the amount entered from this invoice.

    Markup

    The percentage markup.

    See Cost

    Returns the cost history of the items.

  9. Edit the fields as needed and select OK/Save & Close.

Things to Note Editing Bulk Quantities

  • An individual item number is assigned to each bulk item as it is sold.  For example, at point of sale (POS), if you sell item 900-00001.  The receipt will show 900-1000001, which serializes this item, specific to this customer, so the item can be returned appropriately.  On return, the individual item is deleted and the original bulk SKU is increased by the quantity of the return.
  • When conducting a physical inventory of bulk items, the physical quantity counted is automatically adjusted against the previous in-stock count
  • Use Inventory > Items > Levels to manage bulk inventory by vendor.

 

Updated on Fri, 10 Sep 2021 by Angela Chiaravalle

Glad we could be helpful. Thanks for the feedback.

Sorry we couldn't be helpful. Your feedback will help us improve this article.

How helpful was this page?