Page 7022 "Price Worksheet"

Base Application · Microsoft.Pricing.Worksheet · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Price Worksheet
SourceTable	Price Worksheet Line
PageType	Worksheet
UsageCategory	Tasks
ApplicationArea	Basic, Suite

Fields on this page

Layout controls in source order, grouped by the container they sit in. Shows: the table field a control is bound to (or its expression as written); ToolTip: the control’s own, else the bound field’s (marked).

Group	Control	Shows	ToolTip
General	Price Type	`PriceType`	Specifies a filter for which prices to display: sale or purchase.
	Defaults	`Defaults`	Specifies the fields of the price list header that is used as defaults for new lines created in the worksheet.
	Assign-to Group	`SourceGroup`	Specifies a filter for which group the prices apply to: customer, vendor, or project.
	Update multiple price lists	`UpdateMultiplePriceLists`	Specifies if the worksheet is in the mode when user can add new lines and modify the existing lines suggested by the copy lines action.
Lines	Price List Code	Price List Code	Specifies the unique identifier of the price list. from the table field
	Existing Line	Existing Line	Specifies if the current line is a copy of the existing price list line. from the table field
	Status	Status	Specifies whether the price list line is in Draft status and can be edited, Inactive and cannot be edited or used, or Active and used for price calculations. from the table field
	Assign-to Type	`CustomerSourceType`	Specifies the type of entity to which the price list is assigned. The options are relevant to the entity you are currently viewing.
	Assign-to Type	`VendorSourceType`	Specifies the type of entity to which the price list is assigned. The options are relevant to the entity you are currently viewing.
	Assign-to Type	`JobSourceType`	Specifies the type of entity to which the price list is assigned. The options are relevant to the entity you are currently viewing.
	Parent Source No.	Parent Source No.	Specifies the project to which the prices are assigned. If you choose an entity, the price list will be used only for that entity. from the table field
	Source No.	Source No.	Specifies the entity to which the prices are assigned. The options depend on the selection in the Assign-to Type field. If you choose an entity, the price list will be used only for that entity. from the table field
	Assign-to Parent No.	Assign-to Parent No.	Specifies the project to which the prices are assigned. If you choose an entity, the price list will be used only for that entity. from the table field
	Assign-to No.	Assign-to No.	Specifies the entity to which the prices are assigned. The options depend on the selection in the Assign-to Type field. If you choose an entity, the price list will be used only for that entity. from the table field
	Asset Type	Asset Type	Specifies the type of the product. from the table field
	Asset No.	Asset No.	Specifies the identifier of the product. If no product is selected, the price and discount values will apply to all products of the selected product type for which those values are not specified. For example, if you choose Item as the product type but do not specify a specific item, the price will a… from the table field
	Product No.	Product No.	Specifies the identifier of the product. If no product is selected, the price and discount values will apply to all products of the selected product type for which those values are not specified. For example, if you choose Item as the product type but do not specify a specific item, the price will a… from the table field
	Variant Code	Variant Code	Specifies the variant of the item on the line. from the table field
	Variant Code Lookup	Variant Code Lookup	Specifies the variant of the item on the line. from the table field
	Work Type Code	Work Type Code	Specifies the work type code for the resource. from the table field
	Currency Code	Currency Code	Specifies the currency code of the price list line. from the table field
	Unit of Measure Code	Unit of Measure Code	Specifies the unit of measure for the product. from the table field
	Unit of Measure Code Lookup	Unit of Measure Code Lookup	Specifies the unit of measure for the product. from the table field
	Minimum Quantity	Minimum Quantity	Specifies the minimum quantity of the product. from the table field
	Amount Type	Amount Type	Specifies whether the price list line defines prices, discounts, or both. from the table field
	Existing Unit Price	Existing Unit Price	Specifies the current unit price of the product. from the table field
	New Unit Price	Unit Price	Specifies the new unit price of the product. from the table field
	Cost Factor	Cost Factor	Specifies the unit cost factor for project-related prices, if you have agreed with your customer that he should pay certain item usage by cost value plus a certain percent value to cover your overhead expenses. from the table field
	Existing Direct Unit Cost	Existing Direct Unit Cost	Specifies the current direct unit cost of the product. from the table field
	New Direct Unit Cost	Direct Unit Cost	Specifies the new direct unit cost of the product. from the table field
	Existing Unit Cost	Existing Unit Cost	Specifies the current unit cost of the product. from the table field
	Unit Cost	Unit Cost	Specifies the unit cost of the resource. from the table field
	Line Discount %	Line Discount %	Specifies the line discount percentage for the product. from the table field
	Starting Date	Starting Date	Specifies the date from which the price is valid. from the table field
	Ending Date	Ending Date	Specifies the last date that the price is valid. from the table field
	Allow Line Disc.	Allow Line Disc.	Specifies if a line discount will be calculated when the price is offered. from the table field
	Allow Invoice Disc.	Allow Invoice Disc.	Specifies if an invoice discount will be calculated when the price is offered. from the table field
	VAT Bus. Posting Gr. (Price)	VAT Bus. Posting Gr. (Price)	Specifies the VAT business posting group for customers for whom you want the price (which includes VAT) to apply.
	Price Includes VAT	Price Includes VAT	Specifies if the price includes VAT. from the table field

Actions

Group	Action	ToolTip
Navigation	Open Price List	View or edit the price list.
Functions	Suggest Lines	Creates the sales price list lines based on the unit price in the product cards, like item or resource. Change the price list status to ‘Draft’ to run this action.
	Copy Lines	Copies the lines from the existing price list. New prices can be adjusted by a factor and rounded differently. Change the price list status to ‘Draft’ to run this action unless Allow Editing Active Price is enabled.
	Implement Price Change	Update the alternate prices with the ones in the Price Worksheet window.
Page	Edit in Excel	Send the data in the worksheet to an Excel file for analysis or editing.

Events published

OnAfterGetDefaults(var Result: Text; TempWorksheetPriceListHeader: Record "Price List Header") (integration)
OnBeforeOnInit() + BC28 (integration)
OnBeforeOpenPage(var TempWorksheetPriceListHeader: Record "Price List Header" temporary; var TempWorksheetPriceListLine: Record "Price List Line" temporary; var UpdateMultiplePriceLists: Boolean) (integration)

Procedures

SetPriceType(NewPriceType: Enum "Price Type")
SetDefaults(PriceListHeader: Record "Price List Header")

Plus 18 local procedures.

Triggers

OnInit, OnNewRecord, OnOpenPage, OnAfterGetRecord, OnAfterGetCurrRecord

Relations

source table Table 7022 “Price Worksheet Line”

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

Codeunit 7017 “Price List Management” (3 calls: OnOpenPage → VerifySourceGroupInLines, SetDefaultPriceListCode → GetDefaultPriceListCode, SetDefaultPriceListCode → IsAllowedEditingActivePrice)
Codeunit 6723 “Server Setting” (1 call: OnOpenPage → GetIsSaasExcelAddinEnabled)
Codeunit 7049 “Feature - Price Calculation” (1 call: OnInit → FailIfFeatureDisabled)

Documented on Microsoft Learn

Record special sales prices and discounts

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "page", object_name: "Price Worksheet"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.