Page 7002 Sales Prices
src/Layers/W1/BaseApp/Sales/Pricing/SalesPrices.Page.al703 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.Sales.Pricing;using Microsoft.CRM.Campaign;using Microsoft.Finance.Currency;using Microsoft.Inventory.Item;using Microsoft.Pricing.Calculation;using Microsoft.Sales.Customer;using System.Environment;using System.Globalization;using System.Text;/// <summary>/// Displays and manages sales prices with filtering by sales type, item, currency, and date range./// </summary>page 7002 "Sales Prices"{ Caption = 'Sales Prices'; DataCaptionExpression = PageCaptionText; DelayedInsert = true; PageType = List; SaveValues = true; SourceTable = "Sales Price"; ODataKeyFields = SystemId; layout { area(content) { group(General) { Caption = 'General'; Visible = not IsOnMobile; field(SalesTypeFilter; SalesTypeFilter) { ApplicationArea = Basic, Suite; Caption = 'Sales Type Filter'; OptionCaption = 'Customer,Customer Price Group,All Customers,Campaign,None'; ToolTip = 'Specifies a filter for which sales prices to display.'; trigger OnValidate() begin SalesTypeFilterOnAfterValidate(); end; } field(SalesCodeFilterCtrl; SalesCodeFilter) { ApplicationArea = Basic, Suite; Caption = 'Sales Code Filter'; Enabled = SalesCodeFilterCtrlEnable; ToolTip = 'Specifies a filter for which sales prices to display.'; trigger OnLookup(var Text: Text): Boolean var CustList: Page "Customer List"; CustPriceGrList: Page "Customer Price Groups"; CampaignList: Page "Campaign List"; begin if SalesTypeFilter = SalesTypeFilter::"All Customers" then exit; case SalesTypeFilter of SalesTypeFilter::Customer: begin CustList.LookupMode := true; if CustList.RunModal() = ACTION::LookupOK then Text := CustList.GetSelectionFilter() else exit(false); end; SalesTypeFilter::"Customer Price Group": begin CustPriceGrList.LookupMode := true; if CustPriceGrList.RunModal() = ACTION::LookupOK then Text := CustPriceGrList.GetSelectionFilter() else exit(false); end; SalesTypeFilter::Campaign: begin CampaignList.LookupMode := true; if CampaignList.RunModal() = ACTION::LookupOK then Text := CampaignList.GetSelectionFilter() else exit(false); end; end; exit(true); end; trigger OnValidate() begin SalesCodeFilterOnAfterValidate(); end; } field(ItemNoFilterCtrl; ItemNoFilter) { ApplicationArea = Basic, Suite; Caption = 'Item No. Filter'; ToolTip = 'Specifies a filter for which sales prices to display.'; trigger OnLookup(var Text: Text): Boolean var ItemList: Page "Item List"; begin ItemList.LookupMode := true; if ItemList.RunModal() = ACTION::LookupOK then Text := ItemList.GetSelectionFilter() else exit(false); exit(true); end; trigger OnValidate() begin ItemNoFilterOnAfterValidate(); end; } field(StartingDateFilter; StartingDateFilter) { ApplicationArea = Basic, Suite; Caption = 'Starting Date Filter'; ToolTip = 'Specifies a filter for which sales prices to display.'; trigger OnValidate() var FilterTokens: Codeunit "Filter Tokens"; begin FilterTokens.MakeDateFilter(StartingDateFilter); StartingDateFilterOnAfterValid(); end; } field(CurrencyCodeFilterCtrl; CurrencyCodeFilter) { ApplicationArea = Suite; Caption = 'Currency Code Filter'; ToolTip = 'Specifies a filter for which sales prices to display.'; trigger OnLookup(var Text: Text): Boolean var CurrencyList: Page Currencies; begin CurrencyList.LookupMode := true; if CurrencyList.RunModal() = ACTION::LookupOK then Text := CurrencyList.GetSelectionFilter() else exit(false); exit(true); end; trigger OnValidate() begin CurrencyCodeFilterOnAfterValid(); end; } field(SystemId; Rec.SystemId) { ApplicationArea = Suite; ToolTip = 'Specifies system id to provide OData capabilities.'; Visible = false; } } group(Filters) { Caption = 'Filters'; Visible = IsOnMobile; field(FilterDescription; GetFilterDescription()) { ApplicationArea = Basic, Suite; Editable = false; ShowCaption = false; ToolTip = 'Specifies a filter for which sales prices to display.'; trigger OnAssistEdit() begin FilterLines(); CurrPage.Update(false); end; } } repeater(Control1) { ShowCaption = false; field("Sales Type"; Rec."Sales Type") { ApplicationArea = Basic, Suite; Editable = SalesTypeControlEditable; trigger OnValidate() begin SalesCodeControlEditable := SetSalesCodeEditable(Rec."Sales Type"); end; } field("Sales Code"; Rec."Sales Code") { ApplicationArea = Basic, Suite; Editable = SalesCodeControlEditable; } field("Item No."; Rec."Item No.") { ApplicationArea = Basic, Suite; } field("Variant Code"; Rec."Variant Code") { ApplicationArea = Planning; Visible = false; } field("Currency Code"; Rec."Currency Code") { ApplicationArea = Suite; Visible = false; } field("Unit of Measure Code"; Rec."Unit of Measure Code") { ApplicationArea = Basic, Suite; } field("Minimum Quantity"; Rec."Minimum Quantity") { ApplicationArea = Basic, Suite; } field("Unit Price"; Rec."Unit Price") { ApplicationArea = Basic, Suite; } field("Starting Date"; Rec."Starting Date") { ApplicationArea = Basic, Suite; } field("Ending Date"; Rec."Ending Date") { ApplicationArea = Basic, Suite; } field("Price Includes VAT"; Rec."Price Includes VAT") { ApplicationArea = Basic, Suite; Visible = false; } field("Allow Line Disc."; Rec."Allow Line Disc.") { ApplicationArea = Basic, Suite; Visible = false; } field("Allow Invoice Disc."; Rec."Allow Invoice Disc.") { ApplicationArea = Basic, Suite; Visible = false; } field("VAT Bus. Posting Gr. (Price)"; Rec."VAT Bus. Posting Gr. (Price)") { ApplicationArea = Basic, Suite; ToolTip = 'Specifies the VAT business posting group for customers for whom you want the sales price (which includes VAT) to apply.'; Visible = false; } } } area(factboxes) { systempart(Control1900383207; Links) { ApplicationArea = RecordLinks; Visible = false; } systempart(Control1905767507; Notes) { ApplicationArea = Notes; Visible = false; } } } actions { area(processing) { action(SalesPricesFilter) { ApplicationArea = Basic, Suite; Caption = 'Filter'; Image = "Filter"; ToolTip = 'Apply the filter.'; Visible = IsOnMobile; trigger OnAction() begin FilterLines(); end; } action(ClearFilter) { ApplicationArea = Basic, Suite; Caption = 'Clear Filter'; Image = ClearFilter; ToolTip = 'Clear filter.'; Visible = IsOnMobile; trigger OnAction() begin Rec.Reset(); UpdateBasicRecFilters(); Evaluate(StartingDateFilter, Rec.GetFilter("Starting Date")); SetEditableFields(); end; } action(CopyPrices) { ApplicationArea = Basic, Suite; Caption = 'Copy Prices'; Image = Copy; ToolTip = 'Select prices and press OK to copy them to Customer No.'; Visible = not IsLookupMode; trigger OnAction() begin CopyPricesToCustomer(); CurrPage.Update(); end; } } area(Promoted) { group(Category_Process) { Caption = 'Process'; actionref(SalesPricesFilter_Promoted; SalesPricesFilter) { } actionref(ClearFilter_Promoted; ClearFilter) { } } } } trigger OnAfterGetCurrRecord() begin SalesCodeControlEditable := SetSalesCodeEditable(Rec."Sales Type"); OnAfterGetCurrRecordOnAfterCalcSalesCodeControlEditable(Rec, SalesCodeControlEditable); end; trigger OnInit() var FeaturePriceCalculation: Codeunit "Feature - Price Calculation"; begin FeaturePriceCalculation.FailIfFeatureEnabled(); SalesCodeFilterCtrlEnable := true; SalesCodeControlEditable := true; IsLookupMode := CurrPage.LookupMode; end; trigger OnOpenPage() var IsHandled: Boolean; begin IsOnMobile := ClientTypeManagement.GetCurrentClientType() = CLIENTTYPE::Phone; IsHandled := false; OnOpenPageOnBeforeGetRecFilters(Rec, IsHandled); if IsHandled then exit; GetRecFilters(); SetRecFilters(); SetCaption(); end; var Cust: Record Customer; CustPriceGr: Record "Customer Price Group"; Campaign: Record Campaign; ClientTypeManagement: Codeunit "Client Type Management"; PageCaptionText: Text;#pragma warning disable AA0074 Text000: Label 'All Customers';#pragma warning disable AA0470 Text001: Label 'No %1 within the filter %2.';#pragma warning restore AA0470#pragma warning restore AA0074 SalesCodeFilterCtrlEnable: Boolean; IsOnMobile: Boolean; IsLookupMode: Boolean; SalesTypeControlEditable: Boolean; SalesCodeControlEditable: Boolean; MultipleCustomersSelectedErr: Label 'More than one customer uses these sales prices. To copy prices, the Sales Code Filter field must contain one customer only.'; IncorrectSalesTypeToCopyPricesErr: Label 'To copy sales prices, The Sales Type Filter field must contain Customer.'; protected var StartingDateFilter: Text; CurrencyCodeFilter: Text; SalesTypeFilter: Option Customer,"Customer Price Group","All Customers",Campaign,"None"; SalesCodeFilter: Text; ItemNoFilter: Text; procedure GetRecFilters() begin if Rec.GetFilters() <> '' then UpdateBasicRecFilters(); Evaluate(StartingDateFilter, Rec.GetFilter("Starting Date")); end; local procedure UpdateBasicRecFilters() begin if Rec.GetFilter("Sales Type") <> '' then SalesTypeFilter := GetSalesTypeFilter() else SalesTypeFilter := SalesTypeFilter::None; SalesCodeFilter := Rec.GetFilter("Sales Code"); ItemNoFilter := Rec.GetFilter("Item No."); CurrencyCodeFilter := Rec.GetFilter("Currency Code"); end; /// <summary> /// Applies filter settings to the sales price records based on current filter values. /// </summary> procedure SetRecFilters() begin SalesCodeFilterCtrlEnable := true; if SalesTypeFilter <> SalesTypeFilter::None then Rec.SetRange("Sales Type", SalesTypeFilter) else Rec.SetRange("Sales Type"); if SalesTypeFilter in [SalesTypeFilter::"All Customers", SalesTypeFilter::None] then begin SalesCodeFilterCtrlEnable := false; SalesCodeFilter := ''; end; if SalesCodeFilter <> '' then Rec.SetFilter("Sales Code", SalesCodeFilter) else Rec.SetRange("Sales Code"); if StartingDateFilter <> '' then Rec.SetFilter("Starting Date", StartingDateFilter) else Rec.SetRange("Starting Date"); if ItemNoFilter <> '' then Rec.SetFilter("Item No.", ItemNoFilter) else Rec.SetRange("Item No."); if CurrencyCodeFilter <> '' then Rec.SetFilter("Currency Code", CurrencyCodeFilter) else Rec.SetRange("Currency Code"); OnSetRecFiltersOnBeforeCheckFilters(Rec); case SalesTypeFilter of SalesTypeFilter::Customer: CheckFilters(DATABASE::Customer, SalesCodeFilter); SalesTypeFilter::"Customer Price Group": CheckFilters(DATABASE::"Customer Price Group", SalesCodeFilter); SalesTypeFilter::Campaign: CheckFilters(DATABASE::Campaign, SalesCodeFilter); end; CheckFilters(DATABASE::Item, ItemNoFilter); CheckFilters(DATABASE::Currency, CurrencyCodeFilter); SetEditableFields(); CurrPage.Update(false); end; local procedure SetCaption() begin if IsOnMobile then PageCaptionText := '' else PageCaptionText := GetFilterDescription(); end; local procedure GetFilterDescription(): Text var ObjTranslation: Record "Object Translation"; SourceTableName: Text; SalesSrcTableName: Text; Description: Text; begin GetRecFilters(); SourceTableName := ''; if ItemNoFilter <> '' then SourceTableName := ObjTranslation.TranslateObject(ObjTranslation."Object Type"::Table, 27); SalesSrcTableName := ''; Description := ''; case SalesTypeFilter of SalesTypeFilter::Customer: begin SalesSrcTableName := ObjTranslation.TranslateObject(ObjTranslation."Object Type"::Table, 18); Cust."No." := CopyStr(SalesCodeFilter, 1, MaxStrLen(Cust."No.")); if Cust.Find() then Description := Cust.Name; end; SalesTypeFilter::"Customer Price Group": begin SalesSrcTableName := ObjTranslation.TranslateObject(ObjTranslation."Object Type"::Table, 6); CustPriceGr.Code := CopyStr(SalesCodeFilter, 1, MaxStrLen(CustPriceGr.Code)); if CustPriceGr.Find() then Description := CustPriceGr.Description; end; SalesTypeFilter::Campaign: begin SalesSrcTableName := ObjTranslation.TranslateObject(ObjTranslation."Object Type"::Table, 5071); Campaign."No." := CopyStr(SalesCodeFilter, 1, MaxStrLen(Campaign."No.")); if Campaign.Find() then Description := Campaign.Description; end; SalesTypeFilter::"All Customers": SalesSrcTableName := Text000; end; if SalesSrcTableName = Text000 then exit(StrSubstNo('%1 %2 %3', SalesSrcTableName, SourceTableName, ItemNoFilter)); exit(StrSubstNo('%1 %2 %3 %4 %5', SalesSrcTableName, SalesCodeFilter, Description, SourceTableName, ItemNoFilter)); end; local procedure CheckFilters(TableNo: Integer; FilterTxt: Text) var FilterRecordRef: RecordRef; FilterFieldRef: FieldRef; EmptyFilter: Boolean; begin EmptyFilter := FilterTxt = ''; OnBeforeCheckFilters(Rec, TableNo, FilterTxt, EmptyFilter); if EmptyFilter then exit; Clear(FilterRecordRef); Clear(FilterFieldRef); FilterRecordRef.Open(TableNo); FilterFieldRef := FilterRecordRef.Field(1); FilterFieldRef.SetFilter(FilterTxt); if FilterRecordRef.IsEmpty() then Error(Text001, FilterRecordRef.Caption, FilterTxt); end; local procedure SalesCodeFilterOnAfterValidate() begin CurrPage.SaveRecord(); SetRecFilters(); SetCaption(); end; local procedure SalesTypeFilterOnAfterValidate() begin CurrPage.SaveRecord(); SalesCodeFilter := ''; SetRecFilters(); SetCaption(); end; local procedure StartingDateFilterOnAfterValid() begin CurrPage.SaveRecord(); SetRecFilters(); end; local procedure ItemNoFilterOnAfterValidate() begin CurrPage.SaveRecord(); SetRecFilters(); SetCaption(); end; local procedure CurrencyCodeFilterOnAfterValid() begin CurrPage.SaveRecord(); SetRecFilters(); end; local procedure GetSalesTypeFilter(): Integer begin case Rec.GetFilter("Sales Type") of Format(Rec."Sales Type"::Customer): exit(0); Format(Rec."Sales Type"::"Customer Price Group"): exit(1); Format(Rec."Sales Type"::"All Customers"): exit(2); Format(Rec."Sales Type"::Campaign): exit(3); end; end; local procedure SetSalesCodeEditable(SalesType: Enum "Sales Price Type"): Boolean begin exit(SalesType <> Rec."Sales Type"::"All Customers"); end; local procedure SetEditableFields() begin SalesTypeControlEditable := Rec.GetFilter("Sales Type") = ''; SalesCodeControlEditable := SalesCodeControlEditable and (Rec.GetFilter("Sales Code") = ''); end; local procedure FilterLines() var FilterPageBuilder: FilterPageBuilder; begin FilterPageBuilder.AddTable(Rec.TableCaption, DATABASE::"Sales Price"); FilterPageBuilder.SetView(Rec.TableCaption, Rec.GetView()); if Rec.GetFilter("Sales Type") = '' then FilterPageBuilder.AddFieldNo(Rec.TableCaption, Rec.FieldNo("Sales Type")); if Rec.GetFilter("Sales Code") = '' then FilterPageBuilder.AddFieldNo(Rec.TableCaption, Rec.FieldNo("Sales Code")); if Rec.GetFilter("Item No.") = '' then FilterPageBuilder.AddFieldNo(Rec.TableCaption, Rec.FieldNo("Item No.")); if Rec.GetFilter("Starting Date") = '' then FilterPageBuilder.AddFieldNo(Rec.TableCaption, Rec.FieldNo("Starting Date")); if Rec.GetFilter("Currency Code") = '' then FilterPageBuilder.AddFieldNo(Rec.TableCaption, Rec.FieldNo("Currency Code")); if FilterPageBuilder.RunModal() then Rec.SetView(FilterPageBuilder.GetView(Rec.TableCaption)); UpdateBasicRecFilters(); Evaluate(StartingDateFilter, Rec.GetFilter("Starting Date")); SetEditableFields(); end; local procedure CopyPricesToCustomer() var Customer: Record Customer; SalesPrice: Record "Sales Price"; SelectedSalesPrice: Record "Sales Price"; SalesPrices: Page "Sales Prices"; CopyToCustomerNo: Code[20]; begin if SalesTypeFilter <> SalesTypeFilter::Customer then Error(IncorrectSalesTypeToCopyPricesErr); Customer.SetFilter("No.", SalesCodeFilter); if Customer.Count <> 1 then Error(MultipleCustomersSelectedErr); CopyToCustomerNo := CopyStr(SalesCodeFilter, 1, MaxStrLen(CopyToCustomerNo)); SalesPrice.SetRange("Sales Type", SalesPrice."Sales Type"::Customer); SalesPrice.SetFilter("Sales Code", '<>%1', SalesCodeFilter); SalesPrices.LookupMode(true); SalesPrices.SetTableView(SalesPrice); if SalesPrices.RunModal() = ACTION::LookupOK then begin SalesPrices.GetSelectionFilter(SelectedSalesPrice); Rec.CopySalesPriceToCustomersSalesPrice(SelectedSalesPrice, CopyToCustomerNo); end; end; /// <summary> /// Retrieves the currently selected sales price records as a filter. /// </summary> /// <param name="SalesPrice">The sales price record variable to receive the selection filter.</param> procedure GetSelectionFilter(var SalesPrice: Record "Sales Price") begin CurrPage.SetSelectionFilter(SalesPrice); end; /// <summary> /// Raises an event after calculating whether the sales code field should be editable. /// </summary> /// <param name="SalesPrice">The current sales price record.</param> /// <param name="SalesCodeControlEditable">Indicates whether the sales code control is editable.</param> [IntegrationEvent(false, false)] local procedure OnAfterGetCurrRecordOnAfterCalcSalesCodeControlEditable(var SalesPrice: Record "Sales Price"; var SalesCodeControlEditable: Boolean) begin end; /// <summary> /// Raises an event before retrieving record filters when the page opens. /// </summary> /// <param name="SalesPrice">The sales price record.</param> /// <param name="IsHandled">Set to true to skip the default filter retrieval logic.</param> [IntegrationEvent(true, false)] local procedure OnOpenPageOnBeforeGetRecFilters(var SalesPrice: Record "Sales Price"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnSetRecFiltersOnBeforeCheckFilters(var SalesPrice: Record "Sales Price") begin end; /// <summary> /// Raises an event before checking if filter values are valid. /// </summary> /// <param name="SalesPrice">The sales price record.</param> /// <param name="TableNo">The table number being filtered.</param> /// <param name="FilterTxt">The filter text to validate.</param> /// <param name="IsEmptyFilter">Indicates whether the filter is empty.</param> [IntegrationEvent(false, false)] local procedure OnBeforeCheckFilters(var SalesPrice: Record "Sales Price"; TableNo: Integer; var FilterTxt: Text; var IsEmptyFilter: Boolean) begin end;}