Inventory analysis
Description
With this module, inventories are analysed in order to be able to draw conclusions about the quality of inventory accounting from completed inventories in the past, on the one hand, and to be able to check first of all whether the scope of the counting of inventories can be reduced by means of inventory sampling procedures, on the other. If a warehouse is suitable for inventory sampling, the samples can be drawn and checked from this module.
Functionality
Inventory analysis
In this window, you can compile inventory items of one or more physical inventory documents into a common list for the purpose of an analysis or for carrying out inventory sampling.
The reason for wanting to combine different inventories - i.e. inventory documents - is that instead of creating only one inventory/one inventory document with all storage bins, it can also make sense to create several inventory documents subdivided according to different storage bin areas. In the latter case, the inventory of another storage bin area that has already been counted can be recorded and posted during the inventory in one storage bin area and this storage bin area can be released again.
| Menu item | Description |
|---|---|
| Edit | - |
| : Inventory statistics | Inventory items of different inventories are listed in a common, comprehensive inventory list for further analysis. If errors occur, a separate note is given. The faulty inventory items are displayed in the list of faulty items |
| : Frequency and value distribution | The frequency and value distribution can be determined for the inventory items compiled in this way |
| : Inventory sampling | Inventory sampling procedures can be accessed here |
| : : : Inventory sampling history | A new stratification is created and displayedfor the inventory items compiled in this way according to the options set for a stratified inventory sampling |
| : : Sequential Test | A new sample is created and displayedfor the compiled inventory items according to the set options for a sequential test |
| Options | Opens the options window |
| Symbol | Description |
|---|---|
 | Reset list |
 | Any saved lists of inventory items can be called up and displayed |
 | The currently displayed list of inventory items is saved |
| Any saved lists of inventory items can be deleted |
 | Display document history |
 | Display part of the selected inventory item |
 | Display logistics account of the selected inventory item |
 | Display order items of the selected physical inventory item |
 | Display stock level of the selected inventory item |
 | Display stock movements of the selected inventory item |
 | Display disposition movements of the selected inventory item |
 | The module for outputting the inventory analysis in the form of reports or to the clipboard is called up. Scatter diagrams are available as standard reports in relation to a quantity or value deviation between target and actual quantity or value |
| button | Description |
|---|---|
| Select inventories | Call up the selection window to display further inventories in the complete list |
| Field | Description |
|---|---|
 | Calculates and displays the total value of the selected inventories. If inventory items without valuation occur, a warning message is issued and the affected inventory items are selected |
| Value | Total value of the inventory of the selected inventories after taking the inventory (based on counted actual quantities) |
| +/- | Sum of deviations between counted (based on actual quantity) and expected (based on target quantity) value of goods of each inventory item: positive => more goods, negative => less goods. |
| para. | Sum of the absolute deviations between counted (based on actual quantity) and expected (based on target quantity) value of goods. The difference between the previous field (+/-) and this field is equal to twice the value of negative positions |
List window
This window lists the inventory samples stored in this machine.
| Menu item | Description |
|---|---|
| Edit | - |
| : Reset | List content is reset |
| Options | Call up the option window |
| Symbol | Description |
|---|---|
| Copy all entries in the list to the clipboard |
Option window
Here you can make settings for inventory sampling. The window can only be closed via the "OK" button.
Once set, options can be saved as default options for the logged-in user. For this purpose, there is a context menu entry on the tab "Preferences" in the list "User Preferences", via which the current options can be saved.
| Menu item | Description |
|---|---|
| Edit | - |
| : Set default settings | all changed settings are reset to default |
| Field | Description |
|---|---|
| Inventory | - |
| Inventory Analysis | |
| : : : over identical inventories (same parts/identical storage bins) | If this indicator is set, different inventories with identical parts in the same storage bin can be processed in the inventory analysis. Without this indicator, it is thus prevented that identical, already processed inventories of the past are analysed together |
| : Inventory Type | |
| : : Articles per storage location | Each article with its respective storage bin is considered as an independent inventory item. The inventory items are thus considered independent of each other and flow separately into the selected inventory procedure |
| : : Article Storage location comprehensive (grouped by article) | All inventory items of an item are first collected and flow into the selected inventory procedure balanced according to storage bins. This means that the inventory procedure is applied as if there were only one inventory item per item. This type of stocktaking is suitable when the stock accounting is considered to be reliable overall, but it can be assumed that the booked storage bin does not always correspond to the actual storage bin that is accessed. |
| : Frequency and value distribution | see determination of value ranges |
| Value limit of the first value range | Specification of the value limit of the first value range: these values cannot be included in the "standard" determination of the value ranges |
| Numerical value of the value limit of the first value range | |
| Unit of the value limit of the first value range | |
| Determination of value ranges | |
| Fixed | see determination of value ranges |
| : Standard GESTIN | see determination of value ranges |
| : Dynamic | see determination of value ranges |
| Inventory sampling history | |
| : Sampling error | According to the IDW (Institut der deutschen Wirtschaft), for a proper inventory sampling with a statistical certainty of 95%, the relative sampling error must not exceed 1%. |
| : Probability of statement | According to the IDW (Institut der deutschen Wirtschaft), for a proper inventory sampling with a statistical certainty of 95%, the relative sampling error must not exceed 1%. |
| : Layering | |
| : : Standard GESTIN | Selection of the standard GESTIN processing form: the layer formation is modified by changing the upper limits of the first and the last layer |
| : : : Upper limit 1st layer | Inventory items with a value less than the one given here should be included in the first stratum. A reduction of this upper limit thus leads to a reduced number of inventory items in the first stratum, an increase leads to an increased number of |
| : : : Upper limit last layer | No further strata are to be applied above this ceiling, i.e. inventory items with a value greater than that indicated here are excluded from sampling and thus fall within the full coverage area. A larger value of the upper limit leads to a reduced number of full inventory items, a smaller value to an increased number. According to the IDW (Institute of the German Economy), the value of the full inventory items in a stratified inventory sampling should be 45% to 50%, i.e. the upper limit of the last stratum should not exceed 55 |
| : : : : Value | Upper value limit of the last layer |
| : : : : Percent | Percentage of the upper limit of the last layer. If, for example, 75% is entered here, this results in a percentage share of the full absorption of 25%. |
| : : Extended | Selection of the extended processing form: the number of layers is determined first, these are then further processed using 2 available processes |
| : : : Determination number of layers | |
| : : : : automatic | The number of layers is determined according to a method developed by Kabuss (Kabuss 1991) |
| : : : : manual | The number of shifts can be entered manually in the next field |
| : : : Method of layer formation | |
| : : : Dalenius & Hodges | The strata are determined according to a procedure of Dalenius & Hodges (Dalenius & Hodges, 1959) |
| : : : : Ekman | The layers are determined using a method developed by Ekman (Ekman, 1959) |
| : Creation mode | If the layering is created persistently, it is immediately written to the database. It is therefore recommended to initially only create transient stratifications and to check them for permissibility. If you decide on a stratification and it has been created transiently, a persistent copy of this stratification is automatically written into the database |
| Sequential test | |
| : Parameters | |
| : : Lower limit of error (tolerable error p0) | The lower limit of error shall be determined in such a way that the population available for testing can dispense with a physical inventory if its actual error percentage is less than or equal to this lower limit ("Sequential test for the inventory of non-moving storage units in automatically controlled storage systems", AWV, April 1980). A reasonable assumption is to set p0=p1 / 2 ("Sequential test for physical inventory with random samples in the case of orderly inventory accounting", AWV, 1985) |
| : : : Upper limit error fraction (non-tolerable error fraction p1) | The upper limit of error shall be determined in such a way that it is safe to record the stocks in another way if the actual error percentage in the population under test is greater than or equal to this upper limit ("Sequential test for the inventory of non-moving storage units in automatically controlled storage systems", AWV, April 1980). A reasonable assumption is to set p0=p1 / 2 ("Sequential test for physical inventory with random samples in the case of orderly inventory accounting", AWV, 1985). To determine p1 from (previous) samples, see here. |
| : : Error 1. type(α Risk of the storekeeper) | The decision to reject book inventories even though the actual error fraction in the population is less than or equal to p0 is called the 1st kind error. The risk of making such an erroneous decision is called α-risk or "stockholder's risk", since a book stock that is tolerable in itself is rejected as not proper . ("Sequential test for inventory of non-moving storage units in automatically controlled storage systems", AWV, April 1980). It would seem justifiable to allow for misconceptions of up to 5% in the practical process. It is also important to note that such misconceptions can have an impact on both sides, i.e. on both sides. This two-sidedness also suggests to set α = β. ("Sequential test for the physical inventory with random samples in case of orderly inventory accounting", AWV, 1985) |
| : : : 2nd type error(β risk of the auditor) | The decision to accept the book inventory even though the actual proportion of error in the population is greater than or equal to p1 is called the 2nd kind error. The corresponding risk for this wrong decision is called β-risk or "auditor's risk", since an intrinsically incorrect book inventory is accepted . ("Sequential test for the inventory of non-moving storage units in automatically controlled storage systems", AWV, April 1980). It would seem justifiable to allow for misconceptions of up to 5% in the practical process. It is also important to note that such misconceptions can have an impact on both sides, i.e. on both sides. This two-sidedness also suggests to set α = β. ("Sequential test for the physical inventory with random samples in case of orderly inventory accounting", AWV, 1985) |
| : Sample | |
| : : Number of 1st sample | Number of sample elements to be drawn first, resulting from the above parameters. If all drawn samples prove to be free of errors after this first count (see next field "Tolerance limit (acceptance)" = 0), the stock accounting can be accepted. If the first count already contains more errors than the field "Tolerance limit (rejection)" shows, the sequential test must be rejected and another inventory procedure must be used. The sequential test must/should be continued (i.e. new samples must be taken) if the number of errors lies between the two tolerance limits |
| : : Tolerance limits (acceptance) | Tolerance limit on faulty samples from the first drawing in order to be accepted by the stock records |
| : : Tolerance limits (rejection) | Tolerance limit on faulty samples of the first drawing, above which a rejection of the sequential test for checking the stock accounting is mandatory. |
| : Delimitation full inventory range | - |
| : : value range samples | Control of the full range. Decrease the value to below 100% to set the size of the full recording range in addition to the samples. |
| Presets | |
| : Global presets | Global presets can be saved for the client and account. These are displayed here as well as the current default options that each module has. To create a global preset, a user preset must first be saved. With a right click on this user setting and selection of the context menu item "Edit user-defined setting" an editing window for this setting is opened, where the assignment of the employee / user to a client or a cost centre can be changed. (Button "Level") |
| : User Presets | Each user can save any number of presets. It is only important to note that if several settings are found, the first one found is used as the default setting. The name of the setting can be changed with a double-click. |
| button | Description |
|---|---|
| Setting | The settings are applied. This selection can be made for tests if no setting has been saved. |
| Save | The settings are saved. |
Related topics
- Index
- Inventory
- Inventory statistics
- Frequency and value distribution
- Stratification
- Sequential Test
- Import inventory
Technical documentation
Overview
Module name
invanaly.mod
Classes
CX_INVENTORY
CX_STOCK_STRATIFICATION
Security
In addition to restricting access rights via the class and its data fields, the module can be restricted in its use via some of the received messages.
| Message | Parameters | Function | Security |
|---|---|---|---|
| ANALYSIS_INVENTORY | Inventory object | Inventory is listed | |
| Message | Parameters | Function | Receiver module |
|---|---|---|---|
;){kind=link}
;){kind=link}
;){kind=link}