---
id: change/bcapps/10135
type: change
title: "#10135 [Master]-Performance issue when calculating the VAT advance return / VAT statement (Base Application, German environment) - Copy"
summary: Removed database keys from the VAT Entry table in CH and DACH environments to prevent performance degradation on CRUD operations, reverting an earlier attempt to address VAT statement calculation issues.
tier: official
language: en
tags:
  - performance
  - main
  - bc30
  - table vat entry
system: finance
review:
  state: reviewed
  by: opus
  at: "2026-10-08T02:09:24.094Z"
  flags: []
generated:
  at: "2026-10-08T01:26:53.141Z"
  pipeline: 0.2.0
  prompts:
    extract-change: 1
  input_hash: c0cc2e27704b3efca76029f1e5f999bdc34f946e
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/pull/10135
    title: "microsoft/BCApps#10135: [Master]-Performance issue when calculating the VAT advance return / VAT statement (Base Application, German environment) - Copy"
    date: "2026-08-12"
    commit: c0cc2e27704b3efca76029f1e5f999bdc34f946e
    t: null
    quote: null
links:
  learn: []
  objects:
    - object/table/254
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
  changes: []
number: 10135
repo: microsoft/BCApps
source_id: bcapps-prs
url: https://github.com/microsoft/BCApps/pull/10135
kind: pr
base_branch: main
major: "30"
merged_at: "2026-08-12T06:39:12Z"
author: neeleshsinghal
author_type: User
community_contribution: false
labels:
  - "Team: Finance"
change_class: code
change_kind: performance
behavior_change: false
breaking: false
files:
  count: 2
  additions: 0
  deletions: 8
  al: 2
apps:
  - Base Application
objects_touched:
  - key: table/254
    page: table/254
    type: table
    id: 254
    name: VAT Entry
    app: Base Application
    status: modified
objects_unjoined: []
obsoletions: []
backports: []
fixes_issues: []
work_items:
  - 644116
systems:
  - finance
quote: null
joined_against:
  major: "30"
  commit: ecbc028c25dbe83b61313bc566e6c1d41184bb1c
---

# #10135 [Master]-Performance issue when calculating the VAT advance return / VAT statement (Base Application, German environment) - Copy

> Removed database keys from the VAT Entry table in CH and DACH environments to prevent performance degradation on CRUD operations, reverting an earlier attempt to address VAT statement calculation issues.

[Pull request](https://github.com/microsoft/BCApps/pull/10135) · merged into `main` (BC30) on 2026-08-12 by neeleshsinghal · 2 files (+0 -8), 2 AL · performance · tier official · reviewed (checked by Opus)

## What changed

- Deleted keys that were previously added to optimize VAT statement queries
- Affects both Switzerland and DACH region VAT Entry tables
- Protects CRUD performance on the VAT Entry table
- Addresses base application stability concerns

## AL objects touched

- [Table 254 "VAT Entry"](../../objects/table/254.md), Base Application (AT layer): modified

## Context

- Work items: AB#644116
- Labels: Team: Finance
- Systems: finance

Source: metadata of a merged pull request in microsoft/BCApps (bcapps): title, labels, changed paths and counts, with a summary in our words. No source text and no description beyond one short quote (D10, D61).