Skip to main content

Stock Cards - WUI

How a stock card is created, what its fields mean, and where to find recalculation, views, the preview panel, and card movements in the web application

Written by Lenka Haringerová

The values on a stock card are created based on the price list item and stock documents, and they cannot be edited manually. A stock card is created when you select Stock item for an item in the price list and then choose a warehouse in the Warehouse location field on the Warehouse tab.


How a stock card is created

A stock card cannot be created on its own. It is always derived from the price list and the list of warehouses:

  • in the price list item, select Stock item,

  • on the Warehouse tab, in the Warehouse location field, select the warehouses where the item should be tracked.

One card is created for each selected warehouse. The relationship is therefore 1 : N: a single price list item can have as many stock cards as there are warehouses where the item is located. Each card has its own stock level and its own price.

If Automatic warehouse is selected for a warehouse in the list of warehouses, every new stock item is assigned to it automatically. Otherwise, you need to add the location manually for each item.

Cards can also be created in bulk by importing from Excel, usually as a second import right after the price list import.

ℹ️ A stock card cannot be created manually. It can be deleted only until the first stock movement is recorded on it. All values on the card, that is, the quantity in units of measure, the value in CZK, the average price, and the opening balance, are just the result of a calculation from documents and cannot be overwritten.

The relationships across the whole chain are described in the article How the price list, warehouses, and stock cards relate to each other.


Recalculating warehouse balances

In the Stock cards section, in the footer of the list under the three-dot icon (More functions), you will find the Recalculate warehouse balances function. The purpose of the warehouse recalculation is to check and, where necessary, recalculate the prices on the stock card to the correct values. When it runs, it goes through all stock movements.

⚠️ The recalculation works with prices. It does not remove outstanding issue requests (use the Update issue requests function in the same menu for those), and a difference in the actual quantity in the warehouse is resolved by a stocktaking, not by the recalculation. For details, see the article on warehouse recalculation.


Using views in stock cards

Views on stock cards provide user-defined displays of stock items using filters, sorting, and a selection of the information shown. They help you manage inventory efficiently, check goods availability, and quickly find your way around warehouse records, without having to modify the stock card data itself.

Examples of use:

  • Goods below the minimum level – items with a quantity below the defined stock level

  • Non-selling items – stock cards with no movement over a certain period

  • Reserved goods – items with an active reservation for orders or jobs

  • Production items – stock cards intended for production or assembly

Set up your filters and columns, then in the view menu at the top left (Default by default) select Save as new view. For how to work with views, see the article on working with views.


Preview panel for stock cards

The preview panel (split view) displays the details of the selected card next to the list of stock cards. This lets you browse the list and view the card's values at the same time, without opening additional windows.

You can display the panel using the preview panel icon at the top right above the list. Use the same icon to hide it again. To edit the card, click the Edit button in the panel footer.


Stock card detail

Clicking a row only selects the card. To open the detail, click the pencil icon that appears on the right of the selected row:

The Basic information section contains basic values from the Price list section; the other values are updated based on the stock documents that have been created.

Values in fields marked [CZK] are in the currency in which your accounting is kept.

Item identification

Price list: The value is carried over from the Code/abbreviation field in the Price list section.

Warehouse: The value is carried over from the Warehouse location field on the Warehouse tab of the price list item. If you keep the goods in several warehouses, several stock cards are created.

Name: The value is carried over from the Name field of the price list item. If you need to change the name, do so in the Price list section.

Last movement date: The date of the last stock movement of the item, that is, the latest issue date of a goods receipt or goods issue. A document entered retroactively does not decrease this value.

Accounting period: The accounting period the stock card belongs to. If you create a card in 2021, you will not see it in 2020, and so on.

Issue by expiration: We recommend selecting this flag if you will enter batches and expiration dates for the goods on this card. When you save, the batch and expiration are then filled in automatically in the goods issue item, always using the one with the shortest time to expiration.

⚠️ Warning

If you issue a certain quantity of one product from the warehouse, but with different batches and expirations, you need to enter multiple items – the program does not split it by expiration on its own. Even in this case, you can select the batch and expiration date manually.

Quantity and opening balances

Stock level in UoM: The current stock level of the stock goods or product in units of measure. It is calculated from the opening balance and stock documents.

Stock level [CZK]: The current stock level of the stock goods or product in CZK. It is calculated from the opening balance and stock documents.

Opening UoM: The opening stock balance in units of measure as of 1 Jan of the given accounting period. The value is populated after you run Initialize next accounting period (Accounting module), which closes the accounting period and sets the opening balances for the new year. If any movement was still recorded in the previous year, you need to run this option again so that the opening balances are set anew.

Opening [CZK]: The opening stock balance in CZK as of 1 Jan of the given accounting period. The value is populated after you run Initialize next accounting period (Accounting module), in the same way as for the Opening UoM field. If any movement was still recorded in the old year, you need to run this option again.

If you open a stock card after initializing the next accounting period and there is no movement on it yet in the new period, the values in the Stock level [CZK] and Opening [CZK] fields will be the same.

Prices

Average price [CZK]: If you selected the average price method in the Valuation method field under Settings › Modules › Goods, the price shown here is the stock price. The value is recalculated after every goods receipt.

ℹ️ This field is populated always, even if you have the FIFO method set. With FIFO, however, the calculated average price is not used in the goods issue, because the issue is valued according to the specific linked receipt. The value in this field then says nothing about the price at which goods will be issued. For more details, see the articles on FIFO links and on inventory valuation methods.

Last price [CZK]: The last purchase price in CZK.

💡 If you have the Update purchase price in the price list on receipt option turned on under Settings › Modules › Goods, this price is also written to the Purchase price field in the price list after every receipt, from where it feeds into pricing. Other company options are described in the article on company settings.

Minimums, reservations, and availability

Min. stock UoM: The value is used when ordering up to the minimum. In the Issued orders section, under More functions (three dots in the list footer), select Order up to minimum to create an order that fills the minimum stock level in the warehouse. For details, see the article on minimum stock.

Maximum: This field currently serves for information only, showing the maximum stock level in the warehouse.

Reserved UoM: An informational value containing the sum of all reservations of the given stock in the warehouse.

Requests UoM: If generating issue requests is enabled in your company settings (meaning you can create a goods issue even for items that are not in stock), you will see the value of the requests in this field.

Stock level in UoM with requests: The stock level including issue requests.

Available quantity: The quantity actually available, that is, excluding issue requests.


Texts tab

On the Texts tab, you can write any description or note. The fields are optional.


Foreign currency and warehouse location

In the new look of the web application, foreign currency data and warehouse location are hidden in the default form layout. To display them, click the gear icon in the header of the card detail: in the Form settings for full view panel, switch to Hidden, click the eye icon for the Foreign currency and Location sections, and confirm with the Apply button. For how to work with the form layout, see the article on working with forms.

The sections are then displayed on the Other tab.

The Foreign currency section shows data in a foreign currency (stock level, average price, opening balance, last price, and balance as of a date) if the goods are received into stock in a currency other than CZK.

⚠️ Foreign currency values make sense only if the warehouse is actually kept in a foreign currency and its documents are also created in that currency. For more details, see Foreign currency warehouse and domestic currency warehouse.

In the Location section, you can define the room, rack, and shelf where the goods are stored in the warehouse. It helps you find your way around the warehouse more easily. You can find the lists for room, rack, and shelf under Settings › Modules › Goods in the Related settings section (Warehouse location - room, - rack, - shelf).


Goods receipt/issue items

The Goods receipt/issue items section below the card form shows the stock movements of this item in the card's accounting period. You can see the movement date, the document, the quantity, and the price at which the goods were received into or issued from stock.

Why a movement may not appear in the list

If a movement you entered is missing from the list, the reason is usually one of these two:

  • Different accounting period. The list shows only movements from the accounting period the stock card belongs to. A movement from another year will appear only after you switch the period.

  • Unfulfilled issue request. It has zero in the Quantity column and an accounting value of CZK 0, so at first glance it looks like an empty row. On the stock card, it shows up as a positive value in the Requests UoM field.


Related articles

Did this answer your question?