Codeunit 5899 Calc. Inventory Value-Check

Base Application, Microsoft.Inventory.Journal

src/Layers/W1/BaseApp/Inventory/Journal/CalcInventoryValueCheck.Codeunit.al257 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.Inventory.Costing;using Microsoft.Inventory.Item;using Microsoft.Inventory.Ledger;using Microsoft.Inventory.Setup;using Microsoft.Utilities;codeunit 5899 "Calc. Inventory Value-Check"{    Permissions = TableData "Avg. Cost Adjmt. Entry Point" = r;    trigger OnRun()    begin    end;    var        InvtSetup: Record "Inventory Setup";        TempErrorBuf: Record "Error Buffer" temporary;        PostingDate: Date;        CalculatePer: Enum "Inventory Value Calc. Per";        ByLocation: Boolean;        ByVariant: Boolean;        ShowDialog: Boolean;        TestMode: Boolean;        ErrorCounter: Integer;#pragma warning disable AA0074#pragma warning disable AA0470        Text004: Label 'Checking items #1##########';        Text007: Label 'You have to run the Adjust Cost - Item Entries batch job, before you can revalue item %1.';        Text009: Label 'You must not revalue items with Costing Method %1, if Calculate Per is Item Ledger Entry.';        Text011: Label 'You must not enter a %1 if you revalue items with Costing Method %2 and if Average Cost Calc. Type is %3 in Inventory Setup.';        Text012: Label 'The By Location field must not be filled in if you revalue items with Costing Method %1 and if Average Cost Calc. Type is %2 in Inventory Setup.';        Text014: Label 'The By Variant field must not be filled in if you revalue items with Costing Method %1 and if Average Cost Calc. Type is %2 in Inventory Setup.';        Text015: Label 'You must fill in a Location filter and a Variant filter or select the By Location field and the By Variant field, if you revalue items with Costing Method %1, and if Average Cost Calc. Type is %2 in Inventory Setup.';        Text018: Label 'The Item %1 cannot be revalued because there is at least one open outbound item ledger entry.';        Text020: Label 'Open Outbound Entry %1 found.';#pragma warning restore AA0470#pragma warning restore AA0074    procedure SetParameters(NewPostingDate: Date; NewCalculatePer: Enum "Inventory Value Calc. Per"; NewByLocation: Boolean; NewByVariant: Boolean; NewShowDialog: Boolean; NewTestMode: Boolean)    begin        TempErrorBuf.DeleteAll();        ClearAll();        PostingDate := NewPostingDate;        CalculatePer := NewCalculatePer;        ByLocation := NewByLocation;        ByVariant := NewByVariant;        ShowDialog := NewShowDialog;        TestMode := NewTestMode;        InvtSetup.Get();    end;    procedure RunCheck(var Item: Record Item; var NewErrorBuf: Record "Error Buffer")    var        Item2: Record Item;        Window: Dialog;        IsHandled: Boolean;    begin        Item2.Copy(Item);        CheckCalculatePer(Item2);        if Item2.FindSet() then begin            if ShowDialog then                Window.Open(Text004, Item2."No.");            repeat                if ShowDialog then                    Window.Update(1, Item2."No.");                IsHandled := false;                OnBeforeFindOpenOutboundEntry(Item2, PostingDate, TestMode, TempErrorBuf, ErrorCounter, IsHandled);                if not IsHandled then begin                    if FindOpenOutboundEntry(Item2) then                        if not TestMode then                            Error(Text018, Item2."No.");                    if not CheckAdjusted(Item2) then                        AddError(                          StrSubstNo(Text007, Item2."No."), DATABASE::Item, Item2."No.", 0);                end;            until Item2.Next() = 0;            if ShowDialog then                Window.Close();        end;        TempErrorBuf.Reset();        if TempErrorBuf.FindSet() then            repeat                NewErrorBuf := TempErrorBuf;                NewErrorBuf.Insert();            until TempErrorBuf.Next() = 0;    end;    local procedure CheckAdjusted(Item: Record Item): Boolean    var        AvgCostEntryPointHandler: Codeunit "Avg. Cost Entry Point Handler";        IsAdjusted: Boolean;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCheckAdjusted(Item, IsAdjusted, IsHandled);        if IsHandled then            exit(IsAdjusted);        if Item."Costing Method" = Item."Costing Method"::Average then            exit(AvgCostEntryPointHandler.IsEntriesAdjusted(Item."No.", PostingDate));        exit(true);    end;    local procedure CheckCalculatePer(var Item: Record Item)    var        Item2: Record Item;    begin        Item2.CopyFilters(Item);        Item2.FilterGroup(2);        Item2.SetRange("Costing Method", Item2."Costing Method"::Average);        Item2.FilterGroup(0);        OnCheckCalculatePerOnAfterSetFilters(Item2, Item, PostingDate);        if Item2.FindFirst() then            case CalculatePer of                CalculatePer::"Item Ledger Entry":                    AddError(                      StrSubstNo(Text009, Item2."Costing Method"), DATABASE::Item, Item2."No.", 0);                CalculatePer::Item:                    if InvtSetup."Average Cost Calc. Type" = InvtSetup."Average Cost Calc. Type"::Item then begin                        if Item2.GetFilter("Location Filter") <> '' then                            AddError(                                StrSubstNo(                                Text011,                                Item2.FieldCaption("Location Filter"), Item2."Costing Method", InvtSetup."Average Cost Calc. Type"), DATABASE::Item, Item2."No.", 0);                        if Item2.GetFilter("Variant Filter") <> '' then                            AddError(                                StrSubstNo(                                Text011,                                Item2.FieldCaption("Variant Filter"), Item2."Costing Method", InvtSetup."Average Cost Calc. Type"), DATABASE::Item, Item2."No.", 0);                        if ByLocation then                            AddError(                                StrSubstNo(                                Text012,                                Item2."Costing Method", InvtSetup."Average Cost Calc. Type"), DATABASE::Item, Item2."No.", 0);                        if ByVariant then                            AddError(                                StrSubstNo(                                Text014,                                Item2."Costing Method", InvtSetup."Average Cost Calc. Type"), DATABASE::Item, Item2."No.", 0);                    end else                        CheckItemLocationVariantFilters(Item2);            end;        OnAfterCheckCalculatePer(Item);    end;    local procedure FindOpenOutboundEntry(var Item: Record Item) Result: Boolean    var        ItemLedgEntry: Record "Item Ledger Entry";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeFindOpenOutboundEntry2(Item, Result, IsHandled);        if IsHandled then            exit(Result);        ItemLedgEntry.Reset();        ItemLedgEntry.SetCurrentKey("Item No.", Open, "Variant Code", Positive, "Location Code", "Posting Date", "Entry No.");        ItemLedgEntry.SetRange("Item No.", Item."No.");        ItemLedgEntry.SetRange(Open, true);        ItemLedgEntry.SetRange(Positive, false);        ItemLedgEntry.SetRange("Posting Date", 0D, PostingDate);        Item.CopyFilter("Variant Filter", ItemLedgEntry."Variant Code");        Item.CopyFilter("Location Filter", ItemLedgEntry."Location Code");        if ItemLedgEntry.FindSet() then begin            repeat                AddError(                  StrSubstNo(Text020, ItemLedgEntry."Entry No."),                  DATABASE::"Item Ledger Entry", ItemLedgEntry."Item No.", ItemLedgEntry."Entry No.");            until ItemLedgEntry.Next() = 0;            exit(true);        end;        exit(false);    end;    local procedure AddError(Text: Text; SourceTable: Integer; SourceNo: Code[20]; SourceRefNo: Integer)    begin        if TestMode then begin            ErrorCounter := ErrorCounter + 1;            TempErrorBuf.Init();            TempErrorBuf."Error No." := ErrorCounter;            TempErrorBuf."Error Text" := CopyStr(Text, 1, MaxStrLen(TempErrorBuf."Error Text"));            TempErrorBuf."Source Table" := SourceTable;            TempErrorBuf."Source No." := SourceNo;            TempErrorBuf."Source Ref. No." := SourceRefNo;            TempErrorBuf.Insert();        end else            Error(Text);    end;    local procedure CheckItemLocationVariantFilters(var Item: Record Item)    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCheckItemLocationVariantFilters(Item, TempErrorBuf, ErrorCounter, TestMode, ByLocation, ByVariant, IsHandled);        if IsHandled then            exit;        if ((Item.GetFilter("Location Filter") = '') and (not ByLocation)) or           ((Item.GetFilter("Variant Filter") = '') and (not ByVariant))        then            AddError(StrSubstNo(Text015, Item."Costing Method", InvtSetup."Average Cost Calc. Type"), DATABASE::Item, Item."No.", 0);    end;    [IntegrationEvent(false, false)]    local procedure OnAfterCheckCalculatePer(var Item: Record Item)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCheckAdjusted(Item: Record Item; var IsAdjusted: Boolean; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeFindOpenOutboundEntry(Item: Record Item; PostingDate: Date; TestMode: Boolean; var TempErrorBuffer: Record "Error Buffer" temporary; var ErrorCounter: Integer; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCheckCalculatePerOnAfterSetFilters(var Item2: Record Item; var Item: Record Item; PostingDate: Date)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCheckItemLocationVariantFilters(var Item: Record Item; var TempErrorBuf: Record "Error Buffer" temporary; var ErrorCounter: Integer; TestMode: Boolean; ByLocation: Boolean; ByVariant: Boolean; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeFindOpenOutboundEntry2(var Item: Record Item; var Result: Boolean; var IsHandled: Boolean)    begin    end;}