LOGISTICS

LOGISTICS | Gain razor sharp control of your storage units

Uniconta’s Logistics option significantly expands both the General Ledger module and Stock Management to include a wide range of functions. These additional functions can be switched on and off according to the company’s current needs. 

Companies using Logistics gain razor sharp control of their storage units, allowing them, for instance, to keep track of batches and units as well as calculate the actual value of inventory purchases and sales.

Batch-/serial numbers

Batch number management, for example, for perishables, includes expiration dates, comment fields, serial number management on units and warranty management.

Inventory item text

Uniconta’s standard item text is 60 characters. If, however, users need to include longer product texts or translate them into foreign languages, they will need to use Uniconta’s Logistics functions and use ‘Item name groups’. Item name groups allows users to write up to 1,000 characters of text on each inventory item.

Bills of Materials (BOMs)

Logistics can be used to create BOMs and production BOMs. BOMs can then be compared to summary lists and can also be used, for example, to handle any fees. When the BOM is invoiced, the contents of the inventory items and services are then deducted from the BOM. Production orders and production BOMs are included in Uniconta’s Production module.

Inventory unit conversion

Our inventory module can now convert units. This allows users to buy and sell in units predetermined by the user, based on the units that they use in their warehouses. Users first need to create a unit conversion group. This group will contain lines for the user to enter the conversion factor. Users do not need to enter conversion factors between the geometric units (such as meters and centimeters) since this has already been coded into the Uniconta core. Conversion factors are only required between units, such as crates and pieces.

After creating a group, you assign a unit group to the item card, in order that it can be converted. It is also possible to specify standard sales and purchase units on each item card. Users can also specify units in the price lists under Inventory/Maintenance. If an invoice is updated, all item lines will be stored in the item's unit shown on the card. When an invoice is reprinted, Uniconta will then automatically calculate backwards from the item’s unit and list the sales/purchase unit on the invoice. This way there are no changes to the inventory reports, since all transactions only exist in the item’s specified unit.

Duty module

Duty can be calculated as a ”Fixed amount”, ”Amount per unit”, ”Percentage of net amount” or ”Percentage of cost amount”. Next is the ”Factor” since it is dependent on the Duty calculation method.

The ”Show on invoice” function allows the user to select how the duty appears on the invoice:
• ”Order line” creates new order line that shows the duty. If the ”Item number” field is filled out on the duty, then the order line will show this inventory item number. Postings will then also be made according to this item number
• ”Include in unit price” increases the unit price by the "Factor" but will not post it as revenue. Even though the price on the order line is increased by the duty, the duty is still accounted for separately. The sale is posted as if there were no duty on it and the duty is posted separately to a ”Duty account” and an ”Offset account”. If the duty has an item number, then it will be posted according to this number
• ”Hide” means that the duty will affect the accounting but not the invoice. This accounting method is similar to "Include in unit price" method, only the customer is not charged for the duty.

Logistics features

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. ​

Customer Price Lists

  • Create customer price lists and combine them with discounts and promotional periods
  • Prices are used for sales orders and ‘Quick’ invoices

Vendor Price Lists

  • Create vendor price lists and combine them with discounts
  • Prices are used for purchase orders and suggested as a purchase price

Customer Item Numbers

  • Customer item numbers can be created under item name groups
  • Customer item numbers can be included on documents

Stock Management

  • Stock management needs to be switched on if users want detailed management of their inventory
  • Stock management shows inventory that is available, reserved, shipped, and ordered
  • Moving items in the inventory journal now includes ‘To dimension’
  • Counting list with series/batch numbers
  • BOMs include discount percentages on the order lines
  • Accounts for gains and losses and as well as adjustment accounts are system accounts in the Chart of Accounts and can also be selected on the Inventory group
  • Sell by date in the inventory journal now can be used with batch and serial numbers.
  • Warehouse and location in BOMs

EAN on pricelists

  • Price lists include an EAN number. When an EAN number is added to order lines, quotations and purchase orders, Uniconta first looks to see whether an inventory ítem has an EAN number and then it looks at the price list. If there is an EAN number here, then Uniconta will enter the ítem number, Price, amount and discount from the price list. So the same inventory ítem can have several EAN numbers. 

All Items

  • Stock management can be activated for individual items or for all items
  • When ‘All items’ is selected, all items with the type ‘Item’ are included in Stock management
  • Stock management will not include anything given the type ‘Service’

Warehouse

  • Stock management is available by ‘warehouse’, which can be used, for example, to manage by town, country, truck or workshop

Location

  • Location is used to give ‘Warehouse’ an additional dimension e.g. row, case, shelf, hall

Item variants

  • Item management by variant – max. 2 variants e.g. sizes and colours
  • EAN numbers can be set up on variants and cost prices
  • When using variants, all allowable combinations can be selected by one click

Serial and Batch numbers

  • Serial number and batch checks for correct cost price
  • Batch/serial numbers – startup quantity, the number where the user wishes the batch/serial numbers to begin from
  • Series/batch numbers must now unique for the same inventory item

Reports

  • Item stock status – calculates the stock value on a given date
  • On-hand – shows on-hand stock in general as well as by warehouse and variant
    – sales order lookup – purchase order lines
  • Re-order list – calculates the need to re-order inventory items based on set up
  • Inventory reservations show what is reserved, ordered, drawn and delivered across all of the modules, so users can easily view item status
  • BOM reservations, enabling users to break down BOM reservations in the re-order list by the contents of the BOM
  • Inventory report displaying BOMs

Read more about our other modules

Do NOT follow this link or you will be banned from the site!