Navigation Panel > Administration > Run Sets > Purchase Run Sets
Click on the button New
Give the run set a Name like: Average weekly sales incl sales back orders
Make sure the Purchase Run Source is set to Product movements
Set the Purchase Run Type to be Average weekly sales including backorders
Include Indent Products - Indent Products are only purchased from suppliers if they are on sales back orders. They are not considered as part of the average weekly sales part of this.
Only Include If Primary Supplier - this means the system will want to order products where this supplier is the primary product supplier. If the supplier is one of many suppliers on the product and is not the primary product supplier, it will not consider that product.
Include Obsolete Products - is used where some of the products you sell or put on back order may be set to Obsolete by your head office but you may wish to choose to sell them anyway
Tab: Supplier Filter
Where there is an And point to it and you’ll see a + x show
Click on the +
Select the option Add Condition
Where it says Display Name - left click on it and select either field of Card ID or Name
If you chose Card ID
Where it says Begins with - left click on it and select = Equals
Where it says Enter a value - left click on it and key in the supplier’s Card ID
For example:
Expand | ||
---|---|---|
| ||
If you chose Name
Where it says Begins with - left click on it and select Contains
Where it says Enter a value - left click on it and key in the supplier’s card Name or part of it that makes it unique from other supplier card names
For example:
Expand | ||
---|---|---|
| ||
Tab: Product Filter
Expand | ||
---|---|---|
| ||
You only need to place a filter in here if you wish to narrow down your purchase run by category or by product
Tab: Site Filter
Expand | ||
---|---|---|
| ||
Only needs a filter if you have more than one site and only want to run a purchase run based on solely one site only
Tab: Settings
Expand | ||
---|---|---|
| ||
Min Weekly Sales Count - the number of times averaged that the product sold per week
Min Weekly Sales Qty - the actual qty of the product that was sold on average
Weeks Of Floor Stock - how many weeks of floor stock do you want to order for?
Avg Weekly Sales Variance Threshold - the number of times of the above averaged out that you don't want the system to order for (usual threshold setting is 2)
Warehouse Site: which site are you ordering for
Recurring (tick box) - tick if this is a recurring order run set
Archived (tick box) - tick this if you no longer wish to use this run set and stop it from being used in the future.