MinubaConnect - setup

Setup:

 

The latest PDF version of the guide to setting up MinubaConnect can be found here

 

MinubaConnect - general:

The following should be taken into consideration:

 

  • Download MinubaConnect via the BC Marketplace

  • For OnPrem: access to the Dynamics 365 Business Central back end

  • The Minuba menus can be found on the roles Accountant, Chief Financial Officer, Business Manager and the BusinessManager evaluation role.

  • If the customer receives scanned documents (vendor invoices) in Minuba via a third party (e.g. FutureLink), make sure to select the company registration number (CVR) so that it is included in what is scanned. We have experienced phone numbers ending up where the CVR number should be in Minuba, and this can cause problems on import.

  • The Minuba FIK string on invoices to customers was developed for use with e-conomic/Uniconta, and must therefore be handled through extra programming. The FIK string contains a digit between the invoice no. and the check digit that tells whether it is an invoice or an account statement being paid; standard BC/NAV cannot handle this "extra" digit. Continia Payment Management, however, handles this extra digit well, so it will not cause problems in that connection.

 

The following is an extract from a very early version of the MinubaConnect guide.

 

Table of contents of the guide:

 

  • Setup in Minuba Page 3

 

  • Setup in BC/NAV Basic setup Pages 4 - 15 Order types Page 16 Departments Page 17 Invoice posting Pages 18 – 19 Orders/jobs (add-on modules) Page 20 Invoice log Page 21

 

  • Minuba import Page 22 Job queue entry Page 22

 

  • Customer export Page 23

 

  • Blacklist Page 23

 

  • Item dimensions Page 24

 

  • Customer reconciliation/Vendor reconciliation Page 24

 

  • Import to general journal / sales invoice Page 24

 

  • Daily use General journal (purchase invoice) Page 25

 

Further information

The following is from an older guide and will be updated going forward.

 

General

  1. Find Minuba in the ribbon or via the 3 dashes on the far right

 

General

  1. Search for Minuba or go to Departments/Company name/Minuba

 

Tasks:

 

Export of customers to Minuba

This is where NAV customers are exported to Minuba for the first time

 

  1. Select Export of customers to Minuba

  2. Click and it runs.

 

NOTE – A Minuba customer number contains only digits. If you have customer numbers in NAV that contain letters and special characters, they should be renamed beforehand.

 

Import of data from Minuba

This is where documents are imported to NAV, or customers that have already been created in Minuba

 

  1. Select Import of data from Minuba

  2. Click and it runs – this requires that this part has been set up in General setup under Setup.

  3. This run can subsequently be installed as 2 separate imports, one for sales invoices and one for vendor invoices, which are placed in the journals that have been created for this purpose.

 

Reports and analysis:

 

Customer invoice reconciliation

This run can be used to reconcile whether the VAT in Minuba has been posted in NAV

 

  1. This report does not work in NAV 2013, as it does not support Excel

 

Vendor invoice reconciliation

This run can be used to reconcile whether the VAT in Minuba has been posted in NAV

 

  1. This report does not work in NAV 2013, as it does not support Excel

 

Setup:

The setup of G/L posting (customers), purchase invoices and dimensions in NAV can be set up in detail on the basis of Departments, Materials and Order types in Minuba.

 

In Minuba these are set up under Administration

 

Setup / Minuba setup

This is where you set up the integration between NAV and Minuba; the items are reviewed below

 

General

  1. Fill in the fields described below

 

Field

Description

URL

Path to the Minuba solution

Auth. method

Enter Key or User name / Password

Key

Enter the key; it is retrieved from a user in Minuba under Settings / Administration / Users – select the user / Advanced settings / copy the user key for API (authkey) and paste it here

Name

Enter the Minuba user name of the key (first name and last name)

User name

Enter the user name for Minuba (if not using a key)

Password

Enter the password for Minuba (if not using a key)

Password encrypted

Select if encrypted

 

Customer synchronisation

  1. Fill in the fields described below

 

Field

Description

Import customers

Select whether customers are to be imported from Minuba

Customer template

Enter the customer template to be used when creating new customers during import of customer invoices. See an example of a customer template on the next page

Address info from

Enter Invoice address or Contact address

  1. Minuba has 3 types: Invoice, Contact and Installation. Installation cannot be imported into NAV customers

  2. For Invoice address, for example the email must be stated on it before it is imported.

Import delivery address

Select whether the delivery address is to be imported

 

Example of a customer template for use with Minuba import

 

Invoice synchronisation

  1. Fill in the fields described below

 

Field

Description

Import invoice

Select whether invoices are to be imported from Minuba

Posting type

Enter General journal or Sales invoice. General journal – when invoicing from Minuba. Sales invoice – when invoicing from NAV/BC. During testing, always use General journal, as Sales invoice takes a number during creation that cannot be reset.

General journal template

Enter the general journal template

General journal name

Enter the general journal name

Posting level

Enter Line or Account no.

Line: lines are imported individually

Account no.: all lines are collected into one line

Posting text

Enter the posting text (Minuba-vendor invoice %1); entering this text will override the text from Minuba. %1 = Invoice no. %2 = Customer no. %3 = Customer name (truncated at 20 characters) %4 - %10 can be set up as desired.

 

Vendor invoice synchronisation

  1. Fill in the fields described below

 

Field

Description

Import vendor invoice

Select whether

Vendor match

Enter CVR no. or Phone number. CVR no. requires that the field VAT/CVR No. is filled in on the vendor.

Product posting group

Enter which product posting group is to be used as the default.

VAT product posting group

Enter the VAT product posting group for documents with VAT, e.g. VAT-25

VAT product posting group

No VAT

Enter the VAT product posting group for documents without VAT, e.g. Exempt

General journal template

Enter the general journal

General journal name

Enter the general journal name

Posting text

Enter the posting text (Minuba-vendor invoice %1); entering this text will override the text from Minuba.

 

When importing an FI code, it can be an advantage to use a purchase journal that has been prepared for this, if you want to see the fields in that context

 

  1. The payment method code (FIK71/BANK) and the (FI) vendor no. must be inserted by a programmer

  2. Press OK

 

Invoice posting

Invoice posting of sales invoices should be set up in cooperation with your NAV reseller

 

  1. Select Invoice posting, select New

  2. Fill in the fields described below

 

Field

Description

Department name

Enter Department - Department imported from Minuba, and can be used for posting setup

Order type

Enter Order type - Order type is imported from Minuba, and can be used for posting setup

Material code

Enter Material no. – if you want a specific Material no. in Minuba posted differently from the general setup of Type.

Type

Enter Type - these are imported automatically from Materials in Minuba, and can be used for posting setup

Product posting group

Enter the product posting group to be used in relation to Department, Order type, Materials and Type. It can be individually or a combination of several.

VAT product posting group

(VAT)

Enter the VAT product posting group, e.g. VAT-25

VAT product posting group

(No VAT)

Select the VAT product posting group, e.g. Exempt

Default unit

Unit designation for this posting combination, mainly used when invoicing from NAV and OIOUBL via G/L account lines on sales invoices.

 

  1. Repeat step 2 to set up posting for all Departments, Material codes and Types

  2. Press OK

 

Order type – dimensions

Dimensions in NAV are applied based on Order type in Minuba and should be set up in cooperation with your NAV reseller.

 

  1. Select Order type – dimensions

  2. Import order types from Minuba

  3. Fill in the fields described below with the corresponding information from Minuba.

 

Field

Description

Name

Filled in via 'Import order types' from Minuba

Description

Enter a short description of Name

Global Dimension 1 Code

Enter the Global Dimension 1 Code in NAV or leave blank (here Department)

Global Dimension 2 Code

Enter the Global Dimension 2 Code in NAV or leave blank (here Project)

 

  1. Repeat step 2 to select Department or Project for all Order type - dimensions

  2. Press OK

 

Department – dimensions

Dimensions in NAV are applied based on Department in Minuba and should be set up in cooperation with your NAV reseller.

 

  1. Select Department – dimensions

  2. Import departments from Minuba

  3. Fill in the fields described below with the corresponding information from Minuba.

 

Field

Description

Name

Filled in via 'Import departments' from Minuba

Global Dimension 1 Code

Enter the Global Dimension 1 Code in NAV or leave blank (here Department)

Global Dimension 2 Code

Enter the Global Dimension 2 Code in NAV or leave blank (here Project)

 

  1. Repeat step 2 to select Department or Project for all Department - dimensions

  2. Press OK

 

Import blacklist

Here it is possible to blacklist documents from import via Minuba that would otherwise be imported again and again.

 

Field

Description

Type

Enter Vendor invoice or Customer invoice

Account

Enter the vendor's account no.

Document no.

Enter the document no.

 

Setup of general journal or purchase journal

 

These 2 fields can be added to, for example, the general journal and sales invoice by your NAV reseller

 

After this you are ready to get started!

 

Enjoy.