INVENTORY

INVENTORY | Economic and physical inventory management in Uniconta

Stock management in Uniconta is divided into both financial and physical stock management. Physical stock management requires that the company adds Uniconta’s Logistics Module.

Financial stock management allows users to create, purchase and sell goods and services. The stock items are set up in an item card, with an item number, text, and prices. The advantage of creating such an item card is that users do not need to enter the item text manually each time they send an invoice and they do not need to remember all of the various prices.

Users can view current ‘financial’ stock holdings, while the stock movements can be viewed on the transactions report.  It is also possible to print sales statistics on the stock items as well as a counting list for stocktakes.

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.

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 in the Logistics module.

Items and Services

When ‘Item’ is selected as the ‘Item type’ for an inventory item, this allows the user to run Uniconta’s inventory management on that item. This is typically a item placed in physical stock.
The item type ‘Service’, on the other hand, is used for hours, kilometers or postage, for example (i.e for items that are not held as physical stock).

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