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

What can be converted to Uniconta?

1,158 views 16 November 2017 22 March 2018 4 minutes
Print Friendly, PDF & Email

Learn more about:

  • Layout
  • Filter/Clear Filter
  • Templates
  • How to search in Uniconta
  • Attachments
March 22nd, 2018
Uniconta has developed a free conversion tool that enables users to easily and securely convert to Uniconta from other financial management systems, such as Microsoft Dynamics C5, e-conomic, NAV and eCtrl/Axapta.

A conversion module is now included in the Uniconta application for Windows. However, the conversion tool can also be obtained as a separate application here.

 

The following data is automatically included upon conversion

C5e-conomicNAVeCtrl
Accounting year, VAT codes, chart of accounts, system accounts

✓

✓

✓✓
Journals

✓

General ledger transactions

✓

✓

✓✓
Customer master data and transactions, customer groups,  terms of payment and contacts

✓

✓

 ✓✓
Vendor master data and transactions, vendor groups, terms of payment and contacts

✓

✓

✓✓
Inventory master data and inventory groups

✓

✓

✓
Inventory BOMs, inventory pricing and pricing groups

✓

✓
Orders and order lines

✓

✓

Purchases and purchase lines

✓

Notes on orders and purchase lines.

✓

Employees

✓

✓
Dimensions: department, carrier and objective

✓

✓✓
Physical vouchers✓✓
Quotations and order notes✓
Conversion amendments:

We have amended the conversion process for customer and vendor transactions for C5, as we found that our new method yields better and more accurate results.

Uniconta now imports all posts before attempting to match them. Once the import is complete, Uniconta carries out an automatic matching process.

Exchange rate differences from C5 are now included in customer and vendor transactions rather than as separate posts.

Customer, vendor and inventory notes are now included in the conversion from C5.

✓

Account numbers are left aligned

All account numbers in Uniconta are left aligned, since characters may also be included in account numbers. The account number field is a text field and is therefore sorted in the same way as a text field.

Account numbers in C5 are right aligned and will therefore appear in a different order after conversion.

 

Right aligned account number order in  C5:These will be shown as follows, when left aligned in Uniconta:To avoid confusion with Unicontas left aligned account numbers, it is possible to insert ‘o’s in front of the C5 account numbers upon conversion, to make them the same length. They will then look like this:

2

21

100

1001

2001

10009

 

100

1001

10009

2

2001

21

 

00002

00021

00100

01001

02001

10009
and thus they are in the same order as in C5

 

Changing account numbers

Account numbers are easy to change in Uniconta. If the user wishes, for example, to delete the extra ‘0’s inserted in front of the account numbers once conversion is complete, then this can easily be done.  All transactions and references will be automatically updated to reflect any changes made. So either the user keeps the extra ‘0’s or they re-number the Chart of Accounts.

Re-numbering is made quick and easy with the use of the ‘Edit all’ tab under General Ledger/Chart of Accounts,  as shown in the screenshot below. The ‘Edit all’ tab allows the user to go through the whole Chart of Accounts row by row (like in a spreadsheet) and replace the old account number with a new one.

 

 

 

Deleting codes

In C5 it is possible to delete values/codes (departments, VAT codes, payment code etc.) even if they are used in accounts or transactions. It is not possible to do this while ‘live’ in C5, but the data can be manipulated.

In Uniconta it is not possible to delete values/codes that are include in an account or transaction. Uniconta does not allow a field to contain a code that does not exist. The conversion program checks that all of these codes exist upon conversion, before allocating them to a transaction or account. If they do not exist then the field is left empty.

 

General ledger, customer and vendor transactions

Uniconta and C5 work in a similar way when posting transactions. If the day book is used to post transactions for a customer or a vendor, then the transaction also appears in the customer or vendor account as well as in the master account in the general ledger. In Uniconta, there is a field in the list of posted transactions in the general ledger, that shows which customer/vendor is on the original post.

Upon conversion, everything is posted in Uniconta again from start to finish, to ensure that each entry balances. All general ledger transactions from C5 are imported into Uniconta’s posting journal and a day book is created for each accounting year.

The next step is to import the customer and vendor transactions. Once imported, these are stored and each transaction is taken, one at a time, and matched to the original transaction in the posting journal that was just imported. The transactions are traced to their master account, which is then replaced with the customer/vendor account to create the ‘original’ transaction.

When searching for the ‘original’ customer/vendor transaction in the posting journal, the system searches only for master accounts. This ensures that the posting can always be traced back a master account. During this procedure, the system therefore only replaces account numbers on a journal that have a master account.

Note! C5’s master accounts are found by searching in the customer/vendor groups. If the C5 user has ever used a different master account for a customer/vendor group than is currently used, then we will not find the relevant account number and can therefore not replace the account number in the journal.

If we find a customer/vendor posting that cannot be traced to the original posting, then we will need to make two extra journal entries. We will make an entry on the customer/vendor account and a the counter entry on the customer/vendor master account, so that these balance out upon posting.

Once imported, the conversion program posts the journals. Once all journals are posted, the conversion program creates the opening balances for each accounting year.

 

Uniconta’s conversion tool supports:

  • Conversion from C5 version 1.6 including general ledger, customer and vendor transactions as well as inventory setup.
  • Conversion from e-conomic (Denmark) including general ledger, customer and vendor transactions as well as inventory setup.
  • Conversion from e-conomic (Norway) including general ledger, customer and vendor transactions as well as inventory setup.
  • Conversion from e-conomic (Sweden) including general ledger, customer and vendor transactions as well as inventory setup.
  • Conversion from e-conomic (UK) including general ledger, customer and vendor transactions as well as inventory setup.
  • Conversion from NAV including general ledger, customer and vendor transactions as well as inventory setup.
  • Conversion from eCtrl including general ledger, customer and vendor transactions as well as inventory setup and scanned in vouchers.

 

  • Was this Helpful ?
  • YesNo
Categories: Inventory, Unipedia
Home » Unipedia » What can be converted to Uniconta?

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