Estimating quantities for Stock Procurement can be completed by using a nominated Minimum Quantity required, a Calculated Quantity to meet the requirements of a stated number of days, or a comparison of the two methods, with the higher unit calculation being used to create the resulting purchase order.
If you want to combine both methods for nominated stock codes, simply enter a minimum required quantity and the number of days supply required.
Days Supply Method
1.On the ribbon go to Stock > View/Edit Stock.
2.Either enter the stock code that you want to view or edit, or select the ellipsis [...] to open the Stock Select screen and locate the stock code from there.
3.When the correct stock code is on screen, click Edit, then click the Locations tab at the top left of the screen.
4.Move to the Min Qty per Location method field and select Calculated.
5.In the field called Daily Avg Sold per day based on, choose either current month last year, or last (days), and nominate how many days.
6.If applicable, enter a number to the Add extra % Qty field. This will have the effect of a loading.
7.In the Vendors tab at the bottom of the screen, there is a column/field called Lead Time in Days, which is used to tell Jim2 how long it takes for delivery of this stock from the nominated vendor. Accurate lead times are particularly important if using the Days Supply Stock Procurement method.
You can also use a Stock Procurement to update a list of stock in the grid. Select all stock within the grid, right click and select Change Procurement Details.
Here, you can enter your preferences:
Further information: