Table 7001 Price List Line
src/Layers/W1/BaseApp/Pricing/PriceList/PriceListLine.Table.al1,317 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Pricing.PriceList;using Microsoft.CRM.Campaign;using Microsoft.CRM.Contact;using Microsoft.Finance.Currency;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Finance.VAT.Setup;using Microsoft.Foundation.UOM;using Microsoft.Inventory.Item;using Microsoft.Pricing.Asset;using Microsoft.Pricing.Calculation;using Microsoft.Pricing.Source;using Microsoft.Projects.Project.Job;using Microsoft.Projects.Resources.Resource;using Microsoft.Purchases.Pricing;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Customer;using Microsoft.Sales.Pricing;using Microsoft.Sales.Setup;using Microsoft.Utilities;using System.Environment;table 7001 "Price List Line"{ DataClassification = CustomerContent; fields { field(1; "Price List Code"; Code[20]) { Caption = 'Price List Code'; ToolTip = 'Specifies the unique identifier of the price list.'; DataClassification = CustomerContent; TableRelation = "Price List Header"; } field(2; "Line No."; Integer) { Caption = 'Line No.'; DataClassification = CustomerContent; AutoIncrement = true; } field(3; "Source Type"; Enum "Price Source Type") { Caption = 'Assign-to Type'; ToolTip = 'Specifies the type of the entity that offers the price or the line discount on the product.'; DataClassification = CustomerContent; trigger OnValidate() begin TestHeadersValue(FieldNo("Source Type")); CopyRecTo(PriceSource); PriceSource.Validate("Source Type", "Source Type"); CopyFrom(PriceSource); "Amount Type" := PriceSource.GetDefaultAmountType(); if "Asset No." <> '' then begin CopyTo(PriceAsset); PriceAsset.ValidateAssetNo(); CopyFrom(PriceAsset); end; end; } field(4; "Source No."; Code[20]) { Caption = 'Assign-to No. (custom)'; ToolTip = '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.'; DataClassification = CustomerContent; trigger OnValidate() begin TestHeadersValue(FieldNo("Source No.")); if not FieldLookedUp then begin CopyRecTo(PriceSource); PriceSource.Validate("Source No.", "Source No."); end; CopyFrom(PriceSource); "Assign-to No." := "Source No."; end; trigger OnLookup() begin CopyTo(PriceSource); if PriceSource.LookupNo() then begin FieldLookedUp := true; Validate("Source No.", PriceSource."Source No."); FieldLookedUp := false; end; end; } field(5; "Parent Source No."; Code[20]) { Caption = 'Assign-to Parent No. (custom)'; ToolTip = 'Specifies the project to which the prices are assigned. If you choose an entity, the price list will be used only for that entity.'; DataClassification = CustomerContent; trigger OnValidate() begin TestHeadersValue(FieldNo("Parent Source No.")); CopyRecTo(PriceSource); PriceSource.Validate("Parent Source No.", "Parent Source No."); CopyFrom(PriceSource); "Assign-to Parent No." := "Parent Source No."; end; trigger OnLookup() var ParentPriceSource: Record "Price Source"; begin CopyRecTo(PriceSource); if not PriceSource.IsParentSourceAllowed() then exit; ParentPriceSource."Source Group" := "Source Group"; ParentPriceSource."Source Type" := PriceSource.GetParentSourceType(); if ParentPriceSource.LookupNo() then Validate("Parent Source No.", ParentPriceSource."Source No."); end; } field(6; "Source ID"; Guid) { Caption = 'Assign-to ID'; DataClassification = CustomerContent; trigger OnValidate() begin TestHeadersValue(FieldNo("Source ID")); CopyRecTo(PriceSource); PriceSource.Validate("Source ID", "Source ID"); CopyFrom(PriceSource); end; } field(7; "Asset Type"; Enum "Price Asset Type") { Caption = 'Product Type'; ToolTip = 'Specifies the type of the product.'; DataClassification = CustomerContent; InitValue = Item; trigger OnValidate() begin if "Asset Type" = "Asset Type"::" " then "Asset Type" := "Asset Type"::Item; CopyRecTo(PriceAsset); PriceAsset.Validate("Asset Type", "Asset Type"); CopyFrom(PriceAsset); InitHeaderDefaults(); TestStatusDraft(); end; } field(8; "Asset No."; Code[20]) { Caption = 'Product No. (custom)'; ToolTip = '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 apply to all items for which a price is not specified.'; DataClassification = CustomerContent; trigger OnValidate() begin TestStatusDraft(); if not FieldLookedUp then begin CopyRecTo(PriceAsset); PriceAsset.Validate("Asset No.", "Asset No."); end; CopyFrom(PriceAsset); "Product No." := "Asset No."; "Variant Code Lookup" := "Variant Code"; "Unit of Measure Code Lookup" := "Unit of Measure Code"; end; trigger OnLookup() begin PriceCalculationMgt.FeatureCustomizedLookupUsage(Database::"Price List Line"); CopyTo(PriceAsset); if PriceAsset.LookupNo() then begin FieldLookedUp := true; Validate("Asset No.", PriceAsset."Asset No."); FieldLookedUp := false; end; end; } field(9; "Variant Code"; Code[10]) { Caption = 'Variant Code (custom)'; ToolTip = 'Specifies the item variant.'; DataClassification = CustomerContent; trigger OnValidate() begin TestStatusDraft(); if not FieldLookedUp then begin CopyRecTo(PriceAsset); PriceAsset.Validate("Variant Code", "Variant Code"); end; CopyFrom(PriceAsset); "Variant Code Lookup" := "Variant Code"; end; trigger OnLookup() begin CopyTo(PriceAsset); if PriceAsset.LookupVariantCode() then begin FieldLookedUp := true; Validate("Variant Code", PriceAsset."Variant Code"); FieldLookedUp := false; end; end; } field(10; "Currency Code"; Code[10]) { Caption = 'Currency Code'; ToolTip = 'Specifies the currency that is used for the prices on the price list. The currency can be the same for all prices on the price list, or you can specify a currency for individual lines.'; DataClassification = CustomerContent; TableRelation = Currency; trigger OnValidate() begin if "Currency Code" = xRec."Currency Code" then exit; TestHeadersValue(FieldNo("Currency Code")); end; } field(11; "Work Type Code"; Code[10]) { Caption = 'Work Type Code'; ToolTip = 'Specifies the work type code for the resource.'; DataClassification = CustomerContent; TableRelation = "Work Type"; trigger OnValidate() begin TestStatusDraft(); CopyRecTo(PriceAsset); PriceAsset.Validate("Work Type Code", "Work Type Code"); CopyFrom(PriceAsset); end; } field(12; "Starting Date"; Date) { Caption = 'Starting Date'; ToolTip = 'Specifies the date from which the price is valid.'; DataClassification = CustomerContent; trigger OnValidate() begin TestHeadersValue(FieldNo("Starting Date")); CopyRecTo(PriceSource); PriceSource.Validate("Starting Date", "Starting Date"); CopyFrom(PriceSource); end; } field(13; "Ending Date"; Date) { Caption = 'Ending Date'; ToolTip = 'Specifies the last date that the price is valid.'; DataClassification = CustomerContent; trigger OnValidate() begin TestHeadersValue(FieldNo("Ending Date")); CopyRecTo(PriceSource); PriceSource.Validate("Ending Date", "Ending Date"); CopyFrom(PriceSource); end; } field(14; "Minimum Quantity"; Decimal) { AutoFormatType = 0; Caption = 'Minimum Quantity'; ToolTip = 'Specifies the minimum quantity of the product.'; DataClassification = CustomerContent; DecimalPlaces = 0 : 5; MinValue = 0; trigger OnValidate() begin TestStatusDraft(); end; } field(15; "Unit of Measure Code"; Code[10]) { Caption = 'Unit of Measure Code (custom)'; ToolTip = 'Specifies the unit of measure for the product.'; DataClassification = CustomerContent; trigger OnValidate() begin TestStatusDraft(); if not FieldLookedUp then begin CopyRecTo(PriceAsset); PriceAsset.Validate("Unit of Measure Code", "Unit of Measure Code"); end; CopyFrom(PriceAsset); "Unit of Measure Code Lookup" := "Unit of Measure Code"; end; trigger OnLookup() begin CopyTo(PriceAsset); if PriceAsset.LookupUnitofMeasure() then begin FieldLookedUp := true; Validate("Unit of Measure Code", PriceAsset."Unit of Measure Code"); FieldLookedUp := false; end; end; } field(16; "Amount Type"; Enum "Price Amount Type") { Caption = 'Defines'; ToolTip = 'Specifies whether the price list line defines prices, discounts, or both.'; DataClassification = CustomerContent; trigger OnValidate() begin if "Amount Type" = xRec."Amount Type" then exit; TestStatusDraft(); VerifyAmountTypeForSourceType("Amount Type"); if PriceAsset."Amount Type" <> "Price Amount Type"::Any then TestField("Amount Type", PriceAsset."Amount Type"); case "Amount Type" of "Amount Type"::Price: begin "Line Discount %" := 0; GetValueFromHeader(FieldNo("Allow Invoice Disc.")); GetValueFromHeader(FieldNo("Allow Line Disc.")); end; "Amount Type"::Discount: begin "Unit Price" := 0; "Cost Factor" := 0; "Allow Invoice Disc." := false; "Allow Line Disc." := false; end; end; end; } field(17; "Unit Price"; Decimal) { AccessByPermission = tabledata "Sales Price Access" = R; DataClassification = CustomerContent; AutoFormatExpression = Rec."Currency Code"; AutoFormatType = 2; Caption = 'Unit Price'; ToolTip = 'Specifies the unit price of the product.'; MinValue = 0; trigger OnValidate() begin TestStatusDraft(); CheckAmountType(FieldCaption("Unit Price"), "Amount Type"::Discount); Verify(); if "Unit Price" <> 0 then "Cost Factor" := 0; end; } field(18; "Cost Factor"; Decimal) { AutoFormatType = 0; AccessByPermission = tabledata "Sales Price Access" = R; DataClassification = CustomerContent; Caption = 'Cost Factor'; ToolTip = '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.'; trigger OnValidate() begin TestStatusDraft(); if not CheckDefaultValueExists("Cost Factor") then CheckAmountType(FieldCaption("Cost Factor"), "Amount Type"::Discount); TestField("Source Group", "Source Group"::Job); Verify(); if "Cost Factor" <> 0 then "Unit Price" := 0; end; } field(19; "Unit Cost"; Decimal) { AccessByPermission = tabledata "Purchase Price Access" = R; DataClassification = CustomerContent; AutoFormatExpression = Rec."Currency Code"; AutoFormatType = 2; Caption = 'Unit Cost'; ToolTip = 'Specifies the unit cost of the resource.'; MinValue = 0; trigger OnValidate() begin TestStatusDraft(); if not CheckDefaultValueExists("Unit Cost") then CheckAmountType(FieldCaption("Unit Cost"), "Amount Type"::Discount); Verify(); end; } field(20; "Line Discount %"; Decimal) { DataClassification = CustomerContent; AutoFormatType = 0; DecimalPlaces = 0 : 5; Caption = 'Line Discount %'; ToolTip = 'Specifies the line discount percentage for the product.'; MaxValue = 100; MinValue = 0; trigger OnValidate() begin TestStatusDraft(); if not CheckDefaultValueExists("Line Discount %") then CheckAmountType(FieldCaption("Line Discount %"), "Amount Type"::Price); Verify(); end; } field(21; "Allow Line Disc."; Boolean) { Caption = 'Allow Line Disc.'; ToolTip = 'Specifies if a line discount will be calculated when the price is offered.'; DataClassification = CustomerContent; trigger OnValidate() begin TestStatusDraft(); if "Allow Line Disc." then CheckAmountType(FieldCaption("Allow Line Disc."), "Amount Type"::Discount); end; } field(22; "Allow Invoice Disc."; Boolean) { Caption = 'Allow Invoice Disc.'; ToolTip = 'Specifies if an invoice discount will be calculated when the price is offered.'; DataClassification = CustomerContent; trigger OnValidate() begin TestStatusDraft(); if "Allow Invoice Disc." then CheckAmountType(FieldCaption("Allow Invoice Disc."), "Amount Type"::Discount); end; } field(23; "Price Includes VAT"; Boolean) { Caption = 'Price Includes VAT'; ToolTip = 'Specifies if prices include VAT.'; DataClassification = CustomerContent; trigger OnValidate() begin TestHeadersValue(FieldNo("Price Includes VAT")); end; } field(24; "VAT Bus. Posting Gr. (Price)"; Code[20]) { Caption = 'VAT Bus. Posting Gr. (Price)'; DataClassification = CustomerContent; TableRelation = "VAT Business Posting Group"; trigger OnValidate() begin TestHeadersValue(FieldNo("VAT Bus. Posting Gr. (Price)")); end; } field(25; "VAT Prod. Posting Group"; Code[20]) { Caption = 'VAT Prod. Posting Group'; DataClassification = CustomerContent; TableRelation = "VAT Product Posting Group"; trigger OnValidate() begin TestStatusDraft(); end; } field(26; "Asset ID"; Guid) { Caption = 'Asset ID'; DataClassification = CustomerContent; trigger OnValidate() begin TestStatusDraft(); CopyRecTo(PriceAsset); PriceAsset.Validate("Asset ID", "Asset ID"); CopyFrom(PriceAsset); end; } field(27; "Line Amount"; Decimal) { DataClassification = CustomerContent; AutoFormatExpression = Rec."Currency Code"; AutoFormatType = 2; Caption = 'Line Amount'; MinValue = 0; Editable = false; } field(28; "Price Type"; Enum "Price Type") { Caption = 'Price Type'; ToolTip = 'Specifies the price type: sale or purchase price.'; DataClassification = CustomerContent; trigger OnValidate() begin TestHeadersValue(FieldNo("Price Type")); end; } field(29; Description; Text[100]) { Caption = 'Description'; ToolTip = 'Specifies the description of the product.'; DataClassification = CustomerContent; trigger OnValidate() begin TestStatusDraft(); end; } field(30; Status; Enum "Price Status") { Caption = 'Price Status'; ToolTip = '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.'; DataClassification = CustomerContent; trigger OnValidate() begin TestHeadersValue(FieldNo(Status)); end; } field(31; "Direct Unit Cost"; Decimal) { AccessByPermission = tabledata "Purchase Price Access" = R; DataClassification = CustomerContent; AutoFormatExpression = Rec."Currency Code"; AutoFormatType = 2; Caption = 'Direct Unit Cost'; ToolTip = 'Specifies the direct unit cost of the product.'; MinValue = 0; trigger OnValidate() begin TestStatusDraft(); if not CheckDefaultValueExists("Direct Unit Cost") then CheckAmountType(FieldCaption("Direct Unit Cost"), "Amount Type"::Discount); Verify(); end; } field(32; "Source Group"; Enum "Price Source Group") { Caption = 'Source Group'; DataClassification = CustomerContent; } field(33; "Product No."; Code[20]) { Caption = 'Product No.'; ToolTip = '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 apply to all items for which a price is not specified.'; DataClassification = CustomerContent; TableRelation = if ("Asset Type" = const(Item)) Item where("No." = field("Product No.")) else if ("Asset Type" = const("G/L Account")) "G/L Account" else if ("Asset Type" = const(Resource)) Resource else if ("Asset Type" = const("Resource Group")) "Resource Group" else if ("Asset Type" = const("Item Discount Group")) "Item Discount Group"; ValidateTableRelation = false; trigger OnValidate() begin Validate("Asset No.", "Product No."); end; } field(34; "Assign-to No."; Code[20]) { Caption = 'Assign-to No.'; ToolTip = '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.'; DataClassification = CustomerContent; TableRelation = if ("Source Type" = const(Campaign)) Campaign else if ("Source Type" = const(Contact)) Contact else if ("Source Type" = const(Customer)) Customer else if ("Source Type" = const("Customer Disc. Group")) "Customer Discount Group" else if ("Source Type" = const("Customer Price Group")) "Customer Price Group" else if ("Source Type" = const(Job)) Job else if ("Source Type" = const("Job Task")) "Job Task"."Job Task No." where("Job No." = field("Parent Source No."), "Job Task Type" = const(Posting)) else if ("Source Type" = const(Vendor)) Vendor; ValidateTableRelation = false; trigger OnValidate() begin Validate("Source No.", "Assign-to No."); end; } field(35; "Assign-to Parent No."; Code[20]) { Caption = 'Assign-to Parent No.'; ToolTip = 'Specifies the project to which the prices are assigned. If you choose an entity, the price list will be used only for that entity.'; DataClassification = CustomerContent; TableRelation = if ("Source Type" = const("Job Task")) Job; ValidateTableRelation = false; trigger OnValidate() begin Validate("Parent Source No.", "Assign-to Parent No."); end; } field(36; "Variant Code Lookup"; Code[10]) { Caption = 'Variant Code'; ToolTip = 'Specifies the item variant.'; TableRelation = if ("Asset Type" = const(Item)) "Item Variant".Code where("Item No." = field("Asset No.")); ValidateTableRelation = false; trigger OnValidate() begin Validate("Variant Code", "Variant Code Lookup"); end; } field(37; "Unit of Measure Code Lookup"; Code[10]) { Caption = 'Unit of Measure Code'; ToolTip = 'Specifies the unit of measure for the product.'; TableRelation = if ("Asset Type" = const(Item)) "Item Unit of Measure".Code where("Item No." = field("Asset No.")) else if ("Asset Type" = const(Resource)) "Resource Unit of Measure".Code where("Resource No." = field("Asset No.")) else if ("Asset Type" = const("Resource Group")) "Unit of Measure"; ValidateTableRelation = false; trigger OnValidate() begin Validate("Unit of Measure Code", "Unit of Measure Code Lookup"); end; } } keys { key(PK; "Price List Code", "Line No.") { Clustered = true; } key(Key1; "Asset Type", "Asset No.", "Source Type", "Source No.", "Starting Date", "Currency Code", "Variant Code", "Unit of Measure Code", "Minimum Quantity") { } key(Key2; "Source Type", "Source No.", "Asset Type", "Asset No.", "Starting Date", "Currency Code", "Variant Code", "Unit of Measure Code", "Minimum Quantity") { } key(Key3; Status, "Price Type", "Amount Type", "Currency Code", "Unit of Measure Code", "Source Type", "Source No.", "Asset Type", "Asset No.", "Variant Code", "Starting Date", "Ending Date", "Minimum Quantity") { } key(Key4; Status, "Price Type", "Amount Type", "Currency Code", "Unit of Measure Code", "Source Type", "Parent Source No.", "Source No.", "Asset Type", "Asset No.", "Work Type Code", "Starting Date", "Ending Date", "Minimum Quantity") { } key(Key5; "Product No.", "Asset No.") { } } trigger OnDelete() begin if (Status = Status::Active) and not IsEditable() then Error(CannotDeleteActivePriceListLineErr, "Price List Code", "Line No."); end; trigger OnInsert() begin if ("Price List Code" = '') and ("Price Type" = "Price Type"::Sale) and ("Amount Type" <> "Amount Type"::Discount) then begin if not ("Source Type" in ["Source Type"::Customer, "Source Type"::"Customer Price Group"]) then "Allow Line Disc." := true; if ("Source Type" <> "Source Type"::"Customer Price Group") and ("Asset Type" <> "Asset Type"::Item) then "Allow Invoice Disc." := true; end; end; protected var PriceListHeader: Record "Price List Header"; PriceAsset: Record "Price Asset"; PriceSource: Record "Price Source"; var PriceCalculationMgt: Codeunit "Price Calculation Mgt."; IsNewRecord: Boolean; FieldLookedUp: Boolean; FieldNotAllowedForAmountTypeErr: Label 'Field %1 is not allowed in the price list line where %2 is %3.', Comment = '%1 - the field caption; %2 - Amount Type field caption; %3 - amount type value: Discount or Price'; LineSourceTypeErr: Label 'cannot be set to %1 if the header''s source type is %2.', Comment = '%1 and %2 - the source type value.'; CannotDeleteActivePriceListLineErr: Label 'You cannot delete the active price list line %1 %2.', Comment = '%1 - the price list code, %2 - line no'; procedure SetNextLineNo() var PriceListLine: Record "Price List Line"; IsHandled: Boolean; begin IsHandled := false; OnBeforeSetNextLineNo(Rec, IsHandled); if IsHandled then exit; "Line No." := 10000; PriceListLine.SetLoadFields("Line No."); PriceListLine.SetRange("Price List Code", "Price List Code"); if PriceListLine.FindLast() then "Line No." += PriceListLine."Line No."; end; procedure IsAssetItem(): Boolean; begin exit("Asset Type" = "Asset Type"::Item); end; procedure IsAssetResource(): Boolean; begin exit("Asset Type" in ["Asset Type"::Resource, "Asset Type"::"Resource Group"]); end; procedure IsEditable() Result: Boolean; begin case Status of Status::Draft: exit(true); Status::Active: exit(IsAllowedEditingActivePrice()); else exit(false); end; end; procedure IsHeaderActive() Result: Boolean; begin GetHeader(); exit(PriceListHeader.Status = "Price Status"::Active); end; procedure IsLineToVerify() Result: Boolean; begin Result := (Status = Status::Draft) and IsHeaderActive(); end; local procedure IsAllowedEditingActivePrice() Result: Boolean; var PriceListManagement: Codeunit "Price List Management"; begin Result := PriceListManagement.IsAllowedEditingActivePrice("Price Type"); OnAfterIsAllowedEditingActivePrice(Rec, Result); end; procedure IsUOMSupported() Result: Boolean; begin Result := IsAssetItem() or IsAssetResource(); OnAfterIsUOMSupported(Rec, Result); end; procedure IsAmountMandatory(AmountType: enum "Price Amount Type"): Boolean; var ClientTypeManagement: Codeunit "Client Type Management"; begin if ClientTypeManagement.GetCurrentClientType() in [CLIENTTYPE::OData, CLIENTTYPE::ODataV4] then exit(true); case "Amount Type" of "Amount Type"::Any: exit(true) else exit(AmountType = "Amount Type"); end; end; procedure IsAmountSupported(): Boolean; begin exit("Asset Type" <> "Asset Type"::"Item Discount Group"); end; procedure IsRealLine(): Boolean; begin exit("Line No." <> 0); end; procedure IsSourceNoAllowed(): Boolean; var PriceSourceInterface: Interface "Price Source"; begin PriceSourceInterface := "Source Type"; exit(PriceSourceInterface.IsSourceNoAllowed()); end; procedure CheckAmountType(FldCaption: Text; AmountType: Enum "Price Amount Type") begin if "Amount Type" = AmountType then Error(FieldNotAllowedForAmountTypeErr, FldCaption, FieldCaption("Amount Type"), Format("Amount Type")); end; procedure CopySourceFrom(PriceListHeader: Record "Price List Header") begin "Source Group" := PriceListHeader."Source Group"; "Source Type" := PriceListHeader."Source Type"; SetSourceNo(PriceListHeader."Parent Source No.", PriceListHeader."Source No."); "Source ID" := PriceListHeader."Source ID"; OnAfterCopySourceFrom(Rec, PriceListHeader); end; procedure CopyFrom(PriceListHeader: Record "Price List Header") begin CopyFrom(PriceListHeader, false); end; procedure CopyFrom(PriceListHeader: Record "Price List Header"; ForceDefaults: Boolean) begin "Price Type" := PriceListHeader."Price Type"; Status := "Price Status"::Draft; if not PriceListHeader."Allow Updating Defaults" or ForceDefaults then begin CopySourceFrom(PriceListHeader); "Starting Date" := PriceListHeader."Starting Date"; "Ending Date" := PriceListHeader."Ending Date"; "Currency Code" := PriceListHeader."Currency Code"; end; if PriceListHeader."Amount Type" <> "Price Amount Type"::Any then Validate("Amount Type", PriceListHeader."Amount Type"); "Price Includes VAT" := PriceListHeader."Price Includes VAT"; "VAT Bus. Posting Gr. (Price)" := PriceListHeader."VAT Bus. Posting Gr. (Price)"; "Allow Invoice Disc." := PriceListHeader."Allow Invoice Disc."; "Allow Line Disc." := PriceListHeader."Allow Line Disc."; OnAfterCopyFromPriceListHeader(PriceListHeader, ForceDefaults); end; local procedure CopyFrom(PriceSource: Record "Price Source") begin "Price Type" := PriceSource."Price Type"; "Source Group" := PriceSource."Source Group"; "Source Type" := PriceSource."Source Type"; SetSourceNo(PriceSource."Parent Source No.", PriceSource."Source No."); "Source ID" := PriceSource."Source ID"; if not GetHeader() or PriceListHeader."Allow Updating Defaults" then begin "Currency Code" := PriceSource."Currency Code"; "Price Includes VAT" := PriceSource."Price Includes VAT"; "Allow Invoice Disc." := PriceSource."Allow Invoice Disc."; "Allow Line Disc." := PriceSource."Allow Line Disc."; "VAT Bus. Posting Gr. (Price)" := PriceSource."VAT Bus. Posting Gr. (Price)"; "Starting Date" := PriceSource."Starting Date"; "Ending Date" := PriceSource."Ending Date"; end; OnAfterCopyFromPriceSource(PriceSource, Rec); end; procedure CopyFrom(PriceAsset: Record "Price Asset") begin if PriceAsset."Amount Type" <> PriceAsset."Amount Type"::Any then "Amount Type" := PriceAsset."Amount Type"; "Price Type" := PriceAsset."Price Type"; "Asset Type" := PriceAsset."Asset Type"; SetAssetNo(PriceAsset."Asset No."); "Asset ID" := PriceAsset."Asset ID"; Description := PriceAsset.Description; "Unit of Measure Code" := PriceAsset."Unit of Measure Code"; "Unit of Measure Code Lookup" := PriceAsset."Unit of Measure Code"; "Variant Code" := PriceAsset."Variant Code"; "Work Type Code" := PriceAsset."Work Type Code"; if not GetHeader() or PriceListHeader."Allow Updating Defaults" then if "VAT Bus. Posting Gr. (Price)" = '' then begin "Price Includes VAT" := PriceAsset."Price Includes VAT"; "VAT Bus. Posting Gr. (Price)" := PriceAsset."VAT Bus. Posting Gr. (Price)"; end; if (PriceListHeader.Code = '') or (IsNullGuid(PriceListHeader.SystemId)) or (not PriceListHeader."Allow Invoice Disc.") then "Allow Invoice Disc." := PriceAsset."Allow Invoice Disc."; CopyFromAssetType(); OnAfterCopyFromForPriceAsset(PriceAsset, Rec); end; procedure CopyPriceFrom(PriceAsset: Record "Price Asset") begin case PriceAsset."Price Type" of PriceAsset."Price Type"::Sale: "Unit Price" := PriceAsset."Unit Price"; PriceAsset."Price Type"::Purchase: begin "Direct Unit Cost" := PriceAsset."Unit Price"; "Unit Cost" := PriceAsset."Unit Price 2"; end; end; OnAfterCopyPriceFrom(Rec, PriceAsset); end; procedure SetNewRecord(NewRecord: Boolean) begin IsNewRecord := NewRecord; end; local procedure CopyRecTo(var PriceAsset: Record "Price Asset") begin if IsNewRecord then CopyTo(PriceAsset) else xRec.CopyTo(PriceAsset); end; local procedure CopyRecTo(var PriceSource: Record "Price Source") begin if IsNewRecord then CopyTo(PriceSource) else xRec.CopyTo(PriceSource); end; procedure CopyTo(var PriceAsset: Record "Price Asset") begin PriceAsset."Price Type" := "Price Type"; PriceAsset."Asset Type" := "Asset Type"; PriceAsset."Asset No." := "Asset No."; PriceAsset.Description := Description; PriceAsset."Asset ID" := "Asset ID"; PriceAsset."Unit of Measure Code" := "Unit of Measure Code"; PriceAsset."Variant Code" := "Variant Code"; PriceAsset."Allow Invoice Disc." := "Allow Invoice Disc."; PriceAsset."Price Includes VAT" := "Price Includes VAT"; PriceAsset."VAT Bus. Posting Gr. (Price)" := "VAT Bus. Posting Gr. (Price)"; OnAfterCopyToPriceAsset(PriceAsset); end; procedure CopyTo(var PriceSource: Record "Price Source") begin PriceSource."Price Type" := "Price Type"; PriceSource."Source Group" := "Source Group"; PriceSource.Validate("Source Type", "Source Type"); PriceSource."Parent Source No." := "Parent Source No."; PriceSource."Source No." := "Source No."; PriceSource."Source ID" := "Source ID"; PriceSource."Currency Code" := "Currency Code"; PriceSource."Price Includes VAT" := "Price Includes VAT"; PriceSource."Allow Invoice Disc." := "Allow Invoice Disc."; PriceSource."Allow Line Disc." := "Allow Line Disc."; PriceSource."VAT Bus. Posting Gr. (Price)" := "VAT Bus. Posting Gr. (Price)"; PriceSource."Starting Date" := "Starting Date"; PriceSource."Ending Date" := "Ending Date"; OnAfterCopyToPriceSource(PriceSource); end; procedure CopyFilteredLinesToTemporaryBuffer(var TempPriceListLine: Record "Price List Line" temporary) Copied: Boolean; var IsHandled: Boolean; begin IsHandled := false; OnBeforeCopyFilteredLinesToTemporaryBuffer(Rec, TempPriceListLine, Copied, IsHandled); if IsHandled then exit; if FindSet() then repeat TempPriceListLine := Rec; OnCopyFilteredLinesToTemporaryBufferOnBeforeInsert(TempPriceListLine); if TempPriceListLine.Insert() then Copied := true; until Next() = 0; OnAfterCopyFilteredLinesToTemporaryBuffer(TempPriceListLine); end; local procedure GetHeader(): Boolean; begin if "Price List Code" <> '' then begin if PriceListHeader.Code <> "Price List Code" then exit(PriceListHeader.Get("Price List Code")); exit(true); end; Clear(PriceListHeader); end; procedure SetHeader(var NewPriceListHeader: Record "Price List Header") begin PriceListHeader := NewPriceListHeader; end; local procedure GetValueFromHeader(FieldId: Integer) begin if not GetHeader() then exit; case FieldId of FieldNo("Allow Invoice Disc."): "Allow Invoice Disc." := PriceListHeader."Allow Invoice Disc."; FieldNo("Allow Line Disc."): "Allow Line Disc." := PriceListHeader."Allow Line Disc."; end; end; local procedure InitHeaderDefaults() begin if GetHeader() then CopyFrom(PriceListHeader); OnAfterInitHeaderDefaults(PriceListHeader); end; local procedure IsSourceTypeSupported(): Boolean; var PriceSourceGroup: Interface "Price Source Group"; begin PriceSourceGroup := PriceListHeader."Source Group"; exit(PriceSourceGroup.IsSourceTypeSupported("Source Type")); end; procedure SetAssetNo(AssetNo: Code[20]) begin "Asset No." := AssetNo; "Product No." := AssetNo; end; local procedure SetSourceNo(ParentSourceNo: Code[20]; SourceNo: Code[20]) begin "Parent Source No." := ParentSourceNo; "Source No." := SourceNo; "Assign-to Parent No." := ParentSourceNo; "Assign-to No." := SourceNo; end; procedure SyncDropDownLookupFields() begin "Assign-to Parent No." := "Parent Source No."; "Assign-to No." := "Source No."; "Product No." := "Asset No."; "Unit of Measure Code Lookup" := "Unit of Measure Code"; "Variant Code Lookup" := "Variant Code"; end; local procedure TestHeadersValue(FieldId: Integer) var LineSourceTypeError: Text; begin if not GetHeader() then exit; TestStatusDraft(); case FieldId of FieldNo("Source Group"): TestField("Source Group", PriceListHeader."Source Group"); FieldNo(Status): TestField(Status, PriceListHeader.Status); end; if not PriceListHeader."Allow Updating Defaults" then case FieldId of FieldNo("Price Includes VAT"): TestField("Price Includes VAT", PriceListHeader."Price Includes VAT"); FieldNo("VAT Bus. Posting Gr. (Price)"): TestField("VAT Bus. Posting Gr. (Price)", PriceListHeader."VAT Bus. Posting Gr. (Price)"); FieldNo("Currency Code"): TestField("Currency Code", PriceListHeader."Currency Code"); FieldNo("Starting Date"): TestField("Starting Date", PriceListHeader."Starting Date"); FieldNo("Ending Date"): TestField("Ending Date", PriceListHeader."Ending Date"); FieldNo("Source Type"): if PriceListHeader."Source No." <> '' then TestField("Source Type", PriceListHeader."Source Type") else begin LineSourceTypeError := StrSubstNo(LineSourceTypeErr, "Source Type", PriceListHeader."Source Type"); if "Source Type".AsInteger() < PriceListHeader."Source Type".AsInteger() then FieldError("Source Type", LineSourceTypeError); if not IsSourceTypeSupported() then FieldError("Source Type", LineSourceTypeError); end; FieldNo("Source No."): if PriceListHeader."Source No." <> '' then TestField("Source No.", PriceListHeader."Source No."); FieldNo("Source Id"): if PriceListHeader."Source No." <> '' then TestField("Source Id", PriceListHeader."Source Id"); FieldNo("Parent Source No."): if PriceListHeader."Parent Source No." <> '' then TestField("Parent Source No.", PriceListHeader."Parent Source No."); end; end; procedure TestStatusDraft() begin if not IsEditable() then TestField(Status, Status::Draft); end; procedure Verify() var IsHandled: Boolean; begin IsHandled := false; OnBeforeVerify(Rec, IsHandled); if IsHandled then exit; VerifySource(); TestField("Asset Type"); if ("Asset Type" = "Asset Type"::Item) and ("Amount Type" <> "Amount Type"::Discount) then TestField("Asset No."); OnAfterVerify(Rec); end; local procedure VerifyParentSource() Result: Boolean; var PriceSourceLocal: Record "Price Source"; PriceSourceInterface: Interface "Price Source"; begin CopyTo(PriceSourceLocal); PriceSourceInterface := "Source Type"; Result := PriceSourceInterface.VerifyParent(PriceSourceLocal); end; local procedure VerifyAmountTypeForSourceType(AmountType: Enum "Price Amount Type") begin CopyTo(PriceSource); PriceSource.VerifyAmountTypeForSourceType(AmountType); end; procedure VerifySource() begin if VerifyParentSource() then TestField("Parent Source No.") else TestField("Parent Source No.", ''); if IsSourceNoAllowed() then TestField("Source No.") else TestField("Source No.", ''); end; procedure UseCustomizedLookup(): Boolean var SalesReceivablesSetup: Record "Sales & Receivables Setup"; PriceListLineSync: Codeunit "Price List Line Sync"; begin if not PriceListLineSync.IsPriceListLineSynchronized() then begin if GuiAllowed() then PriceListLineSync.SendOutOfSyncNotification(); exit(true); end; SalesReceivablesSetup.Get(); exit(SalesReceivablesSetup."Use Customized Lookup"); end; procedure RenameNo(LineType: Enum "Price Asset Type"; OldNo: Code[20]; NewNo: Code[20]) begin Reset(); SetRange("Asset Type", LineType); SetRange("Product No.", OldNo); if not Rec.IsEmpty() then ModifyAll("Product No.", NewNo, true); end; local procedure CopyFromAssetType() var Item: Record Item; GLAccount: Record "G/L Account"; Resource: Record Resource; IsHandled: Boolean; begin OnBeforeCopyFromAssetType(Rec, IsHandled); if IsHandled then exit; if "Asset No." = '' then exit; case "Asset Type" of "Asset Type"::Item: begin Item.Get("Asset No."); Validate("VAT Prod. Posting Group", Item."VAT Prod. Posting Group"); OnCopyFromAssetTypeOnAfterCopyFromAssetTypeItem(Item, Rec); end; "Asset Type"::"G/L Account": begin GLAccount.Get("Asset No."); Validate("VAT Prod. Posting Group", GLAccount."VAT Prod. Posting Group"); OnCopyFromAssetTypeOnAfterCopyFromAssetTypeGLAccount(GLAccount, Rec); end; "Asset Type"::Resource: begin Resource.Get("Asset No."); Validate("VAT Prod. Posting Group", Resource."VAT Prod. Posting Group"); OnCopyFromAssetTypeOnAfterCopyFromAssetTypeResource(Resource, Rec); end; else begin OnCopyFromAssetTypeElseCase(Rec, IsHandled); if IsHandled then exit; end; end; end; local procedure CheckDefaultValueExists(Value: Decimal): Boolean begin exit(Value = 0); end; [IntegrationEvent(true, false)] local procedure OnAfterCopyFromForPriceAsset(PriceAsset: Record "Price Asset"; var PriceListLine: Record "Price List Line") begin end; [IntegrationEvent(true, false)] local procedure OnAfterCopyFromPriceListHeader(PriceListHeader: Record "Price List Header"; ForceDefaults: Boolean) begin end; [IntegrationEvent(true, false)] local procedure OnAfterCopyFromPriceSource(PriceSource: Record "Price Source"; var PriceListLine: Record "Price List Line") begin end; [IntegrationEvent(false, false)] local procedure OnAfterCopyPriceFrom(var PriceListLine: Record "Price List Line"; PriceAsset: Record "Price Asset") begin end; [IntegrationEvent(false, false)] local procedure OnAfterCopySourceFrom(var PriceListLine: Record "Price List Line"; PriceListHeader: Record "Price List Header") begin end; [IntegrationEvent(true, false)] local procedure OnAfterCopyToPriceAsset(var PriceAsset: Record "Price Asset") begin end; [IntegrationEvent(true, false)] local procedure OnAfterCopyToPriceSource(var PriceSource: Record "Price Source") begin end; [IntegrationEvent(true, false)] local procedure OnAfterInitHeaderDefaults(PriceListHeader: Record "Price List Header") begin end; [IntegrationEvent(false, false)] local procedure OnAfterIsAllowedEditingActivePrice(PriceListLine: Record "Price List Line"; var Result: Boolean) begin end; [IntegrationEvent(false, false)] procedure OnAfterIsUOMSupported(PriceListLine: Record "Price List Line"; var Result: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnAfterVerify(var PriceListLine: Record "Price List Line") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeVerify(var PriceListLine: Record "Price List Line"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnCopyFilteredLinesToTemporaryBufferOnBeforeInsert(var TempPriceListLine: Record "Price List Line" temporary) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeCopyFromAssetType(var PriceListLine: Record "Price List Line"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeSetNextLineNo(var PriceListLine: Record "Price List Line"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnCopyFromAssetTypeElseCase(var PriceListLine: Record "Price List Line"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnCopyFromAssetTypeOnAfterCopyFromAssetTypeItem(Item: Record Item; var PriceListLine: Record "Price List Line") begin end; [IntegrationEvent(false, false)] local procedure OnCopyFromAssetTypeOnAfterCopyFromAssetTypeGLAccount(GLAccount: Record "G/L Account"; var PriceListLine: Record "Price List Line") begin end; [IntegrationEvent(false, false)] local procedure OnCopyFromAssetTypeOnAfterCopyFromAssetTypeResource(Resource: Record Resource; var PriceListLine: Record "Price List Line") begin end; [IntegrationEvent(false, false)] local procedure OnAfterCopyFilteredLinesToTemporaryBuffer(var TempPriceListLine: Record "Price List Line" temporary) begin end; [IntegrationEvent(true, false)] local procedure OnBeforeCopyFilteredLinesToTemporaryBuffer(var PriceListLine: Record "Price List Line"; var TempPriceListLine: Record "Price List Line" temporary; var Copied: Boolean; var IsHandled: Boolean) begin end;}