Suggested Replenishment
Suggested replenishment is the computer assisted ordering tool that allows you to create purchase orders for replenishing inventory sold. The system looks at your sales and quantity on hand to help you figure out what to order. S2K lists only items you buy from the vendor selected, and also looks at case pack size so that you order the min qty as you cannot order only 6 qty of a product that come in 12 packs for example. S2K also gives you the option of using your qty on hand so you do not over stock your store. You can choose to ignore that stock as well. You can edit as needed then produce the PO based on your edits.
NOTE: the SKUs displayed are based on sellable unit NOT case SKU as it is based on sales.
A nice feature is that S2K allows you to input case pack for items missing that field and shows you previous purchase quantities to help figure out those missing numbers.
This tool is accessible from the Daily Books menu:
To generate the suggested order follow these basic steps:
1- Choose station
2- Choose department (optional otherwise all for vendor will list)
3- Choose vendor
4- Choose date range that you wish to analyze sales for (this will default to the last 30 days so only edit if you want to go back farther)
5- Enter the order date (this is the PO date that will be generated)
6- Click refresh to see your results
Some other settings:
1- Refresh – This updates the suggested replenishment quanitites based on changes made to the Product Detail of an item.
2- When you make changes to Order Qty, Case Pack or Order Cost, you need to Click SAVE
3- You can print, email or export to Excel
4- Hide Never Sold – this setting is to show items never sold from this vendor but purchased so you can manually add to the PO as needed
5- Use Qty On Hand for Calc – if you click to unselect this option, the calculation will not use your current on hand to determine order qty. NOTE: if you are in negative inventory the system ignores the on hand #
6- The system by default looks at the last 60 days for purchases. If you have purchased from this vendor greater than 60 days ago, then increase this # as needed.
7- PO#- allows you to enter a PO # that will be used when generating the PO in S2K.
8- This is the last step of the whole process, click generate PO when satisfied with the order.
Dept, Item#, Description – Basic info on the items
Qty On Hand – this is what you show in inventory as of the order date
Sales Since Purchase – this tells you how many you have sold since the last time you purchased the item for this vendor
Qty – This is the qty needed to replenish sales since purchase minus any on hand (note: if you are in negative inventory that on hand # is ignored)
Order Qty – This is what the system computed for the order, GREEN FIELDS CAN BE EDITED AS NEEDED.
Case Pack – This is the min # of units that have to be ordered as they come in a case.
There are 2 ways to edit the case pack:
1- Just edit on the screen for this PO only: just click in the field and edit, S2K will auto adjust the order qty accordingly, this change will only affect this replenishment:
2- If you want to change or setup the case pack for this and future orders, right click on the item and choose the “Item Details” option:
This will take you to the Product Editing screen where you can enter and save the case pack…
a. For Local (flex) items, you can edit on the main screen and click save:
b. For HQ (core) items, you can edit on the Local Attributes tab and save:
You will need to refresh the screen on the suggested replenishment page in order to see the updated case pack if you make changes using this method. The order qty will automatically update to reflect the new suggested order amount based on the new case pack size.
NOTE: The setting for case pack in local attributes will trump the core setting for case pack if any exists from HQ. GREEN FIELDS CAN BE EDITED AND SAVED from the suggested replenishment screen, however changes to case pack will not overwrite the default setting. To change the default case pack you must go into item details by right clicking on the item. If there is NO case pack setting in either place, then the case pack will be 0 and just use the # of units sold to calculate amount to purchase.
Order Cost – Cost per unit. Based on last cost. GREEN FIELDS CAN BE EDITED AND SAVED.
Extended – Total cost. #units ordered times per unit cost.
Last Purchase # - the qty that was ordered on that last invoice. This is a great guide in figuring out case pack if you are unsure.
Last Vendor – tells you which vendor you bought this item from last time
Last Purchased On – the date of last purchase for the item
Last Cost – last cost from last invoice.
Make any changes as needed, save and refresh when done. If you are ready to create a PO, then last step is to click the CREATE PO button.
The purchase order can be found under Non-Fuel Invoices…Purchase Orders.
You can also email the PO to your vendor by clicking EMAIL at the top of your screen. (Setup required by S2K tech).
