ClassiX AppsWarehouse

Inventory

Description
Functionality
Related topics
Technical documentation
Determination of the new average price

Description

This app supports the recording of current inventories (so-called stock corrections) as well as annual inventories in the form of one-time or permanent inventories. Since an inventory is supposed to represent a comparison/check of the (book) stocks in the DP system with the actual stocks in the warehouse, inventories are initially generated from data in the DP. In combination with the inventory analysis app, inventory sampling is also supported.

Inventories are an important part of monthly and annual financial statements. As part of accounting, inventories are subject to strict organisational guidelines.

Structure

There are 5 different ways of setting up an inventory:

Selection according to storage bins: Here, all parts that have or once had stocks in the selected storage bins are transferred to the inventory document with the corresponding book stocks. A permanent inventory is carried out via this selection and selection of the extended selection of storage bins.
Selection by parts: Here, all defined storage bins (with or without stock) of the selected parts are taken over into the inventory document with the corresponding book balances.
Selection byparts and storage bins: Here, individual parts can be assigned new, i.e. previously unbooked storage bins - therefore also initially without book inventory.
Selection by storage bin part accounts per last inventory date - A search window opens in which a date can be entered and warehouses selected. The system then searches either for all selected warehouses or, if none was selected, for all warehouses for the storage bin part accounts for which no inventory has been posted since the date entered and transfers these to the new inventory.
Import of inventory data - To carry out inventory sampling with data from other merchandise management systems, inventory items can also be imported.

The following generally applies to the selection: If a part is invalid but still has stock in one of its storage bins, it is included in the inventory. If there is no stock quantity, an invalid part is not included in the inventory.

By default, when an inventory is set up, the average price of a part in a warehouse is copied into the inventory document. This value can be subsequently changed in the inventory manually or by programme run.

The date, value and quantity of the last inventory are also written to the new inventory document when the inventory is set up. This data can be viewed and further evaluated in the inventory analysis.

Instead of creating a single 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, while an inventory document is still being counted in one storage bin area, the count of another storage bin area that has already been counted can be recorded and posted in the separate inventory document and then this storage bin area can be released. By means of the inventory analysis, it is nevertheless possible to obtain an overview of several inventories.

Duplicate inventory items (same part, same storage bin) are generally not permitted by the system.

Count

After creating the inventory document, a count list can be printed with which the actual count or inventory can then be carried out in the warehouse. Once the actual counted stocks have been entered in the count list, they are subsequently recorded in the inventory document. The counted stocks can be entered manually via the count list or via a mobile data entry station (MDE).

Reconciliation and posting

After reconciliation of the counted stocks and the EDP book stocks, the inventory document is posted. Depending on whether a stock correction is desired or not, either only the difference is posted or the counted quantity is also saved in the system as a stocktaking quantity with date. Posted inventories can no longer be edited subsequently.

The valuation on the inventory item is used to recalculate the moving average price. This valuation is taken from the currently valid average price of the part when the inventory item is created. More on this topic in the chapter "Determining the new average price".

When posting, the posting of the items is divided into individual steps. This is necessary for very long inventories of many parts, otherwise the database is blocked too long for other users. If posting is interrupted, it can happen that individual items have already been properly posted, but others have not yet been posted. You can recognise the complete inventory posting as usual by the posting date on the inventory header document and the blocked posting button. As long as this is not locked, the inventory is not completely posted.

Input window

This window is used to enter and maintain inventories. You can select an inventory by entering the desired number in the Number field and confirming with RETURN. If you want to call up the list window, you can select the menu item "Search".

There are three views (details are described in the options window ):

Inventory
Count list
Valuation

The count list hides all fields that represent the current stock in the ClassiX® system so that the count result is not influenced by the target quantity. These include:

Target quantity	Book balance at the time the inventory was taken (display controllable via an option).
Deviation	Deviation of the counted quantity from the target quantity (display controllable via an option)
Percent	Quantity deviation in percent (display controllable via an option)
Value per	Individual valuation of the stock at the storage bin. The default for this value is the average price of the part in the warehouse at the time the inventory is set up. This value can be maintained in the inventory: Value "new"
Ø price	Average price of the part in stock at the time the inventory was taken (informative field): value "old".
Valuation	"new" stock value of the part at this storage bin (calculated from "counted quantity * value per").
Difference	Valued inventory Difference from valuation "new" - valuation "old" (calculated from "valuation - (target quantity * Ø price)")

When posting, all totals are calculated automatically. A currency table valid for the inventory can be created at the inventory header.

Menu item

Description

Edit

: Currency table

A - local! - currency table valid for the inventory can be defined. - currency table can be defined. The part valuations in foreign currencies are converted into the local currency via this unit table when they are created and before they are posted.

: : Insert

A new local currency table is created for the inventory called up.

: : Edit

The local currency table of the inventory is called up for editing.

: : Remove

The local currency table of the inventory is deleted.

: Inventory items

: : insert

: : per storage location

Insert storage bin with all parts booked there (see description).

: : : per part

Insert part with stocks of all storage bins (see description).

: : : per part in the storage bin

Insert part at a storage bin to be selected (see description).

: : : per cost unit

All used storage bins of the cost unit selected in the header. This function has no result if the inventory has not been assigned to a cost unit.

: : : per last inventory date

Storage bin accounts of parts for which no inventory has been posted at this storage bin since the date entered (see description).

A variant to this selection of uncounted storage bins is offered by the extended selection of storage bins.

: : Duplicate item

The item is duplicated with storage bin and part, but without target quantity. This function is mainly necessary if the quantity is to be posted from one stock type to the other.

: : Exchange part

Exchanges the part on the selected inventory item with a new part to be selected in the same storage bin.

: : Advanced sorting

In addition to the generally available column sorting of the inventory items, the items output in the list can also be sorted by entering special sorting criteria in the sorting window.

: : Change inventory type

The stock type can be changed for items that do not have a target quantity. If the quantity at a storage location is to be assigned to a new stock type, the item must be duplicated or the item. Then set the new item to the desired stock type.

: : : Stock

Regular stock.

: : B stock

Stock of goods with slight defects or damage, used goods.

: : : blocked stock

Goods that are not to be used.

: : Samples

Samples can be taken (even several times) from a once-created inventory document with a very large number of items in order to test the stock reliability of the warehouse.

: : : Draw a free number of samples

By entering a free number of samples, a subset of items can be selected from the listed inventory document. The other items not included in the sample are managed internally in the inventory document as a noted item from which further samples can always be taken.

: : : Withdraw drawn samples

The items from the internal noted item are completely reset and reinserted into the physical inventory document as "normal" physical inventory items, i.e. the original physical inventory document is completely restored.

: : Delete

The inventory item(s) selected in the list is/are removed.

: Shall update quantities

Updating the target quantity is necessary if stock postings have been made after a physical inventory has been set up (after the physical inventory document has been created) - but before the count: This is because a physical inventory only posts the difference in quantity between the target (original book inventory) and the actual (new book inventory that is actually to be transferred).

As a rule, the storage area to be counted is blocked for receipts or issues between the time the inventory document is created and the time of the count. This ensures that a possible, actual deviation between the posted target quantity and the counted actual quantity can be found correctly.

In practice, however, this is often not possible. Often, inventory documents are prepared and processed in advance (the target quantity on the inventory document is thus frozen), but the warehouse is not yet blocked. The warehouse is not blocked until the count lists are issued, so this is the time to update the target quantities with this programme selection.

Updating the target quantities is only possible if the option "Allow stock postings after creation of the inventory document" is not set.

Update 'Value per

Via the valuation (prices of the items) of the inventory, the moving average prices on the parts warehouse accounts are adjusted.

If the creation of the inventory was so long ago that the moving average price has been adjusted by goods receipts in the meantime, the new average price can be updated via these menu items on the inventory items. This step is particularly recommended for quantity inventories before posting, as otherwise the moving average price may be reset to an old value.

More on this in the chapter "Calculation of the average price".

ATTENTION: Any manually overwritten valuations on the inventory items are lost when one of these menu items is called up!

: : All items from average price

For all items in the inventory, the current average price of the part in the warehouse is transferred to the inventory again. This run is only possible as long as an inventory has not yet been posted, as not only the individual valuation of an inventory item is changed, but also the - informative - average price. The latter is also used for comparison in the case of large inventory differences.

: : Marked items from average price

For the marked items in the inventory, the current average price of the part in the warehouse is transferred to the inventory again. This run is only possible as long as an inventory has not yet been posted, since not only the individual valuation of an inventory item is changed, but also the - informative - average price. The latter is also used for comparison in the case of large inventory differences.

: : All items from standard price

For all items in the inventory, the current standard price from the part roll (purchased or production part) is transferred to the inventory again.

: : Selected items from standard price

For the marked items of the inventory, the current standard price from the part roll (purchased or production part) is transferred again to the inventory.

: Is synchronise quantities

If this app is used for the inventory as an add-on (e.g. as GESTIN-77 for an inventory sampling), the book stocks are imported from the materials management system. The time (date and time) at which the target quantity was taken from the book inventory is noted on each imported inventory item. If stock movements take place between this time and the (later) time of the count, the counted actual quantity must be synchronised accordingly afterwards.

As a rule, the storage area to be counted is blocked for receipts or issues between the time the inventory document is created and the time of the count. This ensures that a possible, actual deviation between the posted target and counted actual quantity can be found correctly.

However, if you do not want to/can not block the warehouse between the creation of the inventory document and the execution of the count, you can set this by setting a corresponding option. This option leads to the fact that the time of recording the actual quantity must be entered on the count lists and this time of the count must then also be entered in the entry screen when entering the actual quantities (a process that should certainly only be carried out by means of mobile entry).

After the count has been entered, the stock movement entries must first be imported, namely those that were made between the time of the transfer of the book inventory (target quantity) and the time of the entry of the count.

Then this programme selection must be called up in order to synchronise all stock movements made in the meantime with the counted actual quantity. This is the only way to ensure that the counted actual quantity can be compared with the correct target or book quantity in order to detect any discrepancies.

Which inventory items have been changed can be seen in one of the last columns (synchronisation quantity) of the list of inventory items.

The synchronisation of the actual quantities is only possible if the option "Allow stock postings after creation of the inventory document" is set.

Update the total value of the inventory

Calculates and displays the total value of the inventory. If there are inventory items without valuation, a warning message is issued and the inventory items concerned are selected.

: Count list

: : count position number

In addition to the consecutive item number of the entries of the inventory document, an additional number can be assigned, which is in order of the selected sorting - and thus in order of the desired count.

: : : Extended sorting

In addition to the generally available column sorting of the inventory items, the items output in the list can also be sorted by entering special sorting criteria in the sorting window.

: : : Set count item number

A new, consecutively assigned number is assigned for the count list sorted on the screen. In this way, the sorting of the list is frozen.

: : : Remove count position number

The count position number is removed.

: : Print count list

: : : All

All inventory items are printed on a count list.

: : : Selected

Only the selected inventory items are printed on a count list.

: : : From sampling procedure

Only the inventory items selected within the available inventory sampling procedures (stratified inventory sampling or sequential test) are printed on a count list.

: : Count lists print identifier

If the count list is printed (via Word), then a print identifier is automatically set.

: : : Set

The print identifier is set manually.

: : : Reset

The print identifier is reset.

: : Check for complete count

A check is made whether entries have been made for all inventory items to be counted.

: : : Set identifier

If quantities have been entered for all inventory items, the inventory document is marked as completely counted.

: : : Reset identifier

The identification of being completely counted is deleted in the inventory document.

: Post inventory

The inventory is posted: no more changes can be made afterwards.

Cancel inventory

A cancellation document is created as a successor for the inventory or an existing cancellation document is displayed. No more changes can be made to a cancelled inventory. If the inventory was already posted before the cancellation, this posting is cancelled.

: Data exchange

: : ClassiX standard file format

Import and export of inventory data in ClassiX standard file format. This import and export is used to record the count data outside the system directly in the exported file and then re-import it into the system.

: : : Export inventory list

: : : : As .csv file with ";" separated data fields.

The inventory items are written to a .csv file with the individual data fields separated by a ";". (In Excel, a .csv file constructed in this way can be edited like a normal .xls file).

The structure of the data fields is as follows:

1. inventory document number
2. item
3. part no.
4. attributes
5. description
6. storage location
7. counted quantity (this field is only output as an empty column in order to enter the counted quantity here).
8. counting unit of measure

: : : as Excel file (*.xls)

The inventory items are written directly into an .xls Excel file, the data structure is as described above. This file format is not supported in the browser version.

: : : as Excel 2010 file (*.xslx)

The inventory items are written directly into an .xlsx Excel 2010 (and higher) file, the data structure is as described above.

: : : Re-import inventory list

An inventory list exported in the Excel format described above is re-imported - with the count quantities now filled externally.

: : : : As a .csv file with ";" separated data fields.

The counted quantity and its unit are read in from the 7th and 8th column of the .csv file (see above data structure for export .csv file).

: : : : as Excel file (*.xls)

The counted quantity and its unit are read in from the 7th and 8th column of the .xls file (see above data structure for export .csv file). This file format is not supported in the browser version.

: : : : as Excel 2010 file (*.xslx)

The counted quantity and its unit are read in from the 7th and 8th column of the .xlsx file (see above data structure for export .csv file).

: : GESTIN-77 file format

Import and export of inventory data in GESTIN-77 file format.

: : : Import book inventory data from the host inventory system.

Import of inventory data of the leading merchandise management system.

Hint:
For all non-excel file formats, the import files must be encoded in ANSI.

: : : Excel 2010 file (*.xlsx)

As of Excel 2010, the xml-based .xslx format is available. The advantage of this format is that files in this format can be read in much faster than with the Excel .xls format that was valid until then.

The content of the data fields corresponds to that of the *.lep file described below. (See there also the further description of the import).

The difference to the .lep format is that the lengths of the text fields depend on the value in the individual cells and the order of the data fields can be changed in the options. Also, the additional fields serial number/batch and part class can be read in this format.

Since the first line of an Excel file is very often a header line, the corresponding parameter for the first line of the import must be adjusted in the options. The spreadsheet from which the import is to be made must also be specified.

: : : : Excel file (*.xls)

The content of the data fields corresponds to that of the *.lep file described below. (See there also the further description of the import).

The difference to the .lep format is that the lengths of the text fields depend on the value in the individual cells and the order of the data fields can be changed in the options. The additional fields serial number/batch and subclass can also be read in this format.

Since the first line of an Excel file is very often a header line, the corresponding parameter for the first line of the import must be adjusted in the options. The spreadsheet from which the import is to be made must also be specified.

With an .xls file, the call via the Excel OLE interface is rather slow for larger files ( > 1000 entries). It is therefore recommended to export the Excel file in the *.csv file format (with semicolon as separator) or in an .xlsx format, which are also supported.

: : : Semicolon-separated ASCII file (U286BUCH.csv)

The content of the data fields corresponds to that of the *.lep file described below. (See there also the further description of the import).

The import of the data starts by default (see options) from line 1.

: : : : Fixed format ASCII file (U286BUCH.lep)

The order and structure of the data fields is as follows (the structure and order of the data fields cannot be changed for the fixed .lep format)
Total number of digits: 150

Data field

Description

Data type

Length

Digits

Ident number

Item number

Text

001-025

Localiser

Storage location

Text

026-050

Logical bearing number

Warehouse. This field is also used to indicate that the inventory item is not to be included in a sampling procedure (full inventory).

Text

051-054

Sign book set

Sign of the following book quantity field ("+" or " " for positive quantity, "-" for negative quantity). If the book quantity is negative, the inventory item is marked so that it is not included in a sampling procedure (full inventory). This is also the case if the book price (see below) is also negative, although a positive valuation is determined by multiplication

Text

055-055

Book set

Book quantity with 3 decimal places (without comma character). If this field contains alphanumeric characters, an error message is displayed and the import is aborted.

Numeric

056-066

Book quantity unit

Unit of the quantity. This field must correspond to a unit predefined in the system. The following abbreviations are converted by default into the units known in the system; other units must be entered in the system as user-defined units.

German	English	Unit of measure
st	ea	Piece
stk	pce	Piece
stz	st	Set
set		set
saz		sentence
pr	pr	Pair
par		Pair
ro	co	Roll
rl		Roll
rol		roll
pck	pck	Pack
ml	ml	cm³
m2	m2	m²
sqm	sqm	m²
m3	m3	m³
m		m
mtr	mtr	m
ltr	ltr	l

Text

067-070

Sign Book Price

Sign of the following book price field ("+" or " " for positive price, "-" for negative price). If the book price is negative, the inventory item is marked so that it is not included in a sampling procedure (full inclusion). This is also the case if the book quantity (see above) is also negative, although a positive valuation is determined by multiplication

Text

071-071

Book price

Price of the item at the storage location with 2 decimal places (without comma). If this field contains alphanumeric characters, an error message is displayed and the import is cancelled.

Numeric

072-082

Book price unit

Power of 10 (0 = price per 1, 1 = price per 10, 2 = price per 100, 3 = price per 1,000, 4 = price per 10,000, 5 = price per 100,000).

Numeric

083-084

Naming

Article designation

Text

085-136

Positions 137-150 are ignored during import and export.

The import of data starts by default (see options) from line 1.

During import, parts, warehouses and storage locations - if not already present in the system - are created automatically. The units (abbreviations) of the foreign system (book quantity unit see above) are converted into the units defined in the system.

Inventory items with negative book quantity and or negative book price are automatically marked so that they cannot be included in a sampling procedure (full inclusion).

Duplicate inventory items (same part, same storage location) are not read in by the system, duplicate items are written in the note field of the inventory as well as in the log file.

: : : Viastore file (*.BS)

This is the inventory data of the viad@t merchandise management system from Viastore. The data fields are separated by semicolons:

Data field	Description	Data type	Length	Mandatory field
datacode	record type (always 01)	Text	2	yes
client	client, owner	Text	3	yes
partid	Item number	Text	18	yes
partty	Article type	Text	4	yes
qinv	Available quantity	F11.3	11
stdprice	Price of the material (total price of the stock)	F10.2	10
said	Storage area	Text	3
locid	storage location	Text	10
coid	Loading unit number	Text	20
lotid	Lot number	Text	16
invid	Consecutive stock number (uniquely identifies a stock in viad@t).	Numeric	10

The import of the data starts by default (see options) from line 1.

: : : Freely defined fixed format

This selection imports a fixed format ASCII file for which the start position and the length of the data fields have been specified in the options.

: : : : Test import inventory data

With this selection, the import of one of the upper file formats can be tested in advance. The number of errors found is continuously displayed at the bottom left of the screen.

: : : Export count positions

Export of the inventory items to be counted for counting by means of the host system.

: : : Excel 2010 file (*.xlsx)

The items to be counted of an inventory document - from sampling or as inventory item of the full inventory area - are output. The field Book quantity is set to zero in each case.

After the export, the identifier that the count list was printed out completely is set in the inventory document.

The difference to the above .lep format is that the lengths of the text fields depend on the value in the individual cells and the order of the data fields can be changed in the options. Also, the additional fields serial number/batch and part class can be output in this format. For serial numbers, one entry is output per serial number in the file.

: : : Excel file (*.xls)

: : : Semicolon separated ASCII file with the inventory items to be counted (U286ZPOS.csv).

The export starts without a heading from line 1.

: : : Fixed format ASCII file with the inventory items to be counted (U286ZPOS.lep).

See previous field, the fields are not separated by semicolons in this format.

: : : Freely defined fixed format

This selection tests the import for a fixed format ASCII file for which the start position and the length of the data fields have been specified in the options.

: : : Import count positions

Import of counted inventory quantities from the host system.

: : : Excel 2010 file (*.xlsx)

The previously exported count items of a physical inventory document (see previous selection) are read in again with this selection. The data in the file overwrite any manual count entries.

After the import, a check is made to see whether all items to be counted have been entered (imported); if this is the case, the inventory document is marked as completely entered.

The structure of the data fields corresponds to the *.lep format when importing book inventory data from the host merchandise management system (see above).

Since the first line of an Excel file is very often a header line, the corresponding parameter for the first line of the import must be adjusted in the options. The spreadsheet from which the import is to be made must also be specified.

: : : : Excel file (*.xls)

The previously exported count items of an inventory document (see previous selection) are read in again with this selection. The data in the file overwrite any manual count entries. This file format is not supported in the browser version.

After the import, it is checked whether all items to be counted have been recorded (imported); if this is the case, the inventory document is marked as completely recorded.

The structure of the data fields corresponds to the *.lep format when importing book inventory data from the host merchandise management system (see above).

: : : : Semicolon separated ASCII file with the counted inventory items (U286IST.csv)

The previously exported count items of a physical inventory document (see previous selection) are read in again with this selection. The data in the file overwrite any manual counting entries.

After the import, a check is made to see whether all items to be counted have been entered (imported); if this is the case, the inventory document is marked as completely entered.

The structure of the data fields corresponds to the *.lep format when importing book inventory data from the host merchandise management system (see above).

The import of the data starts by default (see options) from line 1.

: : : : Fixed format ASCII file with the counted inventory items (U286IST.lep).

see previous field, the fields are not separated by semicolons in this format.

: : : Export actual inventory data

Export of inventory quantities after inventory sampling.

: : : Counted actual quantities

: : : : Excel 2010 file (*.xlsx)

All counted/to-be-counted items of an inventory document are output with the absolute actual quantity.

The structure of the data fields corresponds to the *.lep format when importing book inventory data from the host merchandise management system (see above).

: : : : Excel file (*.xls)

All counted/to-be-counted items of an inventory document are output with the absolute actual quantity. This file format is not supported in the browser version.

The structure of the data fields corresponds to the *.lep format when importing book inventory data of the host merchandise management system (see above).

: : : : Semicolon separated ASCII file with counted actual quantities (absolute) (U286ZPOSA.csv)

The export starts without a heading from line 1.

: : : : : Fixed format ASCII file with counted actual quantities (absolute) (U286ZPOSA.lep)

see previous field, the fields are not separated by semicolons in this format.

: : : : Target/actual quantity differences

: : : Excel 2010 file (*.xlsx)

All items of an inventory document are output with the difference quantity from the counted actual quantity - whether actually counted as a sample or as an inventory item of the full inventory area or taken as an inventory item of a shift only from the target quantity - minus (imported) target quantity.

The structure of the data fields corresponds to the *.lep format when importing book inventory data from the host merchandise management system (see above).

The difference to the .lep format is that the lengths of the text fields depend on the value in the individual cells and the order of the data fields can be changed in the options. If the additional field Serial number is specified, this is output as a blank entry in this difference list.

: : : Excel file (*.xls)

All items of an inventory document are output with the difference quantity from the counted actual quantity - whether actually counted as a sample or as an inventory item of the full inventory range or as an inventory item of a shift only taken from the target quantity - minus (imported) target quantity. This file format is not supported in the browser version.

The structure of the data fields corresponds to the *.lep format when importing book inventory data of the host merchandise management system (see above).

: : : Semicolon separated ASCII file with target/actual quantity differences (U286ZPOSD.csv)

The export starts without a heading from line 1.

: : : : Fixed format ASCII file with target/actual quantity differences (U286ZPOSD.lep)

see previous field, the fields are not separated by semicolons in this format.

: inventory sampling

: : exclude/include

For the documents selected in the inventory list, you can specify whether they should generally be excluded from a sampling. A repeated call of the same functionality resets this identifier.

Negative inventory items (target quantity or valuation negative) are automatically excluded from sampling by the system and cannot be included manually afterwards.

Whether an inventory item is generally excluded from sampling is displayed in the "Sampling" column (see below).

Analyse inventories

Inventory items from different inventories are listed in a common, comprehensive inventory list for further analyses.

: Close

Close window.

Options

Opens the options window.

Search

Call up the list window.

Toolbar
Icon	Description
	Create new inventory
	Save changes
	Print, Fax, Email... with call of the print menu
	Display part of the selected inventory item
	Display purchase order item of the selected inventory item
	Display logistics account of the selected inventory item.
	Display warehouse stock of the selected inventory item
	Display stock movements of the selected inventory item.
	Display MRP movements of the selected inventory item.
	Display document history
	Create/edit notes
	Calculates and displays the total value of the inventory. If there are inventory items without valuation, a warning message is issued and the affected inventory items are selected.
	The window for transferring the inventory items to the clipboard is called up.

Fields

Field

Description

Inventory

: number

Number of the inventory document.

: date

Date of creation of the inventory document.

: status

Status of the inventory document (created, posted, cancelled, ...).

: Inventory correction only

Last inventory values / data are retained, only a stock difference is posted. If this flag is not set, when posting the inventory, the inventory value is written to the "average price" in the logistics account and the fields "inventory value", "inventory date" and "inventory quantity" are written to the warehouse account of the part.

: agent

Selected agent.

Rating

: statistical period

Statistical period for posting the inventory.

: Posted/Cancelled

Posting date; this field is empty if the inventory has not yet been posted/cancelled.

: Total value

Total value of the stock after taking inventory (based on counted actual quantities); calculated automatically when posting or after having the total value calculated.

: +/-

Sum of the differences between counted (based on actual quantity) and expected (based on target quantity) goods value of each inventory item: positive => more goods, negative => less goods. This field is calculated automatically when posting or after having the total value calculated.

: Abs.

Sum of the absolute differences between the counted (based on the actual quantity) and expected (based on the target quantity) value of goods of each inventory item: is calculated automatically when posting or after having the total value calculated. The difference between the previous field (+/-) and this field is equal to twice the value of negative items.

Inventory list

Listing of the inventory items

To jump to a specific inventory item, you can enter the item number. If the display option "Count list" has been set under the options, you can also enter the count item number to jump to a specific inventory item. The number of count items still to be entered is also output.

Field

Description

Inv.Pos.

Sequence number of the inventory item

Count.item.

This column is only displayed if the display option "Count list" has been selected in the options.

No.

Number of the warehouse

Bearing

Short name of the bearing

Camp location

Designation of the storage place

Short name of the storage place

Part

Part number

Text

Part text. If it is a part with characteristic values, these are output in the second line

Counting set

Output of the counted quantity

Quantity counted recorded

This column shows with a grey tick that the item has been counted. A red tick is set if the item was counted, but due to a synchronisation of the actual quantity (see menu option "Synchronise actual quantities") the deviation is not equal to the target quantity minus the actual quantity.

Last inventory

Indication of the last inventory for this part in this storage location. This column can also be displayed further back, depending on the display options currently set (see below).

Some of the following columns are not output if the 'Count list' is set in the display options

Target quantity

Output of the target quantity. This is the quantity that is to be checked or confirmed as book inventory by a physical inventory.

Deviation

Absolute deviation of the counted quantity (actual quantity) from the target quantity (possibly corrected by the synchronised quantity: see menu option "Synchronise actual quantities").

Percent

Percentage deviation of the counted quantity (actual quantity) from the target quantity (possibly corrected by the synchronised quantity: see menu option "Synchronise actual quantities").

Deviation serial numbers

If the part has serial numbers, a possible deviation of the counted quantity from the number of serial numbers is displayed here.

Value per

Output of the individual value of the inventory item. This value is taken from the current average price when the inventory item is created from the part master. This value can be overwritten manually and is written back into the partial master as the new average value for inventories that are not of the type "Inventory correction only".

Ø price

Output of the running average value of the part. This value is taken from the current average price when the inventory item is created from the part master and can thus be used as a comparison value for a possible new "value per".

Valuation

Total value of the inventory item as multiplication of the counted quantity and the individual value of the inventory item (column 'Value per').

Difference

Difference of the previous column 'Valuation' to the value resultingfrom the multiplication of target quantity and average price (column 'Ø price').

Last inventory

Indication of the last inventory for this part in this storage bin. Depending on the display options currently set, this column can also be output further forward (see above).

Foreign currency value per

Output of the (possible) individual value of the inventory item in foreign currency. This column is only output if the valuation list is set in the display options.

Logistics KZ

Output of the logistics control identifier from the logistics account of the part of the inventory item.

Inventory sampling

no	The inventory item has been manually or automatically (due to negative values) excluded from sampling. The inventory item is to be counted
contain	The inventory item has been processed in a sampling procedure, but the item has not been selected as a sample to be counted
yes	The inventory item was processed in a sampling procedure and the item was selected as a sample to be counted
	The inventory item is to be counted. If a sampling procedure has been applied, then the item is one that has been automatically excluded from this procedure (full inventory item)

Cycle counting KZ

Marking of a part for the cycle-counting inventory procedure.

Recording of counted quantity

Date of recording of the counted quantity

Time of recording the counted quantity

Synchronisation quantity

Quantity that is used to calculate the deviation between target and actual quantity after calling up the menu item Synchronise actual quantities.

Date of the synchronisation document

Time of the synchronisation document

Posting date of this item

Date of posting of the inventory item

Number of positions / selected

Display of the total number of inventory items plus the number of selected inventory items.

Buttons
Button	Description
Insert	A submenu for inserting new inventory items opens (see above menu item "Insert").
Remove	The inventory item(s) selected in the list is/are removed.
OK	Changes to the inventory are saved. If no changes have been made, the button is locked.
New	The input window is cleared.
Delete	The displayed inventory is deleted.

Position window

This window is used to maintain the inventory items. The quickest way to enter the inventory is to jump to the next / previous item with the arrow keys 'up' and 'down' after entering the values for an item. The data is automatically saved when you switch. If you select the Close button, no data is written to the database.

The display and maintenance of the fields depends on the display options.

Fields
Field	Description	only with option
Counting quantity	Quantity of the part in the specified storage location, specifying the corresponding unit of measure.	Inventory list, count list
Serial numbers	It is checked whether the number of serial numbers assigned to the part bin account corresponds to the amount of the counted quantity. If this is not the case, the serial numbers of the counted parts must be assigned to the inventory item. When the inventory is posted, the serial numbers in the part storage bin account are then automatically adjusted.	Inventory list, count list
Target	Only output of the target quantity (book inventory of the part at the storage location)	Inventory list; count list only if the option "with target quantity" is set.
Value	Valuation of the storage part on the day of the inventory. The price of a part can be determined per storage bin. This value should only be changed if the parts in the storage bin no longer correspond to the current average price	Inventory list, valuation list
per	Indication per which quantity the value in the previous field applies.	Inventory list, valuation list
Original price	Valuation of the stock item on the day of the inventory in the original currency. This applies to purchased parts whose purchase is made in a foreign currency	Valuation list
per	Indication per which quantity the value in the previous field is valid.	Scorecard
Count by	Enter the time of the count in order to be able to offset any stock movements from the entry of the inventory items (with the book quantity thus determined) (see corresponding option	Inventory list; count list only if option "Allow stock postings after creation of inventory document" is set.
at	Enter the date of the count (see also explanation in the previous field). The date can be adjusted via "Page up" and "Page down".	Inventory list; count list only if option "Allow stock entries after creation of inventory document" is set.
memorise	If the count is transferred to the system on a day other than the day on which it was counted, this option can be used to note the count date and preset it when entering the next items.	Inventory list; count list only if the option "Allow stock entries after creation of inventory document" is set.

Buttons
Button	Description
OK	Changes to the position are saved.
Close	The window is closed without saving changes to the current position. If you want to save the changes, you must press the "OK" button or select another position using the arrow keys (position is then saved automatically).

List window

Used to search and list inventories.

Menu
Menu item	Description
Edit	-
: Analyse inventories	Inventory items from different inventories are listed in a common, cross-inventory list in order to be able to analyse them further.

Toolbar
Symbol	Description
	Create new inventory
	Edit inventory
	Delete inventory
	Print inventory
	Create/edit notes
	Copy all inventories to the clipboard

Search fields
Field	Description
Number	Search by number
Date	Search by date
Status	Search by status

Buttons
Button	Description
Edit	The current inventory is displayed in the input window.
New	An empty input window opens.
Delete	The selected inventory is deleted.
Close	The window is closed.

Sorting window

In this window, special sorting criteria can be made to sort the displayed items in the list.

Fields
Field	Description
Part number	Sorting by part number
Start position	Position in the part number from which to sort
Length	Length of the sort term, from the start position specified in the previous field.
Storage location	Sorting according to the storage bin number
Start position	Position in the storage bin number from which to sort
Length	Length of the sorting term, from the start position specified in the previous field.
Sort	If both part number and bin number sorting is activated, the leading tick can be used to specify the order in which sorting is to take place.

Buttons
Button	Description
Sort	The displayed items are sorted according to the entered sorting criteria

Draw number of samples

From this window, a freely definable number of samples can be taken from the inventory items in the inventory document currently being processed. After drawing the sample, only the items that were drawn by sample remain in the inventory document.

The remaining items are removed from the display and kept in the inventory document as a noted item for the items originally present in the inventory document. You can therefore always select new samples from the noted item.

Fields
Field	Description
Original total number of items	Number of items originally (before the first sampling) present in the inventory document.
Number of samples already drawn	Number of samples already drawn
Number of new samples to be drawn	New number of samples to be drawn

Buttons
Button	Description
Draw samples	The entered number of samples is drawn from the inventory document

Selection window

This window is used to select an inventory.

Search fields
Field	Description
Number	Search by number
Date	Search by date
Status	Search by status

Buttons
Button	Description
OK	The selected inventory is taken over.
Close	The selection is cancelled.

Mobile data acquisition

This window is adapted in size and functionality to a mobile data collection station. The information such as inventory/line or storage location/article number should be scanned in order to only have to enter the counted quantity directly at the station.

Fields
Field	Description
Inventory	Input of an inventory number. A mobile data entry always refers to an inventory prepared for a count list. This inventory must not yet have been posted
Line	Alternatively, the position of the entry in the inventory count list can be specified or the place and article are specified. In the latter case, the system checks whether the bin and item are already in the count list. If this is the case, the corresponding line is automatically determined and output, otherwise a new entry is inserted in the count list. This ensures that articles that are in the storage bin but not in the count list are also counted. In the opposite case - a certain item with a certain bin occurs in the count list, but the item is not in the bin when counted - this item is also not recorded in this bin (as it is not in this bin), i.e. the count quantity remains at zero in the count list.
bin	Specification of the storage bin. This field can only be entered if no valid line has been entered.
Item	Entry of the item number. This field can only be entered if no valid line has been entered.
Quantity	Enter the quantity to be counted. If a quantity has already been entered for the combination inventory/line or place/article, it appears here in this field. A counted quantity can only be entered once for one of the above combinations. If the counted quantity entered differs from the book quantity by more than 10%, the characters "????" are displayed in the "Book" button. This is to alert the person entering the data that there is a large deviation from the book quantity.
	Unit of measure

Buttons
Button	Description
Book/??? Book ???	The counted quantity is stored. The "???" is always output if the counted quantity recorded deviates from the book quantity by more than 10%.
Close	The window is closed without saving changes. If you want to save the changes, you must press the "Book" button.

Options window

Here, among other things, all settings for the search can be made. The window can only be closed by pressing the "OK" button.
Once options have been set, they can be saved as default options for the logged-in user. For this purpose, there is a context menu entry on the "Preferences" tab in the "User preferences" list, which can be used to save the current options.

Menu
Menu item	Description
Edit	-
: Set default settings	all changed settings are reset to default

Fields

Field

Description

Display options

Various options for displaying the inventory items

: Inventory list

Displays the target quantities, counted quantities, differences and valuations in local currency

: count list

Does not show any valuations or target quantities, only the counted quantity. The data fields for the valuation and the button for posting are hidden.

: with target quantity

If the inventory list is to be output in the form of the count list, you can select here whether the columns with the target quantity (book quantity) and the absolute and percentage deviation from the actual quantity are also to be output.

: valuation

Displays the valuation in the local currency and the valuation in the foreign currency, if available.

: Only count items from sampling procedure used.

If this option is selected, only the count items are displayed or printed in the inventory lists and valuation lists.

: Standard lists

Select a report for each inventory list, count list and valuation list from which the formatting of the list box is to be adopted as the default setting. When the window is opened, the list is automatically formatted with it. This allows an individual definition of the columns as standard list.

The possible input fields when maintaining inventory items also depend on this setting.

Data entry

: Inventory guidelines

Options for handling created inventory documents

: : Allow stock entries after the inventory documenthas been created.

This option is only to be observed if this app is used for the inventory as an add-on to an external merchandise management system (e.g. within the framework of the GESTIN-77 inventory sampling). In such a case, the inventory document is imported via an interface. If further stock movements are then carried out in the external system after importing the book inventory, stock removals can be imported subsequently via an interface by setting this option.

If this option is set, it is therefore possible to carry out a stocktaking without having to block the warehouse to be counted: after entering the counting results, any stock movements carried out are calculated against the target quantity valid at the time the stocktaking document is created. In this way, the target quantity at the time of the count can be determined automatically and a target/actual comparison of the book quantity to the counted quantity can be carried out correctly.

The prerequisite for this is that, on the one hand, the exact time of the "freezing" of the book values is set correctly (is set automatically when the inventory document is created or read in via the interface) and, on the other hand, all warehouse bookings from this time until the time of the count are recorded on time (which can be guaranteed when booking using mobile terminals).

If this option is set, the time (time and date) at which the count was recorded can also be explicitly entered in the window for entering the count results. If this option is not set, this data is automatically filled with the time and date of recording (not the recording!) of the count result.

: Input of new inventory items

Options for entering new inventory items

: : Create missing stock accounts

If a part has not yet had a warehouse account, the warehouse account for the part is created without prompting or cancellation: If this option is not set, it can be checked whether the part has ever been kept in a warehouse.

: : Set missing main storage bins

If an inventory is posted for a part in a storage bin and this part does not yet have a main storage bin entered in the warehouse account, the inventory storage bin is subsequently entered as the main storage bin. The system also checks whether the logistical control indicators are set correctly. If this is not the case, the part is declared as a stock-controlled purchased part. Keyword "initial inventory".

: Input count (via MDE)

Options for mobile entry of the count.

: : Warning deviation difference at

Specification of a percentage. When entering a counted quantity, a warning is issued if the percentage difference between the entered actual quantity and the posted target quantity is greater than the percentage specified here.

Data exchange

: GESTIN-77 file format

For the data exchange to the leading host merchandise management system, the format of the stock data import file can be specified here.

: : file format

For the data exchange with the leading host ERP system, the format of the inventory data or can be specified here.

: : : Fixed

Specification of a format with fixed/fixed field length.

: : : .lep (GESTIN-77)

Fixed format import file in GESTIN-77 format (*.lep) (see GESTIN-77 file format).

: : : .BS (vi@dat from viastore systems)

Fixed format import file in viad@t format from viastore systems (*.BS).

: : Variable

Specification of a format with variable field length.

: : : .csv

Import file with variable field length, fields separated by semicolon (*.csv).

: : : .xslx (Excel 2010)

Import file is available as Excel file with extension *.xslx (at least from Excel version 2010).

: : : .xls (Excel)

Import file exists as Excel file with extension *.xsl (Excel before version 2010). This file format is not supported in the browser version.

: : : SQL query

To import data, an SQL statement can also be sent directly to an external database. This field is locked in the browser version.

Import GESTIN-77

: : File directory

Optional specification of the directory in which the import file is located. If only a file directory is specified (i.e. no file name: see next field), the directory must be terminated with \*. This field is locked in the browser version.

: : file name

Optional specification of the name of the import file. If both a file directory and a file name are specified, the import process starts without an additional query of the import file. This field is locked in the browser version.

: : archive directory

Optional specification of the directory into which the import file is to be moved after completion of the import process. This field is locked in the browser version.

: : Excel spreadsheet

If an Excel import format (*.xsl, or *.xslx) has been selected as the file format (see above), the number of the spreadsheet must be entered here.

: : Import from line *

Specifies from which line of the import file the data is to be read in. This specification applies to all import files, i.e. also to the files with counted actual quantities. The export, on the other hand, is always written from line 1

: : Add up duplicate entries for part/storage location.

In principle, an import file should be structured in such a way that the combination part/storage location only occurs once in the file. If this is not possible, this option controls that "duplicate" entries are no longer rejected by the system as errors, but are added to an item of the inventory document.

However, if the price of the entries that occur more than once is different, this will also be rejected initially. With the option "Average price automatically" (see next field) it can be set that in such a case the price should be averaged automatically.

: : Average price automatically

With this additional option (only selectable if the previous option has also been selected) you can determine that - if the entries each have different prices - not only the quantities are to be added up but also the price is to be averaged. The prices are only averaged if there are also quantities in the storage bins, i.e. different entries of a part in the same storage bin with a different price in each case - but without quantity - are not taken into account.

If all entries of a part at the same storage bin have no quantity, only the last entry is taken into account.

If the newly calculated price leads to a deviation of the total valuation of more than 0.5% due to rounding, the import is aborted with an error message.

: Export GESTIN-77

: : File directory

Optional specification of the directory in which the export file is to be stored. This field is locked in the browser version.

Record description

Data field

The following is a list of data fields that can be specified for import, export (in GESTIN format) (fields with an * are mandatory fields). These specifications are only valid for the file formats Excel (*.xls or *.xslx) (import only) or .csv (import and export).

: : Item number *

Position of the item number specification in the import/export file.

: : storage location *

Position of the indication of the storage bin in the import/export file.

: : read over

Here, storage locations can be specified - separated from each other by semicolons (;) - that are to be read over during import. This is needed, for example, if the warehouse management system outputs storage locations that are used purely for its administration (interim storage bins) or that are generally to be excluded from the (random) inventory.

: : warehouse *

Position of the warehouse number or identifier in the import/export file. This field is a mandatory entry, if a warehouse ID is not specified in the import file, you can enter a 0 here, but you must specify a warehouse ID in the next field.

If there are entries in this and the next field "set", then - if there is no value at the storage position - the value from the field "set" is taken.

If data is imported from SAP WMS, the plant, storage location and storage type can be read in separately (see here). The field "warehouse" is then regarded as "warehouse number". (Internally, the field is then saved with the variable name third.number).

: : set

If no field number can be entered in the previous field for the warehouse, a warehouse identifier must be permanently specified in this field for all entries in the import/export file.

If there are entries in the previous field "warehouse" and in this field, then - if there is no value in the warehouse item - the value from this field is taken.

: : set full admission if

This identifier is used in stratified inventory sampling to remove inventory items from the sampling procedure and to allocate a complete inventory of these parts marked in this way. If the identifier maintained here corresponds to the field "Logical warehouse number" of a data record of the import file according to the GESTIN-77 file format, then this inventory item is marked for the complete inventory.

The value "LAVA" is preset for full stocktaking.

: : sign book quantity

Position of the sign of the book quantity in the import/export file. If a zero is entered here, the sign is im-, exported with the field of the book quantity (see below).

: : book set *

Position of the book quantity in the import/export file.

: : divide by

If the book quantity in the import file is output without a decimal point, the factor by which the book quantity must be divided to obtain the value with correct decimal places can be specified here. By default, 1000 is entered here, i.e. the book quantity in the import file is output - without decimal point - with 3 decimal places.

: : unit of measure

Position of the unit of measure of the book quantity in the import/export file. If a zero is entered here, "pieces" is always used as the unit of measure.

: : sign book price

Position of the indication of the sign of the book price in the import/export file. If a zero is entered here, the sign is im-, exported with the field of the book price (see below).

: : book price *

Position of the book price in the import/export file.

: : divide by

If the book price in the import file is output without a decimal point, the factor by which the book price must be divided to obtain the value with correct decimal places can be specified here. By default, 100 is entered here, i.e. the book price in the import file is output - without decimal point - with 2 decimal places.

: : book price unit

Position of the book price unit in the import/export file. This book price unit is processed by default as 0 for 1, 1 for 10, 2 for 100, etc., if a zero is entered here, the book price is assumed to be "per 1".

However, the next field can be used to specify if the book price unit is given directly as a number, i.e. e.g. 25, 50, 250, etc.

: : free "per number

If this checkbox is set, the book price unit is not processed as an exponent of the number 10, but it is read in directly as "per number ...". In this case, the position of a separate "per quantity unit" for the book price unit can then also be specified in the next field

: : per unit of measure

When freely specifying the "per quantity..." of the book price, a separate quantity unit can also be specified for the price. E.g. if one has a book price of "10,50€ per 15kg", where the stock itself is given in kg.

If a zero is entered here, the unit of measure of the book stock is taken over.

: : article description

Position of the item description in the import/export file.

: : Article description 2

Position of the indication of the second line of the item description in the import/export file.

: : Article number supplier

Message specification of the supplier's item number in the import/export file.

: : devaluation %

Percentage of the devaluation of the inventory item in the import/export file. The book price of the inventory item is reduced by exactly this factor.

: : serial number

Position of the specification of a serial number for an item at a storage location in the Im/Export file. If a zero is entered here, the items/parts are imported/exported without a serial number.

The following rules apply for processing with serial numbers:

For each serial number - of a certain part at a certain storage location - there is an entry/line in the import file.
All entries with a serial number - of a certain part in a certain storage location - have the same book price
For all entries with a serial number, the book quantity must generally be equal to one
If a particular part in a particular storage bin has at least one entry with a serial number, all entries for that part in that storage bin must also have a serial number

: : batch, if

(this field is only visible if a number is entered in the previous field).

The serial number can conditionally also be a batch number. In this case the parts are created as "batch parts". The condition can be entered in the next field. The following data fields can be queried:

Data field/variable	Description	Example
itemClassID	Part class	var(itemClassID) = "C" \| var(itemClassID) ="E"

: : storage aid

Identification of a storage aid (LHM) in the import/export file.

: : Part class

Position of the part class specification. The read-in parts are assigned to this part class.

: : EAN code

Position of the indication of the EAN code of the item.

: : Date book values

Position indicating the date of the book values. If you do not want to block the warehouse between the creation of the inventory document (= "freezing" of the book values) and the counting of the parts, this information is required in order to be able to carry out an automatic correction of the book values by means of the interim warehouse movements.

: : Actual quantity

Position of the indication of the actual quantity. This information is required if you want to read in inventories that have already been carried out in order to be able to determine the stock accuracy.

: : Time Book values

Position indicating the time of the book values. If you do not want to block the warehouse between the creation of the inventory document (= "freezing" of the book values) and the counting of the parts, this information is required in order to be able to carry out an automatic correction of the book values by means of the intermediate warehouse movements.

: : difference to local time

Indication of how many hours the time specified in the import file differs from the user's local system time. A negative specification (e.g. -2.00h) results in an import time of e.g. 9.21h in the system being corrected to 11.21h and vice versa, with a specification of +2.00h to 7.21h.

The result of the calculation of the corrected time can also lead to a correction of the date of the entry. In the above example (-2.00h), therefore, with an import time of 23.20 and an import date of 12.10.2013, the time is corrected to 1.20 and the date to 13.10.2013.

The difference entered here must not be greater than +/- 12 hours.

: : Last inventory

Position of the specification of the date of the last inventory in the import/export file. If this field is set, a data record is only read in during import if its inventory date is older than the period specified in the next field.

If no inventory date is set in a data record, the data record will be imported in any case.

: : read in if older...

Period for filtering data records during import with regard to an inventory that has already been carried out. If the inventory date specified in a data record is older than the period specified here, then the data record is imported for the inventory, otherwise the data record is not imported and it is thus excluded from the (renewed) inventory.

If the field remains empty despite specification of an item for the last inventory, filtering does not take place, i.e. all data records are imported - despite possible specification of an inventory date.

SAP WMS data fields

The following is a list of the data fields that are necessary for importing stocks from an SAP WMS: In the WMS/MM, in addition to the warehouse number (called "warehouse" here), the plant, the storage location and the storage type are also managed as separate data fields. If all fields are read in, the "warehouse" is marked inGESTIN-77 as WORK NUMBER-SITE-WAREHOUSE NUMBER-WAREHOUSE TYPE.

: : plant

Position indicating the plant number. If this exists, it is placed before the warehouse or the storage location (if specified) (see field above) separated by a "-" character (e.g. WERKNR-LAGERNR or WERKNR-LAGERORT-LAGERNR). (Internally, the field is stored with the variable name first.number).

: : storage location

Position of the indication of the storage location. If this is available, it is placed in front of the warehouse (see field above) separated by a "-" character (e.g. LAGERORT-LAGERNR). (Internally, the field is stored with the variable name second.number).

: : storage type

Position of the storage type specification. If this is available, it is placed after the warehouse (see field above) separated by a "-" character (e.g. LAGERNR-LAGERTYP) (internally, the field is stored with the variable name fourth.number).

Default settings

: Global presets

Global presets can be saved for the client and cost centre. These are displayed here as well as the current default options that each app has. To create a global preset, a user preset must first be saved. Right-clicking on this user setting and selecting the context menu item "Edit user-defined setting" opens an editing window for this setting, on which the assignment from employee / user to a client or cost centre can be changed. ("Level" button)

: User Preferences

Each user can save as many presettings as desired. The only thing to note is 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.

Buttons
Button	Description
Set	The settings are adopted. This selection can be made for tests if no setting has been saved yet.
Save	The settings are saved.

Technical documentation

Overview
Implementation
Quality Assurance

Inventory basic module
- Inventory editing app
- Inventory selection app

Overview

inventry.bmp (8118 byte)

Determination of the new average price:

The determination of the new average price for parts when posting an inventory is done as follows:

When creating inventory items, the current average prices are written to the document as the "old average price" and as the new valuation, as well as the current stock level of the selected storage bin as the SET quantity. Calculations are then carried out when posting:

(Current total stock * current average price )
+ (valuation * counted quantity storage bin)
- (old average price * TARGET quantity-storage bin).
/
current stock quantity + counted quantity storage bin - SET quantity storage bin

current average price unit of measure

If a part now has stock in several storage bins, the new value will also only change the average price proportionally according to the new total stock. It is then not taken over 1:1

For a simplified explanation

If the part only has one storage bin, the formula could be simplified somewhat: The first part of the formula is omitted because the SET quantity of the storage bin is the current stock and the old average price is the current average price:

(valuation * count quantity-storage bin)
/
Quantity counted

Current average price unit

Example:

The receipt shows a valuation of 10€/1piece. The quantity counted is 10 pieces. The value indicated on the inventory item is therefore taken over 1:1 as the new average price:

Valuation * counted quantity 100 EUR
/ counted quantity (10 pieces) = 10 EUR/piece

Average price denominator (1 piece) 10 EUR

Per denominator of current average price = 10 EUR / 1pc.

Inventory basic module

Module name

inventry.mod

Classes

CX_INVENTORY

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.

Received messages
Message	Parameter	Function
INVENTORY_CHANGED	Inventory object	Inventory has been changed
INVENTORY_CREATED	Inventory object	Inventory was created
INVENTORY_DELETED	Inventory object	Inventory has been deleted

Sent messages
Message	Parameters	Function	Receive module
EDIT_INVENTORY	NULL or inventory object	Call up input window for inventory	Inventory editing module

Inventory editing module

Module name

invenedt.mod

Classes

CX_INVENTORY

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.

Received messages
Message	Parameter	Function
COMMENT_CHANGED	Object	Comment has been changed
EDIT_INVENTORY	NULL or inventory object	Call up input window for inventory
EDIT_INVENTORY_COUNT_LIST	NULL or inventory object	Call up input window for inventory (count list view).
INVENTORY_CHANGED	Inventory object	Inventory has been changed
INVENTORY_CREATED	Inventory object	Inventory was created
INVENTORY_DELETED	Inventory object	Inventory has been deleted
INVENTORY_REGISTER_UNIT_TABLE
LIST_INVENTORY	Collection Inventory objects or NULL	Call list window for inventory
LIST_INVENTORY_COUNT_LIST	Collection Inventory objects or NULL	Call up list window for inventory (count list)
LOAD_INVENTORY		Import inventory
STOCK_SELECTED	Stock object	Stock was selected
STOCK_SPACE_SELECTED	Collection stockspace objects	Storage bins have been selected

Sent messages
Message	Parameters	Function	Receive module
EDIT_COMMENT	Object	Call up input window for comment	Comment editing module
EDIT_INVENTORY	NULL or inventory object	Call up input window for inventory	Inventory editing module
EDIT_INVENTORY_COUNT_LIST	NULL or inventory object	Call up input window for inventory (count list view).	Inventory editing module
EDIT_ITEM	NULL or partial master object	Call up input window for part masters	Part master editing module
EDIT_PURCHASE_ITEM	NULL or order item object	Call up input window for order item	Order item editing module
EDIT_STOCK_ACCOUNT
INVENTORY_CHANGED	Inventory object	Inventory has been changed
INVENTORY_CREATED	Inventory object	Inventory was created
INVENTORY_DELETED	Inventory object	Inventory has been deleted
LIST_INVENTORY	NULL or Collection Inventory objects	Call list window for inventory	Inventory editing module
LIST_ITEM_STOCK_SUB_MONITORS
PRINT_INVENTORY_COUNT_PAPER
SELECT_DISPO_ACCOUNT_LOGGINGS
SELECT_STOCK_LOGGINGS
SELECT_STOCK_SPACE	NULL or Collection storage bin objects	Invoke selection window for storage bins	Selection window selection module
SHOW_PREVIEW	Widget	Print preview	Print preview

Inventory selection module

Module name

invensel.mod

Classes

CX_INVENTORY

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.

Received messages
Message	Parameter	Function
INVENTORY_CHANGED	Inventory object	Inventory has been changed
INVENTORY_CREATED	Inventory object	Inventory was created
INVENTORY_DELETED	Inventory object	Inventory has been deleted
SELECT_INVENTORY	Collection Inventory objects or NULL, receiver of the response.	Call selection window for inventory

Sent messages
Message	Parameters	Function	Receive module
EDIT_INVENTORY	NULL or inventory object	Call up input window for inventory	Inventory editing module
INVENTORY_SELECTED	Inventory object, receiver	Inventory was selected

Inventory

Inventory

Description

Structure

Count

Reconciliation and posting

Functionality

Input window

Position window

List window

Sorting window

Draw number of samples

Selection window

Mobile data acquisition

Options window

Related topics

Technical documentation

Overview

Determination of the new average price:

Inventory basic module

Module name

Classes

Security

Inventory editing module

Module name

Classes

Security

Inventory selection module

Module name

Classes

Security

Search

AppsWarehouse

App Suites

Operational business

Support

Translations

Inventory

Structure

Count

Reconciliation and posting

Module name

Classes

Security

Module name

Classes

Security

Module name

Classes

Security

Search

AppsWarehouse

App Suites

Operational business

Support