Codeunit 1811 Excel Post Processor

Base Application, System.Integration

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;}