Codeunit 1218 Map Incoming Doc to Purch Doc

Base Application, System.IO

src/Layers/W1/BaseApp/System/DataExchange/MapIncomingDoctoPurchDoc.Codeunit.al695 lines, Copyright (c) Microsoft Corporation. MIT

namespace System.IO;using Microsoft.EServices.EDocument;using Microsoft.Finance.ReceivablesPayables;using Microsoft.Finance.VAT.Calculation;using Microsoft.Inventory.Item;using Microsoft.Purchases.Document;using Microsoft.Utilities;using System.Utilities;codeunit 1218 "Map Incoming Doc to Purch Doc"{    Permissions = TableData "Data Exch. Field" = d;    TableNo = "Data Exch.";    trigger OnRun()    var        ErrorMessage: Record "Error Message";        IncomingDocument: Record "Incoming Document";    begin        IncomingDocument.Get(Rec."Incoming Entry No.");        ErrorMessage.SetContext(IncomingDocument);        if ErrorMessage.HasErrors(false) then            exit;        if IncomingDocument."Document Type" = IncomingDocument."Document Type"::Journal then            CODEUNIT.Run(CODEUNIT::"Map Incoming Doc to Gen. Line", IncomingDocument)        else            ProcessIntermediateData(Rec);        DeleteIntermediateData(Rec);    end;    var        TempProcessedHdrFldId: Record "Integer" temporary;        TempProcessedLineFldId: Record "Integer" temporary;        NotFoundErr: Label 'Cannot find a value for field %1 of table %2 in table %3.', Comment = '%1 - field caption, %2 - table caption, %3 - table caption';        TotalsMismatchErr: Label 'The total amount %1 on the created document is different than the total amount %2 in the incoming document.', Comment = '%1 total amount, %2 expected total amount';        TotalsMismatchWithHintErr: Label 'The total amount %1 on the created document is different than the expected value %2. The incoming document has a prepaid amount of %3. You must handle prepayments manually.', Comment = '%1 total amount, %2 expected total amount,%3 total charge amount,%4 prepaid amount';        TempNameValueBufferPurchHdr: Record "Name/Value Buffer" temporary;        TotalsMismatchDocNotCreatedErr: Label 'The total amount %1 on the created document is different than the total amount %2 in the incoming document. To retry the document creation manually, open the Incoming Document window and choose the action Create Document.', Comment = '%1 total amount, %2 expected total amount';        InvoiceChargeHasNoReasonErr: Label 'Invoice charge on the incoming document has no reason code.';        VATMismatchErr: Label '%1 %2 on line number %3  has %4 %5, which is different than %4 %6 in the incoming document.', Comment = ' %1 is type value, %2 is the No.,  %3 is the line no , %4 field caption VAT%, %5 VAT pct on the line,%6 is the VAT pct in the incoming doc';        TempNameValueBufferPurchLine: Record "Name/Value Buffer" temporary;        UnableToApplyDiscountErr: Label 'The invoice discount of %1 cannot be applied. Invoice discount must be allowed on at least one invoice line and invoice total must not be 0.', Comment = '%1 - a decimal number';    [Scope('OnPrem')]    procedure ProcessIntermediateData(DataExch: Record "Data Exch.")    begin        OnBeforeProcessIntermediateData(DataExch);        ProcessHeaders(DataExch);        ApplyInvoiceDiscounts(DataExch);        ApplyInvoiceCharges(DataExch);        VerifyTotals(DataExch);    end;    local procedure ProcessHeaders(DataExch: Record "Data Exch.")    var        PurchaseHeader: Record "Purchase Header";        IntermediateDataImport: Record "Intermediate Data Import";        RecRef: RecordRef;        CurrRecordNo: Integer;    begin        CurrRecordNo := -1;        IntermediateDataImport.SetRange("Data Exch. No.", DataExch."Entry No.");        IntermediateDataImport.SetRange("Table ID", DATABASE::"Purchase Header");        IntermediateDataImport.SetRange("Parent Record No.", 0);        IntermediateDataImport.SetCurrentKey("Record No.");        if not IntermediateDataImport.FindSet() then            exit;        repeat            if CurrRecordNo <> IntermediateDataImport."Record No." then begin                // new record                if CurrRecordNo <> -1 then begin// if not start of loop then add lines - for current record                    RecRef.Modify(true);                    ProcessLines(PurchaseHeader, DataExch, CurrRecordNo);                    RecRef.Close();                end;                CurrRecordNo := IntermediateDataImport."Record No.";                RecRef.Open(DATABASE::"Purchase Header");                CreateNewPurchHdr(RecRef, DataExch, CurrRecordNo);                RecRef.SetTable(PurchaseHeader);            end;            if not IntermediateDataImport."Validate Only" then                if not IsFieldProcessed(TempProcessedHdrFldId, IntermediateDataImport."Field ID") then                    if IntermediateDataImport.Value <> '' then                        ProcessField(TempProcessedHdrFldId, RecRef, IntermediateDataImport."Field ID", IntermediateDataImport.Value);        until IntermediateDataImport.Next() = 0;        // process the last rec in DB        if CurrRecordNo <> -1 then begin            RecRef.Modify(true);            ProcessLines(PurchaseHeader, DataExch, CurrRecordNo);            RecRef.Close();        end;    end;    local procedure ProcessLines(PurchaseHeader: Record "Purchase Header"; DataExch: Record "Data Exch."; ParentRecordNo: Integer)    var        IntermediateDataImport: Record "Intermediate Data Import";        RecRef: RecordRef;        CurrRecordNo: Integer;    begin        CurrRecordNo := -1;        IntermediateDataImport.SetRange("Data Exch. No.", DataExch."Entry No.");        IntermediateDataImport.SetRange("Table ID", DATABASE::"Purchase Line");        IntermediateDataImport.SetRange("Parent Record No.", ParentRecordNo);        IntermediateDataImport.SetCurrentKey("Record No.");        if not IntermediateDataImport.FindSet() then begin            OnProcessLinesIntermediateDataImportNotFound(DataExch, PurchaseHeader, ParentRecordNo);            exit;        end;        repeat            if CurrRecordNo <> IntermediateDataImport."Record No." then begin                // new record                if CurrRecordNo <> -1 then                    // if not start of loop then save current rec                    RecRef.Modify(true);                CurrRecordNo := IntermediateDataImport."Record No.";                CreateNewPurchLine(PurchaseHeader, RecRef, DataExch."Entry No.", ParentRecordNo, CurrRecordNo);            end;            if not IntermediateDataImport."Validate Only" then                if not IsFieldProcessed(TempProcessedLineFldId, IntermediateDataImport."Field ID") then                    if IntermediateDataImport.Value <> '' then                        ProcessField(TempProcessedLineFldId, RecRef, IntermediateDataImport."Field ID", IntermediateDataImport.Value);        until IntermediateDataImport.Next() = 0;        // Save the last rec        if CurrRecordNo <> -1 then            RecRef.Modify(true);        OnAfterProcessLines(PurchaseHeader, DataExch, ParentRecordNo);    end;    local procedure ApplyInvoiceDiscounts(DataExch: Record "Data Exch.")    var        PurchaseHeader: Record "Purchase Header";        IntermediateDataImport: Record "Intermediate Data Import";        PurchLine: Record "Purchase Line";        TempVATAmountLine: Record "VAT Amount Line" temporary;        ErrorMessage: Record "Error Message";        PurchCalcDiscByType: Codeunit "Purch - Calc Disc. By Type";        InvoiceDiscountAmount: Decimal;        InvDiscBaseAmount: Decimal;    begin        IntermediateDataImport.SetRange("Data Exch. No.", DataExch."Entry No.");        IntermediateDataImport.SetRange("Table ID", DATABASE::"Purchase Header");        IntermediateDataImport.SetRange("Field ID", PurchaseHeader.FieldNo("Invoice Discount Value"));        IntermediateDataImport.SetRange("Parent Record No.", 0);        IntermediateDataImport.SetFilter(Value, '<>%1', '');        if not IntermediateDataImport.FindSet() then            exit;        repeat            Evaluate(InvoiceDiscountAmount, IntermediateDataImport.Value, 9);            if InvoiceDiscountAmount > 0 then begin                GetRelatedPurchaseHeader(PurchaseHeader, IntermediateDataImport."Record No.");                PurchLine.SetRange("Document No.", PurchaseHeader."No.");                PurchLine.SetRange("Document Type", PurchaseHeader."Document Type");                PurchLine.CalcVATAmountLines(0, PurchaseHeader, PurchLine, TempVATAmountLine);                InvDiscBaseAmount := TempVATAmountLine.GetTotalInvDiscBaseAmount(false, PurchaseHeader."Currency Code");                if PurchCalcDiscByType.InvoiceDiscIsAllowed(PurchaseHeader."Invoice Disc. Code") and (InvDiscBaseAmount <> 0) then                    PurchCalcDiscByType.ApplyInvDiscBasedOnAmt(InvoiceDiscountAmount, PurchaseHeader)                else                    LogMessage(DataExch."Entry No.", PurchaseHeader, PurchaseHeader.FieldNo("No."),                      ErrorMessage."Message Type"::Warning, StrSubstNo(UnableToApplyDiscountErr, InvoiceDiscountAmount));            end;        until IntermediateDataImport.Next() = 0;    end;    local procedure ApplyInvoiceCharges(DataExch: Record "Data Exch.")    var        PurchaseHeader: Record "Purchase Header";        ItemChargeAssignmentPurch: Record "Item Charge Assignment (Purch)";        IntermediateDataImport: Record "Intermediate Data Import";        InvoiceChargeAmount: Decimal;        InvoiceChargeReason: Text[100];    begin        IntermediateDataImport.SetRange("Data Exch. No.", DataExch."Entry No.");        IntermediateDataImport.SetRange("Table ID", DATABASE::"Item Charge Assignment (Purch)");        IntermediateDataImport.SetRange("Field ID", ItemChargeAssignmentPurch.FieldNo("Amount to Assign"));        IntermediateDataImport.SetRange("Parent Record No.", 0);        IntermediateDataImport.SetFilter(Value, '<>%1', '');        if not IntermediateDataImport.FindSet() then            exit;        repeat            Evaluate(InvoiceChargeAmount, IntermediateDataImport.Value, 9);            InvoiceChargeReason := GetInvoiceChargeReason(IntermediateDataImport);            GetRelatedPurchaseHeader(PurchaseHeader, IntermediateDataImport."Record No.");            CreateInvoiceChargePurchaseLine(DataExch."Entry No.", IntermediateDataImport."Record No.", PurchaseHeader, InvoiceChargeReason, InvoiceChargeAmount);        until IntermediateDataImport.Next() = 0;    end;    local procedure VerifyTotals(DataExch: Record "Data Exch.")    var        PurchaseHeader: Record "Purchase Header";        IntermediateDataImport: Record "Intermediate Data Import";        TempTotalPurchaseLine: Record "Purchase Line" temporary;        CurrentPurchaseLine: Record "Purchase Line";        ErrorMessage: Record "Error Message";        IncomingDocument: Record "Incoming Document";        DocumentTotals: Codeunit "Document Totals";        AmountIncludingVATFromFile: Decimal;        VATAmount: Decimal;        PrepaidAmount: Decimal;        ProcessingMsg: Text[250];    begin        IntermediateDataImport.SetRange("Data Exch. No.", DataExch."Entry No.");        IntermediateDataImport.SetRange("Table ID", DATABASE::"Purchase Header");        IntermediateDataImport.SetRange("Field ID", PurchaseHeader.FieldNo("Amount Including VAT"));        IntermediateDataImport.SetRange("Parent Record No.", 0);        IntermediateDataImport.SetFilter(Value, '<>%1', '');        if not IntermediateDataImport.FindSet() then            exit;        repeat            PrepaidAmount := GetPrepaidAmount(DataExch, IntermediateDataImport."Record No.");            Evaluate(AmountIncludingVATFromFile, IntermediateDataImport.Value, 9);            GetRelatedPurchaseHeader(PurchaseHeader, IntermediateDataImport."Record No.");            VerifyLineVATs(DataExch, PurchaseHeader, IntermediateDataImport."Record No.");            // prepare variables needed for calculation of totals            VATAmount := 0;            TempTotalPurchaseLine.Init();            CurrentPurchaseLine.SetRange("Document Type", PurchaseHeader."Document Type");            CurrentPurchaseLine.SetRange("Document No.", PurchaseHeader."No.");            // calculate totals and compare them with values from the incoming document            IncomingDocument.Get(DataExch."Incoming Entry No.");            if CurrentPurchaseLine.FindFirst() then begin                DocumentTotals.PurchaseCalculateTotalsWithInvoiceRounding(CurrentPurchaseLine, VATAmount, TempTotalPurchaseLine);                if AmountIncludingVATFromFile <> TempTotalPurchaseLine."Amount Including VAT" then begin                    ProcessingMsg := StrSubstNo(TotalsMismatchErr, TempTotalPurchaseLine."Amount Including VAT", AmountIncludingVATFromFile);                    if PrepaidAmount <> 0 then                        ProcessingMsg :=                          StrSubstNo(TotalsMismatchWithHintErr, TempTotalPurchaseLine."Amount Including VAT",                            AmountIncludingVATFromFile, PrepaidAmount);                    if IncomingDocument."Created Doc. Error Msg. Type" = IncomingDocument."Created Doc. Error Msg. Type"::Error then begin                        ProcessingMsg :=                          StrSubstNo(TotalsMismatchDocNotCreatedErr, TempTotalPurchaseLine."Amount Including VAT", AmountIncludingVATFromFile);                        LogMessage(DataExch."Entry No.", IncomingDocument, IncomingDocument.FieldNo("Entry No."),                          ErrorMessage."Message Type"::Error, ProcessingMsg);                    end else                        LogMessage(DataExch."Entry No.", PurchaseHeader, PurchaseHeader.FieldNo("No."),                          ErrorMessage."Message Type"::Warning, ProcessingMsg);                end;            end;        until IntermediateDataImport.Next() = 0;    end;    local procedure VerifyLineVATs(DataExch: Record "Data Exch."; PurchaseHeader: Record "Purchase Header"; ParentRecordNo: Integer)    var        PurchaseLine: Record "Purchase Line";        IntermediateDataImport: Record "Intermediate Data Import";        ErrorMessage: Record "Error Message";        VATPctFromFile: Decimal;    begin        IntermediateDataImport.SetRange("Data Exch. No.", DataExch."Entry No.");        IntermediateDataImport.SetRange("Table ID", DATABASE::"Purchase Line");        IntermediateDataImport.SetRange("Field ID", PurchaseLine.FieldNo("VAT %"));        IntermediateDataImport.SetRange("Parent Record No.", ParentRecordNo);        IntermediateDataImport.SetFilter(Value, '<>%1', '');        IntermediateDataImport.SetCurrentKey("Record No.");        if not IntermediateDataImport.FindSet() then            exit;        repeat            Evaluate(VATPctFromFile, IntermediateDataImport.Value, 9);            GetRelatedPurchaseLine(PurchaseLine, ComposeKeyForCreatedPurchLine(ParentRecordNo, IntermediateDataImport."Record No."));            if VATPctFromFile <> PurchaseLine."VAT %" then                LogMessage(DataExch."Entry No.", PurchaseHeader, PurchaseHeader.FieldNo("No."), ErrorMessage."Message Type"::Warning,                  StrSubstNo(VATMismatchErr, PurchaseLine.Type, PurchaseLine."No.", PurchaseLine."Line No.",                    PurchaseLine.FieldCaption("VAT %"), PurchaseLine."VAT %", VATPctFromFile));        until IntermediateDataImport.Next() = 0;    end;    local procedure SetFieldValue(var FieldRef: FieldRef; Value: Text[250])    var        ConfigValidateManagement: Codeunit "Config. Validate Management";        ErrorText: Text;    begin        TruncateValueToFieldLength(FieldRef, Value);        ErrorText := ConfigValidateManagement.EvaluateValueWithValidate(FieldRef, Value, true);        if ErrorText <> '' then            Error(ErrorText);    end;    local procedure TruncateValueToFieldLength(FieldRef: FieldRef; var Value: Text[250])    begin        if FieldRef.Type in [FieldType::Code, FieldType::Text] then            Value := CopyStr(Value, 1, FieldRef.Length);    end;    local procedure CreateNewPurchHdr(var RecRef: RecordRef; DataExch: Record "Data Exch."; RecordNo: Integer)    var        PurchaseHeader: Record "Purchase Header";        IntermediateDataImport: Record "Intermediate Data Import";        FldNo: Integer;    begin        TempProcessedHdrFldId.Reset();        TempProcessedHdrFldId.DeleteAll();        IntermediateDataImport.SetRange("Data Exch. No.", DataExch."Entry No.");        IntermediateDataImport.SetRange("Table ID", DATABASE::"Purchase Header");        IntermediateDataImport.SetRange("Record No.", RecordNo);        // Set PK and insert        FldNo := PurchaseHeader.FieldNo("Document Type");        ProcessField(TempProcessedHdrFldId, RecRef, FldNo,          GetValueFromIntermediate(IntermediateDataImport, RecRef, FldNo, PurchaseHeader.FieldCaption("Document Type")));        OnCreateNewPurchHdrOnBeforeRecRefInsert(RecRef, IntermediateDataImport);        RecRef.Insert(true);        // Vendor No.        FldNo := PurchaseHeader.FieldNo("Buy-from Vendor No.");        ProcessField(TempProcessedHdrFldId, RecRef, FldNo,          GetValueFromIntermediate(IntermediateDataImport, RecRef, FldNo, PurchaseHeader.FieldCaption("Buy-from Vendor No.")));        // Buy-from Vendor Name        FldNo := PurchaseHeader.FieldNo("Buy-from Vendor Name");        if TryGetValueFromIntermediate(IntermediateDataImport, RecRef, FldNo, PurchaseHeader.FieldCaption("Buy-from Vendor Name"), IntermediateDataImport.Value) then            ProcessFieldNoValidate(TempProcessedHdrFldId, RecRef, FldNo,              GetValueFromIntermediate(IntermediateDataImport, RecRef, FldNo, PurchaseHeader.FieldCaption("Buy-from Vendor Name")));        RecRef.Modify(true);        SetHeaderConfirmGeneratorFields(IntermediateDataImport, RecRef);        // Pay-to Name        FldNo := PurchaseHeader.FieldNo("Pay-to Name");        if TryGetValueFromIntermediate(IntermediateDataImport, RecRef, FldNo, PurchaseHeader.FieldCaption("Pay-to Name"), IntermediateDataImport.Value) then            if not IsFieldProcessed(TempProcessedHdrFldId, FldNo) then                ProcessFieldNoValidate(TempProcessedHdrFldId, RecRef, FldNo,                  GetValueFromIntermediate(IntermediateDataImport, RecRef, FldNo, PurchaseHeader.FieldCaption("Pay-to Name")));        // Currency        FldNo := PurchaseHeader.FieldNo("Currency Code");        ProcessField(TempProcessedHdrFldId, RecRef, FldNo,          GetValueFromIntermediate(IntermediateDataImport, RecRef, FldNo, PurchaseHeader.FieldCaption("Currency Code")));        // Incoming Doc Entry No        FldNo := PurchaseHeader.FieldNo("Incoming Document Entry No.");        ProcessField(TempProcessedHdrFldId, RecRef, FldNo, Format(DataExch."Incoming Entry No."));        RecRef.Modify(true);        CorrelateCreatedDocumentWithRecordNo(RecRef, RecordNo);    end;    local procedure SetHeaderConfirmGeneratorFields(var IntermediateDataImport: Record "Intermediate Data Import"; var RecRef: RecordRef)    var        PurchaseHeader: Record "Purchase Header";        FldNo: Integer;        Value: Text[250];        DecimalValue: Decimal;    begin        RecRef.SetTable(PurchaseHeader);        PurchaseHeader.SetHideValidationDialog(true);        // Pay-to Vendor        FldNo := PurchaseHeader.FieldNo("Pay-to Vendor No.");        if TryGetValueFromIntermediate(IntermediateDataImport, RecRef, FldNo, PurchaseHeader.FieldCaption("Pay-to Vendor No."), Value) then begin            PurchaseHeader.Validate("Pay-to Vendor No.", CopyStr(Value, 1, MaxStrLen(PurchaseHeader."Pay-to Vendor No.")));            SetFieldProcessed(TempProcessedHdrFldId, FldNo);            SetFieldProcessed(TempProcessedHdrFldId, PurchaseHeader.FieldNo("Pay-to Name"));        end;        // Buy-from Contact No.        FldNo := PurchaseHeader.FieldNo("Buy-from Contact No.");        if TryGetValueFromIntermediate(IntermediateDataImport, RecRef, FldNo, PurchaseHeader.FieldCaption("Buy-from Contact No."), Value) then begin            PurchaseHeader.Validate("Buy-from Contact No.", CopyStr(Value, 1, MaxStrLen(PurchaseHeader."Buy-from Contact No.")));            SetFieldProcessed(TempProcessedHdrFldId, FldNo);        end;        // Pay-to Contact No.        FldNo := PurchaseHeader.FieldNo("Pay-to Contact No.");        if TryGetValueFromIntermediate(IntermediateDataImport, RecRef, FldNo, PurchaseHeader.FieldCaption("Pay-to Contact No."), Value) then begin            PurchaseHeader.Validate("Pay-to Contact No.", CopyStr(Value, 1, MaxStrLen(PurchaseHeader."Pay-to Contact No.")));            SetFieldProcessed(TempProcessedHdrFldId, FldNo);        end;        // VAT Base Discount %        FldNo := PurchaseHeader.FieldNo("VAT Base Discount %");        if TryGetValueFromIntermediate(IntermediateDataImport, RecRef, FldNo, PurchaseHeader.FieldCaption("VAT Base Discount %"), Value) then begin            Evaluate(DecimalValue, Value, 9);            PurchaseHeader.Validate("VAT Base Discount %", DecimalValue);            SetFieldProcessed(TempProcessedHdrFldId, FldNo);        end;        PurchaseHeader.Modify(true);        RecRef.GetTable(PurchaseHeader);    end;    local procedure CreateNewPurchLine(PurchaseHeader: Record "Purchase Header"; var RecRef: RecordRef; DataExchNo: Integer; ParentRecNo: Integer; RecordNo: Integer)    var        PurchaseLine: Record "Purchase Line";    begin        TempProcessedLineFldId.Reset();        TempProcessedLineFldId.DeleteAll();        InsertEmptyPurchaseLine(PurchaseHeader, PurchaseLine);        RecRef.GetTable(PurchaseLine);        SetLineMandatoryFields(RecRef, DataExchNo, ParentRecNo, RecordNo);        CorrelateCreatedPurchLineWithRecordNo(RecRef, ComposeKeyForCreatedPurchLine(ParentRecNo, RecordNo));    end;    local procedure CreateInvoiceChargePurchaseLine(EntryNo: Integer; RecordNo: Integer; var PurchaseHeader: Record "Purchase Header"; InvoiceChargeReason: Text[100]; InvoiceChargeAmount: Decimal)    var        PurchaseLine: Record "Purchase Line";        PreMapIncomingPurchDoc: Codeunit "Pre-map Incoming Purch. Doc";        GLAccountNo: Code[20];    begin        GLAccountNo :=          PreMapIncomingPurchDoc.FindAppropriateGLAccount(            EntryNo, RecordNo, InvoiceChargeReason, InvoiceChargeAmount, PurchaseHeader."Buy-from Vendor No.");        InsertEmptyPurchaseLine(PurchaseHeader, PurchaseLine);        PurchaseLine.Validate(Type, PurchaseLine.Type::"G/L Account");        PurchaseLine.Validate("No.", GLAccountNo);        PurchaseLine.Validate(Description, InvoiceChargeReason);        PurchaseLine.Validate(Quantity, 1);        PurchaseLine.Validate("Direct Unit Cost", InvoiceChargeAmount);        PurchaseLine.Modify(true);    end;    local procedure SetLineMandatoryFields(var RecRef: RecordRef; DataExchNo: Integer; ParentRecNo: Integer; RecordNo: Integer)    var        IntermediateDataImport: Record "Intermediate Data Import";        PurchaseLine: Record "Purchase Line";        FldNo: Integer;        Type: Option;    begin        IntermediateDataImport.SetRange("Data Exch. No.", DataExchNo);        IntermediateDataImport.SetRange("Table ID", DATABASE::"Purchase Line");        IntermediateDataImport.SetRange("Parent Record No.", ParentRecNo);        IntermediateDataImport.SetRange("Record No.", RecordNo);        // Type        FldNo := PurchaseLine.FieldNo(Type);        Evaluate(Type, GetValueFromIntermediate(IntermediateDataImport, RecRef, FldNo, PurchaseLine.FieldCaption(Type)));        ProcessField(TempProcessedLineFldId, RecRef, FldNo, Format(Type));        if Type <> 0 then begin            // No.            FldNo := PurchaseLine.FieldNo("No.");            ProcessField(TempProcessedLineFldId, RecRef, FldNo,              GetValueFromIntermediate(IntermediateDataImport, RecRef, FldNo, PurchaseLine.FieldCaption("No.")));            // Quantity            FldNo := PurchaseLine.FieldNo(Quantity);            ProcessField(TempProcessedLineFldId, RecRef, FldNo,              GetValueFromIntermediate(IntermediateDataImport, RecRef, FldNo, PurchaseLine.FieldCaption(Quantity)));            // UOM            FldNo := PurchaseLine.FieldNo("Unit of Measure Code");            if TryGetValueFromIntermediate(IntermediateDataImport, RecRef, FldNo, PurchaseLine.FieldCaption("Unit of Measure Code"), IntermediateDataImport.Value) then                ProcessField(TempProcessedLineFldId, RecRef, FldNo, IntermediateDataImport.Value);            // Direct Unit Cost            FldNo := PurchaseLine.FieldNo("Direct Unit Cost");            ProcessField(TempProcessedLineFldId, RecRef, FldNo,              GetValueFromIntermediate(IntermediateDataImport, RecRef, FldNo, PurchaseLine.FieldCaption("Direct Unit Cost")));        end;        RecRef.Modify(true);    end;    procedure GetValueFromIntermediate(var IntermediateDataImport: Record "Intermediate Data Import"; RecRef: RecordRef; FieldID: Integer; FieldName: Text): Text[250]    var        Value: Text[250];    begin        TryGetValueFromIntermediate(IntermediateDataImport, RecRef, FieldID, FieldName, Value);        exit(Value);    end;    [TryFunction]    local procedure TryGetValueFromIntermediate(var IntermediateDataImport: Record "Intermediate Data Import"; RecRef: RecordRef; FieldID: Integer; FieldName: Text; var Value: Text[250])    begin        Value := '';        IntermediateDataImport.SetRange("Field ID", FieldID);        if not IntermediateDataImport.FindFirst() then            Error(NotFoundErr, FieldName, RecRef.Caption, IntermediateDataImport.TableCaption());        Value := IntermediateDataImport.Value;    end;    procedure ProcessField(var TempInt: Record "Integer"; RecRef: RecordRef; FieldNo: Integer; Value: Text[250])    var        FieldRef: FieldRef;    begin        FieldRef := RecRef.Field(FieldNo);        SetFieldValue(FieldRef, Value);        SetFieldProcessed(TempInt, FieldNo);    end;    local procedure ProcessFieldNoValidate(var TempInt: Record "Integer"; RecRef: RecordRef; FieldNo: Integer; Value: Text[250])    var        FieldRef: FieldRef;    begin        FieldRef := RecRef.Field(FieldNo);        FieldRef.Value(Value);        SetFieldProcessed(TempInt, FieldNo);    end;    local procedure SetFieldProcessed(var TempInt: Record "Integer"; FieldID: Integer)    begin        Clear(TempInt);        TempInt.Number := FieldID;        TempInt.Insert();    end;    procedure IsFieldProcessed(var TempInt: Record "Integer"; FieldID: Integer): Boolean    begin        TempInt.Reset();        TempInt.SetRange(Number, FieldID);        exit(TempInt.FindFirst());    end;    local procedure CorrelateCreatedDocumentWithRecordNo(RecRef: RecordRef; RecordNo: Integer)    begin        TempNameValueBufferPurchHdr.Init();        TempNameValueBufferPurchHdr.ID := RecordNo;        TempNameValueBufferPurchHdr.Name := Format(RecordNo);        TempNameValueBufferPurchHdr.Value := Format(RecRef.RecordId);        TempNameValueBufferPurchHdr.Insert();    end;    local procedure GetRelatedPurchaseHeader(var PurchaseHeader: Record "Purchase Header"; RecordNo: Integer)    var        RecId: RecordID;    begin        TempNameValueBufferPurchHdr.Get(RecordNo);        Evaluate(RecId, Format(TempNameValueBufferPurchHdr.Value));        PurchaseHeader.Get(RecId);    end;    local procedure CorrelateCreatedPurchLineWithRecordNo(RecRef: RecordRef; "Key": Text[250])    var        ID: Integer;    begin        Clear(TempNameValueBufferPurchLine);        ID := 1;        if TempNameValueBufferPurchLine.FindLast() then            ID := TempNameValueBufferPurchLine.ID + 1;        TempNameValueBufferPurchLine.Init();        TempNameValueBufferPurchLine.ID := ID;        TempNameValueBufferPurchLine.Name := Key;        TempNameValueBufferPurchLine.Value := Format(RecRef.RecordId);        TempNameValueBufferPurchLine.Insert();    end;    local procedure GetRelatedPurchaseLine(var PurchaseLine: Record "Purchase Line"; "Key": Text[250])    var        RecId: RecordID;    begin        TempNameValueBufferPurchLine.Reset();        TempNameValueBufferPurchLine.SetRange(Name, Key);        TempNameValueBufferPurchLine.FindFirst();        Evaluate(RecId, Format(TempNameValueBufferPurchLine.Value));        PurchaseLine.Get(RecId);    end;    local procedure ComposeKeyForCreatedPurchLine(ParentRecNo: Integer; RecNo: Integer): Text[250]    begin        exit(Format(ParentRecNo) + '_' + Format(RecNo));    end;    local procedure GetPrepaidAmount(DataExch: Record "Data Exch."; RecordNo: Integer): Decimal    var        IntermediateDataImport: Record "Intermediate Data Import";        PrepaymentInvLineBuffer: Record "Prepayment Inv. Line Buffer";        Amount: Decimal;    begin        Amount := 0;        IntermediateDataImport.SetRange("Data Exch. No.", DataExch."Entry No.");        IntermediateDataImport.SetRange("Table ID", DATABASE::"Prepayment Inv. Line Buffer");        IntermediateDataImport.SetRange("Field ID", PrepaymentInvLineBuffer.FieldNo(Amount));        IntermediateDataImport.SetRange("Record No.", RecordNo);        if IntermediateDataImport.FindFirst() then            Evaluate(Amount, IntermediateDataImport.Value, 9);        exit(Amount);    end;    local procedure GetInvoiceChargeReason(IntermediateDataImport: Record "Intermediate Data Import"): Text[100]    var        IntermediateDataImport2: Record "Intermediate Data Import";        ItemCharge: Record "Item Charge";        PlaceholderPurchaseLine: Record "Purchase Line";        ErrorMessage: Record "Error Message";    begin        IntermediateDataImport2.SetRange("Data Exch. No.", IntermediateDataImport."Data Exch. No.");        IntermediateDataImport2.SetRange("Table ID", DATABASE::"Item Charge");        IntermediateDataImport2.SetRange("Field ID", ItemCharge.FieldNo(Description));        IntermediateDataImport2.SetRange("Record No.", IntermediateDataImport."Record No.");        IntermediateDataImport2.SetRange("Parent Record No.", 0);        IntermediateDataImport2.SetFilter(Value, '<>%1', '');        if IntermediateDataImport2.FindFirst() then            exit(CopyStr(IntermediateDataImport2.Value, 1, MaxStrLen(PlaceholderPurchaseLine.Description)));        LogMessage(          IntermediateDataImport."Data Exch. No.",          PlaceholderPurchaseLine,          PlaceholderPurchaseLine.FieldNo(Description),          ErrorMessage."Message Type"::Error,          InvoiceChargeHasNoReasonErr);    end;    local procedure LogMessage(EntryNo: Integer; RelatedRec: Variant; FieldNo: Integer; MessageType: Option; ProcessingMessage: Text)    var        DataExch: Record "Data Exch.";        ErrorMessage: Record "Error Message";        IncomingDocument: Record "Incoming Document";    begin        DataExch.Get(EntryNo);        IncomingDocument.Get(DataExch."Incoming Entry No.");        if IncomingDocument."Created Doc. Error Msg. Type" = IncomingDocument."Created Doc. Error Msg. Type"::Error then            MessageType := ErrorMessage."Message Type"::Error;        ErrorMessage.SetContext(IncomingDocument);        ErrorMessage.LogMessage(RelatedRec, FieldNo,          MessageType, CopyStr(ProcessingMessage, 1, MaxStrLen(ErrorMessage."Message")));    end;    local procedure DeleteIntermediateData(DataExch: Record "Data Exch.")    var        DataExchField: Record "Data Exch. Field";        IntermediateDataImport: Record "Intermediate Data Import";    begin        DataExchField.SetRange("Data Exch. No.", DataExch."Entry No.");        DataExchField.DeleteAll();        IntermediateDataImport.SetRange("Data Exch. No.", DataExch."Entry No.");        IntermediateDataImport.DeleteAll();    end;    local procedure InsertEmptyPurchaseLine(PurchaseHeader: Record "Purchase Header"; var PurchaseLine: Record "Purchase Line")    var        LineNo: Integer;    begin        Clear(PurchaseLine);        PurchaseLine.Validate("Document Type", PurchaseHeader."Document Type");        PurchaseLine.Validate("Document No.", PurchaseHeader."No.");        LineNo := 10000;        PurchaseLine.SetRecFilter();        LineNo := LineNo + GetLastLineNo(PurchaseHeader);        PurchaseLine.Validate("Line No.", LineNo);        PurchaseLine.Insert(true);    end;    local procedure GetLastLineNo(PurchaseHeader: Record "Purchase Header"): Integer    var        PurchLine: Record "Purchase Line";    begin        PurchLine.SetRange("Document Type", PurchaseHeader."Document Type");        PurchLine.SetRange("Document No.", PurchaseHeader."No.");        if PurchLine.FindLast() then            exit(PurchLine."Line No.");    end;    [IntegrationEvent(false, false)]    local procedure OnAfterProcessLines(PurchaseHeader: Record "Purchase Header"; DataExch: Record "Data Exch."; ParentRecordNo: Integer)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeProcessIntermediateData(DataExch: Record "Data Exch.")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCreateNewPurchHdrOnBeforeRecRefInsert(var RecRef: RecordRef; var IntermediateDataImport: Record "Intermediate Data Import")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnProcessLinesIntermediateDataImportNotFound(var DataExch: Record "Data Exch."; var PurchaseHeader: Record "Purchase Header"; ParentRecordNo: Integer)    begin    end;}