Report 794 Adjust Item Costs/Prices
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;}