Loading
Uniconta
Search
Generic filters
Free trial signup
  • Visit a Country Site
    • Dansk
    • Uniconta GermanyDeutsch
    • Eesti
    • Uniconta GermanyÍslenska
    • Lietuva
    • Uniconta NetherlandsNederlands
    • Norsk
    • English
  • Search
  • Uniconta
    • What is Uniconta ?
    • Modules
    • Ledger
    • Customer
    • Sales Order
    • Vendor
    • Purchase
    • Inventory
    • Logistics
    • Project
    • Light Manufacturing
    • CRM
    • Fixed assets
    • Dashboard
    • Company
    • Adaptability
    • Uniconta Assistant App
    • Uniconta Upload App
  • Download
    • Uniconta for Windows
    • Uniconta for Mac
    • Download for Developers
    • Free trial signup
  • Resellers
    • Find a reseller
    • Become a reseller
    • Uniconta Partner info Login
    • Uniconta Partner info Sign up
  • Developers
    • Become an integration partner
    • Documentation
    • Samples
    • Downloads
  • Accountants
    • Become a Univisor
  • News Overview
    • Blog
    • News
    • Uniconta Update
    • Customer cases
  • About us
    • About us
      • Management
      • Contact
      • IT Security ISAE 3402
      • System status
    • Terms & Conditions
      • License Agreement
      • Data Processing Agreement (DPA)
      • Privacy policy
      • Cookie policy
      • Sub-processors

Unipedia

  • Introduction
    • Get started with Uniconta
    • Which browser are you using?
    • Get started with an existing set of accounts
  • Converting to Uniconta
    • Conversion tool
    • What can be converted to Uniconta?
    • Converting from NAV to Uniconta
    • Converting from e-conomic to Uniconta
    • Converting from C5 to Uniconta
    • Converting from eCtrl to Uniconta
    • Checking your accounts after conversion
  • General Ledger
    • How to split voucher PDF
    • Chart of Accounts
      • Chart of Accounts
      • Account types
      • System Accounts
      • Import a Chart of Accounts
    • General journals
      • Journal Entries
      • Import from a file
      • Import Bank statement
        • Automatic account selection
      • Posting in foreign currency
      • Posting customer payments
      • How to manage voucher number series
      • Setting up Journals
      • Cancel voucher/delete journal/delete record
    • Bank Reconciliation
      • Bank Management / Bank reconciliation
      • Automatic account selection
    • Budget
      • Budget
    • Reports
      • Account statements
      • Transactions
      • Financial Statement
      • Physical Vouchers
      • Posted Journals
    • VAT reporting
      • VAT reporting – Denmark
      • VAT specification – Denmark
      • EU sales
      • Intrastat
      • EU sales list
    • Pivot table
    • Maintenance
      • Dimensions
      • – Join two dimensions
      • – Reverse charged VAT – Denmark
      • Voucher number series
      • – Automatic allocation of number series
      • Terms of payment
      • – Managing cash discounts
      • Accounting year
      • – Year end closing/opening balances
      • Join two accounts
    • Audit activities
      • Company accounts templates
      • Export transactions
  • Customer
    • Customer
      • Customer
      • – Reconciling Customer Accounts
    • Quick invoice
      • Quick invoice
    • Sales
      • Sales orders
      • – Create purchase/sales order
      • Quotations
      • Mass update
      • – Generate UBL
      • – Purchases and sales without VAT
      • Order journal
    • Reports
      • Statement
      • Transactions
      • Open transactions
      • Payment proposals (SEPA)
      • Ageing report
      • Interest and collection letter
        • – Collection letter messages
      • Invoices
      • Delivery note
      • Stock transactions
      • Order lines
      • Customer statistics
      • Pivot table
    • Maintenance
      • Customer groups
      • Order groups
      • Shipments
      • Terms of delivery
      • Layout groups
      • Number sequences
        • – Error messages
      • Invoice layout
        • – Creating watermarks
      • E-mail setup
        • – Setting up SMTP
        • – Mail server set up
        • – Forwarding e-mails to Uniconta
      • Document messages
      • SEPA set up
      • Mandates (SEPA)
      • Customer Direct Debit
      • Join
        • Join two accounts
        • Join two sales orders
        • Join many
  • CRM
    • – Introduction to CRM
    • Prospects
      • – Creating an quotation for a prospect
      • – Create follow-up
    • Customers & Prospects
    • Follow-up activities
    • Create e-mail list
    • Campaign
    • Maintenance
      • Interests
      • Products
      • CRM groups
      • Follow-up groups
      • Campaign groups
  • Vendor
    • Mass update
    • – Purchases and sales without VAT
    • Reports
      • Statement
      • Merge payments
      • Ageing report
      • Pivot table
    • Maintenance
      • Vendor groups
      • Purchase order groups
      • Vendor layout groups
      • Number sequences
      • File formats for methods of payment
        • – Setting up messages for vendor payments
        • – Setting up bank days
      • Join
      • – Join two accounts
      • – Join two purchase orders
      • – Join many
  • Inventory
    • Items
    • Stock Journal
    • – Posting in the stock journals
    • – BOMs in Uniconta
    • – Handling packaging fees
    • Reports
      • Inventory account statement
      • Inventory transactions
      • Item stock status
      • On-hand
      • Re-order list
      • Pivot table
    • Maintenance
      • – Purchasing number series items
      • Join two items
      • Variants
        • – Default variants
        • – Importing old inventory transactions
  • Project
    • Get started with Project and Time
    • Invoicing in the project module
    • Project Categories
    • Pivot table
    • Project groups
  • Company
    • Company information
    • View a demonstration company
    • User rights
      • Manage users
      • Requests for company access
      • Request company access
    • Maintenance
      • Configure application functionality
      • Preferences
      • Subscription (Administrators)
      • – Create subscription (Administrators)
      • – Create subscription (Client)
      • – From trial period to subscription
      • – Counting financial items
      • – Azure Authentication in Uniconta
      • Modification URL
      • Create a new company
    • Contacts
  • Administrator
    • Distributor Administration
    • User Login History
    • Partner Plugin
  • Tools
    • Main Menu
    • Save layout as a menu item
    • User Plugin
      • How to change Uniconta’s default plugin path
    • Report Generator
      • Report Generator
        • Acccount statement
        • Collection letter documents
        • Company accounts cover page
        • Picking list
        • Purchase documents
        • Sales documents
      • Create a report to be viewed externally
      • Expression binding for Reports
    • Additional setup
      • Local backup
      • Import e-conomic
  • Data Access
    • Transfer data from Uniconta to Excel
    • OData filter function
  • General
    • User Interface
      • User Profile
      • Shortcut Keys in Uniconta
      • Layout
      • Templates
      • How to search in Uniconta
      • Filter/Clear Filter
      • General tips
    • General Functions
      • Attachments
      • Copy and paste in Uniconta
      • Export data and reports to file format
      • Send documents and data by e-mail
      • Print reports and list forms
      • National company number lookup
      • Excel, export and import
    • Security
      • Forgot Password
      • Backup
      • Uniconta Security
    • Installation
      • Installation on RDS – Remote Desktop Server
      • Optimal internet access for Uniconta
      • Install Uniconta in Windows 7
      • Uniconta in the Microsoft App-Store
      • Uniconta for Mac
Search
Generic filters

Items

1,522 views 30 October 2017 8 October 2018 6 minutes
Print Friendly, PDF & Email

Learn more about:

  • Layout
  • Filter/Clear Filter
  • Templates
  • How to search in Uniconta
  • Attachments
October 8th, 2018

 

The Inventory Items card

The inventory module is used for general inventory management and can be used as the central module for sales and purchase invoicing.

Inventory movements are determined according to the posting rules selected in the purchase and sales order modules. Inventory levels can, however, also be edited manually in the Inventory module itself.

It is the ‘Item type’ selected on the item card, that determines whether the inventory levels for the item are driven by the inventory module or not.

The item group determines how the item is grouped in the chart of accounts and MUST be selected.

Users must also determine whether they would like Uniconta to accept negative inventory levels under Company/Preferences.

The item card – description of fields

Use the navigation panel to go to Inventory/Items. The item card is divided up in to several sections, such as the ‘Description’, ‘Prices’ and ‘Group’ sections.

 

(Click on screenshot to enlarge.)

Description

 

Item

45 characters

Enter the item number here. All characters can be used except ” , and space.
To change an item number, go to Inventory/Items and select the ‘Edit’ button. Type over the existing number in the ‘Item’ field and click on the ‘Save’ button. All transactions throughout the system for this item will be thereby be changed to reflect the new item number.
Item name

150 characters

Type the item’s name here. If more than 40 characters are required or additional langages needed, then users can use the Item name group function under Inventory/Maintenance/Item name group. 

 

 

Item typeItem – used for inventory management

Service – typically hours, kilometers/miles or other items that do not require inventory management

BOM – a bill of materials that combines several inventory items that are sold as a package. Packaging, freight and taxes can also be included in the bill of materials.

Production BOM – Finished goods that include raw materials and hours. Once production items are finished, the production BOM is declared complete in the inventory journal. The number of items produced will be listed and the raw materials used will be taken out of inventory.

 

BlockedIt is possible to block inventory items, for example if they have expired.

Tip! – It is useful to add a note for the item, stating why it is blocked. This can be done in the note column on the item itself under Inventory/Items.

Prices

Cost priceEnter the item’s cost price here. The field will accept up to 5 decimals.

The cost price will be updated according to the cost price model selected in the ‘Settings’ box. See also below:

Fixed cost price =  The cost price is fixed but can be changed manually.

Average = This is a running average and is updated based on the purchase records.

FIFO = The last price that the item is purchased for. (This is updated to the first in first out principal cost price upon invoicing/posting).

Uniconta requires that the cost price is given in the company’s default currency (the currency selected under Company/Company Information)

Cost prices are determined by the price of the purchases made. If, for example, the company’s default currency is DKK, but the purchase price is in EUR, the cost price will be calculated based on the currency that the purchase is made in, i.e. EUR if the cost price model is FIFO.

 

Sales price 1-3Sales prices are set up for each customer in the required currency to a maximum of 5 decimal places. If a customer has a special price this can be set up under Inventory/Maintenance/Customer price lists.

 

Purchase priceEnter the purchase price for the item here. This is the price that will appear on the purchase order line when the order is placed with the vendor.

Group

GroupSelect the group for the item from those created under Inventory/Maintenance/Item groups. A group MUST be chosen here, as it determines how the item is accounted for in the chart of accounts.

 

Discount groupHere the user can select an inventory discount group.
Prices and discounts can also be selected by item number and item group from the price lists. Discount groups can also be selected by inventory item and used in the price lists. Read more in the discount group article.
UnitSelect the unit here. Additional units CANNOT be set up by Uniconta users, since these units are linked to a conversion table for electronic invoices (UBL).  Uniconta can set up additional units upon request.

 

DecimalsUp to 5 decimals can be selected here.

 

VendorSelect the primary vendor used to order the item. To turn on the sub-directory for vendors and EAN numbers activate the function via Company/Maintenance/Configure application functionality and check the ‘Purchase accounts’ box. Read more here.

 

EAN numberEnter the standard EAN number for this item. This is used for bar codes.

To set up several EAN numbers on the same item, go to Inventory/Maintenance/Item name group.

 

Item locationThis field can be used to identify the item’s location/placement. For example, ‘Shelf 3’. This is a manual entry.

 

WarehouseSelect the geographical location of the ‘Warehouse’. For example, the town it is located in or the truck.

 

LocationThis field can be used to identify the item’s physical location in the warehouse, for example, ‘Hall 1’.

 

Settings

Cost price modelSelect the model – Fixed cost price, Average or FIFO.

This determines the cost of the items taken from inventory.

Batch/serial numbers 

Select from: None, Serial number or Batch number. This enables serial number and batch number management.

 

Mandatory batch/serial numberCheck the box to make a batch/serial number mandatory upon invoicing and purchasing.

Note that if the user would like to have a ‘mandatory batch/serial number’ then they should use ‘sales orders’ instead of the ‘quick invoice’ function.

 

Mandatory markingIf this box is checked then the transaction will be rejected upon sale if the batch/serial number is not found. If mandatory marking is not used and the batch/serial number is not found, then a transaction will be created with a serial number. The inventory records will then show a holding of ‘-1’ for the item. In other words it is possible to use serial numbers on the sale side without using them on the purchase side.

 

Give total discountCheck this box if a total discount is available on the item. Do not check the box if the ‘item’ being set up is freight or other fees, for example, where a discount is usually not given. The total discount is subtracted from the transaction upon posting, ensuring that the correct revenue is recorded on the sales account right away, rather than the discount being subtracted afterwards. This will result in the discount being the same whether, say, a 10% discount is given by line item or a 10% discount is given in total.

 

BOM. Cost of lines

 

Check this box if the cost price for a BOM and production lists should be calculated automatically based on the contents of the BOM.

 

Item included in the BOM 

Check this box if the item should be included in the BOM.

 

Hide in salesCheck this box if the item should not be shown when entering sales lines.

 

Hide in purchasesCheck this box if the item should not be shown when entering purchase lines.

 

Quantity

 

In stock (Physical)                Automatic field  – number of items physically in stock.

Reserved                               Automatic field  – number of items reserved.

Ordered                                 Automatic field – number of items on order.

Available                               Automatic field – number of items available.

Available for reservation       Automatic field – number of items available for reservation.

 

Size

WeightEnter the weight of the item.
VolumeEnter the volume of the item.
CartonEnter the number of cartons for the item.

 

Brand

Brand                                   Select the brand here if the item should be defined by brand.

Category                              Select the category here if the item should be defined by category.

 

Stock Levels

 

Minimum stock level      Enter the minimum stock level acceptable for the item– this is used to trigger re-orders

 

Maximum stock level     Enter the maximum stock level acceptable for the item – this is used to prevent over ordering

 

Purchase quantity           Enter the minimum amount to be ordered upon purchase – this is also to manage re-orders

 

Default sales quantity    Enter how many of the item is usually sold and this amount will be entered by default upon ordering, but can be edited.

 

Alternative Item

Use Alternative              Select from ‘Never’, ‘Always’ or ‘Zero in Stock’

Alternative item             Select an alternative item to be used, for example a replacement item when this item is not available.

 

EU-sales

Tariff numberEnter the KN8 item code (used for Intrastat statistics).
Country of OriginSelect the country of origin (used for Intrastat statistics).

 

Project, dimensions and variant selections are also available if set up for the company.

 

 

  • Was this Helpful ?
  • YesNo
Categories: Inventory, Unipedia
Home » Unipedia » Items

Get in touch with us

Uniconta

  • Uniconta
  • Modules
  • Downloads
  • Free trial signup
  • Subscription Terms
  • System Status

PARTNER

  • Become a Reseller
  • Uniconta API key application
  • For Developers
  • For Accountants (Univisor)
  • Uniconta Partner info

INFO

  • News
  • Updates
  • Customer cases
  • Video
  • IT Security
  • About us
  • Management

Support

  • Unipedia
  • API information
  • Contacts
  • Visit a Country Site
    • Dansk
    • Uniconta GermanyDeutsch
    • Eesti
    • Uniconta GermanyÍslenska
    • Lietuva
    • Uniconta NetherlandsNederlands
    • Norsk
    • English
Uniconta
© Copyright 2019 | All rights reserved | [email protected] | Terms & Conditions
Facebook LinkedIn Youtube