Location-Based VAT for Items

# VAT Rate per Dimension - User Guide

Location-Based VAT for Items

Version: 1.0
Last Updated: February 2025
Audience: Business Central Users, Sales Teams, Finance Teams

Introduction

What is this feature?

The Location-Based VAT for Items feature automatically adjusts the VAT (Value Added Tax) product posting group for items on sales lines based on the location where the items will be shipped from.

Why would you use this?

Imagine your company:

Sells the same item from multiple locations (domestic, EU, USA)
Each location has different VAT rules (domestic 25%, B2B EU 0%, USA export 0%)
You want the correct VAT rate to apply automatically, without manual intervention

Without this feature: You manually change VAT posting groups on every sales line.

With this feature: The system automatically applies the correct VAT posting group based on location.

Benefits

✅ Accuracy: Eliminates manual VAT posting group selection errors
✅ Speed: No manual adjustments needed per line
✅ Compliance: Ensures correct VAT treatment per location
✅ Flexibility: Easy to update rates and locations over time
✅ Transparency: Clear audit trail of what VAT rate was applied

How It Works

The Basic Concept

Item: LAPTOP-001
Default VAT Group: STANDARD (25% Danish VAT)

When you sell from different locations:

Location: DK-HQ          →  STANDARD (25%) ← Domestic
Location: DE-STORE       →  B2B-INTRA-EU (0%) ← B2B EU
Location: US-STORE       →  US-EXPORT (0%) ← USA Export

The Process

Here's what happens step-by-step when you create a sales order:

STEP 1: Create Sales Order
        ↓
STEP 2: Add Item Line with Location Code = "DE-STORE"
        ↓
STEP 3: System detects location and checks for mappings
        ↓
STEP 4: System finds mapping: STANDARD → B2B-INTRA-EU
        ↓
STEP 5: System automatically changes:
        Line.VAT Prod. Posting Group = B2B-INTRA-EU
        ↓
STEP 6: VAT % is calculated automatically (0% from setup)
        ↓
STEP 7: Line Amount (Incl. VAT) shows correct total

Result: User doesn't have to do anything! ✓

System Logic Flow

┌────────────────────────────────────────┐
│ User sets Location Code on Sales Line   │
└────────┬──────────────────────────────┘
         │
         ▼
┌─────────────────────────────────────────┐
│ Is "Advanced VAT for Sales" enabled?    │
└────────┬──────────────┬────────────────┘
         │              │
       YES              NO
         │              │
         ▼              └─→ [No action - use defaults]
    ┌────────────────────┐
    │ Does Location have  │
    │ mapping configured? │
    └──────┬─────────┬───┘
           │         │
         FOUND      NOT FOUND
           │         │
           ▼         ▼
      ┌─────────────────────┐
      │ Override to mapped   │ Fallback to item's
      │ VAT Prod. Group     │ default VAT group
      │                      │
      │ Example:            │
      │ STANDARD →          │ Example:
      │ B2B-INTRA-EU        │ Keep STANDARD
      └─────────────────────┘
           │                 │
           └────────┬────────┘
                    ▼
      ┌──────────────────────────────┐
      │ Calculate VAT % from:        │
      │ VAT Posting Setup table      │
      │ (Bus. Group + Prod. Group)   │
      └──────────────────────────────┘
           │
           ▼
      ┌──────────────────────────────┐
      │ Line Amount (Incl. VAT)      │
      │ calculated correctly ✓       │
      └──────────────────────────────┘

Getting Started

Prerequisites

Before using this feature, you need:

✅ The VAT Rate per Dimension app installed and activated
✅ Valid license for the app
✅ Locations defined in your system (e.g., DK-HQ, DE-STORE, US-STORE)
✅ VAT Product Posting Groups created (e.g., STANDARD, B2B-INTRA-EU, US-EXPORT)
✅ VAT Posting Setup configured with VAT rates for each combination

Checking Prerequisites

Step 1: Verify App is Enabled

Search for: "VAT Rate per Dim. Setup"
Open the page
Look for: "Advanced VAT for Sales" field
Check: Is it enabled (☑)?

If not enabled, ask your administrator to enable it.

Step 2: Verify Locations Exist

Search for: "Locations"
You should see your shipping locations:
- DK-HQ
- DE-STORE
- US-STORE
- Etc.

If locations are missing, contact your administrator.

Step 3: Verify VAT Posting Groups Exist

Search for: "VAT Product Posting Groups"
You should see groups like:
- STANDARD
- B2B-INTRA-EU
- US-EXPORT
- Etc.

Configuration Guide

Who Should Do This?

This configuration should be done by someone with:

Access to setup pages
Knowledge of your company's VAT rules
Understanding of locations and VAT treatment

Typically: Finance Manager or System Administrator

Configuration Process

Step 1: Enable the Feature

Search for: "VAT Rate per Dim. Setup"
Open the page
Locate the record (Primary Key = blank)
Set: "Advanced VAT for Sales" = ☑ (Enabled)
Click: Save (or press Ctrl+S)

Step 2: Create Location Mappings

From the VAT Rate per Dim. Setup page, click the link:
"VAT Rate Advanced Sales Product Posting Group"

OR

Search for: "VAT Rate Advanced Sales Product Posting Group"
Click: New to create a new mapping
Fill in the following fields:

Field: Starting Date

What it is: The date from which this mapping is effective
Example: 01-01-2025
Why it matters: Allows you to change VAT rules on specific dates (e.g., tax law changes)

Field: Location Code

What it is: The shipping location
Example: DE-STORE, DK-HQ, US-STORE
Action: Click the dropdown or type the location code

Field: Transl. VAT Prod. Posting Grp (From)

What it is: The item's DEFAULT VAT product posting group
Example: STANDARD
Typical value: Whatever VAT group your items have by default
Action: Type or select from dropdown

Field: VAT Prod. Posting Group (To)

What it is: The NEW VAT product posting group to use when selling from this location
Example: B2B-INTRA-EU
Action: Type or select from dropdown

Example Configuration

Here's a real example of what your mappings might look like:

Mapping 1 - Denmark (Domestic):
  Starting Date:                  01-01-2025
  Location Code:                  DK-HQ
  From VAT Prod. Posting Group:   STANDARD
  To VAT Prod. Posting Group:     DK-DOMESTIC
  
Mapping 2 - Germany (B2B EU):
  Starting Date:                  01-01-2025
  Location Code:                  DE-STORE
  From VAT Prod. Posting Group:   STANDARD
  To VAT Prod. Posting Group:     B2B-INTRA-EU
  
Mapping 3 - France (B2B EU):
  Starting Date:                  01-01-2025
  Location Code:                  FR-STORE
  From VAT Prod. Posting Group:   STANDARD
  To VAT Prod. Posting Group:     B2B-FRANCE
  
Mapping 4 - USA (Export):
  Starting Date:                  01-01-2025
  Location Code:                  US-STORE
  From VAT Prod. Posting Group:   STANDARD
  To VAT Prod. Posting Group:     US-EXPORT

Step 3: Verify VAT Posting Setup

Important: For the VAT rates to be calculated correctly, you must have VAT Posting Setup entries for all combinations.

Search for: "VAT Posting Setup"
You should see entries like:

VAT Bus. Posting Group | VAT Prod. Posting Group | VAT % | VAT Account
DOMESTIC               | DK-DOMESTIC             | 25%   | 4700
EU-INTRA               | B2B-INTRA-EU            | 0%    | 4700
EU-INTRA               | B2B-FRANCE              | 0%    | 4700
EXPORT                 | US-EXPORT               | 0%    | 4700

If any combinations are missing:

Click: New
Fill in all required fields
Click: Save

Note: This is usually done by your system administrator.

Using the Feature

Creating a Sales Order

Scenario: Selling to Germany

Create Sales Order:
- Search for: "Sales Order"
- Click: New
- Fill in Customer, Ship-To Address (Germany), etc.
Add Item Line:
- Click: Lines tab
- Click: New Line
- Type: Item
- Item No.: LAPTOP-001
- Quantity: 1
- Location Code: DE-STORE ← This is the key!
Watch the Magic:
- After you set Location Code and move to the next field
- System automatically changes:
  - VAT Prod. Posting Group: STANDARD → B2B-INTRA-EU
  - VAT %: 25% → 0%

Result:

Amount (Excl. VAT): 10,000 DKK
Amount (Incl. VAT): 10,000 DKK ← No VAT added (0%)

What Happens Behind the Scenes

When you set the Location Code:

System registers the change
System checks: Is "Advanced VAT for Sales" enabled? → YES
System looks up the item's default VAT group → STANDARD
System searches for mapping: Location = DE-STORE, From = STANDARD
System finds: → To = B2B-INTRA-EU
System applies: Line.VAT Prod. Posting Group = B2B-INTRA-EU
System calculates VAT %: From VAT Posting Setup = 0%
Line Amount is calculated with correct VAT

You don't have to do anything except set the Location Code! ✓

Multiple Items from Different Locations

You can have items from different locations in the same order:

Sales Order: ORDER-001

Line 10: LAPTOP-001
         Location: DE-STORE
         VAT Prod. Group: B2B-INTRA-EU
         VAT %: 0%
         Amount: 10,000 DKK
         
Line 20: MONITOR-001
         Location: DE-STORE
         VAT Prod. Group: B2B-INTRA-EU
         VAT %: 0%
         Amount: 3,000 DKK
         
Line 30: KEYBOARD-001
         Location: DK-HQ ← Different location!
         VAT Prod. Group: DK-DOMESTIC
         VAT %: 25%
         Amount: 2,000 DKK (+ 500 DKK VAT = 2,500 total)

Order Totals:
  Subtotal: 15,000 DKK
  VAT: 500 DKK (only on DK items)
  Total: 15,500 DKK

System handles each line based on its location automatically!

What if Location Has No Mapping?

If you set a Location Code that doesn't have a mapping:

Example:
  Location: UK-STORE (no mapping configured)
  Item: LAPTOP-001 (default VAT = STANDARD)
  
System does:
  1. Searches for mapping (UK-STORE, STANDARD) → NOT FOUND
  2. Falls back to item's default: STANDARD
  3. VAT %: 25% (domestic rate)
  4. No error occurs
  
Result:
  Item gets default VAT treatment (safe fallback)
  To get correct VAT:
    → Create mapping for UK-STORE location
    → Or manually change VAT Prod. Group on line (if authorized)

Troubleshooting

Problem 1: VAT Prod. Posting Group Doesn't Change

Symptom:

You set Location Code on the line
VAT Prod. Posting Group stays as STANDARD (doesn't change to expected value)

Diagnostic Checklist:

☐ Is "Advanced VAT for Sales" enabled?
  → Go to: VAT Rate per Dim. Setup
  → Check: Advanced VAT for Sales = ☑
  → If unchecked: Ask administrator to enable it

☐ Does the line have Location Code filled in?
  → On the Sales Line, check: Location Code field
  → Should not be blank
  → If blank: Type the location code

☐ Does the mapping exist?
  → Go to: VAT Rate Advanced Sales Product Posting Group
  → Search for record with:
     Location = [your location]
     From VAT Prod. Group = [item's default group]
  → If not found: Ask administrator to create it

☐ Does Starting Date match?
  → On the mapping record: Starting Date
  → Check: Starting Date ≤ Today's date
  → If future date: Change to today or earlier

☐ Is the Item's default VAT group correct?
  → Search for: Items
  → Find your item
  → Check: VAT Prod. Posting Group
  → Make sure this matches the "From" field in mapping

Solution Steps:

If "Advanced VAT for Sales" is unchecked:
- Contact administrator to enable it
If mapping doesn't exist:
- Ask administrator to create mapping for your location
- Mapping should be: (Location, Item default VAT) → Target VAT
If everything looks correct:
- Try these troubleshooting steps:
  a) Close and reopen the Sales Order
  b) Modify Location Code (change it and change it back)
  c) Contact your administrator with order number

Problem 2: VAT % is Wrong

Symptom:

VAT Prod. Posting Group changed correctly (e.g., to B2B-INTRA-EU)
But VAT % shows wrong value (e.g., 25% instead of 0%)

Diagnostic Checklist:

☐ Does VAT Posting Setup have the combination?
  → Go to: VAT Posting Setup
  → Look for entry with:
     VAT Bus. Posting Group = [from Sales Header]
     VAT Prod. Posting Group = [B2B-INTRA-EU]
  → If missing: This is the problem!

☐ Is the VAT % correct in that entry?
  → Check the "VAT %" column
  → Should match your expectation (usually 0% for B2B EU)
  → If wrong: Contact administrator to fix it

☐ Did the order's VAT Bus. Posting Group change?
  → On Sales Header: Check VAT Bus. Posting Group field
  → Should match the customer's setup
  → If changed unexpectedly: Change it back or investigate

Solution Steps:

Verify the missing VAT Posting Setup entry:
- Ask administrator to check if entry exists
- If missing: Administrator should create it
Check the VAT % value:
- If it's wrong: Administrator should fix it
In the meantime (if urgent):
- You can manually change VAT Prod. Posting Group on the line
- BUT: Better to have correct setup so it works automatically

Problem 3: Error When Posting Order

Symptom:

You try to post a sales order
Error message appears: "VAT Posting Setup does not exist"
Order won't post

Cause:
The combination of VAT Bus. Posting Group + VAT Prod. Posting Group is missing from VAT Posting Setup.

Solution:

Contact your administrator
They should:
- Check VAT Posting Setup for the missing combination
- Create the missing entry with:
  - VAT Bus. Posting Group: [from your order]
  - VAT Prod. Posting Group: [from your line]
  - Sales VAT Account: [appropriate account]
  - Sales VAT Unreal. Account: [appropriate account]
  - And other required fields
Once created, you can post the order

FAQ

Q1: Can I have the same item with different VAT rates from different locations?

A: Yes, absolutely! This is exactly what the feature does.

Example:

Item: LAPTOP-001

From DK-HQ:    VAT Group = DK-DOMESTIC    (25% VAT)
From DE-STORE: VAT Group = B2B-INTRA-EU   (0% VAT)
From US-STORE: VAT Group = US-EXPORT      (0% VAT)

Same item, three different VAT treatments - all automatic!

Q2: What if I don't want to use a location?

A: That's fine! The feature only activates if you fill in a Location Code.

If you don't set Location Code:

System skips the automatic override
Item keeps its default VAT group
Works like normal Business Central

Q3: Can I manually override the VAT Prod. Posting Group?

A: Yes, you can! If you need to use a different VAT group:

On the Sales Line, find: VAT Prod. Posting Group field
Click it and select the group you want
The system will allow you to change it
But remember: This is a manual override, not automatic

Best practice:

Only override if the automatic mapping is temporarily wrong
Ask your administrator to update the mapping for future orders

Q4: What happens if I change the Location Code after adding items?

A: The system will recalculate the VAT groups.

Example:

1. You set Location Code = DK-HQ
   → VAT Group changes to DK-DOMESTIC (25%)

2. You change Location Code = DE-STORE
   → VAT Group changes to B2B-INTRA-EU (0%)
   → Amount recalculated automatically

Q5: What if there are multiple items with different default VAT groups?

A: The system works based on each item's default VAT group.

Example:

Item LAPTOP-001:    Default VAT = STANDARD
Item BOOK-001:      Default VAT = BOOKS-VAT
Item SERVICE-001:   Default VAT = SERVICE-VAT

From DE-STORE location, you can have mappings:
  STANDARD → B2B-INTRA-EU
  BOOKS-VAT → B2B-INTRA-EU
  SERVICE-VAT → B2B-INTRA-EU

When you add each item from DE-STORE:
  LAPTOP-001 gets B2B-INTRA-EU ✓
  BOOK-001 gets B2B-INTRA-EU ✓
  SERVICE-001 gets B2B-INTRA-EU ✓

Q6: Does this feature work on posted orders?

A: No, only on open (unposted) orders.

Timeline:

UNPOSTED ORDER:
  - You can add/remove/modify lines
  - Feature works automatically
  - Location changes trigger automatic VAT group changes

POSTED ORDER:
  - Order is locked in
  - Cannot change VAT groups
  - VAT entries are final (locked in General Ledger)
  - Cannot be undone (like any posting)

Q7: Can I have different VAT rates for the same location based on date?

A: Yes! This is what the "Starting Date" field is for.

Example:

Location: DE-STORE
Starting Date: 01-01-2025  →  B2B-INTRA-EU (0% VAT)
Starting Date: 01-04-2025  →  B2B-INTRA-VAT19 (19% VAT)
                               ← Tax law changed on April 1st

Order from Jan 15:  Uses first mapping (0%)
Order from May 1:   Uses second mapping (19%)

This allows you to handle tax law changes automatically!

Q8: What if I delete a location mapping?

For new orders: The mapping won't apply (fallback to item default)
For existing orders: They keep the VAT group that was applied when created
For posted orders: VAT entries don't change (they're locked)

Best practice: Don't delete mappings. Just update them or create new ones with future Starting Dates.

Q9: How do I know which VAT group is being used?

A: Look at the VAT Prod. Posting Group field on the Sales Line.

The value shown is what will be used for:

Calculating VAT %
Creating VAT entries when posted
Tax reporting

If you're unsure if it's correct:

Check your mapping table: Is it the expected group?
Check VAT Posting Setup: Is the VAT % correct?
If wrong: Contact your administrator

Q10: Do Resources and Item Charges also use this feature?

A: Yes! The feature works on:

✅ Items
✅ Resources
✅ Item Charges
❌ G/L Accounts (they use a different feature)

If you have Resources or Charges with Location codes, they'll automatically get the right VAT treatment too!

Best Practices

1. Always Set Location Code

Do:

✓ Every sales line should have Location Code set
✓ Helps system determine correct VAT
✓ Accurate tracking of where items came from

Don't:

✗ Leave Location Code blank "just to be quick"
✗ Assume system will figure it out
✗ Create orders without location info

2. Understand Your Mapping

Do:

✓ Know which locations have which mappings
✓ Print or save your mapping table as reference
✓ Ask questions if unsure about a mapping

Don't:

✗ Guess what a mapping should be
✗ Use wrong location to avoid tax
✗ Override VAT groups without understanding why

3. Verify Before Posting

Do:

✓ Check VAT % is correct before posting
✓ Review order totals including VAT
✓ Compare to previous similar orders

Don't:

✗ Post without checking VAT amounts
✗ Assume automatic = always correct
✗ Ignore error messages about VAT

4. Report Issues

Do:

✓ Report if VAT group doesn't change as expected
✓ Provide order number when reporting issues
✓ Save copies of mappings for reference

Don't:

✗ Manually override instead of reporting
✗ Create workarounds to avoid problems
✗ Keep issues to yourself

Quick Reference

Common Locations and VAT Groups

LOCATION    | DEFAULT FROM    | MAP TO          | TYPICAL VAT %
────────────┼─────────────────┼─────────────────┼──────────────
DK-HQ       | STANDARD        | DK-DOMESTIC     | 25%
DE-STORE    | STANDARD        | B2B-INTRA-EU    | 0%
FR-STORE    | STANDARD        | B2B-FRANCE      | 0%
US-STORE    | STANDARD        | US-EXPORT       | 0%
SE-STORE    | STANDARD        | B2B-INTRA-EU    | 0%

Steps to Create an Order (Quick Guide)

1. Search: "Sales Order"
2. Click: New
3. Fill: Customer, Ship-To, etc.
4. Lines Tab:
   a. Click: New Line
   b. Type: Item
   c. Item No.: [select item]
   d. Quantity: [type quantity]
   e. Location Code: [select location] ← Important!
5. System automatically updates VAT Prod. Group ✓
6. Review: VAT % is correct
7. Save and Post

When to Contact Administrator

Contact administrator if:
☐ "Advanced VAT for Sales" is not enabled
☐ Mapping you need doesn't exist
☐ VAT % is showing wrong value
☐ Cannot post due to VAT Posting Setup error
☐ Location doesn't exist in system
☐ Need to create new VAT groups
☐ Want to change or delete existing mappings

Support and Questions

Getting Help

For feature questions:

Review this documentation (Table of Contents above)
Check the FAQ section
Check the Troubleshooting section

For configuration questions:

Contact your System Administrator
Ask your Finance Manager
Provide order number and specific issue

For bugs or unexpected behavior:

Contact your System Administrator
Provide:
- Order number
- Customer name
- Items used
- Location Code
- Expected vs. actual VAT group

Summary

The Location-Based VAT for Items feature:

✅ Automatically adjusts VAT based on shipping location
✅ Eliminates manual errors by removing manual adjustments
✅ Handles multiple locations in the same order correctly
✅ Falls back gracefully if no mapping exists
✅ Works transparently - you just set the location code

To use it:

Set Location Code on sales lines
System automatically applies correct VAT group
VAT % is calculated correctly
Post the order as usual

Key point: You don't have to do anything special except set the Location Code. The system handles everything else! ✓

For questions or issues, contact your System Administrator.

Last Updated: February 2025
Version: 1.0

Location-Based VAT for Items