Report 5706 Create Stockkeeping Unit
src/Layers/W1/BaseApp/Inventory/Location/CreateStockkeepingUnit.Report.al260 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.Location;using Microsoft.Inventory.Item;using Microsoft.Inventory.Tracking;report 5706 "Create Stockkeeping Unit"{ AdditionalSearchTerms = 'create sku'; ApplicationArea = Warehouse; Caption = 'Create Stockkeeping Unit'; ProcessingOnly = true; UsageCategory = Administration; dataset { dataitem(Item; Item) { DataItemTableView = sorting("No."); RequestFilterFields = "No.", "Inventory Posting Group", "Location Filter", "Variant Filter"; trigger OnAfterGetRecord() var ItemVariant: Record "Item Variant"; IsHandled: Boolean; begin IsHandled := false; OnBeforeItemOnAfterGetRecord(Item, IsHandled); if IsHandled then CurrReport.Skip(); if SaveFilters then begin LocationFilter := GetFilter("Location Filter"); VariantFilter := GetFilter("Variant Filter"); SaveFilters := false; end; SetFilter("Location Filter", LocationFilter); SetFilter("Variant Filter", VariantFilter); Location.SetFilter(Code, GetFilter("Location Filter")); OnItemOnAfterGetRecordOnAfterSetLocationFilter(Location, Item); if ReplacePreviousSKUs then begin StockkeepingUnit.Reset(); StockkeepingUnit.SetRange("Item No.", "No."); if GetFilter("Variant Filter") <> '' then StockkeepingUnit.SetFilter("Variant Code", GetFilter("Variant Filter")); if GetFilter("Location Filter") <> '' then StockkeepingUnit.SetFilter("Location Code", GetFilter("Location Filter")); StockkeepingUnit.DeleteAll(); end; DialogWindow.Update(1, "No."); ItemVariant.SetRange("Item No.", "No."); ItemVariant.SetFilter(Code, GetFilter("Variant Filter")); case true of (SKUCreationMethod = SKUCreationMethod::Location) or ((SKUCreationMethod = SKUCreationMethod::"Location & Variant") and (not ItemVariant.Find('-'))): if Location.Find('-') then repeat DialogWindow.Update(2, Location.Code); SetRange("Location Filter", Location.Code); CreateSKUIfRequired(Item, Location.Code, ''); until Location.Next() = 0; (SKUCreationMethod = SKUCreationMethod::Variant) or ((SKUCreationMethod = SKUCreationMethod::"Location & Variant") and (not Location.Find('-'))): if ItemVariant.Find('-') then repeat DialogWindow.Update(3, ItemVariant.Code); SetRange("Variant Filter", ItemVariant.Code); CreateSKUIfRequired(Item, '', ItemVariant.Code); until ItemVariant.Next() = 0; (SKUCreationMethod = SKUCreationMethod::"Location & Variant"): if Location.Find('-') then repeat DialogWindow.Update(2, Location.Code); SetRange("Location Filter", Location.Code); if ItemVariant.Find('-') then repeat DialogWindow.Update(3, ItemVariant.Code); SetRange("Variant Filter", ItemVariant.Code); CreateSKUIfRequired(Item, Location.Code, ItemVariant.Code); until ItemVariant.Next() = 0; until Location.Next() = 0; end; end; trigger OnPostDataItem() begin DialogWindow.Close(); end; trigger OnPreDataItem() begin OnBeforeItemOnPreDataItem(Item); Location.SetRange("Use As In-Transit", false); DialogWindow.Open( Text000 + Text001 + Text002); SaveFilters := true; end; } } requestpage { SaveValues = true; layout { area(content) { group(Options) { Caption = 'Options'; field(SKUCreationMethod; SKUCreationMethod) { ApplicationArea = Location; Caption = 'Create Per'; ToolTip = 'Specifies if you want to create stockkeeping units per location or per variant or per location combined with variant.'; } field(ItemInInventoryOnly; ItemInInventoryOnly) { ApplicationArea = Location; Caption = 'Item In Inventory Only'; ToolTip = 'Specifies if you only want the batch job to create stockkeeping units for items that are in your inventory (that is, for items where the value in the Inventory field is above 0).'; } field(ReplacePreviousSKUs; ReplacePreviousSKUs) { ApplicationArea = Warehouse; Caption = 'Replace Previous SKUs'; ToolTip = 'Specifies if you want the batch job to replace all previous created stockkeeping units on the items you have included in the batch job.'; } } } } actions { } } labels { } var StockkeepingUnit: Record "Stockkeeping Unit"; DialogWindow: Dialog; SaveFilters: Boolean; LocationFilter: Code[1024]; VariantFilter: Code[1024];#pragma warning disable AA0074#pragma warning disable AA0470 Text000: Label 'Item No. #1##################\'; Text001: Label 'Location Code #2########\'; Text002: Label 'Variant Code #3########\';#pragma warning restore AA0470#pragma warning restore AA0074 protected var Location: Record Location; SKUCreationMethod: Enum "SKU Creation Method"; ItemInInventoryOnly: Boolean; ReplacePreviousSKUs: Boolean; procedure CreateSKUIfRequired(var Item2: Record Item; LocationCode: Code[10]; VariantCode: Code[10]) var Location: Record Location; IsHandled: Boolean; begin IsHandled := false; OnBeforeCreateSKU(Item2, LocationCode, VariantCode, ItemInInventoryOnly, IsHandled, SKUCreationMethod); if IsHandled then exit; Location.SetLoadFields(Code, "SKU Creation Policy"); if Location.Get(LocationCode) then if Location."SKU Creation Policy" = Location."SKU Creation Policy"::Blocked then exit; Item2.CalcFields(Inventory); if (ItemInInventoryOnly and (Item2.Inventory > 0)) or (not ItemInInventoryOnly) then if not StockkeepingUnit.Get(LocationCode, Item2."No.", VariantCode) then CreateSKU(Item2, LocationCode, VariantCode); end; procedure SetParameters(CreatePerOption: Enum "SKU Creation Method"; NewItemInInventoryOnly: Boolean; NewReplacePreviousSKUs: Boolean) begin SKUCreationMethod := CreatePerOption; ItemInInventoryOnly := NewItemInInventoryOnly; ReplacePreviousSKUs := NewReplacePreviousSKUs; end; [IntegrationEvent(false, false)] local procedure OnBeforeCreateSKU(var Item: Record Item; LocationCode: Code[10]; VariantCode: Code[10]; ItemInInventoryOnly: Boolean; var IsHandled: Boolean; SKUCreationMethod: Enum "SKU Creation Method") begin end; [IntegrationEvent(true, false)] local procedure OnBeforeStockkeepingUnitInsert(var StockkeepingUnit: Record "Stockkeeping Unit"; Item: Record Item) begin end; procedure CreateSKU(var Item2: Record Item; LocationCode: Code[10]; VariantCode: Code[10]) begin StockkeepingUnit.Init(); StockkeepingUnit."Item No." := Item2."No."; StockkeepingUnit."Location Code" := LocationCode; StockkeepingUnit."Variant Code" := VariantCode; StockkeepingUnit.CopyFromItem(Item2); StockkeepingUnit.TransferManufCostsFromItem(Item2); StockkeepingUnit."Last Date Modified" := WorkDate(); StockkeepingUnit."Special Equipment Code" := Item2."Special Equipment Code"; StockkeepingUnit."Put-away Template Code" := Item2."Put-away Template Code"; StockkeepingUnit.SetHideValidationDialog(true); StockkeepingUnit.Validate("Phys Invt Counting Period Code", Item2."Phys Invt Counting Period Code"); StockkeepingUnit."Put-away Unit of Measure Code" := Item2."Put-away Unit of Measure Code"; StockkeepingUnit."Use Cross-Docking" := Item2."Use Cross-Docking"; OnBeforeStockkeepingUnitInsert(StockkeepingUnit, Item2); StockkeepingUnit.Insert(true); OnAfterCreateSKU(StockkeepingUnit, Item2); end; [IntegrationEvent(false, false)] local procedure OnBeforeItemOnPreDataItem(var Item: Record Item) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeItemOnAfterGetRecord(var Item: Record Item; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnItemOnAfterGetRecordOnAfterSetLocationFilter(var Location: Record Location; var Item: Record Item) begin end; [IntegrationEvent(true, false)] local procedure OnAfterCreateSKU(var StockkeepingUnit: Record "Stockkeeping Unit"; Item: Record Item) begin end;}