Skip to main content

Warehouse Accounting - WUI

Where to Set Up Posting of Goods Receipts and Issues in the Web App and How to Verify That the Warehouse Account Matches the Stock Balance

Written by Lenka Haringerová

This article describes where in the web application you set up the posting of stock documents (receipts and issue slips) and how to check that the value of inventory in the accounts matches the stock level in the warehouse.


Posting stock movements

This chapter is intended for users who track inventory using method A, that is, who post receipts and issue slips from the warehouse. If you track inventory using method B, stock movements do not enter the accounts. The procedure for method A is described in more detail in the article on posting inventory using method A.

You can preset the posting of stock movements in several ways. If you do not need to differentiate posting by type of inventory (material, goods, etc.), set it directly on the stock document type. You can find the types in Settings › Records › Documents › Document Types › Stock Document Types.

In the list of types, select the row of the document type (e.g., STANDARD) and open its detail using the pencil icon. On the Posting tab, fill in the Posting rule - receipt [CREDIT] and Posting rule - issue [DEBIT] fields. The receipt rule determines the credit side, that is, the inventory acquisition account (e.g., 131 or 111), and the issue rule determines the debit side, that is, the expense account (e.g., 504 or 501).

You enter the counter-account of the posting, that is, the stock inventory account, on the warehouse in Settings › Records › Goods and Warehouses › List of Warehouses. In the warehouse detail, fill it in the Warehouse account field.

Differentiating accounts by goods group

In practice, accounts are usually differentiated by type of inventory. You define the types in Settings › Records › Goods and Warehouses › Goods and Material Groups. A basic breakdown might be, for example, services, goods, and material.

You then set up posting for each group separately, in the group detail on the Posting tab. Here you specify the accounts for individual operations: received invoice account, issued inv. account, stock acc. - R (receipt into stock), stock acc. - I for invoice, stock acc. - plain I (issue without an invoice), and stock acc. - transfer I.

The stock inventory account (e.g., 132) is also set in this case on the warehouse in the list of warehouses, as described above.

You still need to assign the goods and material group to price list items. In the Price List module, open the item and select the group in the Goods group field.

As soon as you select an item from the given group on a document, it is posted automatically to the preset accounts. For details about groups, see the article Goods Groups.


Checking warehouse posting

When you need to verify that the value of inventory on the stock accounts matches the stock level in the warehouse, compare the account balance with the warehouse stock level as of the same date.

Stock account balance

You can find the balance of a stock account (e.g., 132) in the Accounting Outputs module using the Trial Balance or Account Movements output. Enter the account in the Accounts, groups, classes separated by commas field, or select it from the list in the Account field. In the Output section, choose whether the results are displayed in the module or a PDF file is created, and run the output using the Export button.

Stock level as of a date

Compare the account balance with the stock level, which you can find, for example, in the Stock Level as of Date module. In the Warehouse and Date Settings window, select the warehouse and the date as of which you are comparing the stock levels, and confirm with the Confirm button. The value of inventory in the domestic currency is shown in the In dom. curr. column.

In this module, you can select only one warehouse at a time. If you have multiple warehouses, display the stock level for each warehouse separately.

If you want to see the stock level of all warehouses together, open the Stock Cards module and click Totals in the footer of the list. In the Summation panel, you will see the opening balance and the value of inventory in CZK for each warehouse, as well as their total.

⚠️ If the stock level and the account balance do not match, some movement has been posted incorrectly or not at all. Go through the individual stock movements and check that they have the correct accounts filled in. For how to find the cause, see the article on diagnosing incorrect stock prices.


Related articles

Did this answer your question?