Item Template

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

Use this template to create or update Items 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 Item line.

Use it for initial loads and bulk updates.

Dependencies (what must exist first)

• Base Unit of Measure Code
• Inventory Posting Group
• Gen. Prod. Posting Group
• VAT Prod. Posting Group

If you use duty control:

• TVT Duty (Duty Codes)
• valid Alc. % Vol and Unit Volume values per item

Step-by-step

1

Export the template

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

2

Populate rows

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

Minimum viable fields:

No. , Description , Base Unit of Measure , Inventory Posting Group , Gen. Prod. Posting Groups , VAT Prod. Posting Groups

3

Import and apply

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

4

Verify

1. Open Items.
2. Filter on imported No. values.
3. Check posting groups, UoM, and blocking status.

Bevica-specific import rules

We recommend disabling Sales Line Worksheet features while any large item related bulk processes are being run, i.e. creating items, importing balances.

Navigate to Bevica Setup, Sales Line Worksheet fasttab, Enable Sales Line Worksheet.

If you are intending to import data into the LWIN7 field, you need to import the item data first and then the LWIN7 field once the items have been created.

When importing items which are duty controlled, if you make any changes to the B-DM-ITEM template, make sure that you:

• include the Alc. % Vol, Unit Volume and Duty Code fields and all are ticked to be validated
• ensure the Alc. % Vol and Unit Volume fields are before the Duty Code
• do not include the Duty Controlled field - this will be populated by the system as part of validating the Alc. % Vol, Unit Volume and Duty Code

Field reference (template columns)

Field list

The template has the following fields:

Field ID / Name	Related Table / Name	FieldType	Note
1 No.		Code 20 (Mandatory)	Unique item reference. If items are being imported from another system keep the same item reference.
3 Description		Text 100
8 Base Unit of Measure	(204) Unit of Measure	Code (Mandatory)	Any value entered here must already exist in its related table. Set the smallest unit the item will be bought, stored, or sold in, e.g. bottle size, can, brick1
10 Type		Options: Inventory Service Non-Inventory (Mandatory)	Must be one of the options listed. The default is Inventory.
11 Inventory Posting Group	(49) Inventory Posting Group	Code 20 (Mandatory)	Any value entered here must already exist in its related table.
18 Unit Price		Decimal	The price of the item per base unit of measure. Note that the price is in the local currency of your Bevica company.
31 Vendor No.	(23) Vendor	Code 20	Used for filtering and reporting. Any value entered here must already exist in its related table.
41 Gross Weight		Decimal	The base unit gross weight.
44 Unit Volume		Decimal (Mandatory if Duty Controlled)	The item's unit volume.
54 Blocked		Boolean	If set, the item cannot be used on any document.
90 VAT Bus. Posting Gr. (Price)	(323) VAT Business Posting Group	Code 20	Set this if the price above includes VAT. The value must be the VAT Business Posting Group which, when matched with the VAT Product Posting Group, will reflect the VAT % applicable to the price. Any value entered here must already exist in its related table
91 Gen. Prod. Posting Group	(251) Gen. Product Posting Group	Code 20 (Mandatory)	Any value entered here must already exist in its related table.
95 Country/Region of Origin Code	(9) Country/Region	Code 10	Used for filtering and reporting. Any value entered here must already exist in its related table.
99 VAT Prod. Posting Group	(324) VAT Product Posting Group	Code 20 (Mandatory)	Any value entered here must already exist in its related table.
87 Price Includes VAT		Boolean	Set this if the price above includes VAT.
5425 Sales Unit of Measure	(5404) Item Unit of Measure	Code 10 (Mandatory)	If you enter a value in here which is different to the Base Unit of Measure, the import routine will create an Item Unit of Measure record for both the Sales Unit of Measure as well as the Base Unit of Measure.1
5426 Purch. Unit of Measure	(5404) Item Unit of Measure	Code 10 (Mandatory)	If you enter a value in here which is different to the Base Unit of Measure, the import routine will create an item Unit of Measure record for both the Purchase Unit of Measure as well as the Base Unit of Measure.1
5702 Item Category Code	(5722) Item Category	Code 20	Any value entered here must already exist in its related table.
8003 Sales Blocked		Boolean	If set, the item cannot be added to any sales document.
8004 Purchasing Blocked		Boolean	If set, the item cannot be added to any purchase document.
70511 Alc. % Vol.		Decimal (Mandatory if Duty Controlled)	Must be populated if the item is duty controlled.
70504 Code (Duty Code)	(70513) TVT Duty	Code 20 (Mandatory if Duty Controlled)	Any value entered here must already exist in its related table.
70508 Region Code	(70502) TVT Region Code	Code 20	Used for filtering and reporting. Any value entered here must already exist in its related table.
70512 Vintage		Code 10	Optionally enter the vintage.
999999901.. 999999912 Dimension 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 item. Any value entered here must already exist in its related dimension code table. Note: Do not populate the Duty dimension column. This dimension is used internally by the system.

If you import your item with a Base Unit of Measure as 37.5cl and your Sales Unit of Measure and Purchase Unit of Measure as 12x37.5cl, both units of measure will be created in the Item Unit of Measure table.

You only need to consider importing into the Item Unit of Measure table if you have a different unit of measure other than the base, sales and purchase units of measure.