i-Clarity Purchase Order Processing consists of 5 stages:

1. Creating an initial purchase order
2. Sending it to the supplier
3. Recording the goods and services that have been received
4. Reconciling the goods received with the supplier invoice
5. Exporting the confirmed invoice to an accounts package, e.g. Xero, for analysis and payment.

Purchase Orders are created in 5 different ways:

1. When you create a spectacle order by confirming a dispense
2. When you create an order from the CL Management form
3. From the Stock Form – e.g. for frame stock
4. From the Stock Form – automated ‘Impress’ ordering
5. From the Stock form – using automated reorder quantities

This article looks at method 5, creating a purchase order when stock quantities fall below a defined level

Automated Stock Re-Ordering (Solutions etc)

This is a process for automatically creating a purchase order for products that have dropped below a specified re-order level. This can be particularly useful for products such as CL solutions, which have a limited shelf life but you need to hold sufficient stock to be able to supply your patients.

To set up automated stock reordering, you will need to decide

• What the minimum stock level you want to trigger the reorder, and
• What quantity you want to re-order.

The optimum reorder quantities will depend on several factors, such as

• What rate the products are being sold at
• How long it takes to receive orders from the supplier
• How much carriage costs are, i.e. is it better to wait to send one large order with possibly larger quantities or send multiple smaller orders
• What quantity discounts are available for bulk orders
• How often you want to run the process, e.g. every week or every month. For example, if you want to set aside a single day per month to do all the re-ordering it would be sensible to have higher Min Stock levels and higher re-order quantities

For the first figure, you can review the sales for each product, you can do this in several ways:

• Review the sales for an individual product from the stock form
• Use the ‘Full Sales Report’ from the POS report menu and selecting a suitable time period, e.g. sales over the previous 6 months
• Use the Detailed Stock Sold report from the Stock report menu, again for a suitable period of time, e.g. the last 6 months. (See Appendix 1 to see how to summarise this report in Excel).

All these factors will change over time so this is one area of the system that you should keep under constant review.

Having decided what minimum stock level and reorder quantities you want, then you enter those against each product on the Product tab of Maintenance.

Select the Product then click the ‘Set Re-ordering Levels’ button on the top right corner of the form. You will then be presented with the following dialog:

This enables you to set the Min Stock Level and Re-order Qty for the selected product for each branch.

Note that you can also remove products from this list, by highlighting them and pressing Delete.

Purchase orders are created for products below reorder level using the Replenish Stock button on the Stock form:

This looks at every product that has a Min Stock Level recorded against it and, where it finds product(s) that have dropped below, creates a Purchase Order to the relevant supplier for those products. The suppliers are listed in a dialog box like this:

The purchase orders themselves can be reviewed before printing, by selecting View Purchase Orders then selecting Order Type ‘Replenish to Send’ and clicking Find Purchase Orders. Just like other purchase orders, you can add additional products, delete products, and amend quantities before printing and sending the purchase order to your supplier.

Note 1: You cannot create a Replenish type order for a supplier if there is already a Replenish order for that supplier waiting to be sent. If this is the case, then you will see a message on screen like this:

You can either retrieve the purchase order(s) and print them, or, (possibly better), delete the outstanding purchase order – RE/ST78 in the example above – and then run the Replenish process again, as this will include all the products that were waiting to be ordered in the previous PO too.

Note 2: To avoid overstocking, the Replenish Stock process considers existing purchase orders that have been created for the supplier but have not yet been received.

Details of products that are set up for re-ordering can be listed from two stock reports:

Products Below Min Stock Level - This shows all those products which are due to be reordered in the next Replenish order.

Stock Re-Order levels – This lists all products that are set up with Minimum stock levels and Re-Order quantities: