Page 7004 Sales Line Discounts
src/Layers/W1/BaseApp/Sales/Pricing/SalesLineDiscounts.Page.al668 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 line discounts with filtering by sales type, item type, and date range./// </summary>page 7004 "Sales Line Discounts"{ Caption = 'Sales Line Discounts'; DataCaptionExpression = PageCaptionText; DelayedInsert = true; PageType = List; SaveValues = true; ShowFilter = false; SourceTable = "Sales Line Discount"; layout { area(content) { group(General) { Caption = 'General'; Visible = not IsOnMobile; field(SalesTypeFilter; SalesTypeFilter) { ApplicationArea = Basic, Suite; Caption = 'Sales Type Filter'; OptionCaption = 'Customer,Customer Discount Group,All Customers,Campaign,None'; ToolTip = 'Specifies a filter for which sales line discounts 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 line discounts to display.'; trigger OnLookup(var Text: Text): Boolean var CustList: Page "Customer List"; CustDiscGrList: Page "Customer Disc. 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 Discount Group": begin CustDiscGrList.LookupMode := true; if CustDiscGrList.RunModal() = ACTION::LookupOK then Text := CustDiscGrList.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(StartingDateFilter; StartingDateFilter) { ApplicationArea = Basic, Suite; Caption = 'Starting Date Filter'; ToolTip = 'Specifies a filter for which sales line discounts to display.'; trigger OnValidate() var FilterTokens: Codeunit "Filter Tokens"; begin FilterTokens.MakeDateFilter(StartingDateFilter); StartingDateFilterOnAfterValid(); end; } field(ItemTypeFilter; ItemTypeFilter) { ApplicationArea = Basic, Suite; Caption = 'Type Filter'; OptionCaption = 'Item,Item Discount Group,None'; ToolTip = 'Specifies a filter for which sales line discounts to display.'; trigger OnValidate() begin ItemTypeFilterOnAfterValidate(); end; } field(CodeFilterCtrl; CodeFilter) { ApplicationArea = Basic, Suite; Caption = 'Code Filter'; Enabled = CodeFilterCtrlEnable; ToolTip = 'Specifies a filter for which sales line discounts to display.'; trigger OnLookup(var Text: Text) Result: Boolean var ItemList: Page "Item List"; ItemDiscGrList: Page "Item Disc. Groups"; begin Result := true; case Rec.Type of Rec.Type::Item: begin ItemList.LookupMode := true; if ItemList.RunModal() = ACTION::LookupOK then Text := ItemList.GetSelectionFilter() else Result := false; end; Rec.Type::"Item Disc. Group": begin ItemDiscGrList.LookupMode := true; if ItemDiscGrList.RunModal() = ACTION::LookupOK then Text := ItemDiscGrList.GetSelectionFilter() else Result := false; end; else OnLookupCodeFilterCaseElse(Rec, Text, Result); end; exit(Result); end; trigger OnValidate() begin CodeFilterOnAfterValidate(); end; } field(SalesCodeFilterCtrl2; CurrencyCodeFilter) { ApplicationArea = Suite; Caption = 'Currency Code Filter'; ToolTip = 'Specifies a filter for which sales line discounts 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; } } group(Filters) { Caption = 'Filters'; Visible = IsOnMobile; field(FilterDescription; GetFilterDescription()) { ApplicationArea = Basic, Suite; Editable = false; ShowCaption = false; ToolTip = 'Specifies a filter for which sales line discounts to display.'; trigger OnAssistEdit() begin FilterLines(); CurrPage.Update(false); end; } } repeater(Control1) { ShowCaption = false; field("Sales Type"; Rec."Sales Type") { ApplicationArea = Basic, Suite; trigger OnValidate() begin SetEditableFields(); end; } field("Sales Code"; Rec."Sales Code") { ApplicationArea = Basic, Suite; Editable = SalesCodeEditable; } field(Type; Rec.Type) { ApplicationArea = Basic, Suite; } field("Code"; Rec.Code) { 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("Line Discount %"; Rec."Line Discount %") { ApplicationArea = Basic, Suite; ToolTip = 'Specifies the discount percentage that is granted for the item on the line.'; } field("Starting Date"; Rec."Starting Date") { ApplicationArea = Basic, Suite; } field("Ending Date"; Rec."Ending Date") { ApplicationArea = Basic, Suite; } } } area(factboxes) { systempart(Control1900383207; Links) { ApplicationArea = RecordLinks; Visible = false; } systempart(Control1905767507; Notes) { ApplicationArea = Notes; Visible = false; } } } actions { area(processing) { action(SalesLineDiscountsFilter) { 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(); SetEditableFields(); end; } } area(Promoted) { group(Category_Process) { Caption = 'Process'; actionref(SalesLineDiscountsFilter_Promoted; SalesLineDiscountsFilter) { } actionref(ClearFilter_Promoted; ClearFilter) { } } } } trigger OnAfterGetCurrRecord() begin SetEditableFields(); end; trigger OnInit() var FeaturePriceCalculation: Codeunit "Feature - Price Calculation"; begin FeaturePriceCalculation.FailIfFeatureEnabled(); CodeFilterCtrlEnable := true; SalesCodeFilterCtrlEnable := true; SalesCodeEditable := true; end; trigger OnOpenPage() begin IsOnMobile := ClientTypeManagement.GetCurrentClientType() = CLIENTTYPE::Phone; GetRecFilters(); SetRecFilters(); SetCaption(); end; var Cust: Record Customer; CustDiscGr: Record "Customer Discount Group"; Campaign: Record Campaign; Item: Record Item; ItemDiscGr: Record "Item Discount Group"; ClientTypeManagement: Codeunit "Client Type Management";#pragma warning disable AA0074 Text000: Label 'All Customers';#pragma warning restore AA0074 PageCaptionText: Text; SalesCodeEditable: Boolean; SalesCodeFilterCtrlEnable: Boolean; CodeFilterCtrlEnable: Boolean; IsOnMobile: Boolean; protected var CodeFilter: Text; CurrencyCodeFilter: Text; SalesCodeFilter: Text; SalesTypeFilter: Option Customer,"Customer Discount Group","All Customers",Campaign,"None"; ItemTypeFilter: Option Item,"Item Discount Group","None"; StartingDateFilter: Text[30]; local procedure GetRecFilters() begin if Rec.GetFilters() <> '' then UpdateBasicRecFilters(); end; /// <summary> /// Applies filter settings to the sales line discount records based on current filter values. /// </summary> procedure SetRecFilters() begin SalesCodeFilterCtrlEnable := true; CodeFilterCtrlEnable := 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 ItemTypeFilter <> ItemTypeFilter::None then Rec.SetRange(Type, ItemTypeFilter) else Rec.SetRange(Type); if ItemTypeFilter = ItemTypeFilter::None then begin CodeFilterCtrlEnable := false; CodeFilter := ''; end; if CodeFilter <> '' then Rec.SetFilter(Code, CodeFilter) else Rec.SetRange(Code); if CurrencyCodeFilter <> '' then Rec.SetFilter("Currency Code", CurrencyCodeFilter) else Rec.SetRange("Currency Code"); if StartingDateFilter <> '' then Rec.SetFilter("Starting Date", StartingDateFilter) else Rec.SetRange("Starting Date"); OnSetRecFiltersOnBeforeCurrPageUpdate(Rec, ItemTypeFilter); 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 := ''; case ItemTypeFilter of ItemTypeFilter::Item: begin SourceTableName := ObjTranslation.TranslateObject(ObjTranslation."Object Type"::Table, 27); Item.SetFilter("No.", CodeFilter); if not Item.FindFirst() then Clear(Item); end; ItemTypeFilter::"Item Discount Group": begin SourceTableName := ObjTranslation.TranslateObject(ObjTranslation."Object Type"::Table, 341); ItemDiscGr.SetFilter(Code, CodeFilter); if not ItemDiscGr.FindFirst() then Clear(ItemDiscGr); end; else OnGetFilterDescriptionCaseElse(Rec, ItemTypeFilter, SourceTableName, Item); end; SalesSrcTableName := ''; Description := ''; case SalesTypeFilter of SalesTypeFilter::Customer: begin SalesSrcTableName := ObjTranslation.TranslateObject(ObjTranslation."Object Type"::Table, 18); Cust.SetFilter("No.", SalesCodeFilter); if Cust.FindFirst() then Description := Cust.Name; end; SalesTypeFilter::"Customer Discount Group": begin SalesSrcTableName := ObjTranslation.TranslateObject(ObjTranslation."Object Type"::Table, 340); CustDiscGr.SetFilter(Code, SalesCodeFilter); if CustDiscGr.FindFirst() then Description := CustDiscGr.Description; end; SalesTypeFilter::Campaign: begin SalesSrcTableName := ObjTranslation.TranslateObject(ObjTranslation."Object Type"::Table, 5071); Campaign.SetFilter("No.", SalesCodeFilter); if Campaign.FindFirst() then Description := Campaign.Description; end; SalesTypeFilter::"All Customers": SalesSrcTableName := Text000; end; if SalesSrcTableName = Text000 then exit(StrSubstNo('%1 %2 %3 %4 %5', SalesSrcTableName, SalesCodeFilter, Description, SourceTableName, CodeFilter)); exit(StrSubstNo('%1 %2 %3 %4 %5', SalesSrcTableName, SalesCodeFilter, Description, SourceTableName, CodeFilter)); 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 ItemTypeFilterOnAfterValidate() begin CurrPage.SaveRecord(); CodeFilter := ''; SetRecFilters(); end; local procedure CodeFilterOnAfterValidate() 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 Disc. Group"): exit(1); Format(Rec."Sales Type"::"All Customers"): exit(2); Format(Rec."Sales Type"::Campaign): exit(3); end; end; local procedure GetTypeFilter() TypeFilter: Integer begin case Rec.GetFilter(Type) of Format(Rec.Type::Item): exit(0); Format(Rec.Type::"Item Disc. Group"): exit(1); else OnGetTypeFilterCaseElse(Rec, TypeFilter); end; end; local procedure FilterLines() var FilterPageBuilder: FilterPageBuilder; begin FilterPageBuilder.AddTable(Rec.TableCaption, DATABASE::"Sales Line Discount"); 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(Type) = '' then FilterPageBuilder.AddFieldNo(Rec.TableCaption, Rec.FieldNo(Type)); if Rec.GetFilter(Code) = '' then FilterPageBuilder.AddFieldNo(Rec.TableCaption, Rec.FieldNo(Code)); 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(); SetEditableFields(); end; local procedure UpdateBasicRecFilters() begin if Rec.GetFilter("Sales Type") <> '' then SalesTypeFilter := GetSalesTypeFilter() else SalesTypeFilter := SalesTypeFilter::None; if Rec.GetFilter(Type) <> '' then ItemTypeFilter := GetTypeFilter() else ItemTypeFilter := ItemTypeFilter::None; SalesCodeFilter := Rec.GetFilter("Sales Code"); CodeFilter := Rec.GetFilter(Code); CurrencyCodeFilter := Rec.GetFilter("Currency Code"); Evaluate(StartingDateFilter, Rec.GetFilter("Starting Date")); end; local procedure SetEditableFields() begin SalesCodeEditable := Rec."Sales Type" <> Rec."Sales Type"::"All Customers"; end; /// <summary> /// Raises an event to handle custom lookup for code filter when the type is not Item or Item Disc. Group. /// </summary> /// <param name="SalesLineDiscount">The sales line discount record.</param> /// <param name="Text">The lookup text value.</param> /// <param name="Result">The result of the lookup operation.</param> [IntegrationEvent(true, false)] local procedure OnLookupCodeFilterCaseElse(SalesLineDiscount: Record "Sales Line Discount"; var Text: Text; var Result: Boolean) begin end; /// <summary> /// Raises an event to handle custom type filter conversion when the type is not Item or Item Disc. Group. /// </summary> /// <param name="SalesLineDiscount">The sales line discount record.</param> /// <param name="TypeFilter">The type filter integer value to set.</param> [IntegrationEvent(true, false)] local procedure OnGetTypeFilterCaseElse(var SalesLineDiscount: Record "Sales Line Discount"; var TypeFilter: Integer) begin end; /// <summary> /// Raises an event after the record filters have been applied and before the page is updated, allowing subscribers to apply additional filtering based on the current item type filter. /// </summary> /// <param name="SalesLineDiscount">The sales line discount record being filtered.</param> /// <param name="ItemTypeFilter">The current item type filter value.</param> [IntegrationEvent(true, false)] local procedure OnSetRecFiltersOnBeforeCurrPageUpdate(var SalesLineDiscount: Record "Sales Line Discount"; ItemTypeFilter: Option Item,"Item Discount Group","None") begin end; /// <summary> /// Raises an event to resolve the filter description when the item type filter is not Item or Item Discount Group, allowing subscribers to provide a custom source table name and item filtering. /// </summary> /// <param name="SalesLineDiscount">The sales line discount record being described.</param> /// <param name="ItemTypeFilter">The current item type filter value.</param> /// <param name="SourceTableName">The source table name to display in the filter description.</param> /// <param name="Item">The item record used to build the filter description.</param> [IntegrationEvent(true, false)] local procedure OnGetFilterDescriptionCaseElse(var SalesLineDiscount: Record "Sales Line Discount"; ItemTypeFilter: Option Item,"Item Discount Group","None"; var SourceTableName: Text; var Item: Record Item) begin end;}