Overview

This document is a quick reference guide how to import vendors and bank accounts via configuration packages.

How to find

Go to Departments/Administration/Application Setup/RapidStart Services for Microsoft Dynamics NAV/Configuration Packages, or use Search Box to find Configuration Packages.

Here you have special configuration package named Brokerdeal Cashback Vendors prepared for the Brokerdeal Cashback vendor import.

Open

How to import data

How to prepare the import file

For the import you need the Vendor Import Template excel sheet. Prepare the data for the import by filling them up into this excel sheet. This file includes two sheets – Vendor and Vendor Bank Account. Please be sure that you will only paste or fill up here the data.

Open

Vendor sheet fields

No.

Assign the No. manually according to your company habits, see below.

Name

Fill up the name of the vendor.

Vendor Posting Group

Always fill in this field GENERAL.

Currency code

Code of the vendor’s currency - (always blank for EURO currency). Please, fill in GBP for Pounds, USD for Dollars, etc.

VAT Registration No.

This is VAT Registration number of the vendor.

Gen. Bus. Posting Group

Always fill in this field GENERAL.

VAT Bus. Posting Group

EU-REG – this code is for EU VAT registered customers, except for Maltese one.

LOCAL – this code is for Maltese customers.

NON-EU – this code is for NON EU customers

NON-REG-EU – this code is for EU VAT non registered customers, except for Maltese one.

Preferred Bank Account

Assign here Bank Account code from the sheet Bank Account. You can specify this code manually. Format is up to you. See the data sample above, in the first part of the chapter 3.

Bank Account sheet fields

Vendor No.

Please assign here the same value from the field No. in the Vendor sheet.

Code

You can specify this code manually. Format is up to you. See the data sample above, in the first part of the chapter 3. Please be sure, that this field value is the same, as in the Vendor sheet.

Name

This is the field for the name of the bank account.

IBAN

This is the field for the bank account IBAN code.

SWIFT Code

This is the field for the bank account SWIFT code.

Importing data through a configuration package

Once you get the MS Excel file and your data are entered into the MS Excel Sheet, you can start with the import.  Make sure that the import file is not open and open the configuration package BD CASH VENDORS.

Addressing import errors

Errors encountered during the import process are highlighted in red accordingly along with a respective count. To fix the error you must follow the steps below: 

• Click on the count value found under No. of Package Errors. In Figure 13 the count is depicted as 1. The error entry in particular is displayed.

• Click on Show Error in the HOME tab to open the Package Error page.

• The error in this case is data exceeding the character limit. You can either amend the excel and reupload accordingly, or you can amend the data directly from NAV.

• The latter can be done from the page illustrated in Figure 14. Find the field causing the error and change the value. The entry should disappear from the screen and the count reduced accordingly.

Applying a package

The import done so far has not been committed to the database. To do so, you must apply the package so that all new records and/or amendments are reflected.

This is triggered from the Apply Package process in the Home tab. Once it is completed a confirmation message with all the results will be displayed.