Stock entries

Inventory records show all transactions that have taken place in the warehouse. Select Lager/Reports/Postings to view the stock records

In the stock records, it is possible to edit variants and storage location and location. It is also possible to add a batch or serial number to the entry.

Edit variants

Read more about variants Here... Clicking Edit variant allows you to change the variant of the stock item

Edit storage location/location

Clicking Edit location/storage location allows you to change the location and storage location that the item is pulled from.

Batch and Serial number

By clicking on Batch/Serial numbers, you can see the batch/serial number assigned to the item for the selected posting. Here it is possible to remove the batch/serial number from the entry.

Clicking Add batch/serial numbers allows you to assign a batch/serial number to the selected entry.

Mark inventory transactions

Here, stock transactions can be marked against purchases. This can be used, for example, to ensure the correct purchase price when a batch is written up or written down via a counting sheet. This ensures that cost prices are recalculated correctly if a specific item has been used. It works like when a sales order is marked against a specific purchase. Stand on the record (Do not fill in the marker. You can't). Press Mark inventory transactions. Now the cost price from the purchase will be set as the cost price on the inventory at "Recalculation of cost prices"

When items are selected, the sales order lines in the inventory items can see which purchases the line is selected against by clicking on selected items

Dimensions of inventory transactions

If you use dimensions in Uniconta, the inventory items are stamped with the same dimensions that financial transactions from the inventory item are stamped with. This means that the inventory transaction now also inherits dimensions from the order header and the item.

Example when selling with dimensions

On the following sales order, "Sorø" has been selected in the "Department" dimension

On the product card itself, "Lager" has been selected in the "Carrier" dimension.

When simulating the sales order and viewing the posting, you will see that the stock transaction has been stamped with the different dimensions.

Inventory status without reservations and orders

To get a real overview of your inventory status, you need to use stock records. Go to Lager/Reports/Postings To see the desired data, you need to use filters in Uniconta.

Right-click on the date field and select Advanced filter
In the Filter Editor, click Equels and select which operation the date should be filtered by.

In the example below, "Greater than or equal to" is shown

In the example below, "In between" is shown where the date range is in between the two dates, the selected dates are included in the date range.

The example below shows how you can group on the individual items if needed.

Right-click on the item field and select Group by
Right-click again on the item field and select Show Groups by to view the ribbon with the groupings

In the example below, the grouping of items is shown where at the bottom you can see the filtering that is also set on the overview

Description of selected fields

Below is a description of selected fields under inventory entries

Field name	Field Description
Stock update	This field is used for example in project: When a purchase is booked for a project, two inventory entries are booked, first the item is added to stock and then immediately withdrawn because it has been used on the project. These two stock entries are marked in the Stock update field. When a final invoice is subsequently created from the project, another inventory entry (issue) is created. However, this record does not have a check mark in the Inventory update field, and therefore this record is not counted in the calculation of inventory count etc. If it was counted, there would have been 1 receipt and 2 issues posted for the project. project and the inventory would show -1. The field is also used for converted inventory records from e.g. C5 to Uniconta: The inventory records converted from C5 to Uniconta do not have a mark in the Inventory update field, and this means that all the converted inventory records are not counted in inventory levels. The inventory records are converted to see what items have been bought and sold historically, but an opening inventory must be manually posted in Uniconta after the conversion from C5 to Uniconta. The field is also used for BOMs: An item of the BOM type, where the BOM is not included in the item, will not be updated in the warehouse. In this case, only the sub-items of the BOM will be updated, also have a check mark in Stock update.
Adjustment of cost amount	When running Cost price recalculation, a check mark will be placed in Adjustment of cost amount if the individual entry is adjusted based on the selected cost price principle.
Cost price	The cost price for the individual entry. This can be changed by running Recalculate cost prices, and for a purchase, it can be changed from the menu.
Quantity price	The quantity price comes from the Price field from a sales order or Price from a purchase order. For sales/purchase taxes, where the tax is included in the sales/purchase price, Quantity price=Price+tax.
Total amount
Net amount	Is the sales price minus any discounts.
Gross amount	Is the raw selling price before any discounts are calculated.
DB	Contribution margin
DG% OF DG%.	Degree of coverage in percent
Cost value	Is Number * Cost price
Discount percentage	Discount percentage given to one line item
Rabat	A Discount, in value, that can be given to one line item. The value is per quantity. For example, two items are sold and a discount of 10 is given. This means that each item is given a discount of 10. For two items, the discount is 20.
Final discount %.	A final discount is assigned to the order header and applies to the entire order, unless otherwise set up for the item.
Movement of goods	The movement that has taken place on the entry in question. You can read more about movement of goods under posting stock drafts. ..
Bookkeeping number (Lager)	If a booking number exists for the warehouse, it means that the entry has been booked via a warehouse draft. This can exist without a bookkeeping number. For example, Moving and Opening in a stock draft does not post anything in the financials.
Posting number	If a bookkeeping number exists, it belongs to a financial item and the item is booked in finance.
Cost amount booked
BOM lines	Shows that this item record is a record that comes via a BOM.
Imported	If there is a check mark in the Imported field, the record has most likely been imported from another system to Uniconta. A check mark may also be set in connection with a stock reset, as an imported record is not included in the stock update. Note! It is recommended to contact a reseller if you want a stock reset.
Batch or serial number	If this field is checked, it means that a batch or serial number has been used in this entry.
Reference
Week	This field can be filled in manually on order lines and is stored in the stock records if applicable.

Change in cost prices

It is possible to change cost prices on purchases, credit notes and removals. Read more here... https://www.uniconta.com/da/unipedia/kostpriser-indkoeb-flytning-og-kreditnotaer/