Report 5899 Calculate Inventory Value
src/Layers/W1/BaseApp/Inventory/Journal/CalculateInventoryValue.Report.al773 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.Journal;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Foundation.AuditCodes;using Microsoft.Foundation.NoSeries;using Microsoft.Inventory.Costing;using Microsoft.Inventory.Item;using Microsoft.Inventory.Ledger;using Microsoft.Inventory.Location;using Microsoft.Utilities;using System.Utilities;report 5899 "Calculate Inventory Value"{ Caption = 'Calculate Inventory Value'; ProcessingOnly = true; dataset { dataitem(Item; Item) { DataItemTableView = sorting("No.") where(Type = const(Inventory)); RequestFilterFields = "No.", "Costing Method", "Location Filter", "Variant Filter"; trigger OnAfterGetRecord() var ItemLedgerEntry: Record "Item Ledger Entry"; SkipItem: Boolean; IncludeExpectedCost: Boolean; RemCost: Decimal; begin if ShowDialog then Window.Update(); SkipItem := false; OnBeforeOnAfterGetRecord(Item, SkipItem); if SkipItem then CurrReport.Skip(); if (CalculatePer = CalculatePer::Item) and ("Costing Method" = "Costing Method"::Average) then begin CalendarPeriod."Period Start" := PostingDate; AvgCostEntryPointHandler.GetValuationPeriod(CalendarPeriod, PostingDate); if PostingDate <> CalendarPeriod."Period End" then Error(Text011, "No.", PostingDate, CalendarPeriod."Period End"); end; TempValJnlBuffer.Reset(); TempValJnlBuffer.DeleteAll(); IncludeExpectedCost := ("Costing Method" = "Costing Method"::Standard) and (CalculatePer = CalculatePer::Item); ItemLedgerEntry.SetCurrentKey("Item No.", Positive, "Location Code", "Variant Code"); ItemLedgerEntry.SetRange("Item No.", "No."); ItemLedgerEntry.SetRange(Positive, true); CopyFilter("Location Filter", ItemLedgerEntry."Location Code"); CopyFilter("Variant Filter", ItemLedgerEntry."Variant Code"); ItemLedgerEntry.SetFilter("Date Filter", '<=%1', PostingDate); ItemLedgerEntry.SetAutoCalcFields("Remaining Qty. by Date"); OnItemAfterGetRecordOnAfterItemLedgEntrySetFilters(ItemLedgerEntry, Item); if ItemLedgerEntry.FindSet() then repeat if IncludeEntryInCalc(ItemLedgerEntry, PostingDate, IncludeExpectedCost) then begin RemQty := ItemLedgerEntry."Remaining Qty. by Date"; RemCost := CalcRemainingCost(ItemLedgerEntry, RemQty, IncludeExpectedCost); case CalculatePer of CalculatePer::"Item Ledger Entry": begin OnAfterGetRecordItemOnBeforInsertItemJnlLine(ItemLedgerEntry, ItemJnlLine); InsertItemJnlLine( ItemLedgerEntry."Entry Type", ItemLedgerEntry."Item No.", ItemLedgerEntry."Variant Code", ItemLedgerEntry."Location Code", RemQty, RemCost, ItemLedgerEntry."Entry No.", 0, ItemLedgerEntry."Dimension Set ID"); end; CalculatePer::Item: InsertValJnlBuffer( ItemLedgerEntry."Item No.", ItemLedgerEntry."Variant Code", ItemLedgerEntry."Location Code", RemQty, RemCost); end; end; until ItemLedgerEntry.Next() = 0; if CalculatePer = CalculatePer::Item then if (GetFilter("Location Filter") <> '') or ByLocation then begin ByLocation2 := true; CopyFilter("Location Filter", Location.Code); if Location.FindSet() then begin Clear(TempValJnlBuffer); TempValJnlBuffer.SetCurrentKey("Item No.", "Location Code", "Variant Code"); TempValJnlBuffer.SetRange("Item No.", "No."); repeat TempValJnlBuffer.SetRange("Location Code", Location.Code); if (GetFilter("Variant Filter") <> '') or ByVariant then begin ByVariant2 := true; ItemVariant.SetRange("Item No.", "No."); CopyFilter("Variant Filter", ItemVariant.Code); if ItemVariant.FindSet() then repeat TempValJnlBuffer.SetRange("Variant Code", ItemVariant.Code); Calculate(Item, ItemVariant.Code, Location.Code); until ItemVariant.Next() = 0; TempValJnlBuffer.SetRange("Variant Code", ''); Calculate(Item, '', Location.Code); end else Calculate(Item, '', Location.Code); until Location.Next() = 0; end; TempValJnlBuffer.SetRange("Location Code", ''); if ByVariant then begin ItemVariant.SetRange("Item No.", "No."); CopyFilter("Variant Filter", ItemVariant.Code); if ItemVariant.FindSet() then repeat TempValJnlBuffer.SetRange("Variant Code", ItemVariant.Code); Calculate(Item, ItemVariant.Code, ''); until ItemVariant.Next() = 0; TempValJnlBuffer.SetRange("Variant Code", ''); Calculate(Item, '', ''); end else Calculate(Item, '', ''); end else if (GetFilter("Variant Filter") <> '') or ByVariant then begin ByVariant2 := true; ItemVariant.SetRange("Item No.", "No."); CopyFilter("Variant Filter", ItemVariant.Code); if ItemVariant.FindSet() then begin TempValJnlBuffer.Reset(); TempValJnlBuffer.SetCurrentKey("Item No.", "Variant Code"); TempValJnlBuffer.SetRange("Item No.", "No."); repeat TempValJnlBuffer.SetRange("Variant Code", ItemVariant.Code); Calculate(Item, ItemVariant.Code, ''); until ItemVariant.Next() = 0; end; TempValJnlBuffer.SetRange("Location Code"); TempValJnlBuffer.SetRange("Variant Code", ''); Calculate(Item, '', ''); end else begin TempValJnlBuffer.Reset(); TempValJnlBuffer.SetCurrentKey("Item No."); TempValJnlBuffer.SetRange("Item No.", "No."); Calculate(Item, '', ''); end; end; trigger OnPostDataItem() var StockkeepingUnit: Record "Stockkeeping Unit"; ItemCostManagement: Codeunit ItemCostManagement; IsHandled: Boolean; begin if not UpdStdCost then exit; if ByLocation then CopyFilter("Location Filter", StockkeepingUnit."Location Code"); if ByVariant then CopyFilter("Variant Filter", StockkeepingUnit."Variant Code"); TempNewStdCostItem.CopyFilters(Item); if TempNewStdCostItem.FindSet() then repeat if not TempUpdatedStdCostSKU.Get('', TempNewStdCostItem."No.", '') then ItemCostManagement.UpdateStdCostShares(TempNewStdCostItem); StockkeepingUnit.SetRange("Item No.", TempNewStdCostItem."No."); if StockkeepingUnit.FindSet() then repeat if not TempUpdatedStdCostSKU.Get(StockkeepingUnit."Location Code", TempNewStdCostItem."No.", StockkeepingUnit."Variant Code") then begin IsHandled := false; OnPostDataItemForItemOnBeforeValidateStandardCost(TempNewStdCostItem, StockkeepingUnit, IsHandled); if not IsHandled then StockkeepingUnit.Validate("Standard Cost", TempNewStdCostItem."Standard Cost"); StockkeepingUnit.Modify(); end; until StockkeepingUnit.Next() = 0; until TempNewStdCostItem.Next() = 0; end; trigger OnPreDataItem() var TempErrorBuf: Record "Error Buffer" temporary; begin ItemJnlTemplate.Get(ItemJnlLine."Journal Template Name"); ItemJnlTemplate.TestField(Type, ItemJnlTemplate.Type::Revaluation); ItemJnlBatch.Get(ItemJnlLine."Journal Template Name", ItemJnlLine."Journal Batch Name"); if NextDocNo = '' then begin if ItemJnlBatch."No. Series" <> '' then begin ItemJnlLine.SetRange("Journal Template Name", ItemJnlLine."Journal Template Name"); ItemJnlLine.SetRange("Journal Batch Name", ItemJnlLine."Journal Batch Name"); if not ItemJnlLine.FindFirst() then NextDocNo := NoSeriesBatch.GetNextNo(ItemJnlBatch."No. Series", PostingDate); ItemJnlLine.Init(); end; if NextDocNo = '' then Error(Text003); end; CalcInvtValCheck.SetParameters(PostingDate, CalculatePer, ByLocation, ByVariant, ShowDialog, false); CalcInvtValCheck.RunCheck(Item, TempErrorBuf); NextLineNo := 0; if ShowDialog then Window.Open(Text010, "No."); GLSetup.Get(); SourceCodeSetup.Get(); case CalcBase of CalcBase::"Standard Cost - Assembly List": begin CalculateAssemblyCost.SetProperties(PostingDate, true, false, '', true); CalculateAssemblyCost.CalcItems(Item, TempNewStdCostItem); Clear(CalculateAssemblyCost); end; end; OnAfterOnPreDataItem(Item, CalcBase, PostingDate, TempNewStdCostItem); end; } } requestpage { layout { area(content) { group(Options) { Caption = 'Options'; field(PostingDate; PostingDate) { ApplicationArea = Basic, Suite; Caption = 'Posting Date'; ToolTip = 'Specifies the date for the posting of this batch job. By default, the working date is entered, but you can change it.'; } field(NextDocNo; NextDocNo) { ApplicationArea = Basic, Suite; Caption = 'Document No.'; ToolTip = 'Specifies the number of the document that is processed by the report or batch job.'; } field(CalculatePer; CalculatePer) { ApplicationArea = Basic, Suite; Caption = 'Calculate Per'; ToolTip = 'Specifies if you want to sum up the inventory value per item ledger entry or per item.'; trigger OnValidate() begin if CalculatePer = CalculatePer::Item then ItemCalculatePerOnValidate(); if CalculatePer = CalculatePer::"Item Ledger Entry" then ItemLedgerEntryCalculatePerOnV(); end; } field("By Location"; ByLocation) { ApplicationArea = Location; Caption = 'By Location'; Enabled = ByLocationEnable; ToolTip = 'Specifies whether to calculate inventory by location.'; } field("By Variant"; ByVariant) { ApplicationArea = Planning; Caption = 'By Variant'; Enabled = ByVariantEnable; ToolTip = 'Specifies the item variants that you want the batch job to consider.'; } field(UpdStdCost; UpdStdCost) { ApplicationArea = Basic, Suite; Caption = 'Update Standard Cost'; Enabled = UpdStdCostEnable; ToolTip = 'Specifies if you want the items'' standard cost to be updated according to the calculated inventory value. This option is available only if Item is chosen in the Calculate Per field.'; } field(CalcBase; CalcBase) { ApplicationArea = Basic, Suite; Caption = 'Calculation Base'; Enabled = CalcBaseEnable; ToolTip = 'Specifies if the revaluation journal will suggest a new value for the Unit Cost (Revalued) field.'; } } } } actions { } trigger OnInit() begin UpdStdCostEnable := true; CalcBaseEnable := true; ByVariantEnable := true; ByLocationEnable := true; end; trigger OnOpenPage() begin if PostingDate = 0D then PostingDate := WorkDate(); ValidatePostingDate(); ValidateCalcLevel(); end; } labels { } trigger OnPreReport() begin OnBeforePreReport(); end; var TempNewStdCostItem: Record Item temporary; TempUpdatedStdCostSKU: Record "Stockkeeping Unit" temporary; ItemJnlBatch: Record "Item Journal Batch"; ItemJnlLine: Record "Item Journal Line"; TempValJnlBuffer: Record "Item Journal Buffer" temporary; ItemJnlTemplate: Record "Item Journal Template"; GLSetup: Record "General Ledger Setup"; SourceCodeSetup: Record "Source Code Setup"; Location: Record Location; ItemVariant: Record "Item Variant"; CalendarPeriod: Record Date; CalcInvtValCheck: Codeunit "Calc. Inventory Value-Check"; NoSeriesBatch: Codeunit "No. Series - Batch"; CalculateAssemblyCost: Codeunit Microsoft.Assembly.Costing."Calculate Assembly Cost"; AvgCostEntryPointHandler: Codeunit "Avg. Cost Entry Point Handler"; Window: Dialog; CalculatePer: Enum "Inventory Value Calc. Per"; CalcBase: Enum "Inventory Value Calc. Base"; NextDocNo: Code[20]; AverageUnitCostLCY: Decimal; RemQty: Decimal; NextLineNo: Integer; NextLineNo2: Integer; ByLocation: Boolean; ByVariant: Boolean; UpdStdCost: Boolean; ShowDialog: Boolean; ByLocationEnable: Boolean; ByVariantEnable: Boolean; CalcBaseEnable: Boolean; UpdStdCostEnable: Boolean; DuplWarningQst: Label 'Duplicate Revaluation Journals will be generated.\Do you want to continue?'; HideDuplWarning: Boolean;#pragma warning disable AA0074 Text003: Label 'You must enter a document number.';#pragma warning disable AA0470 Text010: Label 'Processing items #1##########'; Text011: Label 'You cannot revalue by Calculate Per Item for item %1 using posting date %2. You can only use the posting date %3 for this period.';#pragma warning restore AA0470#pragma warning restore AA0074 protected var ByLocation2: Boolean; ByVariant2: Boolean; PostingDate: Date; local procedure IncludeEntryInCalc(ItemLedgerEntry: Record "Item Ledger Entry"; PostingDate: Date; IncludeExpectedCost: Boolean) Result: Boolean var IsHandled: Boolean; begin IsHandled := false; OnBeforeIncludeEntryInCalc(ItemLedgerEntry, PostingDate, IncludeExpectedCost, Result, IsHandled); if IsHandled then exit(Result); if IncludeExpectedCost then exit(ItemLedgerEntry."Posting Date" in [0D .. PostingDate]); exit(ItemLedgerEntry."Completely Invoiced" and (ItemLedgerEntry."Last Invoice Date" in [0D .. PostingDate])); end; procedure SetItemJnlLine(var NewItemJnlLine: Record "Item Journal Line") begin ItemJnlLine := NewItemJnlLine; end; local procedure ValidatePostingDate() var NoSeries: Codeunit "No. Series"; begin ItemJnlBatch.Get(ItemJnlLine."Journal Template Name", ItemJnlLine."Journal Batch Name"); if ItemJnlBatch."No. Series" = '' then NextDocNo := '' else NextDocNo := NoSeries.PeekNextNo(ItemJnlBatch."No. Series", PostingDate); end; local procedure ValidateCalcLevel() begin PageValidateCalcLevel(); exit; end; local procedure InsertValJnlBuffer(ItemNo2: Code[20]; VariantCode2: Code[10]; LocationCode2: Code[10]; Quantity2: Decimal; Amount2: Decimal) begin TempValJnlBuffer.Reset(); TempValJnlBuffer.SetCurrentKey("Item No.", "Location Code", "Variant Code"); TempValJnlBuffer.SetRange("Item No.", ItemNo2); TempValJnlBuffer.SetRange("Location Code", LocationCode2); TempValJnlBuffer.SetRange("Variant Code", VariantCode2); if TempValJnlBuffer.FindFirst() then begin TempValJnlBuffer.Quantity := TempValJnlBuffer.Quantity + Quantity2; TempValJnlBuffer."Inventory Value (Calculated)" := TempValJnlBuffer."Inventory Value (Calculated)" + Amount2; TempValJnlBuffer.Modify(); end else if Quantity2 <> 0 then begin NextLineNo2 := NextLineNo2 + 10000; TempValJnlBuffer.Init(); TempValJnlBuffer."Line No." := NextLineNo2; TempValJnlBuffer."Item No." := ItemNo2; TempValJnlBuffer."Variant Code" := VariantCode2; TempValJnlBuffer."Location Code" := LocationCode2; TempValJnlBuffer.Quantity := Quantity2; TempValJnlBuffer."Inventory Value (Calculated)" := Amount2; TempValJnlBuffer.Insert(); end; end; local procedure CalcAverageUnitCost(BufferQty: Decimal; var InvtValueCalc: Decimal; var AppliedAmount: Decimal) var ValueEntry: Record "Value Entry"; AverageQty: Decimal; AverageCost: Decimal; NotComplInvQty: Decimal; NotComplInvValue: Decimal; IsHandled: Boolean; begin ValueEntry."Item No." := Item."No."; ValueEntry."Valuation Date" := PostingDate; if TempValJnlBuffer.GetFilter("Location Code") <> '' then ValueEntry."Location Code" := TempValJnlBuffer.GetRangeMin("Location Code"); if TempValJnlBuffer.GetFilter("Variant Code") <> '' then ValueEntry."Variant Code" := TempValJnlBuffer.GetRangeMin("Variant Code"); ValueEntry.SumCostsTillValuationDate(ValueEntry); AverageQty := ValueEntry."Invoiced Quantity"; AverageCost := ValueEntry."Cost Amount (Actual)"; CalcNotComplInvcdTransfer(NotComplInvQty, NotComplInvValue); AverageQty -= NotComplInvQty; AverageCost -= NotComplInvValue; ValueEntry.Reset(); ValueEntry.SetRange("Item No.", Item."No."); ValueEntry.SetRange("Valuation Date", 0D, PostingDate); ValueEntry.SetFilter("Location Code", TempValJnlBuffer.GetFilter("Location Code")); ValueEntry.SetFilter("Variant Code", TempValJnlBuffer.GetFilter("Variant Code")); ValueEntry.SetRange(Inventoriable, true); ValueEntry.SetRange("Item Charge No.", ''); ValueEntry.SetFilter("Posting Date", '>%1', PostingDate); ValueEntry.SetFilter("Entry Type", '<>%1', ValueEntry."Entry Type"::Revaluation); ValueEntry.CalcSums("Invoiced Quantity", "Cost Amount (Actual)"); AverageQty -= ValueEntry."Invoiced Quantity"; AverageCost -= ValueEntry."Cost Amount (Actual)"; if AverageQty <> 0 then begin AverageUnitCostLCY := AverageCost / AverageQty; IsHandled := false; OnCalcAverageUnitCostOnBeforeCheckNegCost(Item, AverageUnitCostLCY, IsHandled); if not IsHandled then if AverageUnitCostLCY < 0 then AverageUnitCostLCY := 0; end else AverageUnitCostLCY := 0; AppliedAmount := InvtValueCalc; InvtValueCalc := BufferQty * AverageUnitCostLCY; end; local procedure CalcNotComplInvcdTransfer(var NotComplInvQty: Decimal; var NotComplInvValue: Decimal) var ItemLedgerEntry: Record "Item Ledger Entry"; RemQty: Decimal; RemInvValue: Decimal; i: Integer; begin for i := 1 to 2 do begin ItemLedgerEntry.SetCurrentKey("Item No.", Positive, "Location Code", "Variant Code"); ItemLedgerEntry.SetRange("Item No.", Item."No."); ItemLedgerEntry.SetRange(Positive, i = 1); ItemLedgerEntry.SetFilter("Location Code", TempValJnlBuffer.GetFilter("Location Code")); ItemLedgerEntry.SetFilter("Variant Code", TempValJnlBuffer.GetFilter("Variant Code")); if ItemLedgerEntry.FindSet() then repeat if (ItemLedgerEntry.Quantity = ItemLedgerEntry."Invoiced Quantity") and not ItemLedgerEntry."Completely Invoiced" and (ItemLedgerEntry."Last Invoice Date" in [0D .. PostingDate]) and (ItemLedgerEntry."Invoiced Quantity" <> 0) then begin RemQty := ItemLedgerEntry.Quantity; RemInvValue := ItemLedgerEntry.CalculateRemInventoryValue(ItemLedgerEntry."Entry No.", ItemLedgerEntry.Quantity, ItemLedgerEntry.Quantity, false, 0D, PostingDate); NotComplInvQty := NotComplInvQty + RemQty; NotComplInvValue := NotComplInvValue + RemInvValue; end; until ItemLedgerEntry.Next() = 0; end; end; local procedure InsertItemJnlLine(EntryType2: Enum "Item Ledger Entry Type"; ItemNo2: Code[20]; VariantCode2: Code[10]; LocationCode2: Code[10]; Quantity2: Decimal; Amount2: Decimal; ApplyToEntry2: Integer; AppliedAmount: Decimal; DimensionSetID: Integer) var Item: Record Item; StockkeepingUnit: Record "Stockkeeping Unit"; begin if Quantity2 = 0 then exit; if not HideDuplWarning then if ItemJnlLineExists(ItemJnlLine, ItemNo2, VariantCode2, LocationCode2, ApplyToEntry2) then if Confirm(DuplWarningQst) then HideDuplWarning := true else Error(''); InitItemJnlLine(ItemJnlLine, EntryType2, ItemNo2, VariantCode2, LocationCode2); ItemJnlLine.Validate("Unit Amount", 0); if ApplyToEntry2 <> 0 then ItemJnlLine."Inventory Value Per" := ItemJnlLine."Inventory Value Per"::" " else if ByLocation2 and ByVariant2 then ItemJnlLine."Inventory Value Per" := ItemJnlLine."Inventory Value Per"::"Location and Variant" else if ByLocation2 then ItemJnlLine."Inventory Value Per" := ItemJnlLine."Inventory Value Per"::Location else if ByVariant2 then ItemJnlLine."Inventory Value Per" := ItemJnlLine."Inventory Value Per"::Variant else ItemJnlLine."Inventory Value Per" := ItemJnlLine."Inventory Value Per"::Item; if CalculatePer = CalculatePer::"Item Ledger Entry" then begin ItemJnlLine."Applies-to Entry" := ApplyToEntry2; ItemJnlLine.CopyDim(DimensionSetID); end; ItemJnlLine.Validate(Quantity, Quantity2); ItemJnlLine.Validate("Inventory Value (Calculated)", Round(Amount2, GLSetup."Amount Rounding Precision")); case CalcBase of CalcBase::" ": ItemJnlLine.Validate("Inventory Value (Revalued)", ItemJnlLine."Inventory Value (Calculated)"); CalcBase::"Last Direct Unit Cost": if StockkeepingUnit.Get(ItemJnlLine."Location Code", ItemJnlLine."Item No.", ItemJnlLine."Variant Code") then ItemJnlLine.Validate("Unit Cost (Revalued)", StockkeepingUnit."Last Direct Cost") else begin Item.Get(ItemJnlLine."Item No."); ItemJnlLine.Validate("Unit Cost (Revalued)", Item."Last Direct Cost"); end; CalcBase::"Standard Cost - Assembly List", CalcBase::"Standard Cost - Manufacturing": if TempNewStdCostItem.Get(ItemNo2) then begin ItemJnlLine.Validate("Unit Cost (Revalued)", TempNewStdCostItem."Standard Cost"); ItemJnlLine."Single-Level Material Cost" := TempNewStdCostItem."Single-Level Material Cost"; ItemJnlLine."Single-Level Capacity Cost" := TempNewStdCostItem."Single-Level Capacity Cost"; ItemJnlLine."Single-Level Subcontrd. Cost" := TempNewStdCostItem."Single-Level Subcontrd. Cost"; ItemJnlLine."Single-Level Cap. Ovhd Cost" := TempNewStdCostItem."Single-Level Cap. Ovhd Cost"; ItemJnlLine."Single-Level Mfg. Ovhd Cost" := TempNewStdCostItem."Single-Level Mfg. Ovhd Cost"; ItemJnlLine."Rolled-up Material Cost" := TempNewStdCostItem."Rolled-up Material Cost"; ItemJnlLine."Rolled-up Capacity Cost" := TempNewStdCostItem."Rolled-up Capacity Cost"; ItemJnlLine."Rolled-up Subcontracted Cost" := TempNewStdCostItem."Rolled-up Subcontracted Cost"; ItemJnlLine."Rolled-up Mfg. Ovhd Cost" := TempNewStdCostItem."Rolled-up Mfg. Ovhd Cost"; ItemJnlLine."Rolled-up Cap. Overhead Cost" := TempNewStdCostItem."Rolled-up Cap. Overhead Cost"; OnInsertItemJnlLineOnCaseCalcBaseOnStandardCostAssemblyOrManufacturing(ItemJnlLine, TempNewStdCostItem); TempUpdatedStdCostSKU."Item No." := ItemNo2; TempUpdatedStdCostSKU."Location Code" := LocationCode2; TempUpdatedStdCostSKU."Variant Code" := VariantCode2; if TempUpdatedStdCostSKU.Insert() then; end else ItemJnlLine.Validate("Inventory Value (Revalued)", ItemJnlLine."Inventory Value (Calculated)"); else OnInsertItemJnlLineOnCaseCalcBaseOnElse(ItemJnlLine, EntryType2, ItemNo2, VariantCode2, LocationCode2, Quantity2, Amount2, ApplyToEntry2, AppliedAmount, CalcBase, ByLocation2, ByVariant2, PostingDate); end; ItemJnlLine."Update Standard Cost" := UpdStdCost; ItemJnlLine."Partial Revaluation" := true; ItemJnlLine."Applied Amount" := AppliedAmount; ItemJnlLine.Insert(); OnAfterInsertItemJnlLine(ItemJnlLine, EntryType2, ItemNo2, VariantCode2, LocationCode2, Quantity2, Amount2, ApplyToEntry2, AppliedAmount, CalcBase); end; local procedure InitItemJnlLine(var ItemJournalLine: Record "Item Journal Line"; EntryType2: Enum "Item Ledger Entry Type"; ItemNo2: Code[20]; VariantCode2: Code[10]; LocationCode2: Code[10]) begin if NextLineNo = 0 then begin ItemJournalLine.LockTable(); ItemJournalLine.SetRange("Journal Template Name", ItemJournalLine."Journal Template Name"); ItemJournalLine.SetRange("Journal Batch Name", ItemJournalLine."Journal Batch Name"); if ItemJournalLine.FindLast() then NextLineNo := ItemJournalLine."Line No."; end; NextLineNo := NextLineNo + 10000; ItemJournalLine.Init(); ItemJournalLine."Line No." := NextLineNo; ItemJournalLine."Value Entry Type" := ItemJournalLine."Value Entry Type"::Revaluation; OnInitItemJnlLineOnBeforeValidateFields(ItemJournalLine); ItemJournalLine.Validate("Posting Date", PostingDate); ItemJournalLine.Validate("Entry Type", EntryType2); ItemJournalLine.Validate("Document No.", NextDocNo); ItemJournalLine.Validate("Item No.", ItemNo2); ItemJournalLine."Reason Code" := ItemJnlBatch."Reason Code"; ItemJournalLine."Variant Code" := VariantCode2; ItemJournalLine.Validate("Location Code", LocationCode2); ItemJournalLine."Source Code" := SourceCodeSetup."Revaluation Journal"; OnAfterInitItemJnlLine(ItemJournalLine, ItemJnlBatch); end; procedure SetParameters(NewPostingDate: Date; NewDocNo: Code[20]; NewHideDuplWarning: Boolean; NewCalculatePer: Enum "Inventory Value Calc. Per"; NewByLocation: Boolean; NewByVariant: Boolean; NewUpdStdCost: Boolean; NewCalcBase: Enum "Inventory Value Calc. Base"; NewShowDialog: Boolean) begin PostingDate := NewPostingDate; NextDocNo := NewDocNo; CalculatePer := NewCalculatePer; ByLocation := NewByLocation; ByVariant := NewByVariant; UpdStdCost := NewUpdStdCost; CalcBase := NewCalcBase; ShowDialog := NewShowDialog; HideDuplWarning := NewHideDuplWarning; end; local procedure PageValidateCalcLevel() begin UpdStdCostEnable := true; if CalculatePer = CalculatePer::"Item Ledger Entry" then begin ByLocation := false; ByVariant := false; CalcBase := CalcBase::" "; UpdStdCost := false; UpdStdCostEnable := false; end; end; local procedure ItemLedgerEntryCalculatePerOnV() begin ValidateCalcLevel(); end; local procedure ItemCalculatePerOnValidate() begin ValidateCalcLevel(); end; local procedure ItemJnlLineExists(ItemJournalLine: Record "Item Journal Line"; ItemNo: Code[20]; VariantCode: Code[10]; LocationCode: Code[10]; ApplyToEntry: Integer): Boolean begin ItemJournalLine.SetRange("Journal Template Name", ItemJournalLine."Journal Template Name"); ItemJournalLine.SetRange("Journal Batch Name", ItemJournalLine."Journal Batch Name"); ItemJournalLine.SetRange("Item No.", ItemNo); ItemJournalLine.SetRange("Variant Code", VariantCode); ItemJournalLine.SetRange("Location Code", LocationCode); ItemJournalLine.SetRange("Applies-to Entry", ApplyToEntry); exit(not ItemJournalLine.IsEmpty()); end; local procedure CalcRemainingCost(ItemLedgerEntry: Record "Item Ledger Entry"; RemainingQty: Decimal; IncludeExpCost: Boolean): Decimal var UntilValuationDate: Date; UntilPostingDate: Date; begin if ItemLedgerEntry."Entry Type" in [ItemLedgerEntry."Entry Type"::Output, ItemLedgerEntry."Entry Type"::"Assembly Output"] then UntilPostingDate := PostingDate else UntilValuationDate := PostingDate; case CalculatePer of CalculatePer::"Item Ledger Entry": exit( ItemLedgerEntry.CalculateRemInventoryValue( ItemLedgerEntry."Entry No.", ItemLedgerEntry.Quantity, RemainingQty, false, UntilValuationDate, UntilPostingDate)); CalculatePer::Item: exit( ItemLedgerEntry.CalculateRemInventoryValue( ItemLedgerEntry."Entry No.", ItemLedgerEntry.Quantity, RemainingQty, IncludeExpCost and not ItemLedgerEntry."Completely Invoiced", UntilValuationDate, UntilPostingDate)); end; exit(0); end; local procedure Calculate(Item: Record Item; VariantCode: Code[10]; LocationCode: Code[10]) var AppliedAmount: Decimal; begin TempValJnlBuffer.CalcSums(Quantity, "Inventory Value (Calculated)"); if TempValJnlBuffer.Quantity <> 0 then begin AppliedAmount := 0; if Item."Costing Method" = Item."Costing Method"::Average then CalcAverageUnitCost( TempValJnlBuffer.Quantity, TempValJnlBuffer."Inventory Value (Calculated)", AppliedAmount); InsertItemJnlLine( ItemJnlLine."Entry Type"::"Positive Adjmt.", Item."No.", VariantCode, LocationCode, TempValJnlBuffer.Quantity, TempValJnlBuffer."Inventory Value (Calculated)", 0, AppliedAmount, 0); end; end; [IntegrationEvent(false, false)] local procedure OnAfterInitItemJnlLine(var ItemJournalLine: Record "Item Journal Line"; ItemJnlBatch: Record "Item Journal Batch") begin end; [IntegrationEvent(false, false)] local procedure OnAfterInsertItemJnlLine(var ItemJournalLine: Record "Item Journal Line"; EntryType2: Enum "Item Ledger Entry Type"; ItemNo2: Code[20]; VariantCode2: Code[10]; LocationCode2: Code[10]; Quantity2: Decimal; Amount2: Decimal; ApplyToEntry2: Integer; AppliedAmount: Decimal; CalcBase: Enum "Inventory Value Calc. Base") begin end; [IntegrationEvent(false, false)] local procedure OnAfterOnPreDataItem(var Item: Record Item; CalcBase: Enum "Inventory Value Calc. Base"; PostingDate: Date; var TempNewStdCostItem: Record Item temporary) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeOnAfterGetRecord(var Item: Record Item; var SkipItem: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforePreReport() begin end; [IntegrationEvent(false, false)] local procedure OnInitItemJnlLineOnBeforeValidateFields(var ItemJournalLine: Record "Item Journal Line") begin end; [IntegrationEvent(false, false)] local procedure OnItemAfterGetRecordOnAfterItemLedgEntrySetFilters(var ItemLedgerEntry: Record "Item Ledger Entry"; var Item: Record Item) begin end; [IntegrationEvent(false, false)] local procedure OnInsertItemJnlLineOnCaseCalcBaseOnElse(var ItemJournalLine: Record "Item Journal Line"; EntryType2: Enum "Item Ledger Entry Type"; ItemNo2: Code[20]; VariantCode2: Code[10]; LocationCode2: Code[10]; Quantity2: Decimal; Amount2: Decimal; ApplyToEntry2: Integer; AppliedAmount: Decimal; CalcBase: Enum "Inventory Value Calc. Base"; ByLocation2: Boolean; ByVariant2: Boolean; PostingDate: Date) begin end; [IntegrationEvent(false, false)] local procedure OnAfterGetRecordItemOnBeforInsertItemJnlLine(ItemLedgerEntry: Record "Item Ledger Entry"; var ItemJournalLine: Record "Item Journal Line") begin end; [IntegrationEvent(false, false)] local procedure OnPostDataItemForItemOnBeforeValidateStandardCost(var TempNewStdCostItem: Record Item temporary; var StockkeepingUnit: Record "Stockkeeping Unit"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnInsertItemJnlLineOnCaseCalcBaseOnStandardCostAssemblyOrManufacturing(var ItemJournalLine: Record "Item Journal Line"; var TempNewStdCostItem: Record Item temporary) begin end; [IntegrationEvent(false, false)] local procedure OnCalcAverageUnitCostOnBeforeCheckNegCost(var Item: Record Item; var AverageUnitCostLCY: Decimal; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeIncludeEntryInCalc(var ItemLedgerEntry: Record "Item Ledger Entry"; var PostingDate: Date; var IncludeExpectedCost: Boolean; var Result: Boolean; var IsHandled: Boolean) begin end;}