Codeunit 1811 Excel Post Processor
src/Layers/W1/BaseApp/ExcelPostProcessor.Codeunit.al61 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 System.Integration;using Microsoft.Inventory.Item;using System.IO;codeunit 1811 "Excel Post Processor"{ TableNo = "Config. Package Record"; trigger OnRun() begin case Rec."Table ID" of DATABASE::Item: PostProcessItem(Rec); else exit; end; end; local procedure PostProcessItem(ConfigPackageRecord: Record "Config. Package Record") var Item: Record Item; AdjustItemInventory: Codeunit "Adjust Item Inventory"; QuantityOnInventory: Decimal; ErrorText: Text; begin if not FindItemAndGetInventory(ConfigPackageRecord, Item, QuantityOnInventory) then exit; if (Item."Base Unit of Measure" = '') or (Item."Gen. Prod. Posting Group" = '') or (Item."Inventory Posting Group" = '') then exit; ErrorText := AdjustItemInventory.PostAdjustmentToItemLedger(Item, QuantityOnInventory); if ErrorText <> '' then Error(ErrorText); end; local procedure FindItemAndGetInventory(ConfigPackageRecord: Record "Config. Package Record"; var Item: Record Item; var QuantityOnInventory: Decimal): Boolean var ConfigPackageData: Record "Config. Package Data"; begin ConfigPackageData.Get(ConfigPackageRecord."Package Code", ConfigPackageRecord."Table ID", ConfigPackageRecord."No.", Item.FieldNo("No.")); if not Item.Get(ConfigPackageData.Value) then exit(false); if not ConfigPackageData.Get(ConfigPackageRecord."Package Code", ConfigPackageRecord."Table ID", ConfigPackageRecord."No.", Item.FieldNo(Inventory)) then exit(false); if not Evaluate(QuantityOnInventory, ConfigPackageData.Value) then exit(false); exit(true); end;}