Solutions Marketplace

Dynavision

Advanced Item & Price Import

Effortlessly import multiple supplier Excel files to create or update items and prices in Business Central.

The Dynavision Advanced Item & Price import app allows you to import Excel or csv files containing item or (purchase) price information immediately into Business Central without the need to manipulate the source file. There’s no need to ask your vendors to provide data in a custom format (e.g. to use RapidStart), neither to do some in-between file conversion / data mapping / transformation using external tools or to setup complex Data Exchange Definitions. Item catalogues, vendor price lists, … in the original format received from your suppliers can easily be imported.
The app supports a wide variety of Excel files.

Full Description

The Dynavision Advanced Item & Price Import includes following features:

  • Field mapping: Seamlessly map Excel fields to Business Central attributes like product names, descriptions, and prices.
  • Unit of Measure mapping: Easily map supplier units of measure to your system with our powerful tool, eliminating confusion and errors from varying standards.
  • Item import: Seamlessly import and convert supplier data from Excel files, saving time and reducing errors in Business Central
  • Price import: Update prices in Business Central effortlessly by importing Excel files from suppliers.
  • End purchase prices from previous period: Import new purchase prices and automatically end prices from the previous period with our powerful capability.
  • Create calculated columns: With this powerful tool, you can effortlessly perform calculations on imported information from Excel files and create new columns in Business Central filled with the results.
  • Row to multiple tables conversion: Transform Excel rows into user-friendly columns in Business Central during imports
  • Apply transformation rules during import: Apply transformation rules easily to imported data for efficient, accurate results without manual adjustments.

By simply following the detailed manual, you’ll be able to process complex Excel files in no time!

USP

The app supports a wide variety of Excel files, including support for (a mix of): single header, multiple worksheets, multiple headers, multiple groups, multiple details  and more. Item catalogs, vendor price lists, … in the original format received from your suppliers can easily be imported. 

Keywords

Distribution

Wholesale

Excel Imports

D365 BC SAAS

Pricing & article information

Screenshots

Solution demo

Specifications

Countries

The Netherlands

United Kingdom

France

Germany

Norway

Sweden

Belgium

France

Ireland

Denmark

Austria

Switzerland

Languages

Dutch

English

French

Industry

All (horizontal)

Product(s)

D365 BC Saas

Retail price range €

! Based on average customer

99 EUR per Business Central production environments

Complexity

Easy

(No training required)

Fair

(Follow online training)

Complex

(Extensive training course required)

Have a question regarding this solution?