---
title: "Page 7022 Price Worksheet, extension points 29"
author: "JOP-AL"
url: https://jonas-paprotka.de/ref/page/7022-price-worksheet/points/
object: https://jonas-paprotka.de/ref/page/7022-price-worksheet/
app: "Base Application"
major: 29
source: https://jonas-paprotka.de/ref/page/7022-price-worksheet/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 7022 Price Worksheet, extension points 29

JOP-AL, https://jonas-paprotka.de/ref/page/7022-price-worksheet/points/

30 procedures and triggers with a step in src/Layers/W1/BaseApp/Pricing/Worksheet/PriceWorksheet.Page.al, in source order, read from the text, not from a run.

## PriceTypeFilter.OnValidate

[Line 39](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L39), trigger.

- [41](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L41) calls `InitSourceGroup`
- [42](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L42) calls `SetRecFilters`

## Defaults.OnDrillDown

[Line 51](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L51), trigger.

- [53](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L53) calls `ShowPriceListFilters`

## SourceGroupFilter.OnValidate

[Line 62](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L62), trigger.

- [64](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L64) calls `InitSourceGroup`
- [65](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L65) calls `SetRecFilters`

## Price List Code.OnDrillDown

[Line 89](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L89), trigger.

- [93](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L93) calls [Codeunit 7018 Price UX Management](https://jonas-paprotka.de/ref/codeunit/7018-price-ux-management/) `EditPriceList`

## CustomerSourceType.OnValidate

[Line 117](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L117), trigger.

- [119](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L119) calls `ValidateSourceType`

## VendorSourceType.OnValidate

[Line 130](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L130), trigger.

- [132](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L132) calls `ValidateSourceType`

## JobSourceType.OnValidate

[Line 143](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L143), trigger.

- [145](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L145) calls `ValidateSourceType`

## OpenPriceList.OnAction

[Line 358](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L358), trigger.

- [362](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L362) calls [Codeunit 7018 Price UX Management](https://jonas-paprotka.de/ref/codeunit/7018-price-ux-management/) `EditPriceList`

## SuggestLines.OnAction

[Line 381](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L381), trigger.

- [385](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L385) calls [Codeunit 7017 Price List Management](https://jonas-paprotka.de/ref/codeunit/7017-price-list-management/) `AddLines`
- [386](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L386) calls `GetDefaults`

## CopyLines.OnAction

[Line 399](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L399), trigger.

- [403](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L403) calls [Codeunit 7017 Price List Management](https://jonas-paprotka.de/ref/codeunit/7017-price-list-management/) `CopyLines`
- [404](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L404) calls `GetDefaults`

## ImplementPriceChange.OnAction

[Line 417](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L417), trigger.

- [427](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L427) calls [Codeunit 7017 Price List Management](https://jonas-paprotka.de/ref/codeunit/7017-price-list-management/) `ImplementNewPrices`

## EditInExcel.OnAction

[Line 443](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L443), trigger.

- [448](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L448) calls [Codeunit 1490 Edit in Excel Filters](https://jonas-paprotka.de/ref/codeunit/1490-edit-in-excel-filters/) `AddFieldV2`
- [449](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L449) calls [Codeunit 1490 Edit in Excel Filters](https://jonas-paprotka.de/ref/codeunit/1490-edit-in-excel-filters/) `AddFieldV2`
- [450](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L450) calls [Codeunit 1481 Edit in Excel](https://jonas-paprotka.de/ref/codeunit/1481-edit-in-excel/) `EditPageInExcel`

## OnInit

[Line 485](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L485), trigger.

- [489](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L489) raises `OnBeforeOnInit`
- [490](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L490) calls [Codeunit 7049 Feature - Price Calculation](https://jonas-paprotka.de/ref/codeunit/7049-feature-price-calculation/) `FailIfFeatureDisabled`

## OnNewRecord

[Line 493](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L493), trigger.

- [495](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L495) calls [Table 7022 Price Worksheet Line](https://jonas-paprotka.de/ref/table/7022-price-worksheet-line/) `SetNewRecord`
- [497](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L497) validates [Table 7022 Price Worksheet Line](https://jonas-paprotka.de/ref/table/7022-price-worksheet-line/) `Asset Type`

## OnOpenPage

[Line 501](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L501), trigger.

- [506](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L506) raises `OnBeforeOpenPage`
- [508](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L508) calls [Table 7001 Price List Line](https://jonas-paprotka.de/ref/table/7001-price-list-line/) `UseCustomizedLookup`
- [509](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L509) calls [Codeunit 6723 Server Setting](https://jonas-paprotka.de/ref/codeunit/6723-server-setting/) `GetIsSaasExcelAddinEnabled`
- [510](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L510) calls [Codeunit 7017 Price List Management](https://jonas-paprotka.de/ref/codeunit/7017-price-list-management/) `VerifySourceGroupInLines`
- [511](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L511) calls `InitSourceGroup`
- [512](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L512) calls `UpdateSourceType`
- [513](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L513) calls `SetRecFilters`

## Category_Report.OnAfterGetRecord

[Line 516](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L516), trigger.

- [518](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L518) calls `UpdateSourceType`
- [519](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L519) calls `SetFieldsStyle`

## OnAfterGetCurrRecord

[Line 522](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L522), trigger.

- [524](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L524) calls `UpdateSourceType`
- [525](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L525) calls `SetEditableFields`

## CalcSourceNoEditable

[Line 602](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L602), local.

- [604](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L604) calls [Table 7022 Price Worksheet Line](https://jonas-paprotka.de/ref/table/7022-price-worksheet-line/) `IsSourceNoAllowed`

## GetDefaults

[Line 607](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L607), local.

- [609](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L609) calls `InitDefaultsLine`
- [618](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L618) raises `OnAfterGetDefaults`

## InitDefaultsLine

[Line 639](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L639), local.

- [642](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L642) calls [Table 7001 Price List Line](https://jonas-paprotka.de/ref/table/7001-price-list-line/) `CopyFrom`

## InitSourceGroup

[Line 652](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L652), local.

- [656](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L656) calls `InitPriceType`
- [668](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L668) calls `SetDefaultPriceListCode`

## SetDefaultPriceListCode

[Line 671](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L671), local.

- [676](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L676) calls [Codeunit 7017 Price List Management](https://jonas-paprotka.de/ref/codeunit/7017-price-list-management/) `GetDefaultPriceListCode`
- [677](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L677) calls `UpdateDefaults`
- [678](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L678) calls `SetPriceListCodeInWorksheetLines`
- [684](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L684) calls [Codeunit 7017 Price List Management](https://jonas-paprotka.de/ref/codeunit/7017-price-list-management/) `IsAllowedEditingActivePrice`

## SetEditableFields

[Line 687](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L687), local.

- [701](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L701) calls [Table 7005 Price Source](https://jonas-paprotka.de/ref/table/7005-price-source/) `IsParentSourceAllowed`
- [703](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L703) calls [Table 7022 Price Worksheet Line](https://jonas-paprotka.de/ref/table/7022-price-worksheet-line/) `IsAssetItem`
- [704](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L704) calls [Table 7022 Price Worksheet Line](https://jonas-paprotka.de/ref/table/7022-price-worksheet-line/) `IsAssetResource`
- [705](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L705) calls [Table 7022 Price Worksheet Line](https://jonas-paprotka.de/ref/table/7022-price-worksheet-line/) `IsEditable`
- [706](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L706) calls `CalcSourceNoEditable`
- [707](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L707) calls `SetFieldsStyle`

## SetPriceListCodeInWorksheetLines

[Line 738](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L738), local.

- [750](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L750) writes [Table 7022 Price Worksheet Line](https://jonas-paprotka.de/ref/table/7022-price-worksheet-line/) Delete(true)
- [754](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L754) writes [Table 7022 Price Worksheet Line](https://jonas-paprotka.de/ref/table/7022-price-worksheet-line/) Insert(true)

## SetRecFilters

[Line 758](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L758), local.

- [760](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L760) calls `SetFilters`
- [761](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L761) calls `SetVisibleFields`

## SetDefaults

[Line 793](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L793).

- [796](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L796) calls `GetDefaults`

## ShowPriceListFilters

[Line 799](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L799), local.

- [803](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L803) calls [Page 7013 Price List Filters](https://jonas-paprotka.de/ref/page/7013-price-list-filters/) `Set`
- [807](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L807) calls `GetDefaults`

## UpdateDefaults

[Line 812](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L812), local.

- [820](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L820) validates [Table 7000 Price List Header](https://jonas-paprotka.de/ref/table/7000-price-list-header/) `Source Type`
- [820](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L820) calls `GetDefaultSourceType`
- [827](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L827) calls `GetDefaults`

## UpdateSourceType

[Line 830](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L830), local.

- [840](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L840) calls `CalcSourceNoEditable`

## ValidateSourceType

[Line 843](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L843), local.

- [845](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L845) validates [Table 7022 Price Worksheet Line](https://jonas-paprotka.de/ref/table/7022-price-worksheet-line/) `Source Type`
- [846](https://jonas-paprotka.de/ref/page/7022-price-worksheet/source/#L846) calls `CalcSourceNoEditable`

## Source

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

JOP-AL, 2026-11-20.
