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.