--- title: "Location-Based VAT for Items" slug: "location-based-vat-for-items" description: "Automatically adjust VAT rates based on shipping location with the Location-Based VAT for Items feature, ensuring accuracy and compliance in your sales orders." updated: 2026-02-19T11:03:02Z published: 2026-02-19T11:03:02Z canonical: "docs.abakion.com/location-based-vat-for-items" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.abakion.com/llms.txt > Use this file to discover all available pages before exploring further. # 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 --- ## Table of Contents 1. [Introduction](/docs/location-based-vat-for-items#introduction) 2. [How It Works](/docs/location-based-vat-for-items#how-it-works) 3. [Getting Started](/docs/location-based-vat-for-items#getting-started) 4. [Configuration Guide](/docs/location-based-vat-for-items#configuration-guide) 5. [Using the Feature](/docs/location-based-vat-for-items#using-the-feature) 6. [Test Scenarios](/docs/location-based-vat-for-items#test-scenarios) 7. [Troubleshooting](/docs/location-based-vat-for-items#troubleshooting) 8. [FAQ](/docs/location-based-vat-for-items#faq) --- ## 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: 1. ✅ The **VAT Rate per Dimension** app installed and activated 2. ✅ Valid license for the app 3. ✅ Locations defined in your system (e.g., DK-HQ, DE-STORE, US-STORE) 4. ✅ VAT Product Posting Groups created (e.g., STANDARD, B2B-INTRA-EU, US-EXPORT) 5. ✅ VAT Posting Setup configured with VAT rates for each combination ### Checking Prerequisites **Step 1: Verify App is Enabled** 1. Search for: **"VAT Rate per Dim. Setup"** 2. Open the page 3. Look for: **"Advanced VAT for Sales"** field 4. Check: Is it enabled (☑)? If not enabled, ask your administrator to enable it. **Step 2: Verify Locations Exist** 1. Search for: **"Locations"** 2. 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** 1. Search for: **"VAT Product Posting Groups"** 2. 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 1. Search for: **"VAT Rate per Dim. Setup"** 2. Open the page 3. Locate the record (Primary Key = blank) 4. Set: **"Advanced VAT for Sales"** = ☑ (Enabled) 5. Click: **Save** (or press Ctrl+S) ### Step 2: Create Location Mappings 1. 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"** 2. Click: **New** to create a new mapping 3. 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. 1. Search for: **"VAT Posting Setup"** 2. 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: 1. Click: **New** 2. Fill in all required fields 3. Click: **Save** **Note:** This is usually done by your system administrator. --- ## Using the Feature ### Creating a Sales Order #### Scenario: Selling to Germany 1. **Create Sales Order:** - Search for: **"Sales Order"** - Click: **New** - Fill in Customer, Ship-To Address (Germany), etc. 2. **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! 3. **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% 4. **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: 1. System registers the change 2. System checks: Is "Advanced VAT for Sales" enabled? → YES 3. System looks up the item's default VAT group → STANDARD 4. System searches for mapping: Location = DE-STORE, From = STANDARD 5. System finds: → To = B2B-INTRA-EU 6. System applies: Line.VAT Prod. Posting Group = B2B-INTRA-EU 7. System calculates VAT %: From VAT Posting Setup = 0% 8. 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:** 1. If "Advanced VAT for Sales" is unchecked: - Contact administrator to enable it 2. If mapping doesn't exist: - Ask administrator to create mapping for your location - Mapping should be: (Location, Item default VAT) → Target VAT 3. 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:** 1. Verify the missing VAT Posting Setup entry: - Ask administrator to check if entry exists - If missing: Administrator should create it 2. Check the VAT % value: - If it's wrong: Administrator should fix it 3. 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:** 1. Contact your administrator 2. 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 3. 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: 1. On the Sales Line, find: **VAT Prod. Posting Group** field 2. Click it and select the group you want 3. The system will allow you to change it 4. 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? **A:** 1. **For new orders:** The mapping won't apply (fallback to item default) 2. **For existing orders:** They keep the VAT group that was applied when created 3. **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: 1. Check your mapping table: Is it the expected group? 2. Check VAT Posting Setup: Is the VAT % correct? 3. 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:** 1. Set Location Code on sales lines 2. System automatically applies correct VAT group 3. VAT % is calculated correctly 4. 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