Page 5847 Average Cost Calc. Overview

Base Application, Microsoft.Inventory.Costing

src/Layers/W1/BaseApp/Inventory/Costing/AverageCostCalcOverview.Page.al462 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.Inventory.Costing;using Microsoft.Finance.Dimension;using Microsoft.Foundation.Navigate;using Microsoft.Inventory.Item;using Microsoft.Inventory.Ledger;page 5847 "Average Cost Calc. Overview"{    Caption = 'Average Cost Calc. Overview';    DataCaptionExpression = ItemName;    DeleteAllowed = false;    InsertAllowed = false;    ModifyAllowed = false;    PageType = List;    SourceTable = "Average Cost Calc. Overview";    SourceTableTemporary = true;    SourceTableView = sorting("Attached to Valuation Date", "Attached to Entry No.", Type);    layout    {        area(content)        {            repeater(Control1)            {                IndentationColumn = TypeIndent;                IndentationControls = Type;                ShowAsTree = true;                ShowCaption = false;                field(Type; Rec.Type)                {                    ApplicationArea = Basic, Suite;                    Editable = false;                    StyleExpr = 'Strong';                }                field("Valuation Date"; Rec."Valuation Date")                {                    ApplicationArea = Basic, Suite;                    Editable = false;                    StyleExpr = 'Strong';                }                field("Item No."; Rec."Item No.")                {                    ApplicationArea = Basic, Suite;                    Editable = false;                }                field("Location Code"; Rec."Location Code")                {                    ApplicationArea = Location;                    Editable = false;                    Visible = false;                }                field("Variant Code"; Rec."Variant Code")                {                    ApplicationArea = Planning;                    Editable = false;                    Visible = false;                }                field(AverageCostCntrl; Rec.CalculateAverageCost())                {                    ApplicationArea = Basic, Suite;                    AutoFormatType = 2;                    AutoFormatExpression = '';                    Caption = 'Unit Cost';                    Editable = false;                    StyleExpr = 'Strong';                    ToolTip = 'Specifies the average cost for this entry.';                }                field("Cost is Adjusted"; Rec."Cost is Adjusted")                {                    ApplicationArea = Basic, Suite;                    Editable = false;                }                field("Item Ledger Entry No."; Rec."Item Ledger Entry No.")                {                    ApplicationArea = Basic, Suite;                    Editable = false;                    HideValue = ItemLedgerEntryNoHideValue;                    Visible = false;                }                field("Posting Date"; Rec."Posting Date")                {                    ApplicationArea = Basic, Suite;                    Editable = false;                    Visible = false;                }                field("Entry Type"; Rec."Entry Type")                {                    ApplicationArea = Basic, Suite;                    Editable = false;                    HideValue = EntryTypeHideValue;                }                field("Document Type"; Rec."Document Type")                {                    ApplicationArea = Basic, Suite;                    Editable = false;                    Visible = false;                }                field("Document No."; Rec."Document No.")                {                    ApplicationArea = Basic, Suite;                    Editable = false;                    Visible = false;                }                field("Document Line No."; Rec."Document Line No.")                {                    ApplicationArea = Basic, Suite;                    Editable = false;                    HideValue = DocumentLineNoHideValue;                    Visible = false;                }                field(Quantity; Rec.Quantity)                {                    ApplicationArea = Basic, Suite;                    Editable = false;                    StyleExpr = 'Strong';                }                field("Cost Amount (Expected)"; Rec."Cost Amount (Expected)")                {                    ApplicationArea = Basic, Suite;                    Editable = false;                    StyleExpr = 'Strong';                    ToolTip = 'Specifies the expected cost in LCY of the quantity posting.';                }                field("Cost Amount (Actual)"; Rec."Cost Amount (Actual)")                {                    ApplicationArea = Basic, Suite;                    Editable = false;                    StyleExpr = 'Strong';                    ToolTip = 'Specifies the adjusted cost in LCY of the quantity posting.';                }            }        }    }    actions    {        area(processing)        {            group("&Line")            {                Caption = '&Line';                Image = Line;                action(Dimensions)                {                    AccessByPermission = TableData Dimension = R;                    ApplicationArea = Dimensions;                    Caption = 'Dimensions';                    Image = Dimensions;                    ShortCutKey = 'Alt+D';                    ToolTip = 'View or edit dimensions, such as area, project, or department, that you can assign to sales and purchase documents to distribute costs and analyze transaction history.';                    trigger OnAction()                    begin                        if ItemLedgEntry.Get(Rec."Entry No.") then                            ItemLedgEntry.ShowDimensions();                    end;                }                action("&Value Entries")                {                    ApplicationArea = Basic, Suite;                    Caption = '&Value Entries';                    Image = ValueLedger;                    RunObject = Page "Value Entries";                    RunPageLink = "Item Ledger Entry No." = field("Item Ledger Entry No."),                                  "Valuation Date" = field("Valuation Date");                    RunPageView = sorting("Item Ledger Entry No.");                    ShortCutKey = 'Ctrl+F7';                    ToolTip = 'View the history of posted amounts that affect the value of the item. Value entries are created for every transaction with the item.';                }            }            group("&Application")            {                Caption = '&Application';                Image = Apply;                action("Applied E&ntries")                {                    ApplicationArea = Basic, Suite;                    Caption = 'Applied E&ntries';                    Image = Approve;                    ToolTip = 'View the ledger entries that have been applied to this record.';                    trigger OnAction()                    var                        ItemLedgEntry: Record "Item Ledger Entry";                    begin                        if ItemLedgEntry.Get(Rec."Item Ledger Entry No.") then                            CODEUNIT.Run(CODEUNIT::"Show Applied Entries", ItemLedgEntry);                    end;                }                action("Reservation Entries")                {                    AccessByPermission = TableData Item = R;                    ApplicationArea = Reservation;                    Caption = 'Reservation Entries';                    Image = ReservationLedger;                    ToolTip = 'View the entries for every reservation that is made, either manually or automatically.';                    trigger OnAction()                    var                        ItemLedgEntry: Record "Item Ledger Entry";                    begin                        ItemLedgEntry.Get(Rec."Item Ledger Entry No.");                        ItemLedgEntry.ShowReservationEntries(true);                    end;                }            }        }        area(navigation)        {            action("&Navigate")            {                ApplicationArea = Basic, Suite;                Caption = 'Find entries...';                Image = Navigate;                ShortCutKey = 'Ctrl+Alt+Q';                ToolTip = 'Find entries and documents that exist for the document number and posting date on the selected document. (Formerly this action was named Navigate.)';                trigger OnAction()                begin                    Navigate.SetDoc(Rec."Posting Date", Rec."Document No.");                    Navigate.Run();                end;            }        }        area(Promoted)        {            group(Category_Process)            {                Caption = 'Process';                actionref("&Navigate_Promoted"; "&Navigate")                {                }                group(Category_Application)                {                    Caption = 'Application';                    actionref("Applied E&ntries_Promoted"; "Applied E&ntries")                    {                    }                    actionref("Reservation Entries_Promoted"; "Reservation Entries")                    {                    }                }                group(Category_Line)                {                    Caption = 'Line';                    actionref(Dimensions_Promoted; Dimensions)                    {                    }                    actionref("&Value Entries_Promoted"; "&Value Entries")                    {                    }                }            }        }    }    trigger OnAfterGetRecord()    begin        DocumentLineNoHideValue := false;        EntryTypeHideValue := false;        ItemLedgerEntryNoHideValue := false;        TypeIndent := 0;        SetExpansionStatus();        // For synthetic summary (Closing Entry) rows compute dynamic roll‑up values on demand        if Rec.Type = Rec.Type::"Closing Entry" then begin            Rec.Quantity := Rec.CalculateRemainingQty();            // Remaining quantity at valuation point            Rec."Cost Amount (Expected)" := Rec.CalculateCostAmt(false); // Summed expected cost            Rec."Cost Amount (Actual)" := Rec.CalculateCostAmt(true);   // Summed adjusted/actual cost        end;        TypeOnFormat();        ItemLedgerEntryNoOnFormat();        EntryTypeOnFormat();        DocumentLineNoOnFormat();    end;    trigger OnOpenPage()    var        ProgressDialog: Dialog;    begin        ProgressDialog.Open(LoadingAvgCalcLbl);        InitTempTable();                // Load level 0 nodes (root Closing Entry summaries)        ExpandAll(TempAvgCostCalcOverview); // Pre-expand tree so user immediately sees detail        ProgressDialog.Close();        SetRecFilters();        CurrPage.Update(false);        ItemName := StrSubstNo('%1  %2', Item."No.", Item.Description);    end;    var        Item: Record Item;        TempAvgCostCalcOverview: Record "Average Cost Calc. Overview" temporary;        ItemLedgEntry: Record "Item Ledger Entry";        GetAvgCostCalcOverview: Codeunit "Get Average Cost Calc Overview";        Navigate: Page Navigate;        ActualExpansionStatus: Integer;  // 0 = collapsed, 1 = expanded, 2 = leaf        ItemName: Text[250];        TypeIndent: Integer;        ItemLedgerEntryNoHideValue: Boolean;        EntryTypeHideValue: Boolean;        DocumentLineNoHideValue: Boolean;        LoadingAvgCalcLbl: Label 'Loading average cost calculations...';    procedure SetExpansionStatus()    begin        case true of            IsExpanded(Rec):                ActualExpansionStatus := 1; // expanded            HasChildren(Rec):                ActualExpansionStatus := 0 // collapsible (has children but not expanded in current iteration)            else                ActualExpansionStatus := 2; // leaf        end;    end;    procedure InitTempTable()    var        AvgCostCalcOverviewFilters: Record "Average Cost Calc. Overview";    begin        TempAvgCostCalcOverview."Item No." := Item."No.";        TempAvgCostCalcOverview.SetFilter("Valuation Date", Item.GetFilter("Date Filter"));        TempAvgCostCalcOverview.SetFilter("Location Code", Item.GetFilter("Location Filter"));        TempAvgCostCalcOverview.SetFilter("Variant Code", Item.GetFilter("Variant Filter"));        OnInitTempTableOnAfterAvgCostCalcOverviewSetFilters(TempAvgCostCalcOverview, Item);        GetAvgCostCalcOverview.Run(TempAvgCostCalcOverview);        TempAvgCostCalcOverview.Reset();        AvgCostCalcOverviewFilters.CopyFilters(Rec);        Rec.Reset();        Rec.DeleteAll();        TempAvgCostCalcOverview.SetRange(Level, 0);        if TempAvgCostCalcOverview.FindSet() then            repeat                Rec := TempAvgCostCalcOverview;                Rec.Insert();            until TempAvgCostCalcOverview.Next() = 0;        TempAvgCostCalcOverview.SetRange(Level);        Rec.CopyFilters(AvgCostCalcOverviewFilters);    end;    local procedure ExpandAll(var AvgCostCalcOverview: Record "Average Cost Calc. Overview")    var        AvgCostCalcOverviewFilters: Record "Average Cost Calc. Overview";    begin        TempAvgCostCalcOverview."Item No." := Item."No.";        TempAvgCostCalcOverview.SetFilter("Valuation Date", Item.GetFilter("Date Filter"));        TempAvgCostCalcOverview.SetFilter("Location Code", Item.GetFilter("Location Filter"));        TempAvgCostCalcOverview.SetFilter("Variant Code", Item.GetFilter("Variant Filter"));        OnExpandAllOnAfterAvgCostCalcOverviewSetFilters(AvgCostCalcOverview, Item);        GetAvgCostCalcOverview.Run(AvgCostCalcOverview);        AvgCostCalcOverviewFilters.CopyFilters(Rec);        Rec.Reset();        Rec.DeleteAll();        // Pass 1 (descending): compute aggregates by calling Calculate on each (some routines rely on reverse order)        if TempAvgCostCalcOverview.Find('+') then            repeat                Rec := AvgCostCalcOverview;                GetAvgCostCalcOverview.Calculate(AvgCostCalcOverview);                TempAvgCostCalcOverview.Reset();                AvgCostCalcOverview := Rec; // restore record after Calculate changed it            until TempAvgCostCalcOverview.Next(-1) = 0;        // Pass 2 (ascending): insert all nodes to visible temp (Rec) maintaining hierarchy visual order        if TempAvgCostCalcOverview.Find('+') then            repeat                Rec := AvgCostCalcOverview;                Rec.Insert();            until TempAvgCostCalcOverview.Next(-1) = 0;        Rec.CopyFilters(AvgCostCalcOverviewFilters);    end;    local procedure IsExpanded(ActualAvgCostCalcOverview: Record "Average Cost Calc. Overview"): Boolean    var        AvgCostCalcOverview: Record "Average Cost Calc. Overview";        Found: Boolean;    begin        AvgCostCalcOverview := Rec;        Rec.SetCurrentKey("Attached to Valuation Date", "Attached to Entry No.", Type);        Rec := ActualAvgCostCalcOverview;        Found := (Rec.Next(GetDirection()) <> 0);        if Found then            Found := (Rec.Level > ActualAvgCostCalcOverview.Level);        Rec := AvgCostCalcOverview;        exit(Found);    end;    local procedure HasChildren(var ActualAvgCostCalcOverview: Record "Average Cost Calc. Overview"): Boolean    begin        TempAvgCostCalcOverview := ActualAvgCostCalcOverview;        if Rec.Type = Rec.Type::"Closing Entry" then            exit(GetAvgCostCalcOverview.EntriesExist(TempAvgCostCalcOverview));        exit(false);    end;    local procedure GetDirection(): Integer    begin        if Rec.Ascending then            exit(1);        exit(-1);    end;    procedure SetRecFilters()    begin        Rec.Reset();        Rec.SetCurrentKey("Attached to Valuation Date", "Attached to Entry No.", Type);        CurrPage.Update(false);    end;    procedure SetItem(var Item2: Record Item)    begin        Item.Copy(Item2);    end;    local procedure TypeOnFormat()    begin        if Rec.Type <> Rec.Type::"Closing Entry" then            TypeIndent := 1;    end;    local procedure ItemLedgerEntryNoOnFormat()    begin        if Rec.Type = Rec.Type::"Closing Entry" then            ItemLedgerEntryNoHideValue := true;    end;    local procedure EntryTypeOnFormat()    begin        if Rec.Type = Rec.Type::"Closing Entry" then            EntryTypeHideValue := true;    end;    local procedure DocumentLineNoOnFormat()    begin        if Rec.Type = Rec.Type::"Closing Entry" then            DocumentLineNoHideValue := true;    end;    [IntegrationEvent(false, false)]    local procedure OnExpandAllOnAfterAvgCostCalcOverviewSetFilters(var AvgCostCalcOverview: Record "Average Cost Calc. Overview" temporary; var Item: Record Item)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnInitTempTableOnAfterAvgCostCalcOverviewSetFilters(var AvgCostCalcOverview: Record "Average Cost Calc. Overview" temporary; var Item: Record Item)    begin    end;}