Page 5809 Cost Adjustment Detailed Logs
src/Layers/W1/BaseApp/Inventory/Costing/CostAdjustmentDetailedLogs.Page.al150 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.Inventory.Ledger;page 5809 "Cost Adjustment Detailed Logs"{ PageType = List; ApplicationArea = Basic, Suite; SourceTable = "Cost Adjustment Detailed Log"; Caption = 'Cost Adjustment Log per Item'; SourceTableView = sorting("Item No.", "Ending Date-Time") order(descending); Editable = false; layout { area(Content) { repeater(GroupName) { field("Cost Adjustment Run Guid"; Rec."Cost Adjustment Run Guid") { Caption = 'Cost Adjustment Run Guid'; Visible = false; } field("Item No."; Rec."Item No.") { Caption = 'Item No.'; } field("Run Status"; Status) { Caption = 'Status'; ToolTip = 'Specifies the status of the cost adjustment run.'; StyleExpr = StatusStyleExpr; } field("Starting Date-Time"; Rec."Starting Date-Time") { Caption = 'Starting Date-Time'; } field("Ending Date-Time"; Rec."Ending Date-Time") { Caption = 'Ending Date-Time'; } field(Duration; Rec.Duration) { Caption = 'Duration'; } field("Item Register No."; ItemRegisterNo) { Caption = 'Item Register No.'; ToolTip = 'Specifies the item register number that is created for the item. Blank value indicates that the cost adjustment has not produced any new value entries.'; TableRelation = "Item Register"; BlankZero = true; } field("New Value Entries"; ValueEntriesCreated) { Caption = 'New Value Entries'; ToolTip = 'Specifies the number of new value entries that are created for the item. Blank value indicates that the cost adjustment has not produced any new value entries.'; BlankZero = true; } field("Adjusted Cost Amount"; AdjustedCostAmount) { AutoFormatType = 1; AutoFormatExpression = ''; Caption = 'Adjusted Cost Amount'; ToolTip = 'Specifies the adjusted cost amount for the item. Blank value indicates that the cost adjustment has not produced any new value entries.'; BlankZero = true; } } } } actions { area(Navigation) { action("Value Entries") { Caption = 'Value Entries'; ToolTip = 'Open the Value Entries page to view the value entries that the the cost adjustment has produced for the item.'; Image = ValueLedger; trigger OnAction() var ItemRegister: Record "Item Register"; ValueEntry: Record "Value Entry"; begin ItemRegister.SetLoadFields("From Value Entry No.", "To Value Entry No."); if not ItemRegister.Get(ItemRegisterNo) then exit; ValueEntry.SetRange("Entry No.", ItemRegister."From Value Entry No.", ItemRegister."To Value Entry No."); ValueEntry.SetFilter("Item Register No.", '0|%1', ItemRegisterNo); ValueEntry.SetRange("Item No.", Rec."Item No."); Page.RunModal(0, ValueEntry); end; } } area(Promoted) { actionref("Value Entries_Promoted"; "Value Entries") { } } } var Status: Enum "Cost Adjustment Run Status"; StatusStyleExpr: Text; ItemRegisterNo: Integer; ValueEntriesCreated: Integer; AdjustedCostAmount: Decimal; trigger OnAfterGetRecord() var CostAdjustmentLog: Record "Cost Adjustment Log"; ItemRegister: Record "Item Register"; ValueEntry: Record "Value Entry"; begin CostAdjustmentLog.SetCurrentKey("Cost Adjustment Run Guid"); CostAdjustmentLog.SetRange("Cost Adjustment Run Guid", Rec."Cost Adjustment Run Guid"); CostAdjustmentLog.FindFirst(); Status := CostAdjustmentLog.Status; ItemRegisterNo := CostAdjustmentLog."Item Register No."; ValueEntriesCreated := 0; AdjustedCostAmount := 0; if ItemRegisterNo <> 0 then begin ItemRegister.SetLoadFields("From Value Entry No.", "To Value Entry No."); ItemRegister.Get(ItemRegisterNo); ValueEntry.SetRange("Entry No.", ItemRegister."From Value Entry No.", ItemRegister."To Value Entry No."); ValueEntry.SetFilter("Item Register No.", '0|%1', ItemRegisterNo); ValueEntry.SetRange("Item No.", Rec."Item No."); ValueEntry.CalcSums("Cost Amount (Actual)"); AdjustedCostAmount := ValueEntry."Cost Amount (Actual)"; ValueEntriesCreated := ValueEntry.Count(); end; case Status of Status::Success: StatusStyleExpr := 'Favorable'; Status::Failed, Status::"Timed out": StatusStyleExpr := 'Unfavorable'; else StatusStyleExpr := 'Standard'; end; end;}