code change · performanceFinanceofficial - Microsoftreviewed - checked by Opus

#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 · 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

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).