How do I use advanced fill with the weeks of supply?
Follow these steps
Weeks of Supply analyzes your available inventory along with each product's sales history and determines how much you will need to meet the entered weeks of supply (calculated using the weekly average for the specified number of weeks) if your sales were to remain consistent.
- Select Purchasing > Purchase Orders.
- Select Actions > New PO.
- Enter the Supplier, Date, Date Expected, Supplier Reference Number, and any Notes.
- Select Submit.
- Select Actions > Advanced Fill.
- Choose Fill Type: Weeks of Supply.
- Enter the Weeks of Supply or how many weeks of supply you want on hand.
- Enter the Average Based on Weeks or number of weeks you want to use to base the calculation on.
- The number of weeks you base the calculation on is circumstantial. For example, during this time of Coronavirus crisis, a store might have noticed an unusual uptick in sales as shoppers stocked up on suppliers, so it might be better to change the average 4 weeks supply to 8 or 12 weeks to get a more realistic average of weeks of supply.
- Decide whether to Ignore Wholesale or purchases from the wholesale customer when calculating weeks of supply.
- Decide whether to Count Open Supplier Invoices or (unposted) supplier invoices when calculating the available inventory.
- Decide whether to Count Unopen Purchase Orders or open purchase orders when calculating the available inventory.
- You can choose a specific category to fill by selecting - Only fill the PO with products from this category.
- You can choose a specific subcategory to fill by selecting - Only fill the PO with products from this Subcategory.
- Select Submit to generate the PO.
You can select Do Not Reorder on any product you do not want to reorder. This can be useful if you are reordering by Weeks of Supply and you have a specific product you are trying to deplete and you just want to make sure when you are generating POs that the product does not get ordered by mistake. Remember to download your PO Artifact File if you are unsure about the calculations! You can even do this before you submit the PO to your vendor. For more information, see the article What is the PO artifact file.