Skip to content
Guide

Search the Guide

Enter a query to search the Guide.

Íslenska
Menu
On this page

Filter item mappings

This page is for those who set up mappings for vendors with many item numbers. With filters, one mapping line covers many items.

Purpose

Instead of registering one mapping for each of the vendor's item numbers, you can put a filter in eDoc Map.Value. All items that match the filter then go to the same place in BC, for example all items that start with A to one G/L account. With Tax Category you can split the same filter by tax category.

Prerequisites

Permissions

The user needs the EDOCS permission set.

Steps

  1. Open eDoc Mappings for the vendor.

  2. Create a line with eDoc Type Item and a filter in eDoc Map.Value. The same symbols as in BC filters apply:

    • A* matches all numbers that start with A.
    • 1000..1999 matches numbers from 1000 to 1999.
    • 100|200 matches 100 or 200.
    • * matches all numbers. Use it as a last resort.
  3. Choose BC Type (Item, G/L Account, Fixed Asset or Charge (Item)) and BC Id 1.

  4. To split by tax category, create one line for each tax category with the same filter and fill in Tax Category, for example S. A line with an empty Tax Category catches other tax categories.

  5. Leave eDoc Type 2 and eDoc Map.Value 2 empty. Filters don't work on lines with an accounting cost, item property or additional document reference. Those need an exact value.

This is how the system chooses a mapping for a line on a purchase invoice or purchase credit memo:

Filter item mappings in Business Central

  1. An exact mapping for the item number always takes precedence over filters, see the order.
  2. Then the system tries filters with the same Tax Category as the line.
  3. Then filters with an empty Tax Category.

If more than one filter matches, the system uses the first one in eDoc Map.Value order. Make sure filters don't overlap, and put * in only one line.

Incoming orders from customers

For Order -in and ReturnOrder -in, the system tries filters differently:

  • Tax Category isn't used. To choose by tax category, use BC Type Conditional and put the code of a conditional mapping in BC Id 1. In Conditional Mappings, create lines with that code, Condition VAT Scheme-Category and, in Value, the tax scheme and tax category IDs separated by a hyphen (for example VAT-S).
  • The filter is tested on all of the partner's mapping lines, regardless of eDoc Type. A filter on, for example, a Unit of Measure or Vendor line can therefore catch item lines. Only use filters on item lines for these partners.

Verify

  • Open an electronic document with items that match the filter and choose Check Document. No mapping errors should appear.
  • Choose Convert to BC Document and check that the lines go to the right account by tax category.
  • If something stops, see Help.