Query 7319 CalcPickableQtyFromWhseEntry

Base Application, Microsoft.Warehouse.Activity

src/Layers/W1/BaseApp/Warehouse/Activity/CalcPickableQtyFromWhseEntry.Query.al74 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.Warehouse.Activity;using Microsoft.Inventory.Tracking;using Microsoft.Warehouse.Ledger;using Microsoft.Warehouse.Structure;query 7319 CalcPickableQtyFromWhseEntry{    QueryType = Normal;    Access = Internal;    DataAccessIntent = ReadOnly;    Caption = 'Calculate pickable quantity from warehouse entries that are not blocked or dedicated', Locked = true;    elements    {        dataitem(Bin_Content; "Bin Content")        {            DataItemTableFilter = Dedicated = const(false),                                  "Block Movement" = filter(" " | Inbound);            SqlJoinType = InnerJoin;            filter(Bin_Type_Code; "Bin Type Code") { }            column(Location_Code; "Location Code") { }            column(Item_No_; "Item No.") { }            column(Variant_Code; "Variant Code") { }            dataitem(Warehouse_Entry; "Warehouse Entry")            {                DataItemLink = "Location Code" = Bin_Content."Location Code",                                "Bin Code" = Bin_Content."Bin Code",                                "Item No." = Bin_Content."Item No.",                                "Variant Code" = Bin_Content."Variant Code",                                "Unit of Measure Code" = Bin_Content."Unit of Measure Code";                SqlJoinType = InnerJoin;                filter(Serial_No_; "Serial No.") { }                filter(Lot_No_; "Lot No.") { }                filter(Package_No_; "Package No.") { }                column(TotalPickableQtyBase; "Qty. (Base)")                {                    Method = Sum;                }            }        }    }    internal procedure SetTrackingFilterFromItemTrackingSetupIfNotBlankIfRequired(WhseItemTrackingSetup: Record "Item Tracking Setup")    begin        if WhseItemTrackingSetup."Serial No." <> '' then            if WhseItemTrackingSetup."Serial No. Required" then                CurrQuery.SetRange(Serial_No_, WhseItemTrackingSetup."Serial No.")            else                CurrQuery.SetFilter(Serial_No_, '%1|%2', WhseItemTrackingSetup."Serial No.", '');        if WhseItemTrackingSetup."Lot No." <> '' then            if WhseItemTrackingSetup."Lot No. Required" then                CurrQuery.SetRange(Lot_No_, WhseItemTrackingSetup."Lot No.")            else                CurrQuery.SetFilter(Lot_No_, '%1|%2', WhseItemTrackingSetup."Lot No.", '');        if WhseItemTrackingSetup."Package No." <> '' then            if WhseItemTrackingSetup."Package No. Required" then                CurrQuery.SetRange(Package_No_, WhseItemTrackingSetup."Package No.")            else                CurrQuery.SetFilter(Package_No_, '%1|%2', WhseItemTrackingSetup."Package No.", '');    end;}