Customer Ship-to Addresses Template

Excel template for customer ship-to addresses in Bevica Select. Import delivery addresses during Business Central data migration.

Use this template to create Ship-to Addresses (delivery points) for customers.

Ship-to addresses depend on customers. Import customers first.

Before you start

You need:

• Customer Template
• ​Excel Template Data Migration​
• ​Configuration Worksheet

When to use this template

Export it from Configuration Worksheet on the Ship-to Address line.

Use it to set default delivery details per customer site.

Step-by-step

1

Export the template

1. Open Configuration Worksheet.
2. Select the Ship-to Address line.
3. Select Excel → Export to Template.

2

Populate rows

1. Create one row per delivery point.
2. Use a stable Code for each site. Example: postcode, city, or site name.
3. Format Customer No. and Code as Text in Excel.

Minimum viable fields:

Customer No. , Code, Name , Address , Post Code, City , Country/Region Code

3

Import and apply

1. Back on the Ship-to Address line, select Excel → Import from Template.
2. Fix any errors in the preview.
3. Select Apply Data.

4

Verify

1. Open a customer card. Open Ship-to Addresses. Confirm defaults like Location Code, Shipping Agent Code, and Shipping Agent Service Code.

Field reference (template columns)

Field list

The template has the following fields:

Field ID / Name	Related Table	FieldType	Note
1 Customer No.		Code 20 (Mandatory)	The customer must already exist.
2 Code		Code 20 (Mandatory)	Enter a unique reference for this customer. e.g. the Post Code, the City or the customer's Name for this site.
70503 TVT Duty Status	(70516) TVT Duty Status	Code 20	This sets the duty status on sales document created for this Ship-to address. If left blank the default is DUTY PAID.
3 Name		Text 100
5 Address		Text 100
6 Address 2		Text 50
7 City		Text 30
92 County		Text 30
91 Post Code		Code 20
35 Country/Region Code	(9) Country/Region	Code 10	Any value entered here must already exist in its related table.
9 Phone No.		Text 30
102 E-Mail		Text 80	Note that it is only possible to add one email address into this field. You are unable to enter more than one separated by a semi-colon.
83 Location Code	(14) Location	Code 10	This sets the warehouse goods are typically shipped from when delivering to this delivery point. If left blank Users will need to populate it on each sales document. Any value entered here must already exist in its related table.
31 Shipping Agent Code	(291) Shipping Agent	Code 10	Used to denote who is transporting the goods for planning purposes. Any value entered here must already exist in its related table.
5972 Shipping Agent Service Code	(5790) Shipping Agent Services	Code 10	Used to denote the service provided by the Shipping Agent above. Any value entered here must already exist in its related table.