---
title: "Page 9227 Sales Analysis by Dim Matrix, extension points 29"
author: "JOP-AL"
url: https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/points/
object: https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/
app: "Base Application"
major: 29
source: https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/
checked: 2026-11-20
changed: 2026-10-05
subject: "Microsoft Dynamics 365 Business Central"
license: "Metadata from Microsoft's symbol packages. AL source MIT, Copyright (c) Microsoft Corporation. Selection and wording © 2026 JOP-AL. https://jonas-paprotka.de/licenses/"
---

# Page 9227 Sales Analysis by Dim Matrix, extension points 29

JOP-AL, https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/points/

47 procedures and triggers with a step in src/Layers/W1/BaseApp/Sales/Analysis/SalesAnalysisbyDimMatrix.Page.al, in source order, read from the text, not from a run.

## TotalQuantity.OnDrillDown

[Line 55](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L55), trigger.

- [57](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L57) calls [Codeunit 7153 Item Analysis Management](https://jonas-paprotka.de/ref/codeunit/7153-item-analysis-management/) `DrillDownAmount`

## TotalInvtValue.OnDrillDown

[Line 77](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L77), trigger.

- [79](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L79) calls [Codeunit 7153 Item Analysis Management](https://jonas-paprotka.de/ref/codeunit/7153-item-analysis-management/) `DrillDownAmount`

## Field1.OnDrillDown

[Line 99](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L99), trigger.

- [101](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L101) calls `FieldDrillDown`

## Field2.OnDrillDown

[Line 115](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L115), trigger.

- [117](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L117) calls `FieldDrillDown`

## Field3.OnDrillDown

[Line 131](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L131), trigger.

- [133](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L133) calls `FieldDrillDown`

## Field4.OnDrillDown

[Line 147](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L147), trigger.

- [149](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L149) calls `FieldDrillDown`

## Field5.OnDrillDown

[Line 163](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L163), trigger.

- [165](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L165) calls `FieldDrillDown`

## Field6.OnDrillDown

[Line 179](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L179), trigger.

- [181](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L181) calls `FieldDrillDown`

## Field7.OnDrillDown

[Line 195](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L195), trigger.

- [197](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L197) calls `FieldDrillDown`

## Field8.OnDrillDown

[Line 211](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L211), trigger.

- [213](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L213) calls `FieldDrillDown`

## Field9.OnDrillDown

[Line 227](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L227), trigger.

- [229](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L229) calls `FieldDrillDown`

## Field10.OnDrillDown

[Line 243](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L243), trigger.

- [245](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L245) calls `FieldDrillDown`

## Field11.OnDrillDown

[Line 259](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L259), trigger.

- [261](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L261) calls `FieldDrillDown`

## Field12.OnDrillDown

[Line 275](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L275), trigger.

- [277](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L277) calls `FieldDrillDown`

## Field13.OnDrillDown

[Line 291](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L291), trigger.

- [293](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L293) calls `FieldDrillDown`

## Field14.OnDrillDown

[Line 307](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L307), trigger.

- [309](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L309) calls `FieldDrillDown`

## Field15.OnDrillDown

[Line 323](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L323), trigger.

- [325](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L325) calls `FieldDrillDown`

## Field16.OnDrillDown

[Line 339](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L339), trigger.

- [341](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L341) calls `FieldDrillDown`

## Field17.OnDrillDown

[Line 355](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L355), trigger.

- [357](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L357) calls `FieldDrillDown`

## Field18.OnDrillDown

[Line 371](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L371), trigger.

- [373](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L373) calls `FieldDrillDown`

## Field19.OnDrillDown

[Line 387](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L387), trigger.

- [389](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L389) calls `FieldDrillDown`

## Field20.OnDrillDown

[Line 403](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L403), trigger.

- [405](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L405) calls `FieldDrillDown`

## Field21.OnDrillDown

[Line 419](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L419), trigger.

- [421](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L421) calls `FieldDrillDown`

## Field22.OnDrillDown

[Line 435](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L435), trigger.

- [437](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L437) calls `FieldDrillDown`

## Field23.OnDrillDown

[Line 451](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L451), trigger.

- [453](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L453) calls `FieldDrillDown`

## Field24.OnDrillDown

[Line 467](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L467), trigger.

- [469](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L469) calls `FieldDrillDown`

## Field25.OnDrillDown

[Line 483](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L483), trigger.

- [485](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L485) calls `FieldDrillDown`

## Field26.OnDrillDown

[Line 499](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L499), trigger.

- [501](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L501) calls `FieldDrillDown`

## Field27.OnDrillDown

[Line 515](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L515), trigger.

- [517](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L517) calls `FieldDrillDown`

## Field28.OnDrillDown

[Line 531](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L531), trigger.

- [533](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L533) calls `FieldDrillDown`

## Field29.OnDrillDown

[Line 547](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L547), trigger.

- [549](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L549) calls `FieldDrillDown`

## Field30.OnDrillDown

[Line 563](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L563), trigger.

- [565](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L565) calls `FieldDrillDown`

## Field31.OnDrillDown

[Line 579](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L579), trigger.

- [581](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L581) calls `FieldDrillDown`

## Field32.OnDrillDown

[Line 595](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L595), trigger.

- [597](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L597) calls `FieldDrillDown`

## Export to Excel.OnAction

[Line 619](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L619), trigger.

- [624](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L624) calls [Codeunit 7152 Export Item Analysis View](https://jonas-paprotka.de/ref/codeunit/7152-export-item-analysis-view/) `SetCommonFilters`
- [628](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L628) calls [Codeunit 7152 Export Item Analysis View](https://jonas-paprotka.de/ref/codeunit/7152-export-item-analysis-view/) `ExportData`

## Export to Excel.OnAfterGetRecord

[Line 637](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L637), trigger.

- [639](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L639) calls `CalcAmounts`
- [641](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L641) calls `FormatLine`

## OnFindRecord

[Line 644](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L644), trigger.

- [647](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L647) calls [Codeunit 7153 Item Analysis Management](https://jonas-paprotka.de/ref/codeunit/7153-item-analysis-management/) `FindRecord`

## OnNextRecord

[Line 691](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L691), trigger.

- [694](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L694) calls [Codeunit 7153 Item Analysis Management](https://jonas-paprotka.de/ref/codeunit/7153-item-analysis-management/) `NextRecord`

## LoadMatrix

[Line 824](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L824).

- [848](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L848) calls [Codeunit 9200 Matrix Management](https://jonas-paprotka.de/ref/codeunit/9200-matrix-management/) `FormatRoundingFactor`

## CalcAmounts

[Line 883](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L883), local.

- [886](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L886) calls `CalcAmt`
- [888](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L888) calls `CalcAmt`
- [892](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L892) calls [Codeunit 7153 Item Analysis Management](https://jonas-paprotka.de/ref/codeunit/7153-item-analysis-management/) `FindRecord`
- [894](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L894) calls `GetFieldItemFilter`
- [894](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L894) calls `GetFieldLocationFilter`
- [895](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L895) calls `GetFieldDim1Filter`
- [895](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L895) calls `GetFieldDim2Filter`
- [895](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L895) calls `GetFieldDim3Filter`
- [899](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L899) calls `CalcAmt`
- [900](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L900) calls [Codeunit 7153 Item Analysis Management](https://jonas-paprotka.de/ref/codeunit/7153-item-analysis-management/) `NextRecord`
- [902](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L902) calls `GetFieldItemFilter`
- [902](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L902) calls `GetFieldLocationFilter`
- [903](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L903) calls `GetFieldDim1Filter`
- [903](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L903) calls `GetFieldDim2Filter`
- [903](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L903) calls `GetFieldDim3Filter`

## CalcAmt

[Line 908](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L908), local.

- [920](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L920) calls [Codeunit 7153 Item Analysis Management](https://jonas-paprotka.de/ref/codeunit/7153-item-analysis-management/) `CalculateAmount`
- [933](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L933) writes [Table 375 Dimension Code Amount Buffer](https://jonas-paprotka.de/ref/table/375-dimension-code-amount-buffer/) Insert
- [940](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L940) calls [Codeunit 9200 Matrix Management](https://jonas-paprotka.de/ref/codeunit/9200-matrix-management/) `RoundAmount`

## FieldDrillDown

[Line 945](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L945), local.

- [950](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L950) calls [Codeunit 7153 Item Analysis Management](https://jonas-paprotka.de/ref/codeunit/7153-item-analysis-management/) `FindRecord`
- [952](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L952) calls `GetFieldItemFilter`
- [952](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L952) calls `GetFieldLocationFilter`
- [953](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L953) calls `GetFieldDim1Filter`
- [953](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L953) calls `GetFieldDim2Filter`
- [953](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L953) calls `GetFieldDim3Filter`
- [956](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L956) calls [Codeunit 7153 Item Analysis Management](https://jonas-paprotka.de/ref/codeunit/7153-item-analysis-management/) `NextRecord`
- [958](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L958) calls `GetFieldItemFilter`
- [958](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L958) calls `GetFieldLocationFilter`
- [959](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L959) calls `GetFieldDim1Filter`
- [959](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L959) calls `GetFieldDim2Filter`
- [959](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L959) calls `GetFieldDim3Filter`
- [961](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L961) calls [Codeunit 7153 Item Analysis Management](https://jonas-paprotka.de/ref/codeunit/7153-item-analysis-management/) `DrillDownAmount`
- [963](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L963) calls `GetFieldItemFilter`
- [963](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L963) calls `GetFieldLocationFilter`
- [964](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L964) calls `GetFieldDim1Filter`
- [964](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L964) calls `GetFieldDim2Filter`
- [964](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L964) calls `GetFieldDim3Filter`

## GetFieldItemFilter

[Line 989](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L989), local.

- [991](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L991) calls `GetFieldFilter`

## GetFieldLocationFilter

[Line 994](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L994), local.

- [996](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L996) calls `GetFieldFilter`

## GetFieldDim1Filter

[Line 999](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L999), local.

- [1001](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L1001) calls `GetFieldFilter`

## GetFieldDim2Filter

[Line 1004](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L1004), local.

- [1006](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L1006) calls `GetFieldFilter`

## GetFieldDim3Filter

[Line 1009](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L1009), local.

- [1011](https://jonas-paprotka.de/ref/page/9227-sales-analysis-by-dim-matrix/source/#L1011) calls `GetFieldFilter`

## Source

AL source 29: https://github.com/microsoft/BCApps, MIT, releases/29.x at 4303e5e584d3aa5d9e98cbc615525a5396ad6ed7.

JOP-AL, 2026-11-20.
