Page 7022 Price Worksheet
src/Layers/W1/BaseApp/Pricing/Worksheet/PriceWorksheet.Page.al866 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.Worksheet;using Microsoft.Pricing.Calculation;using Microsoft.Pricing.PriceList;using Microsoft.Pricing.Source;using Microsoft.Projects.Project.Pricing;using Microsoft.Purchases.Pricing;using Microsoft.Sales.Pricing;using System.Environment.Configuration;using System.Integration.Excel;page 7022 "Price Worksheet"{ Caption = 'Price Worksheet'; PageType = Worksheet; DelayedInsert = true; SaveValues = true; SourceTable = "Price Worksheet Line"; ApplicationArea = Basic, Suite; UsageCategory = Tasks; layout { area(content) { group(General) { Caption = 'General'; field(PriceTypeFilter; PriceType) { ApplicationArea = Basic, Suite; Caption = 'Price Type'; ToolTip = 'Specifies a filter for which prices to display: sale or purchase.'; trigger OnValidate() begin InitSourceGroup(); SetRecFilters(); end; } field(Defaults; Defaults) { ApplicationArea = Basic, Suite; Editable = false; Caption = 'Defaults'; ToolTip = 'Specifies the fields of the price list header that is used as defaults for new lines created in the worksheet.'; trigger OnDrillDown() begin ShowPriceListFilters(); end; } field(SourceGroupFilter; SourceGroup) { ApplicationArea = Basic, Suite; Caption = 'Assign-to Group'; ToolTip = 'Specifies a filter for which group the prices apply to: customer, vendor, or project.'; trigger OnValidate() begin InitSourceGroup(); SetRecFilters(); end; } field(ModifyExistingLines; UpdateMultiplePriceLists) { ApplicationArea = Basic, Suite; Caption = 'Update multiple price lists'; ToolTip = '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.'; trigger OnValidate() begin CurrPage.SaveRecord(); CurrPage.Update(false); end; } } repeater(Lines) { ShowCaption = false; field("Price List Code"; Rec."Price List Code") { ApplicationArea = Basic, Suite; Visible = UpdateMultiplePriceLists; Editable = false; trigger OnDrillDown() var PriceUXManagement: Codeunit "Price UX Management"; begin PriceUXManagement.EditPriceList(Rec."Price List Code"); end; } field("Existing Line"; Rec."Existing Line") { ApplicationArea = Basic, Suite; Visible = UpdateMultiplePriceLists; Editable = false; } field(Status; Rec.Status) { ApplicationArea = Basic, Suite; Editable = false; Style = Attention; StyleExpr = ModifiedLine; } field(CustomerSourceType; CustomerSourceType) { ApplicationArea = All; Importance = Promoted; Caption = 'Assign-to Type'; Visible = CustomerSourceTypeVisible; ToolTip = 'Specifies the type of entity to which the price list is assigned. The options are relevant to the entity you are currently viewing.'; trigger OnValidate() begin ValidateSourceType(CustomerSourceType.AsInteger()); end; } field(VendorSourceType; VendorSourceType) { ApplicationArea = All; Importance = Promoted; Caption = 'Assign-to Type'; Visible = VendorSourceTypeVisible; ToolTip = 'Specifies the type of entity to which the price list is assigned. The options are relevant to the entity you are currently viewing.'; trigger OnValidate() begin ValidateSourceType(VendorSourceType.AsInteger()); end; } field(JobSourceType; JobSourceType) { ApplicationArea = All; Importance = Promoted; Caption = 'Assign-to Type'; Visible = JobSourceGroup; ToolTip = 'Specifies the type of entity to which the price list is assigned. The options are relevant to the entity you are currently viewing.'; trigger OnValidate() begin ValidateSourceType(JobSourceType.AsInteger()); end; } field("Parent Source No."; Rec."Parent Source No.") { ApplicationArea = Basic, Suite; Visible = ParentSourceNoVisible; Editable = ParentSourceNoEditable; ShowMandatory = ParentSourceEditable; } field("Source No."; Rec."Source No.") { ApplicationArea = Basic, Suite; Editable = SourceEditable; ShowMandatory = SourceEditable; Visible = UseCustomLookup; } field("Assign-to Parent No."; Rec."Assign-to Parent No.") { ApplicationArea = Basic, Suite; Visible = AssignToParentNoVisible; Editable = ParentSourceEditable; ShowMandatory = ParentSourceEditable; } field("Assign-to No."; Rec."Assign-to No.") { ApplicationArea = Basic, Suite; Editable = SourceEditable; ShowMandatory = SourceEditable; Visible = not UseCustomLookup; } field("Asset Type"; Rec."Asset Type") { ApplicationArea = Basic, Suite; Editable = ProductTypeEditable; } field("Asset No."; Rec."Asset No.") { ApplicationArea = Basic, Suite; Editable = PriceLineEditable; ShowMandatory = true; Visible = UseCustomLookup; } field("Product No."; Rec."Product No.") { ApplicationArea = Basic, Suite; Editable = PriceLineEditable; ShowMandatory = true; Visible = not UseCustomLookup; } field("Variant Code"; Rec."Variant Code") { ApplicationArea = Basic, Suite; Visible = VariantCodeVisible; Editable = VariantCodeEditable; } field("Variant Code Lookup"; Rec."Variant Code Lookup") { ApplicationArea = Basic, Suite; Visible = VariantCodeLookupVisible; Editable = VariantCodeEditable; } field("Work Type Code"; Rec."Work Type Code") { ApplicationArea = Jobs; Visible = ResourceAssetVisible; Editable = WorkTypeCodeEditable; } field("Currency Code"; Rec."Currency Code") { ApplicationArea = Suite; Editable = DateEditable; } field("Unit of Measure Code"; Rec."Unit of Measure Code") { ApplicationArea = Basic, Suite; Visible = UoMVisible; Editable = PriceLineEditable; } field("Unit of Measure Code Lookup"; Rec."Unit of Measure Code Lookup") { ApplicationArea = Basic, Suite; Visible = UoMLookupVisible; Editable = PriceLineEditable; } field("Minimum Quantity"; Rec."Minimum Quantity") { ApplicationArea = Basic, Suite; Editable = PriceLineEditable; } field("Amount Type"; Rec."Amount Type") { ApplicationArea = Basic, Suite; Visible = AmountTypeIsVisible; Editable = AmountTypeIsEditable; } field("Existing Unit Price"; Rec."Existing Unit Price") { ApplicationArea = Basic, Suite; Visible = SalesPriceVisible; } field("Unit Price"; Rec."Unit Price") { Caption = 'New Unit Price'; ApplicationArea = Basic, Suite; Visible = SalesPriceVisible; Editable = UnitPriceEditable; Style = Attention; StyleExpr = ModifiedUnitPrice and SalesPriceLine and PriceEditable; } field("Cost Factor"; Rec."Cost Factor") { ApplicationArea = Basic, Suite; Visible = SalesPriceVisible; Editable = UnitPriceEditable; } field("Existing Direct Unit Cost"; Rec."Existing Direct Unit Cost") { ApplicationArea = Basic, Suite; Visible = PurchPriceVisible; } field("Direct Unit Cost"; Rec."Direct Unit Cost") { Caption = 'New Direct Unit Cost'; ApplicationArea = Basic, Suite; Visible = PurchPriceVisible; Editable = UnitPriceEditable; Style = Attention; StyleExpr = ModifiedDirectUnitCost and PurchPriceLine and PriceEditable; } field("Existing Unit Cost"; Rec."Existing Unit Cost") { ApplicationArea = Basic, Suite; Visible = PurchPriceVisible; } field("Unit Cost"; Rec."Unit Cost") { ApplicationArea = Basic, Suite; Visible = PurchPriceVisible; Editable = UnitPriceEditable; Style = Attention; StyleExpr = ModifiedUnitCost and PurchPriceLine and PriceEditable; } field("Line Discount %"; Rec."Line Discount %") { ApplicationArea = Basic, Suite; Visible = DiscountVisible; Editable = LineDiscountEditable; } field("Starting Date"; Rec."Starting Date") { ApplicationArea = Basic, Suite; Editable = DateEditable; } field("Ending Date"; Rec."Ending Date") { ApplicationArea = Basic, Suite; Editable = DateEditable; } field("Allow Line Disc."; Rec."Allow Line Disc.") { ApplicationArea = Basic, Suite; Visible = PriceVisible; Editable = PriceLineEditable; } field("Allow Invoice Disc."; Rec."Allow Invoice Disc.") { ApplicationArea = Basic, Suite; Visible = PriceVisible; Editable = PriceLineEditable; } field("VAT Bus. Posting Gr. (Price)"; Rec."VAT Bus. Posting Gr. (Price)") { ApplicationArea = Basic, Suite; Visible = false; Editable = PriceLineEditable; ToolTip = 'Specifies the VAT business posting group for customers for whom you want the price (which includes VAT) to apply.'; } field("Price Includes VAT"; Rec."Price Includes VAT") { ApplicationArea = Basic, Suite; Visible = false; Editable = PriceLineEditable; } } } area(factboxes) { systempart(Control1900383207; Links) { ApplicationArea = RecordLinks; Visible = false; } systempart(Control1905767507; Notes) { ApplicationArea = Notes; Visible = false; } } } actions { area(Navigation) { action(OpenPriceList) { ApplicationArea = All; Caption = 'Open Price List'; Image = EditLines; Visible = LineExists; ToolTip = 'View or edit the price list.'; trigger OnAction() var PriceUXManagement: Codeunit "Price UX Management"; begin PriceUXManagement.EditPriceList(Rec."Price List Code"); end; } } area(processing) { group("F&unctions") { Caption = 'F&unctions'; Image = "Action"; action(SuggestLines) { ApplicationArea = Basic, Suite; Ellipsis = true; Image = SuggestItemPrice; Caption = 'Suggest Lines'; ToolTip = '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.'; trigger OnAction() begin if DefaultPriceListCode = '' then Error(DefinePriceListCodeErr); PriceListManagement.AddLines(TempWorksheetPriceListHeader); Defaults := GetDefaults(); CurrPage.Update(false); end; } action(CopyLines) { ApplicationArea = Basic, Suite; Ellipsis = true; Image = CopyWorksheet; Enabled = CopyLinesEnabled; Caption = 'Copy Lines'; ToolTip = '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.'; trigger OnAction() begin if DefaultPriceListCode = '' then Error(DefinePriceListCodeErr); PriceListManagement.CopyLines(TempWorksheetPriceListHeader, UpdateMultiplePriceLists); Defaults := GetDefaults(); CurrPage.Update(false); end; } action(ImplementPriceChange) { ApplicationArea = Basic, Suite; Caption = 'I&mplement Price Change'; Ellipsis = true; Image = ImplementPriceChange; Scope = Repeater; ToolTip = 'Update the alternate prices with the ones in the Price Worksheet window.'; trigger OnAction() var PriceWorksheetLine: Record "Price Worksheet Line"; begin CurrPage.SetSelectionFilter(PriceWorksheetLine); if PriceWorksheetLine.Count() = 1 then begin PriceWorksheetLine.Reset(); PriceWorksheetLine.SetRange("Price Type", PriceType); PriceWorksheetLine.SetRange("Source Group", SourceGroup); end; PriceListManagement.ImplementNewPrices(PriceWorksheetLine); end; } } group("Page") { Caption = 'Page'; action(EditInExcel) { ApplicationArea = Basic, Suite; Caption = 'Edit in Excel'; Image = Excel; ToolTip = 'Send the data in the worksheet to an Excel file for analysis or editing.'; Visible = false; //IsSaaSExcelAddinEnabled; AccessByPermission = System "Allow Action Export To Excel" = X; trigger OnAction() var EditinExcel: Codeunit "Edit in Excel"; EditinExcelFilters: Codeunit "Edit in Excel Filters"; begin EditinExcelFilters.AddFieldV2('Price_Type', Enum::"Edit in Excel Filter Type"::Equal, format(Rec."Price Type"), Enum::"Edit in Excel Edm Type"::"Edm.String"); EditinExcelFilters.AddFieldV2('Source_Group', Enum::"Edit in Excel Filter Type"::Equal, format(Rec."Source Group"), Enum::"Edit in Excel Edm Type"::"Edm.String"); EditinExcel.EditPageInExcel(CopyStr(CurrPage.Caption, 1, 240), Page::"Price Worksheet", EditinExcelFilters); end; } } } area(Promoted) { group(Category_Process) { Caption = 'Process', Comment = 'Generated from the PromotedActionCategories property index 1.'; actionref(ImplementPriceChange_Promoted; ImplementPriceChange) { } actionref(SuggestLines_Promoted; SuggestLines) { } actionref(CopyLines_Promoted; CopyLines) { } actionref(OpenPriceList_Promoted; OpenPriceList) { } } group(Category_Category4) { Caption = 'Page', Comment = 'Generated from the PromotedActionCategories property index 3.'; } group(Category_Report) { Caption = 'Report', Comment = 'Generated from the PromotedActionCategories property index 2.'; } } } trigger OnInit() var FeaturePriceCalculation: Codeunit "Feature - Price Calculation"; begin OnBeforeOnInit(); FeaturePriceCalculation.FailIfFeatureDisabled(); end; trigger OnNewRecord(BelowxRec: Boolean) begin Rec.SetNewRecord(true); Rec.TransferFields(TempWorksheetPriceListLine); Rec.Validate("Asset Type", xRec."Asset Type"); Rec."Line No." := 0; end; trigger OnOpenPage() var PriceListLine: Record "Price List Line"; ServerSetting: Codeunit "Server Setting"; begin OnBeforeOpenPage(TempWorksheetPriceListHeader, TempWorksheetPriceListLine, UpdateMultiplePriceLists); UseCustomLookup := PriceListLine.UseCustomizedLookup(); IsSaaSExcelAddinEnabled := ServerSetting.GetIsSaasExcelAddinEnabled(); CopyLinesEnabled := PriceListManagement.VerifySourceGroupInLines(); InitSourceGroup(); UpdateSourceType(); SetRecFilters(); end; trigger OnAfterGetRecord() begin UpdateSourceType(); SetFieldsStyle(); end; trigger OnAfterGetCurrRecord() begin UpdateSourceType(); SetEditableFields(); LineExists := Rec."Price List Code" <> ''; end; var CurrPriceListHeader: Record "Price List Header"; TempWorksheetPriceListHeader: Record "Price List Header" temporary; TempWorksheetPriceListLine: Record "Price List Line" temporary; PriceListManagement: Codeunit "Price List Management"; IsSaaSExcelAddinEnabled: Boolean; DefaultPriceListCode: Code[20]; DefaultPriceListCodeLbl: Text; Defaults: Text; DefinePriceListCodeErr: Label 'Define the default price list.'; DefinePriceListCodeLbl: Label 'Define the price list...'; UpdateMultiplePriceLists: Boolean; DefaultsLbl: Label '%1 = %2; ', Locked = true; CopyLinesEnabled: Boolean; protected var CustomerSourceType: Enum "Sales Price Source Type"; VendorSourceType: Enum "Purchase Price Source Type"; JobSourceType: Enum "Job Price Source Type"; PriceType: Enum "Price Type"; SourceGroup: Enum "Price Source Group"; AllowEditingActivePrice: Boolean; JobSourceGroup: Boolean; AllowUpdatingDefaults: Boolean; AmountTypeIsEditable: Boolean; AmountTypeIsVisible: Boolean; AssetTypeEditable: Boolean; DiscountEditable: Boolean; DiscountVisible: Boolean; ItemAsset: Boolean; ItemAssetVisible: Boolean; VariantCodeEditable: Boolean; LineExists: Boolean; ModifiedLine: Boolean; ModifiedUnitPrice: Boolean; ModifiedUnitCost: Boolean; ModifiedDirectUnitCost: Boolean; ParentSourceNoEditable: Boolean; ParentSourceEditable: Boolean; SourceEditable: Boolean; PriceEditable: Boolean; PriceLineEditable: Boolean; UnitPriceEditable: Boolean; ProductTypeEditable: Boolean; DateEditable: Boolean; LineDiscountEditable: Boolean; PriceVisible: Boolean; PurchPriceLine: Boolean; PurchVisible: Boolean; ResourceAsset: Boolean; ResourceAssetVisible: Boolean; SalesPriceLine: Boolean; SalesVisible: Boolean; SalesPriceVisible: Boolean; PurchPriceVisible: Boolean; SourceNoEditable: Boolean; SourceTypeEditable: Boolean; WorkTypeCodeEditable: Boolean; CustomerSourceTypeVisible: Boolean; VendorSourceTypeVisible: Boolean; AssignToParentNoVisible: Boolean; ParentSourceNoVisible: Boolean; VariantCodeVisible: Boolean; VariantCodeLookupVisible: Boolean; UoMLookupVisible: Boolean; UoMVisible: Boolean; UseCustomLookup: Boolean; procedure SetPriceType(NewPriceType: Enum "Price Type") begin PriceType := NewPriceType; end; local procedure CalcSourceNoEditable() begin SourceNoEditable := Rec.IsSourceNoAllowed(); end; local procedure GetDefaults() Result: Text begin InitDefaultsLine(TempWorksheetPriceListHeader); Result := GetDefaults(TempWorksheetPriceListHeader.FieldCaption("Source Type"), Format(TempWorksheetPriceListHeader."Source Type"), true); Result += GetDefaults(TempWorksheetPriceListHeader.FieldCaption("Parent Source No."), TempWorksheetPriceListHeader."Parent Source No.", false); Result += GetDefaults(TempWorksheetPriceListHeader.FieldCaption("Source No."), TempWorksheetPriceListHeader."Source No.", false); Result += GetDefaults(TempWorksheetPriceListHeader.FieldCaption("Currency Code"), TempWorksheetPriceListHeader."Currency Code", false); Result += GetDefaults(TempWorksheetPriceListHeader.FieldCaption("Starting Date"), format(TempWorksheetPriceListHeader."Starting Date"), false); Result += GetDefaults(TempWorksheetPriceListHeader.FieldCaption("Ending Date"), format(TempWorksheetPriceListHeader."Ending Date"), false); OnAfterGetDefaults(Result, TempWorksheetPriceListHeader); end; local procedure GetDefaults(FldName: Text; FldValue: Text; ShowBlank: Boolean): Text; begin if ShowBlank or (FldValue <> '') then exit(StrSubstNo(DefaultsLbl, FldName, FldValue)) end; local procedure GetDefaultSourceType() DefaultSourceType: Enum "Price Source Type"; begin case SourceGroup of SourceGroup::Customer: DefaultSourceType := Rec."Source Type"::"All Customers"; SourceGroup::Vendor: DefaultSourceType := Rec."Source Type"::"All Vendors"; SourceGroup::Job: DefaultSourceType := Rec."Source Type"::"All Jobs"; end; end; local procedure InitDefaultsLine(TempWorksheetPriceListHeader: Record "Price List Header") begin TempWorksheetPriceListHeader."Allow Updating Defaults" := false; TempWorksheetPriceListLine.CopyFrom(TempWorksheetPriceListHeader); TempWorksheetPriceListLine."Amount Type" := TempWorksheetPriceListHeader."Amount Type"; end; local procedure InitPriceType() begin if PriceType = PriceType::Any then PriceType := PriceType::Sale; end; local procedure InitSourceGroup() begin CurrPage.SaveRecord(); InitPriceType(); if SourceGroup = SourceGroup::All then SourceGroup := SourceGroup::Customer; case SourceGroup of SourceGroup::Customer: if PriceType = PriceType::Purchase then SourceGroup := SourceGroup::Vendor; SourceGroup::Vendor: if PriceType = PriceType::Sale then SourceGroup := SourceGroup::Customer; end; JobSourceGroup := SourceGroup = SourceGroup::Job; SetDefaultPriceListCode(); end; local procedure SetDefaultPriceListCode() var xDefaultPriceListCode: Code[20]; begin xDefaultPriceListCode := DefaultPriceListCode; DefaultPriceListCode := PriceListManagement.GetDefaultPriceListCode(PriceType, SourceGroup, false); UpdateDefaults(xDefaultPriceListCode); SetPriceListCodeInWorksheetLines(); if DefaultPriceListCode = '' then DefaultPriceListCodeLbl := DefinePriceListCodeLbl else DefaultPriceListCodeLbl := DefaultPriceListCode; AllowEditingActivePrice := PriceListManagement.IsAllowedEditingActivePrice(PriceType); end; local procedure SetEditableFields() var PriceSource: Record "Price Source"; begin if Rec."Price List Code" = '' then AllowUpdatingDefaults := true else if Rec."Price List Code" <> CurrPriceListHeader.Code then begin AllowUpdatingDefaults := true; if CurrPriceListHeader.Get(Rec."Price List Code") then AllowUpdatingDefaults := CurrPriceListHeader."Allow Updating Defaults"; end; PriceSource."Source Type" := Rec."Source Type"; ParentSourceNoEditable := PriceSource.IsParentSourceAllowed(); AmountTypeIsEditable := PriceLineEditable and (Rec."Asset Type" <> Rec."Asset Type"::"Item Discount Group"); ItemAsset := Rec.IsAssetItem(); ResourceAsset := Rec.IsAssetResource(); PriceLineEditable := Rec.IsEditable(); CalcSourceNoEditable(); SetFieldsStyle(); end; local procedure SetFieldsStyle() begin ModifiedUnitPrice := Rec."Existing Unit Price" <> Rec."Unit Price"; ModifiedDirectUnitCost := Rec."Existing Direct Unit Cost" <> Rec."Direct Unit Cost"; ModifiedUnitCost := Rec."Existing Unit Cost" <> Rec."Unit Cost"; ModifiedLine := ModifiedUnitPrice or ModifiedDirectUnitCost or ModifiedUnitCost; SalesPriceLine := Rec."Price Type" = Rec."Price Type"::Sale; PurchPriceLine := Rec."Price Type" = Rec."Price Type"::Purchase; PriceEditable := Rec."Amount Type" in [Rec."Amount Type"::Any, Rec."Amount Type"::Price]; DiscountEditable := Rec."Amount Type" in [Rec."Amount Type"::Any, Rec."Amount Type"::Discount]; VariantCodeEditable := PriceLineEditable and ItemAsset; SourceEditable := PriceLineEditable and SourceNoEditable and AllowUpdatingDefaults; ParentSourceEditable := PriceLineEditable and ParentSourceNoEditable and AllowUpdatingDefaults; UnitPriceEditable := PriceLineEditable and PriceEditable; LineDiscountEditable := PriceLineEditable and DiscountEditable; DateEditable := PriceLineEditable and AllowUpdatingDefaults; ProductTypeEditable := PriceLineEditable and AssetTypeEditable; WorkTypeCodeEditable := PriceLineEditable and ResourceAsset; end; local procedure SetFilters() begin Rec.FilterGroup(2); Rec.SetRange("Price Type", PriceType); Rec.SetRange("Source Group", SourceGroup); Rec.FilterGroup(0); end; local procedure SetPriceListCodeInWorksheetLines() var PriceWorksheetLine: Record "Price Worksheet Line"; NewPriceWorksheetLine: Record "Price Worksheet Line"; begin if DefaultPriceListCode = '' then exit; PriceWorksheetLine.SetRange("Price Type", PriceType); PriceWorksheetLine.SetRange("Source Group", SourceGroup); PriceWorksheetLine.SetRange("Price List Code", ''); if PriceWorksheetLine.FindSet(true) then repeat PriceWorksheetLine.Delete(true); NewPriceWorksheetLine := PriceWorksheetLine; NewPriceWorksheetLine."Price List Code" := DefaultPriceListCode; NewPriceWorksheetLine."Line No." := 0; NewPriceWorksheetLine.Insert(true); until PriceWorksheetLine.Next() = 0; end; local procedure SetRecFilters() begin SetFilters(); SetVisibleFields(); CurrPage.Update(false); end; local procedure SetVisibleFields() begin SalesVisible := PriceType = PriceType::Sale; PurchVisible := PriceType = PriceType::Purchase; AmountTypeIsVisible := true;//AmountTypeFilter = AmountTypeFilter::Any; PriceVisible := true;//AmountTypeFilter in [AmountTypeFilter::Any, AmountTypeFilter::Price]; DiscountVisible := true;//AmountTypeFilter in [AmountTypeFilter::Any, AmountTypeFilter::Discount]; ItemAssetVisible := true;//(PriceAsset."Asset Type" = "Price Asset Type"::" ") or PriceListLine.IsAssetItem(); ResourceAssetVisible := true;//(PriceAsset."Asset Type" = "Price Asset Type"::" ") or PriceListLine.IsAssetResource(); SourceTypeEditable := true;//PriceSource."Source Type" = PriceSource."Source Type"::All; AssetTypeEditable := true;//PriceAsset."Asset Type" = PriceAsset."Asset Type"::" "; SalesPriceVisible := PriceVisible and SalesVisible; PurchPriceVisible := PriceVisible and PurchVisible; CustomerSourceTypeVisible := SourceGroup = SourceGroup::Customer; VendorSourceTypeVisible := SourceGroup = SourceGroup::Vendor; ParentSourceNoVisible := JobSourceGroup and UseCustomLookup; AssignToParentNoVisible := JobSourceGroup and not UseCustomLookup; VariantCodeVisible := ItemAssetVisible and UseCustomLookup; VariantCodeLookupVisible := ItemAssetVisible and not UseCustomLookup; UoMVisible := (ItemAssetVisible or ResourceAssetVisible) and UseCustomLookup; UoMLookupVisible := (ItemAssetVisible or ResourceAssetVisible) and not UseCustomLookup; end; procedure SetDefaults(PriceListHeader: Record "Price List Header") begin TempWorksheetPriceListHeader := PriceListHeader; Defaults := GetDefaults(); end; local procedure ShowPriceListFilters() var PriceListFilters: Page "Price List Filters"; begin PriceListFilters.Set(TempWorksheetPriceListHeader); PriceListFilters.LookupMode(true); if PriceListFilters.RunModal() = Action::LookupOK then begin PriceListFilters.GetRecord(TempWorksheetPriceListHeader); Defaults := GetDefaults(); CurrPage.Update(false); end; end; local procedure UpdateDefaults(xDefaultPriceListCode: Code[20]) var PriceListHeader: Record "Price List Header"; begin if DefaultPriceListCode = '' then begin Clear(TempWorksheetPriceListHeader); TempWorksheetPriceListHeader."Price Type" := PriceType; TempWorksheetPriceListHeader."Source Group" := SourceGroup; TempWorksheetPriceListHeader.Validate("Source Type", GetDefaultSourceType()); end else if xDefaultPriceListCode <> DefaultPriceListCode then if PriceListHeader.Get(DefaultPriceListCode) then begin TempWorksheetPriceListHeader := PriceListHeader; TempWorksheetPriceListHeader.Status := "Price Status"::Draft; end; Defaults := GetDefaults(); end; local procedure UpdateSourceType() begin case SourceGroup of SourceGroup::Customer: CustomerSourceType := "Sales Price Source Type".FromInteger(Rec."Source Type".AsInteger()); SourceGroup::Vendor: VendorSourceType := "Purchase Price Source Type".FromInteger(Rec."Source Type".AsInteger()); SourceGroup::Job: JobSourceType := "Job Price Source Type".FromInteger(Rec."Source Type".AsInteger()); end; CalcSourceNoEditable(); end; local procedure ValidateSourceType(SourceType: Integer) begin Rec.Validate("Source Type", SourceType); CalcSourceNoEditable(); CurrPage.SaveRecord(); CurrPage.Update(); end; [IntegrationEvent(false, false)] local procedure OnAfterGetDefaults(var Result: Text; TempWorksheetPriceListHeader: Record "Price List Header") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeOnInit() begin end; [IntegrationEvent(false, false)] local procedure OnBeforeOpenPage(var TempWorksheetPriceListHeader: Record "Price List Header" temporary; var TempWorksheetPriceListLine: Record "Price List Line" temporary; var UpdateMultiplePriceLists: Boolean) begin end;}