Editing Existing Bulk Quantities

The Edit Bulk Quantities option is used only to correct entry errors.  In the case of a return to vendor, 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.

      An individual item number is assigned to each bulk item as it is sold.  For example, at point of sale, 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.