Page 7133 Item Budget Entries
src/Layers/W1/BaseApp/Inventory/Analysis/ItemBudgetEntries.Page.al338 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.Analysis;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Inventory.Item;using Microsoft.Inventory.Location;using System.Utilities;page 7133 "Item Budget Entries"{ ApplicationArea = ItemBudget; Caption = 'Item Budget Entries'; DataCaptionExpression = Rec.GetCaption(); DelayedInsert = true; PageType = List; SourceTable = "Item Budget Entry"; UsageCategory = History; layout { area(content) { repeater(Control1) { ShowCaption = false; field("Budget Name"; Rec."Budget Name") { ApplicationArea = ItemBudget; Editable = false; } field(Date; Rec.Date) { ApplicationArea = ItemBudget; } field("Item No."; Rec."Item No.") { ApplicationArea = ItemBudget; } field(Description; Rec.Description) { ApplicationArea = ItemBudget; } field("Source Type"; Rec."Source Type") { ApplicationArea = ItemBudget; } field("Source No."; Rec."Source No.") { ApplicationArea = ItemBudget; } field("Global Dimension 1 Code"; Rec."Global Dimension 1 Code") { ApplicationArea = Dimensions; Enabled = GlobalDimension1CodeEnable; Visible = GlobalDimension1CodeVisible; } field("Global Dimension 2 Code"; Rec."Global Dimension 2 Code") { ApplicationArea = Dimensions; Enabled = GlobalDimension2CodeEnable; Visible = GlobalDimension2CodeVisible; } field("Budget Dimension 1 Code"; Rec."Budget Dimension 1 Code") { ApplicationArea = Dimensions; Enabled = BudgetDimension1CodeEnable; Visible = BudgetDimension1CodeVisible; } field("Budget Dimension 2 Code"; Rec."Budget Dimension 2 Code") { ApplicationArea = Dimensions; Enabled = BudgetDimension2CodeEnable; Visible = BudgetDimension2CodeVisible; } field("Budget Dimension 3 Code"; Rec."Budget Dimension 3 Code") { ApplicationArea = Dimensions; Enabled = BudgetDimension3CodeEnable; Visible = BudgetDimension3CodeVisible; } field("Location Code"; Rec."Location Code") { ApplicationArea = Location; Visible = false; } field(Quantity; Rec.Quantity) { ApplicationArea = ItemBudget; } field("Cost Amount"; Rec."Cost Amount") { ApplicationArea = ItemBudget; } field("Sales Amount"; Rec."Sales Amount") { ApplicationArea = ItemBudget; } field("Entry No."; Rec."Entry No.") { ApplicationArea = ItemBudget; Editable = false; } field("Dimension Set ID"; Rec."Dimension Set ID") { ApplicationArea = Dimensions; Visible = false; } } } area(factboxes) { systempart(Control1900383207; Links) { ApplicationArea = RecordLinks; Visible = false; } systempart(Control1905767507; Notes) { ApplicationArea = Notes; Visible = false; } } } actions { area(navigation) { group("<Action23>") { Caption = 'Ent&ry'; Image = Entry; action("<Action24>") { 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 Rec.ShowDimensions(); CurrPage.SaveRecord(); end; } action(SetDimensionFilter) { ApplicationArea = Dimensions; Caption = 'Set Dimension Filter'; Ellipsis = true; Image = "Filter"; ToolTip = 'Limit the entries according to the dimension filters that you specify. NOTE: If you use a high number of dimension combinations, this function may not work and can result in a message that the SQL server only supports a maximum of 2100 parameters.'; trigger OnAction() begin Rec.SetFilter("Dimension Set ID", DimensionSetIDFilter.LookupFilter()); end; } } } } trigger OnAfterGetCurrRecord() begin if Rec."Entry No." <> 0 then if Rec."Dimension Set ID" <> xRec."Dimension Set ID" then LowestModifiedEntryNo := Rec."Entry No."; end; trigger OnClosePage() var UpdateItemAnalysisView: Codeunit "Update Item Analysis View"; begin if LowestModifiedEntryNo < 2147483647 then UpdateItemAnalysisView.SetLastBudgetEntryNo(LowestModifiedEntryNo - 1); end; trigger OnDeleteRecord(): Boolean begin if Rec."Entry No." < LowestModifiedEntryNo then LowestModifiedEntryNo := Rec."Entry No."; exit(true); end; trigger OnInit() begin BudgetDimension3CodeEnable := true; BudgetDimension2CodeEnable := true; BudgetDimension1CodeEnable := true; GlobalDimension2CodeEnable := true; GlobalDimension1CodeEnable := true; BudgetDimension3CodeVisible := true; BudgetDimension2CodeVisible := true; BudgetDimension1CodeVisible := true; GlobalDimension2CodeVisible := true; GlobalDimension1CodeVisible := true; LowestModifiedEntryNo := 2147483647; end; trigger OnModifyRecord(): Boolean begin if Rec."Entry No." < LowestModifiedEntryNo then LowestModifiedEntryNo := Rec."Entry No."; exit(true); end; trigger OnNewRecord(BelowxRec: Boolean) begin Rec."Budget Name" := Rec.GetRangeMin("Budget Name"); Rec."Analysis Area" := Rec.GetRangeMin("Analysis Area"); if (ItemBudgetName.Name <> Rec."Budget Name") or (ItemBudgetName."Analysis Area" <> Rec."Analysis Area") then ItemBudgetName.Get(Rec."Analysis Area", Rec."Budget Name"); if Rec.GetFilter("Item No.") <> '' then Rec."Item No." := GetFirstItem(Rec.GetFilter("Item No.")); Rec.Date := GetFirstDate(Rec.GetFilter(Date)); Rec."User ID" := CopyStr(UserId(), 1, MaxStrLen(Rec."User ID")); if Rec.GetFilter("Global Dimension 1 Code") <> '' then Rec."Global Dimension 1 Code" := GetFirstDimValue(GLSetup."Global Dimension 1 Code", Rec.GetFilter("Global Dimension 1 Code")); if Rec.GetFilter("Global Dimension 2 Code") <> '' then Rec."Global Dimension 2 Code" := GetFirstDimValue(GLSetup."Global Dimension 2 Code", Rec.GetFilter("Global Dimension 2 Code")); if Rec.GetFilter("Budget Dimension 1 Code") <> '' then Rec."Budget Dimension 1 Code" := GetFirstDimValue(ItemBudgetName."Budget Dimension 1 Code", Rec.GetFilter("Budget Dimension 1 Code")); if Rec.GetFilter("Budget Dimension 2 Code") <> '' then Rec."Budget Dimension 2 Code" := GetFirstDimValue(ItemBudgetName."Budget Dimension 2 Code", Rec.GetFilter("Budget Dimension 2 Code")); if Rec.GetFilter("Budget Dimension 3 Code") <> '' then Rec."Budget Dimension 3 Code" := GetFirstDimValue(ItemBudgetName."Budget Dimension 3 Code", Rec.GetFilter("Budget Dimension 3 Code")); if Rec.GetFilter("Location Code") <> '' then Rec."Location Code" := GetFirstLocationCode(Rec.GetFilter("Location Code")); end; trigger OnOpenPage() begin if Rec.GetFilter("Budget Name") = '' then ItemBudgetName.Init() else begin Rec.CopyFilter("Analysis Area", ItemBudgetName."Analysis Area"); Rec.CopyFilter("Budget Name", ItemBudgetName.Name); ItemBudgetName.FindFirst(); end; CurrPage.Editable := not ItemBudgetName.Blocked; GLSetup.Get(); GlobalDimension1CodeEnable := GLSetup."Global Dimension 1 Code" <> ''; GlobalDimension2CodeEnable := GLSetup."Global Dimension 2 Code" <> ''; BudgetDimension1CodeEnable := ItemBudgetName."Budget Dimension 1 Code" <> ''; BudgetDimension2CodeEnable := ItemBudgetName."Budget Dimension 2 Code" <> ''; BudgetDimension3CodeEnable := ItemBudgetName."Budget Dimension 3 Code" <> ''; GlobalDimension1CodeVisible := GLSetup."Global Dimension 1 Code" <> ''; GlobalDimension2CodeVisible := GLSetup."Global Dimension 2 Code" <> ''; BudgetDimension1CodeVisible := ItemBudgetName."Budget Dimension 1 Code" <> ''; BudgetDimension2CodeVisible := ItemBudgetName."Budget Dimension 2 Code" <> ''; BudgetDimension3CodeVisible := ItemBudgetName."Budget Dimension 3 Code" <> ''; end; var GLSetup: Record "General Ledger Setup"; ItemBudgetName: Record "Item Budget Name"; DimensionSetIDFilter: Page "Dimension Set ID Filter"; LowestModifiedEntryNo: Integer; GlobalDimension1CodeVisible: Boolean; GlobalDimension2CodeVisible: Boolean; BudgetDimension1CodeVisible: Boolean; BudgetDimension2CodeVisible: Boolean; BudgetDimension3CodeVisible: Boolean; GlobalDimension1CodeEnable: Boolean; GlobalDimension2CodeEnable: Boolean; BudgetDimension1CodeEnable: Boolean; BudgetDimension2CodeEnable: Boolean; BudgetDimension3CodeEnable: Boolean; local procedure GetFirstItem(ItemFilter: Text[250]): Code[20] var Item: Record Item; begin Item.SetFilter("No.", ItemFilter); if Item.FindFirst() then exit(Item."No."); exit(''); end; local procedure GetFirstDate(DateFilter: Text[250]): Date var Period: Record Date; begin if DateFilter = '' then exit(0D); Period.SetRange("Period Type", Period."Period Type"::Date); Period.SetFilter("Period Start", DateFilter); if Period.FindFirst() then exit(Period."Period Start"); exit(0D); end; local procedure GetFirstDimValue(DimCode: Code[20]; DimValFilter: Text[250]): Code[20] var DimVal: Record "Dimension Value"; begin if (DimCode = '') or (DimValFilter = '') then exit(''); DimVal.SetRange("Dimension Code", DimCode); DimVal.SetFilter(Code, DimValFilter); if DimVal.FindFirst() then exit(DimVal.Code); exit(''); end; local procedure GetFirstLocationCode(LocationCodetFilter: Text[250]): Code[10] var Location: Record Location; begin Location.SetFilter(Code, LocationCodetFilter); if Location.FindFirst() then exit(Location.Code); exit(''); end;}