Go to
Lager/Warehouse draft
Select the inventory draft you want to enter entries in.
Read here how to create a draft...
Import from file
It is possible to import stock draft lines via
Import from file - for example, a count made in Excel. The import must be set up before use.
Read about setting up a file via import here...
Copy and paste from Excel
It is possible to copy data from Excel into the draft. Sometimes it may be necessary to change your data in Excel and then transfer it to the inventory draft. Here you should be aware that you need to copy both the movement type and cost price or cost value from the draft, as the item number, when inserted from Excel, does not look it up in the item overview itself.
Delete entries in draft
Delete records deletes all the records in the draft.
Entering in the draft
Select draft lines from the Stock draft overview.
Add entry or click
F2 to create draft lines.
If you fill in the
Text field in the inventory draft, the text will be posted to the financial item.
If you have lines in the draft that you do not want to post, you can put them on hold by checking the
Hold box on the draft lines.
Goods movement
In the draft line, select a Goods movement. The type is stamped down on the item entries.
ATTENTION. For all the following types of transfer to finance, if accounts are filled in the stock draft, these accounts will override the accounts in the standard setups.
ATTENTION. Entries that are only received but not invoice received cannot be processed in the draft. E.g. moved.
| Movement |
Adjustment of inventory WITHOUT financial items. This movement type can be used for relocations, as described under the type Relocation, but without cost price.
Do NOT use this type for opening stock in new accounting
Use the Opening type for opening stock - see detailed description below.
Most often one of the other movement types described below is used. |
| Sale of products |
Used if you want inventory management without the use of sales orders.
Debtor account can be specified in the inventory draft.
A stock transaction is created and displayed on the debtor.
Sales records are NOT created on the debtor and in finance.
A sale is registered with a negative number, i.e. if a piece is sold from stock, it must be noted as -1 in the draft for a sale.
Posted to the accounts specified on the item group in the fields Lager Departure if the Offsetting account (Inventory draft) field is empty and an offsetting entry is made to Cost of goods sold.
If the Counter account (stock draft) field is filled in, post to this account instead and counterpost to Cost of goods sold. |
| Indkøb |
Used if you want inventory management without the use of purchase orders.
The vendor account can be specified in the inventory draft.
Batch and serial number items can be purchased via the draft and assigned an expiration date. Read more here...
A stock transaction is created and displayed on the vendor.
Purchase entries are NOT created on the vendor and in finance.
A purchase is registered with a positive number, so if you buy a piece for the warehouse, it must be noted as +1 in the draft for a purchase.
Post to the accounts specified on the item group in the fields Lager, Receipt (Warehouse draft) and Counter account (Warehouse draft). If the Counter account (Inventory draft) field is empty, post to Stock out instead.
Note! As this will by default result in two entries on status accounts, it is recommended to manually enter the desired accounts for posting directly in the draft for purchase entries in the inventory draft, as these will always override the accounts selected on the groups. |
| Regulation |
Used for periodic inventory adjustments.
Do not use for movements within the warehouse.
Post to the financial account with the system account type "Inventory value adjustment" if such a system account has been created, or alternatively post to the account in the Inventory value adjustment field on the item group and counterpost to the account specified on the item group in the Counter account (Inventory draft) field.
IMPORTANT! If the default chart of accounts setup for system accounts is used, i.e. account 5545 is set as the system account for inventory value adjustments and the Counter account (Inventory draft) field is also filled with a status account, both entries will be posted to accounts under assets in the chart of accounts. Therefore, for example, choose to fill in the Inventory value adjustment field in the item group with a current account, or fill in the Financial account field in the inventory draft with the current account you want to post the adjustment to. |
| Counting
|
Used for inventory counting.
Stock counts can be entered directly in the stock draft or via Lager/Reports/Count List and then posted to a stock draft. In the latter case, the draft lines are automatically assigned the Count type.
Registered as the difference between the stock registered in the warehouse and the counted stock.
This means that it is the difference between 'In stock' and 'Counted' that is transferred to quantity in the stock draft.
Posted to the financial account with the system account type "Draft for loss/profit entry" and to the account specified on the item group in the Counter account (Stock draft) field. If no system account is defined for loss/profit, post to the account specified in the Loss/profit field on the item group instead. |
| Loss/Win |
Used for Loss/Win registration.
A loss is registered with a negative number, i.e. a loss for the warehouse, and must be entered as -1 in the draft.
A win for the warehouse must be registered with a positive number, i.e. a win for the warehouse, and must be entered as +1 in the draft.
Posted to the financial account with the system account type "Draft for entering loss/win" and to the account specified in the item group in the Counter account field (Warehouse draft). If no system account is defined for loss/profit, post to the account specified in the Loss/profit field on the item group instead. |
| Obsolete |
Used to adjust obsolete and discontinued items out of stock.
An obsolete item is registered with a negative number, i.e. a loss for the warehouse and must be noted as -1 in the draft for obsolete item.
Posted to the financial account with the system account type "Draft for entering loss/profit" and to the account specified in the item group in the Counter account (Warehouse draft) field. If no system account is defined for loss/profit, post to the account specified in the Loss/profit field on the item group instead. |
| Finalize |
Used to finalize production BOMs.
Enter the quantity to be finalized in the quantity field.
If necessary, unfold the BOM and see the items included in the BOM and what is deducted. |
| Included in BOM |
When unfolding BOMs, the items included in the BOM are displayed with this type. |
| Opening |
Used to add inventory to the warehouse in connection with a startup where finance is entered. No entries are posted in Finance for this movement type.
Note Uniconta does not calculate imported inventory entries.
Opening inventory must be the quantity in stock on the creation date of the account. |
| Relocation |
Used to move items from one storage location and/or location to another. The item is moved with cost prices.
In the draft, fill in the To storage location and To location fields with the storage location and the location to which the item should be moved. In the Storage location and Location fields, select the storage location and location from which the item should be moved. Enter +1 if you want to move 1 item to the new location.
You can also move between Dimensions using the From Dimension and To Dimension fields. A move will create financial entries if the dimensions are changed. |
Opening a warehouse/how are items stocked?
When starting a warehouse, it is possible to copy/paste inventory from an excel or csv file into the warehouse.
Read more about how to import from excel
here.
When importing items in stock, select 'Opening' in the 'Goods movement' column under
Lager/Stock draft and the 'Draft lines' button, as described below. No records are generated in Finance when you select 'Opening', as finance entries have already been made.
Example of opening
If you have your items listed in Excel or a CSV file, this must contain the following fields: (the headings must be as in the image below)
This data is selected in Excel, copied and pasted into the draft.
Post the draft and your inventory is ready to use.
Example of moving (can use motion in the same way)
It is possible to move goods between locations.
If you did not place your items at your locations in the opening, you can do so using the following example.
Here there is only one storage location, but you could also take advantage of location.
Example of Regulation/Loss/Wind
Here is an example where you want to withdraw an item from stock. For example, for internal use or as a loss.
A Stock draft must be set up under Lager/Stock draft called, for example, Loss/Win or Adjustment. Here you can select a Financial account and a Counter account for automatic posting in this draft.
Financial accounts for Loss/Win can be set as system accounts on the chart of accounts or on the product groups.
- In Inventory draft lines, select 'Loss/Win' or 'Adjustment' as 'Goods movement'. Now Uniconta automatically uses this'Financial account' and 'Counter account' from the stock draft setup(see example 1 below, where 'Counter account' and 'Financial account' remain empty in the fields on draft lines). You can also write a 'Counter account' and 'Financial account' in Warehouse draft lines and the system will overwrite the warehouse draft accounts in the warehouse draft setup (see example 2)
- In the stock draft, you enter the quantity of the item to be pulled out. It must be entered with minus '-'. In this example, it's item 20-13, which we subtract by putting '-1' in 'Quantity'. The cost price should be included here (or automatically or manually).
Example 1 - Automatically using stock draft accounts to regulate in the stock draft
Tap 'Post draft' and simulate postings to see the 'Financial account' and 'Counter account' accounts being used automatically.
Example 2 - Manually entering accounts in stock draft lines
You can also write a Financial account and Counter account on the inventory draft lines to overwrite the automatic inventory draft accounts setup. In the example below, the user selects accounts 1330 (Cost of goods sold - inventory module) and 5545 (Inventory adjustment) directly on the inventory draft line, which overwrites the selections in the draft setup.
Tap 'Post draft' and simulate postings.
Accounting with batch or serial number
If you want to register a specific item with a specific serial number or a batch item via the Warehouse Journal, this can be done directly in the Warehouse Journal.
Add the [Batch/Serial number] field and the [Item] field via Layout.
Select the item and register the Batch/Serial number you want to register.
Learn more about batch and serial numbers
here.