Fincon Accounting can calculate what stock you need to order based on specific settings you have set. You access this information with the Suggested Re-order report.
It is either based on your minimum and maximum stock levels, average sales, or on lead times, depending on how you set it up which will be discussed later in this guide.
The following needs to be in place for suggested re-ordering to work:
- Enable an inventory item's Re-Order flag.
- Set the Required Stock Levels company parameter that determines whether the calculations are based on minimum and maximum stock levels or lead times. If you want to work with average sales, you will set the parameter the same as with minimum and maximum stock levels, and this will be all that needs to be set.
- If you choose to work with lead times you need to enable the Update Stock Item Lead Times company parameter.
- If you choose to work with minimum and maximum stock levels you need to enter the quantities of these levels.
If you choose to use the average sales for suggested re-ordering, you are able to include the minimum and maximum stock levels in the calculations as well. The average sales option uses weighted calculations between the sales of the last 6 periods, the following factors are taken into account:
((Current-1*3) + (Current-2*2) + (Current-3*2) + (Current-4*1) + (Current-5*1) + (Current-6*1)) / 10.
Enabling the Re-Order flag
Watch this video to see how to enable an inventory item's re-order flag or follow the steps below it.
Navigate to the correct window
- Navigate to Inventory / Stock Maintenance.
Call up the appropriate item
- Enter (or select) the appropriate item number in the Item Number text box.
Enable the Re-Order flag
- Click on the Re-Order tab.
- Enter Y in the Re-Order text box.
Save the changes
- Click the Accept button.
Set the Required Stock Levels company parameter
Watch this video to see how to set the Required Stock Levels company parameter or follow the steps below it.
- Navigate to System / Company Parameters.
- Click on the Global Settings tab.
- Click on the Stock tab.
- Enter M or W in the Required Stock Levels text box.
- Click the Accept button,
- Check that the following message box appears: The company parameters have been updated successfully.
Enable the Update Stock Item Lead Times company parameter
Watch this video to see how to enable the Update Stock Item Lead Times company parameter or follow the steps below it.
- Navigate to System / Company Parameters.
- Click on the Global Settings tab.
- Click on the Stock tab.
- Enter Y in the Update Stock Item Lead Times text box.
- Click the Accept button,
- Check that the following message box appears: The company parameters have been updated successfully.
Enter the minimum and maximum stock level quantities
Watch this video to see how to enter the minimum and maximum stock level quantities or follow the steps below it.
This part of the guide assumes that you have set the Required Stock Levels company parameter to work with minimum and maximum stock levels and that you have already created the inventory item.
Navigate to the correct window
- Navigate to Inventory / Stock Maintenance.
Call up the appropriate item
- Enter (or select) the appropriate item number in the Item Number text box.
Set the minimum and maximum stock levels
- Click on the Re-Order tab.
- Enter the minimum and maximum stock quantities for the appropriate stock locations in the MIN QTY and MAX QTY text boxes.
Save the changes
- Click the Accept button.
Once all of this has been set up you can use the Suggested Re-order report to be able to place your orders.