BC Observatoryunofficial, made by waldo
code change · fixInventoryofficial - Microsoftreviewed - checked by Opus

#9810 [master]-Edit in Excel fails with false duplicate error when creating new Item Variants

Item Variants page no longer fails with a false duplicate key error when creating new variants through Edit in Excel by limiting the forced record update to interactive clients only.

Open in Claude9810.mdPull request #9810

Pull request · merged into main (BC30) on 2026-07-31 by MSNehaNawal (community contribution) · 1 file (+4 -1), 1 AL · fix · tier official · reviewed (checked by Opus)

What changed

  • Removed forced immediate record persistence that triggered during Edit in Excel operations
  • Scoped the OnValidate trigger’s CurrPage.Update(true) call to interactive sessions only
  • OData and web service sessions now bypass the early update, preventing duplicate key conflicts
  • Allows Edit in Excel to handle variant creation through its normal OData insert flow
  • Behaviour changes for users or extensions.

AL objects touched

Context

  • Work items: AB#644606
  • Labels: ADO: Sync, From Fork, Team: SCM
  • Systems: inventory
  • From the description: “Scope the forced update so it runs only for interactive clients and is skipped for OData/web-service sessions.”

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