You use this program to establish the minimum quantity of a stock item that is required to be stocked in a warehouse. It can also be used to update the Minimum quantity field held against the warehouse if lead time is configured for the item.
| Field | Description |
|---|---|
| Start Processing |
Commences processing according to your selections. |
| Change Criteria | Changes the criteria in the Information pane. |
| Prints the information currently displayed in the Report output pane. | |
| Save Form Values | This option is only enabled in Design mode (see Automation Design). Your selections are saved and applied when the program is run in automated mode. |
| Field | Description | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Stock code | |||||||||
| Stock code selection | Indicate the stock code(s) you want to include in the minimum quantity calculation. | ||||||||
| Warehouse | |||||||||
| Warehouse selection | Indicate the warehouse(s) for which you want to include stock codes in the minimum quantity calculation. | ||||||||
| Product class | |||||||||
| Product class selection | Indicate the product class(es) for which you want to include stock codes in the minimum quantity calculation. | ||||||||
| Cycle count | |||||||||
| Cycle count selection | Indicate the cycle count(s) for which you want to include stock codes in the minimum quantity calculation. | ||||||||
| Action where min > max | |||||||||
| Select action |
|
||||||||
| After processing completed | These options are displayed within programs that can be automated. They enable you to indicate the action you want to perform once processing is complete (see Automation Design). |
The results of the processing function you selected are displayed in this pane once processing is complete (unless you enabled the option to close the application from the After processing completed section). You use this section to print or email this information.
The calculation establishes the average quantity of a stock item sold over the last 12 months. It then multiplies this figure by the number of months required for an order of the stock item to be supplied.
The minimum quantity calculation is performed as follows:
((annual usage value / unit cost) / number of months' history) x (lead time / 30)
- The annual usage value is divided by the unit cost to obtain the annual usage quantity (i.e. usage quantity = annual usage value / unit cost).
-
The annual usage quantity is divided by the number of months' history to establish an average monthly usage (i.e. average monthly usage = usage quantity / number of months' history).
![[Note]](images/note.png)
The number of months' history is stored against the warehouse in which the item is stocked. From the time of capturing the item, this number is incremented by 1 after each inventory month end, until it reaches a value of 12. This enables the calculation to cater for items that have been stocked for less than 12 months.
- The lead time held against the stock item is divided by 30 and multiplied by the average monthly usage (i.e. inventory minimum quantity = (lead time / 30) x average monthly usage).
- The calculation is only applicable to stock codes with a usage history of two or more months.
- The calculation is not performed for stock items where the current inventory cost is zero.
- The results produced by this program will be inaccurate if there have been fluctuations in the costing of your stock items over the year.
Inserting Application Help
You would typically follow this procedure to display help for the current program in a customized pane that can be pinned to the program window.
Information includes step-by-step instructions for the various functions available within the program, including a brief overview of what the program does, what setup options are required and how to personalize the program.
-
Open the program for which you want to insert application help into a customized pane.
This functionality is only available for a program that has panes.
-
Right-click any form field.
You can also click the triangle menu icon that appears in the title area of a pane.
-
Select Insert Application Help from the context-sensitive menu.
The application help appears in a pane within your program. You can reposition the pane using the docking stickers or pin it to the program window.
Removing the Application Help pane
If you no longer want to display application help in a pane for your current program, you can simply remove it.
-
Select the Close icon in the right-hand corner of the application help pane.
-
Confirm that you want to delete the pane.