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
-
Find Minuba in the ribbon or via the 3 dashes on the far right
General
-
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
-
Select Export of customers to Minuba
-
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
-
Select Import of data from Minuba
-
Click and it runs – this requires that this part has been set up in General setup under Setup.
-
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
-
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
-
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
-
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
-
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
-
Minuba has 3 types: Invoice, Contact and Installation. Installation cannot be imported into NAV customers
-
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
-
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
-
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
-
The payment method code (FIK71/BANK) and the (FI) vendor no. must be inserted by a programmer
-
Press OK
Invoice posting
Invoice posting of sales invoices should be set up in cooperation with your NAV reseller
-
Select Invoice posting, select New
-
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.
-
Repeat step 2 to set up posting for all Departments, Material codes and Types
-
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.
-
Select Order type – dimensions
-
Import order types from Minuba
-
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)
-
Repeat step 2 to select Department or Project for all Order type - dimensions
-
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.
-
Select Department – dimensions
-
Import departments from Minuba
-
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)
-
Repeat step 2 to select Department or Project for all Department - dimensions
-
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.
