Codeunit 5811 Change Exp. Cost Post. to G/L

Base Application, Microsoft.Inventory.Costing

src/Layers/W1/BaseApp/Inventory/Costing/ChangeExpCostPosttoGL.Codeunit.al172 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;using Microsoft.Inventory.Setup;using System.Globalization;codeunit 5811 "Change Exp. Cost Post. to G/L"{    Permissions = TableData "Value Entry" = rm,                  TableData "Avg. Cost Adjmt. Entry Point" = id,                  TableData "Post Value Entry to G/L" = id;    TableNo = "Inventory Setup";    trigger OnRun()    begin    end;    var        ExpCostEnableTxt: Label 'If you enable the %1, the program must update table %2.', Comment = '%1 - Expected Cost Posting to G/L; %2 - Post Value Entry to G/L';        ExpCostDisableTxt: Label 'If you disable the %1, the program must update table %2.', Comment = '%1 - Expected Cost Posting to G/L; %2 - Post Value Entry to G/L';        TakeHoursTxt: Label 'This can take several hours.\';        ConfirmChangeTxt: Label 'Do you really want to change the %1?', Comment = '%1 - Expected Cost Posting to G/L';#pragma warning disable AA0074        Text003: Label 'The change has been cancelled.';        Text004: Label 'Processing entries...\\';#pragma warning disable AA0470        Text005: Label 'Item No. #1########## @2@@@@@@@@@@@@@';        Text007: Label '%1 has been changed to %2. You should now run %3.';        Text008: Label 'Deleting %1 entries...';#pragma warning restore AA0470#pragma warning restore AA0074        DisableWarningTxt: Label 'This will not change amounts on the interim accounts and the eventual clean-up in the G/L must be done manually.\';        Window: Dialog;        EntriesModified: Boolean;    procedure ChangeExpCostPostingToGL(var InventorySetup: Record "Inventory Setup"; ExpCostPostingToGL: Boolean)    var        PostValueEntryToGL: Record "Post Value Entry to G/L";        ConfirmMessage: Text;    begin        if ExpCostPostingToGL then            ConfirmMessage := ExpCostEnableTxt + TakeHoursTxt + ConfirmChangeTxt        else            ConfirmMessage := ExpCostDisableTxt + TakeHoursTxt + DisableWarningTxt + ConfirmChangeTxt;        if not           Confirm(             StrSubstNo(                ConfirmMessage, InventorySetup.FieldCaption("Expected Cost Posting to G/L"), PostValueEntryToGL.TableCaption()), false)        then            Error(Text003);        if ExpCostPostingToGL then            EnableExpCostPostingToGL()        else            DisableExpCostPostingToGL();        UpdateInvtSetup(InventorySetup, ExpCostPostingToGL)    end;    local procedure EnableExpCostPostingToGL()    var        ItemLedgEntry: Record "Item Ledger Entry";        ValueEntry: Record "Value Entry";        PostValueEntryToGL: Record "Post Value Entry to G/L";        OldItemNo: Code[20];        LastUpdateDateTime: DateTime;        RecordNo: Integer;        NoOfRecords: Integer;    begin        Window.Open(          Text004 +          Text005);        ValueEntry.LockTable();        LastUpdateDateTime := CurrentDateTime;        if PostValueEntryToGL.FindSet() then            repeat                ValueEntry.Get(PostValueEntryToGL."Value Entry No.");                UpdatePostValueEntryToGL(ValueEntry."Item Ledger Entry No.");            until PostValueEntryToGL.Next() = 0;        ItemLedgEntry.SetCurrentKey("Item No.", "Entry Type");        ItemLedgEntry.SetFilter("Entry Type", '%1|%2|%3', ItemLedgEntry."Entry Type"::Sale, ItemLedgEntry."Entry Type"::Purchase, ItemLedgEntry."Entry Type"::Output);        NoOfRecords := ItemLedgEntry.Count;        OldItemNo := '';        if ItemLedgEntry.Find('-') then            repeat                RecordNo := RecordNo + 1;                if ItemLedgEntry."Item No." <> OldItemNo then begin                    Window.Update(1, ItemLedgEntry."Item No.");                    OldItemNo := ItemLedgEntry."Item No.";                end;                if CurrentDateTime - LastUpdateDateTime >= 1000 then begin                    Window.Update(2, Round(RecordNo / NoOfRecords * 10000, 1));                    LastUpdateDateTime := CurrentDateTime;                end;                if (ItemLedgEntry.Quantity <> ItemLedgEntry."Invoiced Quantity") and (ItemLedgEntry.Quantity <> 0) then                    UpdatePostValueEntryToGL(ItemLedgEntry."Entry No.");            until ItemLedgEntry.Next() = 0;        Window.Close();    end;    local procedure UpdatePostValueEntryToGL(ItemLedgEntryNo: Integer)    var        PostValueEntryToGL: Record "Post Value Entry to G/L";        ValueEntry: Record "Value Entry";    begin        ValueEntry.SetCurrentKey("Item Ledger Entry No.");        ValueEntry.SetRange("Item Ledger Entry No.", ItemLedgEntryNo);        if ValueEntry.Find('-') then            repeat                if not EntriesModified then                    EntriesModified := true;                if not PostValueEntryToGL.Get(ValueEntry."Entry No.") and                   ((ValueEntry."Cost Amount (Expected)" <> ValueEntry."Expected Cost Posted to G/L") or                    (ValueEntry."Cost Amount (Expected) (ACY)" <> ValueEntry."Exp. Cost Posted to G/L (ACY)"))                then begin                    PostValueEntryToGL."Value Entry No." := ValueEntry."Entry No.";                    PostValueEntryToGL."Item No." := ValueEntry."Item No.";                    PostValueEntryToGL."Posting Date" := ValueEntry."Posting Date";                    OnBeforePostValueEntryToGLInsert(PostValueEntryToGL, ValueEntry);                    PostValueEntryToGL.Insert();                end;            until ValueEntry.Next() = 0;    end;    local procedure DisableExpCostPostingToGL()    var        PostValueEntryToGL: Record "Post Value Entry to G/L";        ValueEntry: Record "Value Entry";    begin        Window.Open(StrSubstNo(Text008, PostValueEntryToGL.TableCaption));        if PostValueEntryToGL.FindSet(true) then            repeat                ValueEntry.Get(PostValueEntryToGL."Value Entry No.");                if ValueEntry."Expected Cost" then                    PostValueEntryToGL.Delete();            until PostValueEntryToGL.Next() = 0;        Window.Close();    end;    local procedure UpdateInvtSetup(var InvtSetup: Record "Inventory Setup"; ExpCostPostingToGL: Boolean)    var        ObjTransl: Record "Object Translation";    begin        InvtSetup."Expected Cost Posting to G/L" := ExpCostPostingToGL;        InvtSetup.Modify();        if EntriesModified then            Message(              Text007, InvtSetup.FieldCaption("Expected Cost Posting to G/L"), InvtSetup."Expected Cost Posting to G/L",              ObjTransl.TranslateObject(ObjTransl."Object Type"::Report, REPORT::"Post Inventory Cost to G/L"));    end;    [IntegrationEvent(false, false)]    local procedure OnBeforePostValueEntryToGLInsert(var PostValueEntryToGL: Record "Post Value Entry to G/L"; ValueEntry: Record "Value Entry")    begin    end;}