Inventory Reorder Based on Future Demand

We're looking at our inventory practices with regard to our Surgery department. Right now, it is a non-stock location that is being replenished using Par and Cycle counting. However, in talking through this, we've found that the coordinator adjusts the count entered based on if she knows there will be additional needs of a product due to upcoming procedures. In our work, we're talking about moving this location to being an inventory location with most of these items in a perpetual inventory. One question that came up is whether we can send a future demand to Lawson so that it does the adjustment up in inventory automatically.

I.e. we have an item set as a fixed order point of 5 since we typically only use a few per day and we get them from the vendor with quick turnaround. However, based on our schedule of surgeries, we know we will need 8 next Tuesday.

Does anyone know of a way to put a future demand into Lawson for this so that it orders higher? Or do you just do a manual PO based on what you know is going to be used? Just looking to see how others do it to see find the most efficient way of doing it.

Find more posts tagged with

Infor Lawson Supply Chain Group - Discussion

Comments

jon-athey

When you run IC140 (Vendor Reorder Advice) you can set the Create Worksheet flag to Y. This will send the items that meet the criteria for replenishment to IC66 (Replenishment PO Worksheet). There you can update reorder quantities based on future needs and release the lines to be picked up by PO100. One problem though is if the SOH (minus demand) is not below the ROP it won't pull into IC66. So if your item with a fixed ROP of 5 has 5 on hand and no demand you'll have to add the item manually to a PO to bring your SOH to 8.

unknown

We use IC142 as it creates a req that can be edited. So you can manually up the quantities as needed.

You could also set some items to Max - to fill the bin no matter what instead of a fixed order.

dechevar

We just moved our surgery to Par from perpetual due to the constant inconsistencies in inventory levels. My hope is to address the future forecasting issue with Point of Use implementation in 2019/2020. My understanding is that it would get a feed from your scheduling system and help to order based on forecasting. I would love to hear if anyone is using it.

For now, we follow the same practice of ordering up manually based on the schedule.

Stace Webley

There is another method that you could do which may not be what you are looking for since it seems you want to address one item at a time. On IC140 there is a field on the Main tab that allows you to pull items for replenishment that haven't hit their ROP yet, but are within X% of it (Reorder Cutoff Percent). Then on the More tab you can order above your normal replenish amount by adding excess (Reorder Excess Percent). Just remember that when you do that be prepared to get more of every item.

Copyright © 2025 Infor. All rights reserved.