Table 6 "Customer Price Group"

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

Learn documents this table through its pages: Page 7 “Customer Price Groups” (2 Learn pages).

Properties

Property	Value
Caption	Customer Price Group
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	Code Δ BC28	Code[10]	Specifies a code to identify the price group.	NotBlank
2	Price Includes VAT Δ BC28	Boolean	Specifies whether the prices given for this price group will include VAT.
5	Allow Invoice Disc. Δ BC28	Boolean	Specifies whether the ordinary invoice discount calculation will apply to customers in this price group.
6	VAT Bus. Posting Gr. (Price)	Code[20]	Specifies the VAT business posting group that determines the default VAT percentage to add to sales prices for customers in this group. via Page 7 “Customer Price Groups”	TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group)
10	Description Δ BC28	Text[100]	Specifies the description of the customer price group.
720	Coupled to CRM Δ BC26	Boolean	Coupled to Dynamics 365 Sales caption	obsolete Removed 26.0; #if not CLEANSCHEMA26; not editable
721	Coupled to Dataverse Δ BC28	Boolean	Specifies that the customer price group is coupled to a price list in Dynamics 365 Sales.	FlowField: exist(“CRM Integration Record” where(“Integration ID” = field(SystemId), “Table ID” = const(Database::“Customer Price Group”))); not editable
7000	Price Calculation Method Δ BC28	Enum “Price Calculation Method”	Specifies the price calculation method that will override the method set in the sales setup for customers in this group.	enum Enum 7000 “Price Calculation Method”
7001	Allow Line Disc. Δ BC28	Boolean	Specifies if a line discount will be calculated when the sales price is offered.

Keys

Key1: Code (clustered)
Key2: SystemModifiedAt

Trigger event subscribers

OnAfterDeleteEvent: Codeunit 7006 “Price Helper - V16” AfterDeleteCustomerPriceGroup, Codeunit 7019 “Price Helper - V15” AfterDeleteCustomerPriceGroup
OnAfterRenameEvent: Codeunit 7006 “Price Helper - V16” AfterRenameCustomerPriceGroup, Codeunit 7019 “Price Helper - V15” AfterRenameCustomerPriceGroup

Procedures

ToPriceSource(var PriceSource: Record "Price Source"): Converts this customer price group to a price source record.

Relations

lookup page Page 7 “Customer Price Groups”
VAT Bus. Posting Gr. (Price): TableRelation Table 323 “VAT Business Posting Group”
Coupled to Dataverse: CalcFormula Table 5331 “CRM Integration Record”

Referenced by

46 fields in 46 objects relate to this table (TableRelation or CalcFormula).

Table 1003 “Job Planning Line”: Customer Price Group
Table 110 “Sales Shipment Header”: Customer Price Group
Table 111 “Sales Shipment Line”: Customer Price Group
Table 112 “Sales Invoice Header”: Customer Price Group
Table 113 “Sales Invoice Line”: Customer Price Group
Table 114 “Sales Cr.Memo Header”: Customer Price Group
Table 115 “Sales Cr.Memo Line”: Customer Price Group
Table 1304 “Sales Price and Line Disc Buff”: Sales Code
Table 1381 “Customer Templ.”: Customer Price Group
Table 167 “Job”: Customer Price Group
Table 169 “Job Ledger Entry”: Customer Price Group
Table 18 “Customer”: Customer Price Group
Table 210 “Job Journal Line”: Customer Price Group
Table 30102 “Shpfy Shop”: Customer Price Group
Table 30152 “Shpfy Catalog”: Customer Price Group
Table 36 “Sales Header”: Customer Price Group
Table 37 “Sales Line”: Customer Price Group
Table 459 “Sales Prepayment %”: Sales Code
Table 5107 “Sales Header Archive”: Price Group Code
Table 5108 “Sales Line Archive”: Price Group Code
Table 5135 “Job Archive”: Customer Price Group
Table 5137 “Job Planning Line Archive”: Customer Price Group
Table 5900 “Service Header”: Customer Price Group
Table 5902 “Service Line”: Customer Price Group
Table 5990 “Service Shipment Header”: Customer Price Group
Table 5991 “Service Shipment Line”: Customer Price Group
Table 5992 “Service Invoice Header”: Customer Price Group
Table 5993 “Service Invoice Line”: Customer Price Group
Table 5994 “Service Cr.Memo Header”: Customer Price Group
Table 5995 “Service Cr.Memo Line”: Customer Price Group
Table 6010 “Service Header Archive”: Customer Price Group
Table 6012 “Service Line Archive”: Customer Price Group
Table 6081 “Serv. Price Group Setup”: Cust. Price Group Code
Table 6660 “Return Receipt Header”: Customer Price Group
Table 6661 “Return Receipt Line”: Customer Price Group
Table 7002 “Sales Price”: Sales Code
Table 7023 “Sales Price Worksheet”: Sales Code
Table 8002 “Planned Subscription Line”: Customer Price Group
Table 8052 “Customer Subscription Contract”: Customer Price Group
Table 8055 “Subscription Package”: Price Group
Table 8057 “Subscription Header”: Customer Price Group
Table 8058 “Item Subscription Package”: Price Group
Table 8059 “Subscription Line”: Customer Price Group
Table 8068 “Sales Subscription Line”: Customer Price Group
Table 8069 “Sales Sub. Line Archive”: Customer Price Group
Table 8073 “Subscription Line Archive”: Customer Price Group

Pages and codeunits on this table

Page 7 “Customer Price Groups” (source table)

Deprecations

field Coupled to CRM: Removed 26.0 (#if not CLEANSCHEMA26), “Replaced by flow field Coupled to Dataverse”

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). 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: "table", object_name: "Customer Price Group"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.