Table 7134 Item Budget Entry
src/Layers/W1/BaseApp/Inventory/Analysis/ItemBudgetEntry.Table.al618 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.Foundation.Enums;using Microsoft.Inventory.Item;using Microsoft.Inventory.Location;using Microsoft.Inventory.Setup;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Customer;using Microsoft.Sales.Setup;using Microsoft.Utilities;using System.Security.AccessControl;table 7134 "Item Budget Entry"{ Caption = 'Item Budget Entry'; DrillDownPageID = "Item Budget Entries"; LookupPageID = "Item Budget Entries"; DataClassification = CustomerContent; fields { field(1; "Entry No."; Integer) { Caption = 'Entry No.'; ToolTip = 'Specifies the number of the entry, as assigned from the specified number series when the entry was created.'; } field(2; "Analysis Area"; Enum "Analysis Area Type") { Caption = 'Analysis Area'; NotBlank = true; } field(3; "Budget Name"; Code[10]) { Caption = 'Budget Name'; ToolTip = 'Specifies the name of the item budget that the entry belongs to.'; TableRelation = "Item Budget Name".Name where("Analysis Area" = field("Analysis Area")); } field(4; Date; Date) { Caption = 'Date'; ToolTip = 'Specifies the date of this item budget entry.'; ClosingDates = true; } field(5; "Item No."; Code[20]) { Caption = 'Item No.'; ToolTip = 'Specifies the number of the item that this budget entry applies to.'; TableRelation = Item; } field(6; "Source Type"; Enum "Analysis Source Type") { Caption = 'Source Type'; ToolTip = 'Specifies the source type of this budget entry.'; trigger OnValidate() begin if "Source Type" <> xRec."Source Type" then Validate("Source No.", ''); end; } field(7; "Source No."; Code[20]) { Caption = 'Source No.'; ToolTip = 'Specifies the number of the source document that the entry originates from.'; TableRelation = if ("Source Type" = const(Customer)) Customer else if ("Source Type" = const(Vendor)) Vendor else if ("Source Type" = const(Item)) Item; } field(8; Description; Text[100]) { Caption = 'Description'; ToolTip = 'Specifies a description of the budget figure.'; } field(9; Quantity; Decimal) { AutoFormatType = 0; Caption = 'Quantity'; ToolTip = 'Specifies the quantity of this item budget entry.'; DecimalPlaces = 0 : 5; } field(10; "Cost Amount"; Decimal) { AutoFormatType = 1; AutoFormatExpression = ''; Caption = 'Cost Amount'; ToolTip = 'Specifies the cost amount of this item budget entry.'; } field(11; "Sales Amount"; Decimal) { AutoFormatType = 1; AutoFormatExpression = ''; Caption = 'Sales Amount'; ToolTip = 'Specifies the sales amount of this item budget line entry.'; } field(13; "User ID"; Code[50]) { Caption = 'User ID'; DataClassification = EndUserIdentifiableInformation; Editable = false; TableRelation = User."User Name"; } field(14; "Location Code"; Code[10]) { Caption = 'Location Code'; ToolTip = 'Specifies the code for the location that this item budget entry is linked to.'; TableRelation = Location; } field(15; "Global Dimension 1 Code"; Code[20]) { CaptionClass = '1,1,1'; Caption = 'Global Dimension 1 Code'; ToolTip = 'Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company''s most important activities, are available on all cards, documents, reports, and lists.'; TableRelation = "Dimension Value".Code where("Global Dimension No." = const(1)); trigger OnValidate() begin if "Global Dimension 1 Code" = '' then exit; GetGLSetup(); ValidateDimValue(GLSetup."Global Dimension 1 Code", "Global Dimension 1 Code"); end; } field(16; "Global Dimension 2 Code"; Code[20]) { CaptionClass = '1,1,2'; Caption = 'Global Dimension 2 Code'; ToolTip = 'Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company''s most important activities, are available on all cards, documents, reports, and lists.'; TableRelation = "Dimension Value".Code where("Global Dimension No." = const(2)); trigger OnValidate() begin if "Global Dimension 2 Code" = '' then exit; GetGLSetup(); ValidateDimValue(GLSetup."Global Dimension 2 Code", "Global Dimension 2 Code"); end; } field(17; "Budget Dimension 1 Code"; Code[20]) { AccessByPermission = TableData Dimension = R; CaptionClass = GetCaptionClass(1); Caption = 'Budget Dimension 1 Code'; ToolTip = 'Specifies the dimension value code for the Budget Dimension 1 code that this item budget entry is linked to.'; trigger OnLookup() begin "Budget Dimension 1 Code" := OnLookupDimCode(2, "Budget Dimension 1 Code"); end; trigger OnValidate() begin if "Budget Dimension 1 Code" = '' then exit; if ItemBudgetName.Name <> "Budget Name" then ItemBudgetName.Get("Analysis Area", "Budget Name"); ValidateDimValue(ItemBudgetName."Budget Dimension 1 Code", "Budget Dimension 1 Code"); end; } field(18; "Budget Dimension 2 Code"; Code[20]) { AccessByPermission = TableData Dimension = R; CaptionClass = GetCaptionClass(2); Caption = 'Budget Dimension 2 Code'; ToolTip = 'Specifies the dimension value code for the Budget Dimension 2 code that this item budget entry is linked to.'; trigger OnLookup() begin "Budget Dimension 2 Code" := OnLookupDimCode(3, "Budget Dimension 2 Code"); end; trigger OnValidate() begin if "Budget Dimension 2 Code" = '' then exit; if ItemBudgetName.Name <> "Budget Name" then ItemBudgetName.Get("Analysis Area", "Budget Name"); ValidateDimValue(ItemBudgetName."Budget Dimension 2 Code", "Budget Dimension 2 Code"); end; } field(19; "Budget Dimension 3 Code"; Code[20]) { AccessByPermission = TableData "Dimension Combination" = R; CaptionClass = GetCaptionClass(3); Caption = 'Budget Dimension 3 Code'; ToolTip = 'Specifies the dimension value code for the Budget Dimension 3 Code that this item budget entry is linked to.'; trigger OnLookup() begin "Budget Dimension 3 Code" := OnLookupDimCode(4, "Budget Dimension 3 Code"); end; trigger OnValidate() begin if "Budget Dimension 3 Code" = '' then exit; if ItemBudgetName.Name <> "Budget Name" then ItemBudgetName.Get("Analysis Area", "Budget Name"); ValidateDimValue(ItemBudgetName."Budget Dimension 3 Code", "Budget Dimension 3 Code"); end; } field(480; "Dimension Set ID"; Integer) { Caption = 'Dimension Set ID'; ToolTip = 'Specifies a reference to a combination of dimension values. The actual values are stored in the Dimension Set Entry table.'; Editable = false; TableRelation = "Dimension Set Entry"; trigger OnLookup() begin Rec.ShowDimensions(); end; } } keys { key(Key1; "Entry No.") { Clustered = true; } key(Key2; "Analysis Area", "Budget Name", "Item No.", "Source Type", "Source No.", Date, "Location Code", "Global Dimension 1 Code", "Global Dimension 2 Code", "Budget Dimension 1 Code", "Budget Dimension 2 Code", "Budget Dimension 3 Code") { SumIndexFields = "Cost Amount", "Sales Amount", Quantity; } key(Key3; "Analysis Area", "Budget Name", "Source Type", "Source No.", "Item No.", Date, "Location Code", "Global Dimension 1 Code", "Global Dimension 2 Code", "Budget Dimension 1 Code", "Budget Dimension 2 Code", "Budget Dimension 3 Code") { SumIndexFields = "Cost Amount", "Sales Amount", Quantity; } key(Key4; "Analysis Area", "Budget Name", "Item No.", Date) { } } fieldgroups { } trigger OnDelete() begin CheckIfBlocked(); DeleteItemAnalysisViewBudgEntry(); end; trigger OnInsert() var TempDimSetEntry: Record "Dimension Set Entry" temporary; IsHandled: Boolean; begin CheckIfBlocked(); TestField(Date); GetGLSetup(); if ("Source No." = '') and ("Item No." = '') then begin GetSalesSetup(); GetInventorySetup(); IsHandled := false; OnInsertOnBeforeCheckGroupDimFilled(Rec, IsHandled); if not IsHandled then if not (CheckGroupDimFilled(SalesSetup."Customer Group Dimension Code") or CheckGroupDimFilled(SalesSetup."Salesperson Dimension Code") or CheckGroupDimFilled(InventorySetup."Item Group Dimension Code")) then TestField("Item No."); end; TestField("Budget Name"); LockTable(); "User ID" := CopyStr(UserId(), 1, MaxStrLen("User ID")); if "Entry No." = 0 then "Entry No." := GetLastEntryNo() + 1; GetGLSetup(); DimMgt.GetDimensionSet(TempDimSetEntry, "Dimension Set ID"); UpdateDimSet(TempDimSetEntry, GLSetup."Global Dimension 1 Code", "Global Dimension 1 Code"); UpdateDimSet(TempDimSetEntry, GLSetup."Global Dimension 2 Code", "Global Dimension 2 Code"); UpdateDimSet(TempDimSetEntry, ItemBudgetName."Budget Dimension 1 Code", "Budget Dimension 1 Code"); UpdateDimSet(TempDimSetEntry, ItemBudgetName."Budget Dimension 2 Code", "Budget Dimension 2 Code"); UpdateDimSet(TempDimSetEntry, ItemBudgetName."Budget Dimension 3 Code", "Budget Dimension 3 Code"); "Dimension Set ID" := DimMgt.GetDimensionSetID(TempDimSetEntry); end; trigger OnModify() var TempDimSetEntry: Record "Dimension Set Entry" temporary; begin CheckIfBlocked(); "User ID" := CopyStr(UserId(), 1, MaxStrLen("User ID")); GetGLSetup(); DimMgt.GetDimensionSet(TempDimSetEntry, "Dimension Set ID"); if "Global Dimension 1 Code" <> xRec."Global Dimension 1 Code" then UpdateDimSet(TempDimSetEntry, GLSetup."Global Dimension 1 Code", "Global Dimension 1 Code"); if "Global Dimension 2 Code" <> xRec."Global Dimension 2 Code" then UpdateDimSet(TempDimSetEntry, GLSetup."Global Dimension 2 Code", "Global Dimension 2 Code"); if "Budget Dimension 1 Code" <> xRec."Budget Dimension 1 Code" then UpdateDimSet(TempDimSetEntry, ItemBudgetName."Budget Dimension 1 Code", "Budget Dimension 1 Code"); if "Budget Dimension 2 Code" <> xRec."Budget Dimension 2 Code" then UpdateDimSet(TempDimSetEntry, ItemBudgetName."Budget Dimension 2 Code", "Budget Dimension 2 Code"); if "Budget Dimension 3 Code" <> xRec."Budget Dimension 3 Code" then UpdateDimSet(TempDimSetEntry, ItemBudgetName."Budget Dimension 3 Code", "Budget Dimension 3 Code"); "Dimension Set ID" := DimMgt.GetDimensionSetID(TempDimSetEntry); end; var ItemBudgetName: Record "Item Budget Name"; GLSetup: Record "General Ledger Setup"; InventorySetup: Record "Inventory Setup"; SalesSetup: Record "Sales & Receivables Setup"; DimVal: Record "Dimension Value"; DimMgt: Codeunit DimensionManagement; GLSetupRetrieved: Boolean; InventorySetupRetrieved: Boolean; SalesSetupRetrieved: Boolean;#pragma warning disable AA0074 Text001: Label '1,5,,Budget Dimension 1 Code'; Text002: Label '1,5,,Budget Dimension 2 Code'; Text003: Label '1,5,,Budget Dimension 3 Code';#pragma warning restore AA0074 local procedure CheckIfBlocked() begin if "Budget Name" = ItemBudgetName.Name then exit; if ItemBudgetName.Name <> "Budget Name" then ItemBudgetName.Get("Analysis Area", "Budget Name"); ItemBudgetName.TestField(Blocked, false); end; local procedure ValidateDimValue(DimCode: Code[20]; DimValueCode: Code[20]) begin if not DimMgt.CheckDimValue(DimCode, DimValueCode) then Error(DimMgt.GetDimErr()); end; local procedure GetGLSetup() begin if not GLSetupRetrieved then begin GLSetup.Get(); GLSetupRetrieved := true; end; end; local procedure GetInventorySetup() begin if not InventorySetupRetrieved then begin InventorySetup.Get(); InventorySetupRetrieved := true; end; end; local procedure GetSalesSetup() begin if not SalesSetupRetrieved then begin SalesSetup.Get(); SalesSetupRetrieved := true; end; end; local procedure OnLookupDimCode(DimOption: Option "Global Dimension 1","Global Dimension 2","Budget Dimension 1","Budget Dimension 2","Budget Dimension 3","Budget Dimension 4"; DefaultValue: Code[20]): Code[20] var DimValue: Record "Dimension Value"; DimValueList: Page "Dimension Value List"; begin if DimOption in [DimOption::"Global Dimension 1", DimOption::"Global Dimension 2"] then GetGLSetup() else if ItemBudgetName.Name <> "Budget Name" then ItemBudgetName.Get("Analysis Area", "Budget Name"); case DimOption of DimOption::"Global Dimension 1": DimValue."Dimension Code" := GLSetup."Global Dimension 1 Code"; DimOption::"Global Dimension 2": DimValue."Dimension Code" := GLSetup."Global Dimension 2 Code"; DimOption::"Budget Dimension 1": DimValue."Dimension Code" := ItemBudgetName."Budget Dimension 1 Code"; DimOption::"Budget Dimension 2": DimValue."Dimension Code" := ItemBudgetName."Budget Dimension 2 Code"; DimOption::"Budget Dimension 3": DimValue."Dimension Code" := ItemBudgetName."Budget Dimension 3 Code"; end; DimValue.SetRange("Dimension Code", DimValue."Dimension Code"); if DimValue.Get(DimValue."Dimension Code", DefaultValue) then; DimValueList.SetTableView(DimValue); DimValueList.SetRecord(DimValue); DimValueList.LookupMode := true; if DimValueList.RunModal() = ACTION::LookupOK then begin DimValueList.GetRecord(DimValue); exit(DimValue.Code); end; exit(DefaultValue); end; procedure GetLastEntryNo(): Integer; var FindRecordManagement: Codeunit "Find Record Management"; begin exit(FindRecordManagement.GetLastEntryIntFieldValue(Rec, FieldNo("Entry No."))) end; procedure GetCaptionClass(BudgetDimType: Integer): Text[250] begin if (ItemBudgetName."Analysis Area" <> "Analysis Area") or (ItemBudgetName.Name <> "Budget Name") then if not ItemBudgetName.Get("Analysis Area", "Budget Name") then exit(''); case BudgetDimType of 1: begin if ItemBudgetName."Budget Dimension 1 Code" <> '' then exit('1,5,' + ItemBudgetName."Budget Dimension 1 Code"); exit(Text001); end; 2: begin if ItemBudgetName."Budget Dimension 2 Code" <> '' then exit('1,5,' + ItemBudgetName."Budget Dimension 2 Code"); exit(Text002); end; 3: begin if ItemBudgetName."Budget Dimension 3 Code" <> '' then exit('1,5,' + ItemBudgetName."Budget Dimension 3 Code"); exit(Text003); end; end; end; local procedure CheckGroupDimFilled(GroupDimCode: Code[20]): Boolean begin if GroupDimCode <> '' then case GroupDimCode of GLSetup."Global Dimension 1 Code": exit("Global Dimension 1 Code" <> ''); GLSetup."Global Dimension 2 Code": exit("Global Dimension 2 Code" <> ''); ItemBudgetName."Budget Dimension 1 Code": exit("Budget Dimension 1 Code" <> ''); ItemBudgetName."Budget Dimension 2 Code": exit("Budget Dimension 2 Code" <> ''); ItemBudgetName."Budget Dimension 3 Code": exit("Budget Dimension 3 Code" <> ''); end; end; procedure GetCaption(): Text[1024] var GLSetup: Record "General Ledger Setup"; ItemBudgetName: Record "Item Budget Name"; Cust: Record Customer; Vend: Record Vendor; Item: Record Item; Dimension: Record Dimension; DimValue: Record "Dimension Value"; SourceTableCaption: Text[250]; SourceFilter: Text; Description: Text[250]; begin case true of GetFilter("Source No.") <> '': case "Source Type" of "Source Type"::Customer: begin SourceTableCaption := Cust.TableCaption(); SourceFilter := GetFilter("Source No."); if MaxStrLen(Cust."No.") >= StrLen(SourceFilter) then if Cust.Get(SourceFilter) then Description := Cust.Name; end; "Source Type"::Vendor: begin SourceTableCaption := Vend.TableCaption(); SourceFilter := GetFilter("Source No."); if MaxStrLen(Vend."No.") >= StrLen(SourceFilter) then if Vend.Get(SourceFilter) then Description := Vend.Name; end; end; GetFilter("Item No.") <> '': begin SourceTableCaption := Item.TableCaption(); SourceFilter := GetFilter("Item No."); if MaxStrLen(Item."No.") >= StrLen(SourceFilter) then if Item.Get(SourceFilter) then Description := Item.Description; end; GetFilter("Global Dimension 1 Code") <> '': begin GLSetup.Get(); Dimension.Code := GLSetup."Global Dimension 1 Code"; SourceFilter := GetFilter("Global Dimension 1 Code"); SourceTableCaption := Dimension.GetMLName(GlobalLanguage); if MaxStrLen(DimValue.Code) >= StrLen(SourceFilter) then if DimValue.Get(GLSetup."Global Dimension 1 Code", SourceFilter) then Description := DimValue.Name; end; GetFilter("Global Dimension 2 Code") <> '': begin GLSetup.Get(); Dimension.Code := GLSetup."Global Dimension 2 Code"; SourceFilter := GetFilter("Global Dimension 2 Code"); SourceTableCaption := Dimension.GetMLName(GlobalLanguage); if MaxStrLen(DimValue.Code) >= StrLen(SourceFilter) then if DimValue.Get(GLSetup."Global Dimension 2 Code", SourceFilter) then Description := DimValue.Name; end; GetFilter("Budget Dimension 1 Code") <> '': if ItemBudgetName.Get("Analysis Area", "Budget Name") then begin Dimension.Code := ItemBudgetName."Budget Dimension 1 Code"; SourceFilter := GetFilter("Budget Dimension 1 Code"); SourceTableCaption := Dimension.GetMLName(GlobalLanguage); if MaxStrLen(DimValue.Code) >= StrLen(SourceFilter) then if DimValue.Get(ItemBudgetName."Budget Dimension 1 Code", SourceFilter) then Description := DimValue.Name; end; GetFilter("Budget Dimension 2 Code") <> '': if ItemBudgetName.Get("Analysis Area", "Budget Name") then begin Dimension.Code := ItemBudgetName."Budget Dimension 2 Code"; SourceFilter := GetFilter("Budget Dimension 2 Code"); SourceTableCaption := Dimension.GetMLName(GlobalLanguage); if MaxStrLen(DimValue.Code) >= StrLen(SourceFilter) then if DimValue.Get(ItemBudgetName."Budget Dimension 2 Code", SourceFilter) then Description := DimValue.Name; end; GetFilter("Budget Dimension 3 Code") <> '': if ItemBudgetName.Get("Analysis Area", "Budget Name") then begin Dimension.Code := ItemBudgetName."Budget Dimension 3 Code"; SourceFilter := GetFilter("Budget Dimension 3 Code"); SourceTableCaption := Dimension.GetMLName(GlobalLanguage); if MaxStrLen(DimValue.Code) >= StrLen(SourceFilter) then if DimValue.Get(ItemBudgetName."Budget Dimension 3 Code", SourceFilter) then Description := DimValue.Name; end; end; exit( DelChr( StrSubstNo('%1 %2 %3 %4', SourceTableCaption, SourceFilter, Description, "Budget Name"), '>')); end; procedure ShowDimensions() var DimSetEntry: Record "Dimension Set Entry"; OldDimSetID: Integer; begin OldDimSetID := "Dimension Set ID"; "Dimension Set ID" := DimMgt.EditDimensionSet("Dimension Set ID", StrSubstNo('%1 %2 %3', "Budget Name", "Item No.", Date)); if OldDimSetID = "Dimension Set ID" then exit; GetGLSetup(); ItemBudgetName.Get("Analysis Area", "Budget Name"); "Global Dimension 1 Code" := ''; "Global Dimension 2 Code" := ''; "Budget Dimension 1 Code" := ''; "Budget Dimension 2 Code" := ''; "Budget Dimension 3 Code" := ''; if DimSetEntry.Get("Dimension Set ID", GLSetup."Global Dimension 1 Code") then "Global Dimension 1 Code" := DimSetEntry."Dimension Value Code"; if DimSetEntry.Get("Dimension Set ID", GLSetup."Global Dimension 2 Code") then "Global Dimension 2 Code" := DimSetEntry."Dimension Value Code"; if DimSetEntry.Get("Dimension Set ID", ItemBudgetName."Budget Dimension 1 Code") then "Budget Dimension 1 Code" := DimSetEntry."Dimension Value Code"; if DimSetEntry.Get("Dimension Set ID", ItemBudgetName."Budget Dimension 2 Code") then "Budget Dimension 2 Code" := DimSetEntry."Dimension Value Code"; if DimSetEntry.Get("Dimension Set ID", ItemBudgetName."Budget Dimension 3 Code") then "Budget Dimension 3 Code" := DimSetEntry."Dimension Value Code"; end; local procedure UpdateDimSet(var TempDimSetEntry: Record "Dimension Set Entry" temporary; DimCode: Code[20]; DimValueCode: Code[20]) begin if DimCode = '' then exit; if TempDimSetEntry.Get("Dimension Set ID", DimCode) then TempDimSetEntry.Delete(); if DimValueCode <> '' then begin DimVal.Get(DimCode, DimValueCode); TempDimSetEntry.Init(); TempDimSetEntry."Dimension Set ID" := "Dimension Set ID"; TempDimSetEntry."Dimension Code" := DimCode; TempDimSetEntry."Dimension Value Code" := DimValueCode; TempDimSetEntry."Dimension Value ID" := DimVal."Dimension Value ID"; TempDimSetEntry.Insert(); end; end; local procedure DeleteItemAnalysisViewBudgEntry() var ItemAnalysisViewBudgEntry: Record "Item Analysis View Budg. Entry"; begin ItemAnalysisViewBudgEntry.SetRange("Entry No.", "Entry No."); ItemAnalysisViewBudgEntry.SetRange("Analysis Area", "Analysis Area"); ItemAnalysisViewBudgEntry.SetRange("Budget Name", "Budget Name"); ItemAnalysisViewBudgEntry.DeleteAll(); end; [IntegrationEvent(false, false)] local procedure OnInsertOnBeforeCheckGroupDimFilled(var ItemBudgetEntry: Record "Item Budget Entry"; var IsHandled: Boolean) begin end;}