INVENTORY

INVENTORY | Economic and physical inventory management in Uniconta

Uniconta allows its users to set up, buy and sell inventory items. Inventory on-hand can be viewed as well as placed into warehouse locations by variant as well as by using serial and batch numbers.

All items can then be sold as single items or as BOMs. Reservations and inventory on-hand can then be checked on an ongoing basis. Uniconta provides both economic inventory management (i.e. when items are bought and sold, inventory is updated by quantity and value) as well as physical inventory management (i.e. when items are bought and sold, users can follow the item’s physical location).

Extended item text

Item text can be up to 60 characters long. If a longer description or translations into other languages are required, then users can extend the text using the ‘Item name group’ function in the Logistics module. Texts can then be up to 1,000 characters by using this ‘Item name group’. Users can also specify the customer's item number so that it can be included on the various forms.

Sales prices and price lists

Three sales prices are available as standard and different currencies can be selected. If more than 3 sales prices are needed, users can expand this functionality using the ‘Price lists’ feature. ‘Price lists’ allow users to create special prices, discounts, promotional periods, fixed contribution ratios, prices by quantity. Price lists are linked to each customer. Vendor price lists can also be created.

The item card

The contents of BOMs are created using the inventory item cards. Each inventory item card displays the inventory status, language as well as the extended item descriptions, price lists that have been set up, serial and batch numbers, item variants and the inventory on-hand. Item and customer statistics are shown directly on each item card – i.e. who has bought the item and how much was earned, showing the contribution margin and contribution ratio. These statistics also show the vendors that the items were bought from and how many items were purchased by each vendor.

Manage your inventory effectively

One of the most important features of an economic system is to enable its users to effectively manage their inventory. The size of the inventory holdings has a large impact on the financial accounts. It is therefore useful to have plenty of inventory information at your fingertips. This applies to the physical location of the items, specific item information as well as outstanding reservations.

Simple BOM set up

BOMs are a collection of items that together can be sold as a single item. Our ‘Report as finished’ function keeps track of each item, their serial number, location, and so on. The individual parts are taken out of inventory once the BOM is reported as finished.

Warehouse management with several options

One of the major advantages of Uniconta’s inventory module is our location management. Users get both a financial and physical inventory management system in one, since the system allows them to buy, sell, and move items between warehouse locations. An automatic inventory statement is created, showing the inventory movements as well as the impact on inventory value.

Uniconta’s razor sharp inventory control

Inventory management is a summary module within Uniconta’s accounting system. It is typically used as an overview of product quantities, their physical location and inventory values. The module gives an easy-to-access overview of available inventory, inventory on order and inventory reserved with locations and cost prices by individual item.

Users can also update delivery notes and see which items have been received. User can then deliver and invoice the order even if the purchase invoice has not yet been updated.

Such in-depth inventory control is rarely used to manage each individual nut and bolt. Our basic inventory management covers the nuts and bolts and is, of course, included in the system.

Inventory features

Master data

  • Manual item number allocation or automatic allocation via the number sequence given on the item group
  • The item number can be up to 40 characters long
  • 4 Product Types – item, service, BOMs and production BOMs
  • Cost price is given in local currency and the purchase price currency can be selected by the user
  • Groups are available and are typically used for setting up postings as well as for automatic item number creation and specification codes and countries of origin for Intrastat and the list system.
  • Device names created by Uniconta, translated into 23 languages and the terms have been converted for electronic invoicing (OIOUBL).
  • 10 decimal places available
  • Select primary vendor that will automatically be suggested upon reordering inventory items
  • EAN-number field which can be used, for example, when printing out inventory labels with bar codes
  • Inventory item placement – detail item’s placement in the warehouse. This can include the warehouse location as well as specify an additional location within the warehouse, so users can fully manage exactly where an item is located
  • Cost price model – Fixed cost price, average or FIFO
  • Select serial or batch number control
  • Give total discount – indicates whether a total discount can be given on the item
  • Hide item in sales and purchases – manage whether an item should appear when creating a sales and/or purchase order
  • Inventory on hand for each item – physical inventory, reserved, ordered, available, available for reservation
  • Size specifications – weight, volume and carton
  • Brand – indicate brand and type e.g. Adidas, Golf – search and filter functions
  • Inventory levels for purchasing and sales management – minimum, maximum, purchase quantity and standard sales quantity
  • Alternative item – proposes an alternative if the requested item is not on hand
  • EU-sales – select tariff number (KN8) and country of origin – used for Intrastat/list system
  • Variants – select a default variant for variant management, for example, size and colour.
  • Attach notes and documents to inventory item lines, for example drawings, assembly instructions, and images – images can then be printed on forms such as quotations.
  • When using dimensions, users can specify suggestions e.g. department, carrier and purpose
  • Up to 5 variants in the inventory module
  • More suppliers and EAN numbers per item number
  • Dimensions on inventory transactions
  • Item names can be up to 150 characters long
  • Price groups 1, 2 and 3 do not allow price of zero

Reports

  • Inventory item statements – customer and vendor movements
  • Transactions – all movements on the inventory item
  • Inventory status – value of inventory at a given date
  • Items on hand – on hand, available, reserved and ordered by variant and warehouse
  • Re-order list – suggested purchase calculation in relation to sales orders, purchase orders and BOMs
  • Counting list – for counting and entering inventory item counts
  • Selected variants – inventory by variant
  • Batch-/serial number – inventory, quantity sold, purchase date, expiration date
  • Posted inventory journals
  • Inventory item – /customer statistics
  • Salesman-/customer statistics
  • Uniconta pivot-tables – displays statistics based on pre-selected criteria on a monthly, quarterly and yearly basis

Updates – new fields, new lists, new function buttons, new reports

  • Uniconta’s ’Tools’ module is included in the standard package
  • New fields available in the inventory item list
  • New reports added to the list of standard reports.

Read more about our other modules

Top