Vendor Template

Excel template for importing vendors into Bevica Select. Use it with RapidStart/Configuration Packages during Business Central data migration.

Use this template to create or update Vendors in Bevica.

Before you start

You need:

• ​Excel Template Data Migration​
• ​Configuration Worksheet

When to use this template

Export it from Configuration Worksheet on the Vendor line.

Use it for initial loads and bulk updates.

Dependencies (what must exist first)

• Vendor Posting Group
• Gen. Bus. Posting Group
• VAT Bus. Posting Group
• Location Code (if you populate it)

Step-by-step

1

Export the template

1. Open Configuration Worksheet.
2. Select the Vendor line.
3. Select Excel → Export to Template.

2

Populate rows

1. Create one row per vendor.
2. Format No. as Text in Excel.
3. Use plain values. Avoid formulas.

Minimum viable fields:

No., Vendor Posting Group, Gen. Bus. Posting Group, VAT Bus. Posting Group, Location Code, TVT Duty Status

3

Import and apply

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

4

Verify

1. Open Vendors.
2. Filter on imported No. values.
3. Check posting groups and defaults on the vendor card.

Field reference (template columns)

The template has the following fields:

Field ID / Name	Related Table	FieldType	Note
1 No.		Code 20 (Mandatory)	Unique vendor reference. If vendors are being imported from another system keep the same reference.
2 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
22 Currency Code	(4) Currency	Code 10	If the vendor is invoicing in local currency leave this field blank. Any value entered here must already exist in its related table.
21 Vendor Posting Group	(92) Vendor Posting Group	Code 20 (Mandatory)	Any value entered here must already exist in its related table.
88 Gen. Bus. Posting Group	(250) Gen. Business Posting Group	Code 20 (Mandatory)	Any value entered here must already exist in its related table.
110 VAT Bus. Posting Group	(323) VAT Business Posting Group	Code 20 (Mandatory)	Any value entered here must already exist in its related table.
27 Payment Terms Code	(3) Payment Terms	Code 10	Any value entered here must already exist in its related table.
5701 Location Code	(14) Location	Code 10 (Mandatory)	Sets the default warehouse that this vendor supplies to. Any value entered here must already exist in its related table. Note that all vendors including non stock vendors should have a default location code.
70511 TVT Duty Status		(Mandatory)	Set the default duty status for orders from this vendor: Duty Free or Duty Paid. Note that all non stock vendors should be set up as Duty Paid.
31 Shipping Agent Code	(291) Shipping Agent	Code 10	Any value entered here must already exist in its related table.
70512 TVT Shipping Agent Service Code	(5790) Shipping Agent Services	Code 10	Any value entered here must already exist in its related table.
39 Blocked		Option	Allowed options are: blank, Payment, All. Typically, only blank (no restrictions) or All (complete restrictions) are used.
42 Priority			Specifies the importance of the vendor when running Suggest Vendor Payments.
47 Payment Method
93 EORI Number		Code 40
70503 TVT AWRS URN		Code 20
999999901 ..9999999012Dimension Code	(349) Dimension Value	Code 20	The Excel template will specify the specific dimension code to use here. Only use this field if the dimension code relates to your vendor. Any value entered here must already exist in its related dimension code table. Note: Do not enter values in the Duty dimension column. This dimension is used internally by the system.