Codeunit 5801 Show Applied Entries
src/Layers/W1/BaseApp/Inventory/Ledger/ShowAppliedEntries.Codeunit.al89 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.Ledger;codeunit 5801 "Show Applied Entries"{ Permissions = TableData "Item Ledger Entry" = rim, TableData "Item Application Entry" = r; TableNo = "Item Ledger Entry"; trigger OnRun() var TempItemLedgerEntry: Record "Item Ledger Entry" temporary; begin TempItemLedgerEntry.DeleteAll(); FindAppliedEntries(Rec, TempItemLedgerEntry); PAGE.RunModal(PAGE::"Applied Item Entries", TempItemLedgerEntry); end; procedure FindAppliedEntries(ItemLedgEntry: Record "Item Ledger Entry"; var TempItemLedgerEntry: Record "Item Ledger Entry" temporary) var ItemApplnEntry: Record "Item Application Entry"; begin if ItemLedgEntry.Positive then begin ItemApplnEntry.Reset(); ItemApplnEntry.SetCurrentKey("Inbound Item Entry No.", "Outbound Item Entry No.", "Cost Application"); ItemApplnEntry.SetRange("Inbound Item Entry No.", ItemLedgEntry."Entry No."); ItemApplnEntry.SetFilter("Outbound Item Entry No.", '<>%1', 0); ItemApplnEntry.SetRange("Cost Application", true); OnFindAppliedEntryOnAfterSetFilters(ItemApplnEntry, ItemLedgEntry); if ItemApplnEntry.Find('-') then repeat InsertTempEntry(TempItemLedgerEntry, ItemApplnEntry."Outbound Item Entry No.", ItemApplnEntry.Quantity); until ItemApplnEntry.Next() = 0; end else begin ItemApplnEntry.Reset(); ItemApplnEntry.SetCurrentKey("Outbound Item Entry No.", "Item Ledger Entry No.", "Cost Application"); ItemApplnEntry.SetRange("Outbound Item Entry No.", ItemLedgEntry."Entry No."); ItemApplnEntry.SetRange("Item Ledger Entry No.", ItemLedgEntry."Entry No."); ItemApplnEntry.SetRange("Cost Application", true); OnFindAppliedEntryOnAfterSetFilters(ItemApplnEntry, ItemLedgEntry); if ItemApplnEntry.Find('-') then repeat InsertTempEntry(TempItemLedgerEntry, ItemApplnEntry."Inbound Item Entry No.", -ItemApplnEntry.Quantity); until ItemApplnEntry.Next() = 0; end; end; local procedure InsertTempEntry(var TempItemLedgerEntry: Record "Item Ledger Entry" temporary; EntryNo: Integer; AppliedQty: Decimal) var ItemLedgEntry: Record "Item Ledger Entry"; IsHandled: Boolean; begin ItemLedgEntry.Get(EntryNo); IsHandled := false; OnBeforeInsertTempEntry(ItemLedgEntry, IsHandled, TempItemLedgerEntry, AppliedQty); if IsHandled then exit; if not ItemLedgEntry."Drop Shipment" then if AppliedQty * ItemLedgEntry.Quantity < 0 then exit; if not TempItemLedgerEntry.Get(EntryNo) then begin TempItemLedgerEntry.Init(); TempItemLedgerEntry := ItemLedgEntry; TempItemLedgerEntry.Quantity := AppliedQty; TempItemLedgerEntry.Insert(); end else begin TempItemLedgerEntry.Quantity := TempItemLedgerEntry.Quantity + AppliedQty; TempItemLedgerEntry.Modify(); end; end; [IntegrationEvent(false, false)] local procedure OnBeforeInsertTempEntry(ItemLedgerEntry: Record "Item Ledger Entry"; var IsHandled: Boolean; var TempItemLedgerEntry: Record "Item Ledger Entry" temporary; AppliedQty: Decimal) begin end; [IntegrationEvent(false, false)] local procedure OnFindAppliedEntryOnAfterSetFilters(var ItemApplicationEntry: Record "Item Application Entry"; ItemLedgerEntry: Record "Item Ledger Entry") begin end;}