Report 5812 Revaluation Posting - Test

Base Application, Microsoft.Inventory.Reports

src/Layers/W1/BaseApp/Inventory/Reports/RevaluationPostingTest.Report.al430 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.Reports;using Microsoft.CRM.Team;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Foundation.NoSeries;using Microsoft.Inventory.Item;using Microsoft.Inventory.Journal;using Microsoft.Inventory.Setup;using System.Security.User;using System.Utilities;report 5812 "Revaluation Posting - Test"{    Caption = 'Revaluation Posting - Test';    DefaultRenderingLayout = RDLCLayout;    dataset    {        dataitem("Item Journal Batch"; "Item Journal Batch")        {            DataItemTableView = sorting("Journal Template Name", Name);            RequestFilterFields = "Journal Template Name", Name;            column(Item_Journal_Batch_Journal_Template_Name; "Journal Template Name")            {            }            column(Item_Journal_Batch_Name; Name)            {            }            dataitem("Item Journal Line"; "Item Journal Line")            {                DataItemLink = "Journal Template Name" = field("Journal Template Name"), "Journal Batch Name" = field(Name);                DataItemTableView = sorting("Journal Template Name", "Journal Batch Name", "Line No.");                RequestFilterFields = "Posting Date";                column(COMPANYNAME; COMPANYPROPERTY.DisplayName())                {                }                column(Item_Journal_Line__Journal_Template_Name_; "Journal Template Name")                {                }                column(Item_Journal_Line__Journal_Batch_Name_; "Journal Batch Name")                {                }                column(Item_Journal_Line__TABLECAPTION__________ItemJnlLineFilter; TableCaption + ': ' + ItemJnlLineFilter)                {                }                column(ItemJnlLineFilter; ItemJnlLineFilter)                {                }                column(Item_Journal_Line__Posting_Date_; Format("Posting Date"))                {                }                column(Item_Journal_Line__Item_No__; "Item No.")                {                }                column(Item_Journal_Line_Description; Description)                {                }                column(Item_Journal_Line_Quantity; Quantity)                {                }                column(Item_Journal_Line_Amount; Amount)                {                }                column(Item_Journal_Line__Unit_Cost__Calculated__; "Unit Cost (Calculated)")                {                }                column(Item_Journal_Line__Unit_Cost__Revalued__; "Unit Cost (Revalued)")                {                }                column(Item_Journal_Line__Inventory_Value__Calculated__; "Inventory Value (Calculated)")                {                }                column(Item_Journal_Line__Inventory_Value__Revalued__; "Inventory Value (Revalued)")                {                }                column(Item_Journal_Line_Amount_Control43; Amount)                {                }                column(Item_Journal_Line_Line_No_; "Line No.")                {                }                column(Revaluation_Posting___TestCaption; Revaluation_Posting___TestCaptionLbl)                {                }                column(CurrReport_PAGENOCaption; CurrReport_PAGENOCaptionLbl)                {                }                column(Item_Journal_Line__Journal_Template_Name_Caption; FieldCaption("Journal Template Name"))                {                }                column(Item_Journal_Line__Journal_Batch_Name_Caption; FieldCaption("Journal Batch Name"))                {                }                column(Item_Journal_Line__Posting_Date_Caption; Item_Journal_Line__Posting_Date_CaptionLbl)                {                }                column(Item_Journal_Line__Item_No__Caption; FieldCaption("Item No."))                {                }                column(Item_Journal_Line_DescriptionCaption; FieldCaption(Description))                {                }                column(Item_Journal_Line_QuantityCaption; FieldCaption(Quantity))                {                }                column(Item_Journal_Line_AmountCaption; FieldCaption(Amount))                {                }                column(Item_Journal_Line__Unit_Cost__Calculated__Caption; FieldCaption("Unit Cost (Calculated)"))                {                }                column(Item_Journal_Line__Unit_Cost__Revalued__Caption; FieldCaption("Unit Cost (Revalued)"))                {                }                column(Item_Journal_Line__Inventory_Value__Calculated__Caption; FieldCaption("Inventory Value (Calculated)"))                {                }                column(Item_Journal_Line__Inventory_Value__Revalued__Caption; FieldCaption("Inventory Value (Revalued)"))                {                }                column(Item_Journal_Line_Amount_Control43Caption; Item_Journal_Line_Amount_Control43CaptionLbl)                {                }                dataitem(DimensionLoop; "Integer")                {                    DataItemTableView = sorting(Number) where(Number = filter(1 ..));                    column(DimText; DimText)                    {                    }                    column(Number; Number)                    {                    }                    column(DimensionsCaption; DimensionsCaptionLbl)                    {                    }                    trigger OnAfterGetRecord()                    begin                        if Number = 1 then begin                            if not DimSetEntry.FindSet() then                                CurrReport.Break();                        end else                            if not Continue then                                CurrReport.Break();                        Clear(DimText);                        Continue := false;                        repeat                            OldDimText := DimText;                            if DimText = '' then                                DimText := StrSubstNo('%1 - %2', DimSetEntry."Dimension Code", DimSetEntry."Dimension Value Code")                            else                                DimText :=                                  StrSubstNo(                                    '%1; %2 - %3', DimText, DimSetEntry."Dimension Code", DimSetEntry."Dimension Value Code");                            if StrLen(DimText) > MaxStrLen(OldDimText) then begin                                DimText := OldDimText;                                Continue := true;                                exit;                            end;                        until DimSetEntry.Next() = 0;                    end;                    trigger OnPreDataItem()                    begin                        if not ShowDim then                            CurrReport.Break();                        DimSetEntry.SetRange("Dimension Set ID", "Item Journal Line"."Dimension Set ID");                    end;                }                dataitem(ErrorLoop; "Integer")                {                    DataItemTableView = sorting(Number);                    column(ErrorText_Number_; ErrorText[Number])                    {                    }                    column(ErrorText_Number_Caption; ErrorText_Number_CaptionLbl)                    {                    }                    trigger OnPostDataItem()                    begin                        ErrorCounter := 0;                    end;                    trigger OnPreDataItem()                    begin                        SetRange(Number, 1, ErrorCounter);                    end;                }                trigger OnAfterGetRecord()                var                    ItemVariant: Record "Item Variant";                    UserSetupManagement: Codeunit "User Setup Management";                    InvtPeriodEndDate: Date;                    TempErrorText: Text[250];                    ItemItemVariantLbl: Label '%1 %2', Comment = '%1 - Item No., %2 - Variant Code';                begin                    OnBeforeItemJournalLineOnAfterGetRecord("Item Journal Line", ErrorCounter, ErrorText);                    if ("Item No." = '') and (Quantity = 0) then                        exit;                    if "Item No." = '' then                        AddError(StrSubstNo(Text001, FieldCaption("Item No.")))                    else                        if not Item.Get("Item No.") then                            AddError(StrSubstNo(Text002, Item.TableCaption(), "Item No."))                        else begin                            if Item.Blocked then                                AddError(StrSubstNo(Text003, Item.FieldCaption(Blocked), false, Item.TableCaption(), "Item No."));                            if "Item Journal Line"."Variant Code" <> '' then begin                                ItemVariant.SetLoadFields(Blocked);                                if ItemVariant.Get("Item Journal Line"."Item No.", "Item Journal Line"."Variant Code") then begin                                    if ItemVariant.Blocked then                                        AddError(StrSubstNo(Text003, ItemVariant.FieldCaption(Blocked), false, ItemVariant.TableCaption(), StrSubstNo(ItemItemVariantLbl, "Item Journal Line"."Item No.", "Item Journal Line"."Variant Code")));                                end else                                    AddError(StrSubstNo(Text002, StrSubstNo(ItemItemVariantLbl, ItemVariant.TableCaption(), "Item Journal Line"."Item No."), "Item Journal Line"."Variant Code"));                            end;                        end;                    if "Posting Date" = 0D then                        AddError(StrSubstNo(Text001, FieldCaption("Posting Date")))                    else begin                        if "Posting Date" <> NormalDate("Posting Date") then                            AddError(StrSubstNo(Text004, FieldCaption("Posting Date")));                        if "Item Journal Batch"."No. Series" <> '' then                            if NoSeries."Date Order" and ("Posting Date" < LastPostingDate) then                                AddError(Text005);                        LastPostingDate := "Posting Date";                        if not UserSetupManagement.TestAllowedPostingDate("Posting Date", TempErrorText) then                            AddError(TempErrorText);                        InvtPeriodEndDate := "Posting Date";                        if not InvtPeriod.IsValidDate(InvtPeriodEndDate) then                            AddError(                              StrSubstNo(                                Text006, Format("Posting Date")))                    end;                    if "Document Date" <> 0D then                        if "Document Date" <> NormalDate("Document Date") then                            AddError(StrSubstNo(Text004, FieldCaption("Document Date")));                    if "Gen. Prod. Posting Group" = '' then                        AddError(StrSubstNo(Text001, FieldCaption("Gen. Prod. Posting Group")))                    else                        if not GenPostingSetup.Get("Gen. Bus. Posting Group", "Gen. Prod. Posting Group") then                            AddError(                              StrSubstNo(                                Text007, GenPostingSetup.TableCaption(),                                "Gen. Bus. Posting Group", "Gen. Prod. Posting Group"));                    if "Item Journal Batch"."No. Series" <> '' then begin                        if LastDocNo <> '' then                            if ("Document No." <> LastDocNo) and ("Document No." <> IncStr(LastDocNo)) then                                AddError(Text008);                        LastDocNo := "Document No.";                    end;                    if not DimMgt.CheckDimIDComb("Dimension Set ID") then                        AddError(DimMgt.GetDimCombErr());                    TableID[1] := DATABASE::Item;                    No[1] := "Item No.";                    TableID[2] := DATABASE::"Salesperson/Purchaser";                    No[2] := "Salespers./Purch. Code";                    CheckDimValuePosting("Item Journal Line");                    OnAfterItemJournalLineOnAfterGetRecord("Item Journal Line", ErrorCounter, ErrorText);                end;                trigger OnPreDataItem()                begin                    if ItemJnlTemplate.Recurring then                        AddError(StrSubstNo(Text000));                    if "Item Journal Batch"."No. Series" <> '' then                        NoSeries.Get("Item Journal Batch"."No. Series");                    LastPostingDate := 0D;                    LastDocNo := '';                end;            }            trigger OnAfterGetRecord()            begin                ItemJnlTemplate.Get("Journal Template Name");                if ItemJnlTemplate.Type <> ItemJnlTemplate.Type::Revaluation then                    CurrReport.Skip();            end;        }    }    requestpage    {        SaveValues = true;        AboutTitle = 'About Revaluation Posting - Test';        AboutText = 'The Revaluation Posting - Test report is used to simulate the revaluation of inventory items without actually posting the changes. This report helps you review the potential impact of revaluation on your inventory values before committing to the changes. It provides a detailed preview of the adjustments that would be made to the inventory valuation, allowing you to verify and ensure accuracy.';        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(ShowDim; ShowDim)                    {                        ApplicationArea = Dimensions;                        Caption = 'Show Dimensions';                        ToolTip = 'Specifies if you want if you want the report to show dimensions.';                    }                }            }        }        actions        {        }    }    rendering    {        layout(RDLCLayout)        {            Type = RDLC;            LayoutFile = './Inventory/Reports/RevaluationPostingTest.rdlc';            Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.';        }    }    labels    {    }    trigger OnPreReport()    begin        ItemJnlLineFilter := "Item Journal Line".GetFilters();        GLSetup.Get();        InvtSetup.Get();    end;    var        InvtSetup: Record "Inventory Setup";        GLSetup: Record "General Ledger Setup";        Item: Record Item;        ItemJnlTemplate: Record "Item Journal Template";        GenPostingSetup: Record "General Posting Setup";        NoSeries: Record "No. Series";        DimSetEntry: Record "Dimension Set Entry";        InvtPeriod: Record "Inventory Period";        DimMgt: Codeunit DimensionManagement;        ItemJnlLineFilter: Text;        ErrorCounter: Integer;        ErrorText: array[30] of Text[250];        LastPostingDate: Date;        LastDocNo: Code[20];        TableID: array[10] of Integer;        No: array[10] of Code[20];        DimText: Text[120];        OldDimText: Text[75];        ShowDim: Boolean;        Continue: Boolean;#pragma warning disable AA0074        Text000: Label 'You cannot use a recurring journal for revaluations.';#pragma warning disable AA0470        Text001: Label '%1 must be specified.';        Text002: Label '%1 %2 does not exist.';        Text003: Label '%1 must be %2 for %3 %4.';        Text004: Label '%1 must not be a closing date.';#pragma warning restore AA0470        Text005: Label 'The lines are not listed according to posting date because they were not entered in that order.';#pragma warning disable AA0470        Text006: Label '%1 is not within your allowed range of posting dates.';        Text007: Label '%1 %2 %3 does not exist.';#pragma warning restore AA0470        Text008: Label 'There is a gap in the number series.';#pragma warning restore AA0074        Revaluation_Posting___TestCaptionLbl: Label 'Revaluation Posting - Test';        CurrReport_PAGENOCaptionLbl: Label 'Page';        Item_Journal_Line__Posting_Date_CaptionLbl: Label 'Posting Date';        Item_Journal_Line_Amount_Control43CaptionLbl: Label 'Total';        DimensionsCaptionLbl: Label 'Dimensions';        ErrorText_Number_CaptionLbl: Label 'Warning!';    procedure AddError(Text: Text[250])    begin        ErrorCounter := ErrorCounter + 1;        ErrorText[ErrorCounter] := Text;    end;    local procedure CheckDimValuePosting(var ItemJournalLine: Record "Item Journal Line")    begin        OnBeforeCheckDimValuePosting(TableID, No, ItemJournalLine);        if not DimMgt.CheckDimValuePosting(TableID, No, ItemJournalLine."Dimension Set ID") then            AddError(DimMgt.GetDimValuePostingErr());    end;    procedure InitializeRequest(NewShowDim: Boolean)    begin        ShowDim := NewShowDim;    end;    [IntegrationEvent(false, false)]    local procedure OnAfterItemJournalLineOnAfterGetRecord(var ItemJournalLine: Record "Item Journal Line"; var ErrorCounter: Integer; var ErrorText: array[30] of Text[250])    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCheckDimValuePosting(var TableID: array[10] of Integer; var No: array[10] of Code[20]; var ItemJournalLine: Record "Item Journal Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeItemJournalLineOnAfterGetRecord(var ItemJournalLine: Record "Item Journal Line"; var ErrorCounter: Integer; var ErrorText: array[30] of Text[250])    begin    end;}