Back

Importing Order Address

Excel import templates
Video 12/18
Play
Close
  • Helpful
  • Not helpful
  • Needs update
  • Technical error
Watch "the details", if you need detailed knowledge about a specific topic. These videos are only relevant for particular users. The Details This video includes functionality from the app "Master Data Information" which is available at Microsoft AppSource. Click to visit AppSource. Master Data Information

Playlists  Manage

Log in to create a playlist or see your existing playlists.

Open Playlist
Presenter: Jesper Nielsen, Head of Onboarding

How to import an order address in the master data worksheet?

In this video, I’ll go through the import of order address and I stand in my master data import worksheet and I go to new and import data.

This is what happens in the video

So here I have to find my order address.

That will be that one and I have to find the Excel file where I have the data.

I choose the sheet and that will be the import template where I have my data stored.

We can see that my template is order address.

Action message is create and I have a checkmark in the column accept action messages and it will take all the lines that have a checkmark and handle them.

So let’s have a look.

I go and say carry out actions and okay.

Now I have import success on all the lines which means that everything is ok.

You can see we still have the vendor number and the code here because both numbers are a part of the primary key in Business Central.

So that’s why NYBORG and SVENDBORG are still here.

So vendor number 10,000.

Let’s go and have a look.

Vendor number 10,000 see if they have some order addresses.

Vendor, order addresses, and there they are.

353511259--