Page 5802 Value Entries
src/Layers/W1/BaseApp/Inventory/Ledger/ValueEntries.Page.al597 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.Ledger;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Foundation.Navigate;using Microsoft.Inventory.Analysis;using Microsoft.Inventory.Item;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Customer;using System.Globalization;using System.Security.User;page 5802 "Value Entries"{ AdditionalSearchTerms = 'costing,inventory cost,inventory valuation'; ApplicationArea = Basic, Suite; Caption = 'Value Entries'; DataCaptionExpression = GetCaption(); Editable = false; PageType = List; AboutTitle = 'About Value Entries'; AboutText = 'Track and analyze the detailed cost and value changes for inventory items, including actual and expected costs, sales and purchase amounts, adjustments, and links to related documents for comprehensive inventory valuation and costing.'; SourceTable = "Value Entry"; SourceTableView = sorting("Entry No.") order(descending); UsageCategory = History; layout { area(content) { repeater(Control1) { ShowCaption = false; field("Posting Date"; Rec."Posting Date") { ApplicationArea = Basic, Suite; } field("Valuation Date"; Rec."Valuation Date") { ApplicationArea = Basic, Suite; Visible = false; } field("Item Ledger Entry Type"; Rec."Item Ledger Entry Type") { ApplicationArea = Basic, Suite; } field("Entry Type"; Rec."Entry Type") { ApplicationArea = Basic, Suite; } field("Variance Type"; Rec."Variance Type") { ApplicationArea = Basic, Suite; Visible = false; } field(Adjustment; Rec.Adjustment) { ApplicationArea = Basic, Suite; ToolTip = 'Specifies this field was inserted by the Adjust Cost - Item Entries batch job, if it contains a check mark.'; } field("Document Type"; Rec."Document Type") { ApplicationArea = Basic, Suite; } field("Document No."; Rec."Document No.") { ApplicationArea = Basic, Suite; } field("Document Line No."; Rec."Document Line No.") { ApplicationArea = Basic, Suite; Visible = false; } field("Item Charge No."; Rec."Item Charge No.") { ApplicationArea = Basic, Suite; } field(Description; Rec.Description) { ApplicationArea = Basic, Suite; } field("Return Reason Code"; Rec."Return Reason Code") { ApplicationArea = Suite; Visible = false; } field("Sales Amount (Expected)"; Rec."Sales Amount (Expected)") { ApplicationArea = Basic, Suite; ToolTip = 'Specifies the expected price of the item for a sales entry, which means that it has not been invoiced yet.'; Visible = false; } field("Sales Amount (Actual)"; Rec."Sales Amount (Actual)") { ApplicationArea = Basic, Suite; ToolTip = 'Specifies the price of the item for a sales entry.'; } field("Cost Amount (Expected)"; Rec."Cost Amount (Expected)") { ApplicationArea = Basic, Suite; ToolTip = 'Specifies the expected cost of the items, which is calculated by multiplying the Cost per Unit by the Valued Quantity.'; } field("Cost Amount (Actual)"; Rec."Cost Amount (Actual)") { ApplicationArea = Basic, Suite; ToolTip = 'Specifies the cost of invoiced items.'; } field("Cost Amount (Non-Invtbl.)"; Rec."Cost Amount (Non-Invtbl.)") { ApplicationArea = Basic, Suite; ToolTip = 'Specifies the non-inventoriable cost, that is an item charge assigned to an outbound entry.'; } field("Cost Posted to G/L"; Rec."Cost Posted to G/L") { ApplicationArea = Basic, Suite; } field("Expected Cost Posted to G/L"; Rec."Expected Cost Posted to G/L") { ApplicationArea = Basic, Suite; Visible = false; } field("Cost Amount (Expected) (ACY)"; Rec."Cost Amount (Expected) (ACY)") { ApplicationArea = Basic, Suite; ToolTip = 'Specifies the expected cost of the items in the additional reporting currency.'; Visible = false; } field("Cost Amount (Actual) (ACY)"; Rec."Cost Amount (Actual) (ACY)") { ApplicationArea = Basic, Suite; ToolTip = 'Specifies the cost of the items that have been invoiced, if you post in an additional reporting currency.'; Visible = false; } field("Cost Amount (Non-Invtbl.)(ACY)"; Rec."Cost Amount (Non-Invtbl.)(ACY)") { ApplicationArea = Basic, Suite; ToolTip = 'Specifies the non-inventoriable cost, that is an item charge assigned to an outbound entry in the additional reporting currency.'; Visible = false; } field("Cost Posted to G/L (ACY)"; Rec."Cost Posted to G/L (ACY)") { ApplicationArea = Basic, Suite; ToolTip = 'Specifies the amount that has been posted to the general ledger if you post in an additional reporting currency.'; Visible = false; } field("Item Ledger Entry Quantity"; Rec."Item Ledger Entry Quantity") { ApplicationArea = Basic, Suite; } field("Valued Quantity"; Rec."Valued Quantity") { ApplicationArea = Basic, Suite; } field("Invoiced Quantity"; Rec."Invoiced Quantity") { ApplicationArea = Basic, Suite; } field("Cost per Unit"; Rec."Cost per Unit") { ApplicationArea = Basic, Suite; } field("Cost per Unit (ACY)"; Rec."Cost per Unit (ACY)") { ApplicationArea = Suite; ToolTip = 'Specifies the cost of one unit of the item in the entry.'; } field("Item No."; Rec."Item No.") { ApplicationArea = Basic, Suite; } field("Item Description"; Rec."Item Description") { ApplicationArea = Basic, Suite; DrillDown = false; Visible = false; } field("Location Code"; Rec."Location Code") { ApplicationArea = Location; Visible = false; } field(Type; Rec.Type) { ApplicationArea = Basic, Suite; Visible = false; } field("No."; Rec."No.") { ApplicationArea = Basic, Suite; Visible = false; } field("Discount Amount"; Rec."Discount Amount") { ApplicationArea = Basic, Suite; Visible = false; } field("Salespers./Purch. Code"; Rec."Salespers./Purch. Code") { ApplicationArea = Basic, Suite; Visible = false; } field("User ID"; Rec."User ID") { ApplicationArea = Basic, Suite; Visible = false; trigger OnDrillDown() var UserMgt: Codeunit "User Management"; begin UserMgt.DisplayUserInformation(Rec."User ID"); end; } field("Source Posting Group"; Rec."Source Posting Group") { ApplicationArea = Basic, Suite; Visible = false; } field("Source Code"; Rec."Source Code") { ApplicationArea = Basic, Suite; Visible = false; } field("Gen. Bus. Posting Group"; Rec."Gen. Bus. Posting Group") { ApplicationArea = Basic, Suite; } field("Gen. Prod. Posting Group"; Rec."Gen. Prod. Posting Group") { ApplicationArea = Basic, Suite; } field("Global Dimension 1 Code"; Rec."Global Dimension 1 Code") { ApplicationArea = Dimensions; Visible = Dim1Visible; } field("Global Dimension 2 Code"; Rec."Global Dimension 2 Code") { ApplicationArea = Dimensions; Visible = Dim2Visible; } field("Source Type"; Rec."Source Type") { ApplicationArea = Basic, Suite; } field("Source No."; Rec."Source No.") { ApplicationArea = Basic, Suite; } field("Source Description"; InventoryLedgerSourceMgt.GetSourceDescription(Rec."Source Type", Rec."Source No.")) { ApplicationArea = Basic, Suite; Caption = 'Source Description'; ToolTip = 'Specifies the name or description of the source. Analysis mode must be used for sorting and filtering on this field.'; Visible = false; } field("Source Order No."; InventoryLedgerSourceMgt.GetSourceOrderNo(Rec."Document Type", Rec."Document No.")) { ApplicationArea = Basic, Suite; Caption = 'Source Order No.'; ToolTip = 'Specifies the order number of the source document this entry is associated with. Analysis mode must be used for sorting and filtering on this field.'; Visible = false; } field("Document Date"; Rec."Document Date") { ApplicationArea = Basic, Suite; Visible = false; } field("External Document No."; Rec."External Document No.") { ApplicationArea = Basic, Suite; } field("Order Type"; Rec."Order Type") { ApplicationArea = Basic, Suite; } field("Order No."; Rec."Order No.") { ApplicationArea = Basic, Suite; Visible = false; } field("Valued By Average Cost"; Rec."Valued By Average Cost") { ApplicationArea = Basic, Suite; } field("Item Ledger Entry No."; Rec."Item Ledger Entry No.") { ApplicationArea = Basic, Suite; } field("Capacity Ledger Entry No."; Rec."Capacity Ledger Entry No.") { ApplicationArea = Manufacturing; } field("Entry No."; Rec."Entry No.") { ApplicationArea = Basic, Suite; } field("Job No."; Rec."Job No.") { ApplicationArea = Jobs; Visible = false; } field("Job Task No."; Rec."Job Task No.") { ApplicationArea = Jobs; Visible = false; } field("Job Ledger Entry No."; Rec."Job Ledger Entry No.") { ApplicationArea = Jobs; Visible = false; } field("Dimension Set ID"; Rec."Dimension Set ID") { ApplicationArea = Dimensions; Visible = false; } field("Shortcut Dimension 3 Code"; Rec."Shortcut Dimension 3 Code") { ApplicationArea = Dimensions; Editable = false; Visible = Dim3Visible; } field("Shortcut Dimension 4 Code"; Rec."Shortcut Dimension 4 Code") { ApplicationArea = Dimensions; Editable = false; Visible = Dim4Visible; } field("Shortcut Dimension 5 Code"; Rec."Shortcut Dimension 5 Code") { ApplicationArea = Dimensions; Editable = false; Visible = Dim5Visible; } field("Shortcut Dimension 6 Code"; Rec."Shortcut Dimension 6 Code") { ApplicationArea = Dimensions; Editable = false; Visible = Dim6Visible; } field("Shortcut Dimension 7 Code"; Rec."Shortcut Dimension 7 Code") { ApplicationArea = Dimensions; Editable = false; Visible = Dim7Visible; } field("Shortcut Dimension 8 Code"; Rec."Shortcut Dimension 8 Code") { ApplicationArea = Dimensions; Editable = false; Visible = Dim8Visible; } } } area(factboxes) { systempart(Control1900383207; Links) { ApplicationArea = RecordLinks; Visible = false; } systempart(Control1905767507; Notes) { ApplicationArea = Notes; Visible = false; } } } actions { area(navigation) { group("Ent&ry") { Caption = 'Ent&ry'; Image = Entry; 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 Rec.ShowDimensions(); 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; } action("General Ledger") { ApplicationArea = Basic, Suite; Caption = 'General Ledger'; Image = GLRegisters; ToolTip = 'Open the general ledger.'; trigger OnAction() begin Rec.ShowGL(); end; } } } area(processing) { 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', Comment = 'Generated from the PromotedActionCategories property index 1.'; actionref("&Navigate_Promoted"; "&Navigate") { } group(Category_Category4) { Caption = 'Entry', Comment = 'Generated from the PromotedActionCategories property index 3.'; actionref("General Ledger_Promoted"; "General Ledger") { } actionref(Dimensions_Promoted; Dimensions) { } actionref(SetDimensionFilter_Promoted; SetDimensionFilter) { } } } group(Category_Report) { Caption = 'Report', Comment = 'Generated from the PromotedActionCategories property index 2.'; } } } trigger OnOpenPage() begin FilterGroupNo := Rec.FilterGroup; // Trick: FILTERGROUP is used to transfer an integer value SetDimVisibility(); end; var InventoryLedgerSourceMgt: Codeunit "Invt. Ledger Source Mgt."; Navigate: Page Navigate; DimensionSetIDFilter: Page "Dimension Set ID Filter"; FilterGroupNo: Integer; protected var Dim1Visible: Boolean; Dim2Visible: Boolean; Dim3Visible: Boolean; Dim4Visible: Boolean; Dim5Visible: Boolean; Dim6Visible: Boolean; Dim7Visible: Boolean; Dim8Visible: Boolean; local procedure SetDimVisibility() var DimensionManagement: Codeunit DimensionManagement; begin DimensionManagement.UseShortcutDims(Dim1Visible, Dim2Visible, Dim3Visible, Dim4Visible, Dim5Visible, Dim6Visible, Dim7Visible, Dim8Visible); end; local procedure GetCaption(): Text var GLSetup: Record "General Ledger Setup"; ObjTransl: Record "Object Translation"; Item: Record Item; Cust: Record Customer; Vend: Record Vendor; Dimension: Record Dimension; DimValue: Record "Dimension Value"; SourceTableName: Text; SourceFilter: Text; SourceDescription: Text; begin SourceDescription := ''; case true of Rec.GetFilter("Item Ledger Entry No.") <> '': begin SourceTableName := ObjTransl.TranslateObject(ObjTransl."Object Type"::Table, 32); SourceFilter := Rec.GetFilter("Item Ledger Entry No."); end; Rec.GetFilter("Capacity Ledger Entry No.") <> '': begin SourceTableName := ObjTransl.TranslateObject(ObjTransl."Object Type"::Table, 5832); SourceFilter := Rec.GetFilter("Capacity Ledger Entry No."); end; Rec.GetFilter("Item No.") <> '': begin SourceTableName := ObjTransl.TranslateObject(ObjTransl."Object Type"::Table, 27); SourceFilter := Rec.GetFilter("Item No."); if MaxStrLen(Item."No.") >= StrLen(SourceFilter) then if Item.Get(SourceFilter) then SourceDescription := Item.Description; end; Rec.GetFilter("Source No.") <> '': case Rec."Source Type" of Rec."Source Type"::Customer: begin SourceTableName := ObjTransl.TranslateObject(ObjTransl."Object Type"::Table, 18); SourceFilter := Rec.GetFilter("Source No."); if MaxStrLen(Cust."No.") >= StrLen(SourceFilter) then if Cust.Get(SourceFilter) then SourceDescription := Cust.Name; end; Rec."Source Type"::Vendor: begin SourceTableName := ObjTransl.TranslateObject(ObjTransl."Object Type"::Table, 23); SourceFilter := Rec.GetFilter("Source No."); if MaxStrLen(Vend."No.") >= StrLen(SourceFilter) then if Vend.Get(SourceFilter) then SourceDescription := Vend.Name; end; end; Rec.GetFilter("Global Dimension 1 Code") <> '': begin GLSetup.Get(); Dimension.Code := GLSetup."Global Dimension 1 Code"; SourceFilter := Rec.GetFilter("Global Dimension 1 Code"); SourceTableName := Dimension.GetMLName(GlobalLanguage); if MaxStrLen(DimValue.Code) >= StrLen(SourceFilter) then if DimValue.Get(GLSetup."Global Dimension 1 Code", SourceFilter) then SourceDescription := DimValue.Name; end; Rec.GetFilter("Global Dimension 2 Code") <> '': begin GLSetup.Get(); Dimension.Code := GLSetup."Global Dimension 2 Code"; SourceFilter := Rec.GetFilter("Global Dimension 2 Code"); SourceTableName := Dimension.GetMLName(GlobalLanguage); if MaxStrLen(DimValue.Code) >= StrLen(SourceFilter) then if DimValue.Get(GLSetup."Global Dimension 2 Code", SourceFilter) then SourceDescription := DimValue.Name; end; Rec.GetFilter("Document Type") <> '': begin SourceTableName := Rec.GetFilter("Document Type"); SourceFilter := Rec.GetFilter("Document No."); SourceDescription := Rec.GetFilter("Document Line No."); end; FilterGroupNo = DATABASE::"Item Analysis View Entry": begin if Item."No." <> Rec."Item No." then if not Item.Get(Rec."Item No.") then Clear(Item); SourceTableName := ObjTransl.TranslateObject(ObjTransl."Object Type"::Table, DATABASE::"Item Analysis View Entry"); SourceFilter := Item."No."; SourceDescription := Item.Description; end; end; exit(StrSubstNo('%1 %2 %3', SourceTableName, SourceFilter, SourceDescription)); end;}