Page 514 Item Avail. by Lot No. Lines
src/Layers/W1/BaseApp/Inventory/Availability/ItemAvailbyLotNoLines.Page.al362 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.Availability;using Microsoft.Foundation.Enums;using Microsoft.Inventory.Item;using Microsoft.Inventory.Ledger;using Microsoft.Inventory.Tracking;page 514 "Item Avail. by Lot No. Lines"{ Caption = 'Lines'; DeleteAllowed = false; Editable = true; InsertAllowed = false; LinksAllowed = false; ModifyAllowed = false; PageType = ListPart; SaveValues = true; SourceTable = "Availability Info. Buffer"; SourceTableTemporary = true; layout { area(content) { repeater(Control1) { Editable = false; ShowCaption = false; field(LotNo; Rec."Lot No.") { ApplicationArea = ItemTracking; Caption = 'Code'; } field(ExpirationDate; Rec."Expiration Date") { ApplicationArea = ItemTracking; Caption = 'Expiration Date'; } field(Quality; Rec.Quality) { ApplicationArea = ItemTracking; Caption = 'Quality'; Visible = false; } field(CertificateNumber; Rec."Certificate Number") { ApplicationArea = ItemTracking; Caption = 'Certificate Number'; Visible = false; } field(Inventory; Rec."Qty. In Hand") { ApplicationArea = Basic, Suite; Caption = 'Inventory'; DecimalPlaces = 0 : 5; trigger OnDrillDown() var ItemLedgerEntry: Record "Item Ledger Entry"; IsHandled: Boolean; begin OnBeforeLookupInventory(IsHandled, Rec); if IsHandled then exit; Rec.LookupInventory(ItemLedgerEntry); if ItemLedgerEntry.FindSet() then Page.RunModal(0, ItemLedgerEntry); end; } field(GrossRequirement; Rec."Gross Requirement") { ApplicationArea = Basic, Suite; Caption = 'Gross Requirement'; DecimalPlaces = 0 : 5; trigger OnDrillDown() var TempReservationEntry: Record "Reservation Entry" temporary; IsHandled: Boolean; begin OnBeforeLookupGrossRequirement(IsHandled, Rec); if IsHandled then exit; Rec.LookupGrossRequirement(TempReservationEntry); if TempReservationEntry.FindSet() then Page.RunModal(0, TempReservationEntry); end; } field(ScheduledRcpt; Rec."Scheduled Receipt") { ApplicationArea = Basic, Suite; Caption = 'Scheduled Receipt'; DecimalPlaces = 0 : 5; trigger OnDrillDown() var TempReservationEntry: Record "Reservation Entry" temporary; IsHandled: Boolean; begin OnBeforeLookupScheduledReceipt(IsHandled, Rec); if IsHandled then exit; Rec.LookupScheduledReceipt(TempReservationEntry); if TempReservationEntry.FindSet() then Page.RunModal(0, TempReservationEntry); end; } field(PlannedOrderRcpt; Rec."Planned Order Receipt") { ApplicationArea = Basic, Suite; Caption = 'Planned Order Receipt'; DecimalPlaces = 0 : 5; trigger OnDrillDown() var TempReservationEntry: Record "Reservation Entry" temporary; IsHandled: Boolean; begin OnBeforeLookupPlannedOrderReceipt(IsHandled, Rec); if IsHandled then exit; Rec.LookupPlannedOrderReceipt(TempReservationEntry); if TempReservationEntry.FindSet() then Page.RunModal(0, TempReservationEntry); end; } field(QtyAvailable; Rec."Available Inventory") { ApplicationArea = Basic, Suite; Caption = 'Available Inventory'; DecimalPlaces = 0 : 5; } } } } actions { } trigger OnAfterGetRecord() begin Calculate(); end; var Item: Record Item; GrossRequirement: Decimal; PlannedOrderRcpt: Decimal; ScheduledRcpt: Decimal; procedure SetItem(var NewItem: Record Item; NewAmountType: Enum "Analysis Amount Type") var IsHandled: Boolean; begin IsHandled := false; OnBeforeSetItem(Rec, NewItem, NewAmountType, IsHandled); if not IsHandled then begin Item.Copy(NewItem); GenerateLines(); if Item.GetFilter("Location Filter") <> '' then Rec.SetFilter("Location Code Filter", Item.GetFilter("Location Filter")); if Item.GetFilter("Variant Filter") <> '' then Rec.SetFilter("Variant Code Filter", Item.GetFilter("Variant Filter")); if NewAmountType = NewAmountType::"Net Change" then Rec.SetRange("Date Filter", Item.GetRangeMin("Date Filter"), Item.GetRangeMax("Date Filter")) else Rec.SetRange("Date Filter", 0D, Item.GetRangeMax("Date Filter")); end; OnAfterSetItem(Item, NewAmountType); CurrPage.Update(false); end; procedure GetItem(var ItemOut: Record Item) begin ItemOut.Copy(Item); end; local procedure GenerateLines() begin BuildLotNoList(Rec, Item."No."); end; local procedure Calculate() var IsHandled: Boolean; begin Rec.SetRange("Lot No. Filter", Rec."Lot No."); OnBeforeCalcAvailQuantities(Rec, Item, IsHandled); if not IsHandled then Rec.CalcFields( Inventory, "Qty. on Sales Order", "Qty. on Service Order", "Qty. on Job Order", "Qty. on Component Lines", "Qty. on Trans. Order Shipment", "Qty. on Asm. Component", "Qty. on Purch. Return", "Planned Order Receipt (Qty.)", "Purch. Req. Receipt (Qty.)", "Qty. on Purch. Order", "Qty. on Prod. Receipt", "Qty. on Trans. Order Receipt", "Qty. on Assembly Order", "Qty. on Sales Return" ); /*GrossRequirement := "Qty. on Sales Order" + "Qty. on Service Order" + "Qty. on Job Order" + "Qty. on Component Lines" + TransOrdShipmentQty + "Planning Issues (Qty.)" + "Qty. on Asm. Component" + "Qty. on Purch. Return";*/ GrossRequirement := Rec."Qty. on Sales Order" + Rec."Qty. on Service Order" + Rec."Qty. on Job Order" + Rec."Qty. on Component Lines" + Rec."Qty. on Trans. Order Shipment" + Rec."Qty. on Asm. Component" + Rec."Qty. on Purch. Return"; /*PlannedOrderReceipt := "Planned Order Receipt (Qty.)" + "Purch. Req. Receipt (Qty.)";*/ PlannedOrderRcpt := Rec."Planned Order Receipt (Qty.)" + Rec."Purch. Req. Receipt (Qty.)"; /*ScheduledReceipt := "FP Order Receipt (Qty.)" + "Rel. Order Receipt (Qty.)" + "Qty. on Purch. Order" + QtyinTransit + TransOrdReceiptQty + "Qty. on Assembly Order" + "Qty. on Sales Return";*/ ScheduledRcpt := Rec."Qty. on Prod. Receipt" + Rec."Qty. on Purch. Order" + Rec."Qty. on Trans. Order Receipt" + Rec."Qty. on Assembly Order" + Rec."Qty. on Sales Return"; Rec."Qty. In Hand" := Rec.Inventory; Rec."Gross Requirement" := GrossRequirement; Rec."Planned Order Receipt" := PlannedOrderRcpt; Rec."Scheduled Receipt" := ScheduledRcpt; Rec."Available Inventory" := Rec.Inventory + PlannedOrderRcpt + ScheduledRcpt - GrossRequirement; OnAfterCalcAvailQuantities(Rec, Item); end; local procedure BuildLotNoList(var AvailabilityInfoBuffer: Record "Availability Info. Buffer"; ItemNo: Code[20]) var ItemByLotNoRes: Query "Item By Lot No. Res."; ItemByLotNoItemLedg: Query "Item By Lot No. Item Ledg."; LotDictionary: Dictionary of [Code[50], Text]; begin Clear(AvailabilityInfoBuffer); AvailabilityInfoBuffer.DeleteAll(); ItemByLotNoItemLedg.SetRange(Item_No, ItemNo); ItemByLotNoItemLedg.SetFilter(Variant_Code, Item.GetFilter("Variant Filter")); ItemByLotNoItemLedg.SetFilter(Location_Code, Item.GetFilter("Location Filter")); ItemByLotNoItemLedg.Open(); while ItemByLotNoItemLedg.Read() do if ItemByLotNoItemLedg.Lot_No <> '' then if not LotDictionary.ContainsKey(ItemByLotNoItemLedg.Lot_No) then begin LotDictionary.Add(ItemByLotNoItemLedg.Lot_No, ''); AvailabilityInfoBuffer.Init(); AvailabilityInfoBuffer."Item No." := Item."No."; AvailabilityInfoBuffer."Lot No." := ItemByLotNoItemLedg.Lot_No; AvailabilityInfoBuffer."Expiration Date" := ItemByLotNoItemLedg.Expiration_Date; AvailabilityInfoBuffer.Insert(); end; // Expected Receipt Date for positive reservation entries. ItemByLotNoRes.SetRange(Item_No, ItemNo); ItemByLotNoRes.SetFilter(Quantity__Base_, '>0'); ItemByLotNoRes.SetFilter(Expected_Receipt_Date, Item.GetFilter("Date Filter")); ItemByLotNoRes.SetFilter(Variant_Code, Item.GetFilter("Variant Filter")); ItemByLotNoRes.SetFilter(Location_Code, Item.GetFilter("Location Filter")); ItemByLotNoRes.Open(); AddReservationEntryLotNos(AvailabilityInfoBuffer, ItemByLotNoRes, LotDictionary); // Shipment date for negative reservation entries. ItemByLotNoRes.SetRange(Item_No, ItemNo); ItemByLotNoRes.SetFilter(Quantity__Base_, '<0'); ItemByLotNoRes.SetFilter(Expected_Receipt_Date, ''); ItemByLotNoRes.SetFilter(Shipment_Date, Item.GetFilter("Date Filter")); ItemByLotNoRes.SetFilter(Variant_Code, Item.GetFilter("Variant Filter")); ItemByLotNoRes.SetFilter(Location_Code, Item.GetFilter("Location Filter")); AddReservationEntryLotNos(AvailabilityInfoBuffer, ItemByLotNoRes, LotDictionary); end; local procedure AddReservationEntryLotNos( var AvailabilityInfoBuffer: Record "Availability Info. Buffer"; var ItemByLotNoRes: Query "Item By Lot No. Res."; var LotDictionary: Dictionary of [Code[50], Text] ) begin ItemByLotNoRes.Open(); while ItemByLotNoRes.Read() do if ItemByLotNoRes.Lot_No <> '' then if not LotDictionary.ContainsKey(ItemByLotNoRes.Lot_No) then begin LotDictionary.Add(ItemByLotNoRes.Lot_No, ''); AvailabilityInfoBuffer.Init(); AvailabilityInfoBuffer."Item No." := Item."No."; AvailabilityInfoBuffer."Lot No." := ItemByLotNoRes.Lot_No; AvailabilityInfoBuffer."Expiration Date" := ItemByLotNoRes.Expiration_Date; AvailabilityInfoBuffer.Insert(); end; end; [IntegrationEvent(true, false)] local procedure OnAfterSetItem(var Item: Record Item; NewAmountType: Enum "Analysis Amount Type") begin end; [IntegrationEvent(true, false)] local procedure OnBeforeCalcAvailQuantities(var AvailabilityInfoBuffer: Record "Availability Info. Buffer"; var Item: Record Item; var IsHandled: Boolean) begin end; [IntegrationEvent(true, false)] local procedure OnAfterCalcAvailQuantities(var AvailabilityInfoBuffer: Record "Availability Info. Buffer"; var Item: Record Item) begin end; [IntegrationEvent(true, false)] local procedure OnBeforeLookupInventory(var IsHandled: Boolean; var AvailabilityInfoBuffer: Record "Availability Info. Buffer") begin end; [IntegrationEvent(true, false)] local procedure OnBeforeLookupGrossRequirement(var IsHandled: Boolean; var AvailabilityInfoBuffer: Record "Availability Info. Buffer") begin end; [IntegrationEvent(true, false)] local procedure OnBeforeLookupScheduledReceipt(var IsHandled: Boolean; var AvailabilityInfoBuffer: Record "Availability Info. Buffer") begin end; [IntegrationEvent(true, false)] local procedure OnBeforeLookupPlannedOrderReceipt(var IsHandled: Boolean; var AvailabilityInfoBuffer: Record "Availability Info. Buffer") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeSetItem(var AvailabilityInfoBuffer: Record "Availability Info. Buffer"; var Item: Record Item; AmountType: Enum "Analysis Amount Type"; var IsHandled: Boolean) begin end;}