Managing Expired IQStore Items
Designed primarily for IQStore items, Inventory Items can have an expiry date set when the goods are received.
In order to apply it, you need to set an expiry date against the Purchase Order Receipt or in Inwards Goods.
Inward Goods:
You cannot set an expiry date when making Quantity on Hand stock level ‘adjustments’. You must use the Inwards Goods or Purchase Order Receipt.
Purchase Order
Use the ‘Lot’ option to access the ‘Expiry’ date
On the inventory board, items containing expired quantities are flagged:
*Note: When ordering, the expired quantity will be excluded from the ‘in stock’ qty:
When picking a sales order, printIQ works on a FIFO pick order – First In, First Out.
With Sales Orders, you can manually change the status from ‘Confirmed’ to ‘Packed’.
This will result in printIQ auto ‘picking’ all items on the sales order and updating the order on the Dispatch Board ready to dispatch.
However, if any of the items on the sales order include expired items, printIQ will not pick the order and will prompt you with a warning:
Click the ‘Pick’ button to draw the required quantity:
As expired items are present, you will see the following option:
Selecting to ‘Use Expired Items’ will pick any expired quantity to fulfil the order.
If you choose to ‘Skip Expired items’ you will be prompted about placing the remaining quantity on back order.
Answer “Yes’ to split out unpicked items into a Back Order:
Set the Current Order Status to ‘Packed’ on this modal:
This will set the order status to ‘On Backorder’ and leave the outstanding qty still to be picked:
Alternatively, if you didn’t answer ‘Yes’ to the prompt on the last item you can create the backorder by clicking the ‘Split Remaining’ button.
Inventory Management of Expired Stocks
The inventory item includes a ‘Disposition Code’ that describes what is to happen to any expired item.
This is purely an informative field and does not change the behaviour of IQ in managing the inventory item.
On the Inventory Board, there is an additional filter for Expired Items.
Periodically you will need to look for expired inventory items and if required, remove the expired items from inventory:
Related Articles
Managing Reserved IQStore Items
Facts About Reserved IQStore Items IQStore items are reserved when a Sales Order is created. After the IQStore has been reserved on an order, the next time a user creates a quote for that IQStore item, the user will see the number of items "in stock" ...Sales Order Picking and Stock Replenishment
Please read in conjunction with KB Article - Sales Orders Backorder Process When a Sales Order is being picked, and there is insufficient quantity of an item supplied by a 3rd party, you can generate a replacement Inventory Purchase Order directly ...Bulk Upload IQstore Items
IQ Store Items can be created and modified in bulk using the sales item import / export options on the IQStore Admin screen toolbar. Download the CSV Selecting Import from the drop-down menu will open a file selector to select the CSV for upload. The ...Sales Order Backorder Process
All sales items contain an ‘Allow Backorder’ flag: When Allow Backorder is NOT selected, only the quantity on hand can be ordered. With Allow Backorder enabled, any quantity of the sales item can be ordered. Placing an order, the quantities in stock ...IQStore Example Items: Test Exercise
This exercise will step through the upload of 3 test IQstore Items into your system. These items and their Product Category can later be de-activated or re-defined as actual items. First step is to create a customer group, the customer groups control ...