Report 794 Adjust Item Costs/Prices

Base Application, Microsoft.Inventory.Item

src/Layers/W1/BaseApp/Inventory/Item/AdjustItemCostsPrices.Report.al328 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.Item;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Inventory.Location;using Microsoft.Utilities;report 794 "Adjust Item Costs/Prices"{    ApplicationArea = Basic, Suite;    Caption = 'Adjust Item Costs/Prices';    ToolTip = 'Adjusts the Last Direct Cost, Standard Cost, Unit Price, Profit %, and Indirect Cost % fields on the item or stockkeeping unit cards. For example, you can change Last Direct Cost by 5% on all items from a specific vendor. The changes are processed immediately when the batch job is started. The fields on the item card that are dependent on the adjusted field are also changed.';    ProcessingOnly = true;    UsageCategory = Tasks;    dataset    {        dataitem(Item; Item)        {            DataItemTableView = sorting("No.");            RequestFilterFields = "No.", "Vendor No.", "Inventory Posting Group", "Costing Method";            trigger OnAfterGetRecord()            begin                Window.Update(1, "No.");                case Selection of                    ItemCostPriceFieldOption::"Unit Price":                        OldFieldValue := "Unit Price";                    ItemCostPriceFieldOption::"Profit %":                        OldFieldValue := "Profit %";                    ItemCostPriceFieldOption::"Indirect Cost %":                        OldFieldValue := "Indirect Cost %";                    ItemCostPriceFieldOption::"Last Direct Cost":                        OldFieldValue := "Last Direct Cost";                    ItemCostPriceFieldOption::"Standard Cost":                        OldFieldValue := "Standard Cost";                    else                        OnAfterGetRecordOnSetOldFieldOnCaseElse(Item, Selection, OldFieldValue);                end;                NewFieldValue := OldFieldValue * AdjFactor;                GetGLSetup();                PriceIsRnded := false;                if RoundingMethod.Code <> '' then begin                    RoundingMethod."Minimum Amount" := NewFieldValue;                    if RoundingMethod.Find('=<') then begin                        NewFieldValue := NewFieldValue + RoundingMethod."Amount Added Before";                        if RoundingMethod.Precision > 0 then begin                            NewFieldValue := Round(NewFieldValue, RoundingMethod.Precision, CopyStr('=><', RoundingMethod.Type + 1, 1));                            PriceIsRnded := true;                        end;                        NewFieldValue := NewFieldValue + RoundingMethod."Amount Added After";                    end;                end;                if not PriceIsRnded then                    NewFieldValue := Round(NewFieldValue, GLSetup."Unit-Amount Rounding Precision");                case Selection of                    ItemCostPriceFieldOption::"Unit Price":                        Validate("Unit Price", NewFieldValue);                    ItemCostPriceFieldOption::"Profit %":                        Validate("Profit %", NewFieldValue);                    ItemCostPriceFieldOption::"Indirect Cost %":                        Validate("Indirect Cost %", NewFieldValue);                    ItemCostPriceFieldOption::"Last Direct Cost":                        Validate("Last Direct Cost", NewFieldValue);                    ItemCostPriceFieldOption::"Standard Cost":                        Validate("Standard Cost", NewFieldValue);                    else                        OnAfterGetRecordOnValidateFieldOnCaseElse(Item, Selection, NewFieldValue);                end;                Modify();            end;            trigger OnPreDataItem()            begin                if AdjustCard = AdjustCard::"Stockkeeping Unit Card" then                    CurrReport.Break();                Window.Open(Text000);            end;        }        dataitem("Stockkeeping Unit"; "Stockkeeping Unit")        {            DataItemTableView = sorting("Item No.", "Location Code", "Variant Code");            trigger OnAfterGetRecord()            begin                SkipNoneExistingItem("Item No.");                Window.Update(1, "Item No.");                Window.Update(2, "Location Code");                Window.Update(3, "Variant Code");                case Selection of                    ItemCostPriceFieldOption::"Last Direct Cost":                        OldFieldValue := "Last Direct Cost";                    ItemCostPriceFieldOption::"Standard Cost":                        OldFieldValue := "Standard Cost";                end;                NewFieldValue := OldFieldValue * AdjFactor;                PriceIsRnded := false;                if RoundingMethod.Code <> '' then begin                    RoundingMethod."Minimum Amount" := NewFieldValue;                    if RoundingMethod.Find('=<') then begin                        NewFieldValue := NewFieldValue + RoundingMethod."Amount Added Before";                        if RoundingMethod.Precision > 0 then begin                            NewFieldValue := Round(NewFieldValue, RoundingMethod.Precision, CopyStr('=><', RoundingMethod.Type + 1, 1));                            PriceIsRnded := true;                        end;                        NewFieldValue := NewFieldValue + RoundingMethod."Amount Added After";                    end;                end;                if not PriceIsRnded then                    NewFieldValue := Round(NewFieldValue, 0.00001);                case Selection of                    ItemCostPriceFieldOption::"Last Direct Cost":                        Validate("Last Direct Cost", NewFieldValue);                    ItemCostPriceFieldOption::"Standard Cost":                        Validate("Standard Cost", NewFieldValue);                end;                Modify();            end;            trigger OnPreDataItem()            begin                if AdjustCard = AdjustCard::"Item Card" then                    CurrReport.Break();                Item.CopyFilter("No.", "Item No.");                Item.CopyFilter("Location Filter", "Location Code");                Item.CopyFilter("Variant Filter", "Variant Code");                Window.Open(                  Text002 +                  Text003 +                  Text004);            end;        }    }    requestpage    {        SaveValues = true;        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(Adjust; AdjustCard)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Adjust';                        OptionCaption = 'Item Card,Stockkeeping Unit Card';                        ToolTip = 'Specifies which card is to be adjusted.';                        trigger OnValidate()                        begin                            UpdateEnabled();                        end;                    }                    field(AdjustField; Selection)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Adjust Field';                        ToolTip = 'Specifies which field should be adjusted.';                        trigger OnValidate()                        begin                            case Selection of                                ItemCostPriceFieldOption::"Indirect Cost %":                                    IndirectCost37SelectionOnValid();                                ItemCostPriceFieldOption::"Profit %":                                    Profit37SelectionOnValidate();                                ItemCostPriceFieldOption::"Unit Price":                                    UnitPriceSelectionOnValidate();                            end;                            OnAfterValidateAdjustField(Selection);                        end;                    }                    field(AdjustmentFactor; AdjFactor)                    {                        ApplicationArea = Basic, Suite;                        AutoFormatType = 0;                        Caption = 'Adjustment Factor';                        DecimalPlaces = 0 : 5;                        MinValue = 0;                        ToolTip = 'Specifies an adjustment factor to multiply the amounts that you want to copy. By entering an adjustment factor, you can increase or decrease the amounts.';                    }                    field(Rounding_Method; RoundingMethod.Code)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Rounding Method';                        TableRelation = "Rounding Method";                        ToolTip = 'Specifies a code for the rounding method that you want to apply to costs or prices that you adjust.';                    }                }            }        }        actions        {        }        trigger OnInit()        begin            Selection3Enable := true;            Selection2Enable := true;            Selection1Enable := true;        end;        trigger OnOpenPage()        begin            if AdjFactor = 0 then                AdjFactor := 1;            UpdateEnabled();        end;    }    labels    {    }    trigger OnPreReport()    begin        RoundingMethod.SetRange(Code, RoundingMethod.Code);        if Item.GetFilters <> '' then            FilteredItem.CopyFilters(Item);    end;    var        RoundingMethod: Record "Rounding Method";        GLSetup: Record "General Ledger Setup";        FilteredItem: Record Item;        Selection: Enum ItemCostPriceFieldOption;        Window: Dialog;        NewFieldValue: Decimal;        OldFieldValue: Decimal;        AdjFactor: Decimal;        AdjustCard: Option "Item Card","Stockkeeping Unit Card";        Selection1Enable: Boolean;        Selection2Enable: Boolean;        Selection3Enable: Boolean;        PriceIsRnded: Boolean;        GLSetupRead: Boolean;        SelectionErr: Label '%1 is not a valid selection.', Comment = '%1 = Selection';#pragma warning disable AA0074#pragma warning disable AA0470        Text000: Label 'Processing items  #1##########';        Text002: Label 'Processing items     #1##########\';        Text003: Label 'Processing locations #2##########\';        Text004: Label 'Processing variants  #3##########';#pragma warning restore AA0470#pragma warning restore AA0074    local procedure UpdateEnabled()    begin        PageUpdateEnabled();    end;    local procedure GetGLSetup()    begin        if not GLSetupRead then            GLSetup.Get();        GLSetupRead := true;    end;    local procedure PageUpdateEnabled()    begin        if AdjustCard = AdjustCard::"Stockkeeping Unit Card" then            if Selection.AsInteger() < 3 then                Selection := ItemCostPriceFieldOption.FromInteger(3);    end;    local procedure UnitPriceSelectionOnValidate()    begin        if not Selection1Enable then            Error(SelectionErr, Format(Selection));    end;    local procedure Profit37SelectionOnValidate()    begin        if not Selection2Enable then            Error(SelectionErr, Format(Selection));    end;    local procedure IndirectCost37SelectionOnValid()    begin        if not Selection3Enable then            Error(SelectionErr, Format(Selection));    end;    local procedure SkipNoneExistingItem(ItemNo: Code[20])    begin        if Item.GetFilters <> '' then begin            FilteredItem.SetRange("No.", ItemNo);            if FilteredItem.IsEmpty() then                CurrReport.Skip();        end;    end;    [IntegrationEvent(false, false)]    local procedure OnAfterGetRecordOnSetOldFieldOnCaseElse(var Item: Record Item; Selection: Enum ItemCostPriceFieldOption; var OldFieldValue: Decimal)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterGetRecordOnValidateFieldOnCaseElse(var Item: Record Item; Selection: Enum ItemCostPriceFieldOption; var NewFieldValue: Decimal)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterValidateAdjustField(Selection: Enum ItemCostPriceFieldOption)    begin    end;}