Deficiency List
This report shows for each Item the stock balance, the quantity ordered, the quantity on Purchase Orders, and a proposed purchase quantity. The proposed purchase quantity takes into account the current stock level, the unfulfilled order quantity, the minimum stock level of the Item and the minimum order quantity from the Item's
Default Purchase Item.
For an up to date Deficiency List, it is necessary to keep several registers up to date. The Item must be entered in the Item and Purchase Item registers, and the following registers must contain correct and up to date information:
- The Purchase Order register contains information about previous Purchase Orders.
- The Order register contains information about Sales Orders not yet shipped.
- Each Item must be defined as "Stocked", and minimum stock levels must be specified either in the Item record itself or in the Minimum Stock Levels setting in the Stock module. Use the setting if you want to set minimum stock levels for each Location.
- For each Item, at least one Purchase Item record must be entered, with normal and minimum ordering quantities specified.
- The Goods Receipt register provides information about physical shipments into stock, and influences the stock balance.
- The Delivery register also influences the stock balance.
Like the
Purchasing Suggestion report, this report uses all the above information to present a purchase proposal for
Stocked Items. The Purchasing Suggestion report only shows those Items that can be ordered through the
'Create Purchase Orders' Operations menu function (i.e. those Items that have a corresponding
Default Purchase Item record), whereas this report lists all
Stocked Items.
- Item No.
- Paste Special
Item register
- Range Reporting Alpha
- Use this field to restrict the report to a particular Item or range of Items. Only Stocked Items will be shown in the report.
- Group
- Paste Special
Item Group register, Sales Ledger
- Range Reporting Alpha
- Use this field to restrict the report to Items of a particular Item Group or range of Groups.
- Location
- Paste Special
Locations setting, Stock module
- Use this field to restrict the report to Items, stock levels and Orders in a particular Stock Location.
- The Minimum Stock Levels setting in the Stock module can be used to specify minimum quantities of each Item that can be held in stock in each Location. If no Location is specified for this report, the minimum stock level shown for each Item will be the figure for all Locations. If a Location is specified for this report, the minimum stock level shown for each Item will be the figure for the Location in question. If there are no records in the Minimum Stock Levels setting for a particular Item, the minimum stock level will be taken from the 'Stock' card of the Item record.
- Department
- Paste Special
Departments setting, Assets module
- If the report is to list Items belonging to a particular Department (specified on the 'Stock' card of the Item record), enter that Department here.
- Salesman
- Paste Special
Person register, System module
- If a Person's initials are entered here, only those Items with a Default Purchase Item belonging to that Person will be listed in the report.
- Sales Group
- Paste Special
Sales Groups setting, System module
- If a Sales Group is entered here, only those Items with a Default Purchase Item belonging to that Sales Group will be listed in the report.
- Sorting
- The report can be sorted by Item Number, Item Group or Description.
- Only with Balance
- This option excludes from the report Items for which there is no stock balance. This will usually mean that some Items of which you have a stock deficiency will not be listed.
- Only with Suggestions
- Switch this option on if you only wish to include Items in the report for which a purchase proposal will be made (i.e. those Items of which you have a deficiency).