Store Items - Expired Stock

Store Items - Expired Stock

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 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 stock.
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 Stocks.



Periodically you will need to review stocks with expired items and if required, remove the expired items from inventory:

    • Related Articles

    • Inventory Items

      This is where you create and manage all inventory items that are not directly related to an individual job. Inventory > Items. From here you have several options you can use to search on the items to require to view:     From the main screen, you can ...
    • 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 ...
    • IQstore Workflow Job to Store Item to Invoice

      Workflow – Job to Store Item to Invoice 1. At any point during the production process, you can transfer some/all of the job into stock.   To do this, use the action on the All Jobs or Production board called “Receipt into stock”: 2. From the modal, ...
    • Stock - Reserved Stock

      Reserved Stock (Materials / Papers) using printIQ v42 and above? Please refer to this link. https://desk.zoho.com/portal/printiq/en/kb/articles/allow-split-picks-to-reduce-reservations Stock Reservations can be enabled individually for Paper, Plates, ...
    • Stock Bulk Upload

      We have created a PDF document that goes through the stock CSV import document in detail. It is the most up-to-date document. It is attached to this page. See this document for the most recent information on the CSV file, and a description of the ...