Would be beneficial to have a 'next available' date for out of stock items... this can be driven from the required by date on Purchase Orders.
Customers can then decide whether to back order or opt for an alternative if not available soon enough...
I agree.. we've just converted to Dear from Unleashed, which has this feature.. and we greatly miss it :)
Like this below. You hover over the calendar icon next to the on purchase qty and it tells you the ETA of the next shipment
This is a bit tricky because you need some rules. If there is 0 QOH, a PO for 50 arriving in one week and current authorised orders of 50, then all the orders would have an expected fill date of next week. But if an additional order of ten is entered, do we assume that the existing orders get priority? To avoid providing incorrect information, you need to agree on how open orders are going to be filled.
Unleashed doesn't actually tell you the next available date, it just shows the next receipt date. What happens to that stock is unknown to Unleashed.
And what if you only fill orders when they are completely shippable: one of the existing orders may not be shipped next week because it is awaiting on stock from another order line.
I am writing a query for a client that will provide fulfilment dates for customer orders. In this case we assume orders are shipped in full, and that the priority is FIFO based on order date. They will need to make sure that bulk picking is done in this order.
maybe in the interim a free text area on the stock levels so that one can inform customers of when next availability is.... at the moment any customer seeing stock levels of 0 may be reluctant to place an order since they would not know why the stock might be next available.....
I actually think both SAP B1 (I know that old legacy solution has the best version of this). It has the concept of a requested shipment date per line item. It then has a proposed delivery schedule where it locks that in at the time you place the order. It will advise if the date is not achievable and will record a proposed delivery and indicate the days delay. If you aren't happy with that you can juggle priority against other orders and see the delay impact.
You don't need anything too fancy. The main shift for all more advanced inventory systems is to manage requested delivery dates at a line item level and split out the requested date from what is achievable - essentially reserving available supply by known supply chain events.
I agree for the vast majority of people, just getting an indication of the next arriving purchase order will take care of 80%.