> For the complete documentation index, see [llms.txt](https://kb.bevica.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://kb.bevica.com/bevica-select/bevica-select-data-migration/bevica_select_-_data_migration_and_go-live-templates/bevica_select_-_item_template.md).

# 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](/bevica-select/bevica_select_training/bevica_select_-_excel_template_data_migration.md#excel-template-data-migration)
* [Configuration Worksheet](/bevica-select/bevica_select_training/bevica_select_-_excel_template_data_migration.md#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

{% stepper %}
{% step %}

### Export the template

1. Open **Configuration Worksheet**.
2. Select the **Item** line.
3. Select **Excel** → **Export to Template**.
   {% endstep %}

{% step %}

### 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`
{% endstep %}

{% step %}

### 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**.
   {% endstep %}

{% step %}

### Verify

1. Open **Items**.
2. Filter on imported `No.` values.
3. Check posting groups, UoM, and blocking status.
   {% endstep %}
   {% endstepper %}

### Bevica-specific import rules

{% hint style="warning" %}
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**.
{% endhint %}

{% hint style="danger" %}
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.
{% endhint %}

{% hint style="info" %}
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
  {% endhint %}

### Field reference (template columns)

#### Field list

The template has the following fields:

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

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.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://kb.bevica.com/bevica-select/bevica-select-data-migration/bevica_select_-_data_migration_and_go-live-templates/bevica_select_-_item_template.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.