Page 7002 Sales Prices

Base Application, Microsoft.Sales.Pricing

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;}