Codeunit 6126 E-Doc. GL Account Matching

E-Document Core, Microsoft.eServices.EDocument.Processing.AI

src/Apps/W1/EDocument/App/src/Processing/AI/Tools/EDocGLAccountMatching.Codeunit.al298 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.eServices.EDocument.Processing.AI;using Microsoft.eServices.EDocument.Processing.Import;using Microsoft.eServices.EDocument.Processing.Import.Purchase;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Foundation.Company;using Microsoft.Purchases.Vendor;using System.AI;using System.Azure.KeyVault;using System.Log;using System.Telemetry;codeunit 6126 "E-Doc. GL Account Matching" implements "AOAI Function", IEDocAISystem{    Access = Internal;    TableNo = "E-Document Purchase Line";    InherentEntitlements = X;    InherentPermissions = X;    EventSubscriberInstance = Manual;    trigger OnRun()    var        GLAccount: Record "G/L Account";        TempEDocLineMatchBuffer: Record "EDoc Line Match Buffer" temporary;        EDocumentAIProcessor: Codeunit "E-Doc. AI Tool Processor";        EDocActivityLogBuilder: Codeunit "Activity Log Builder";        Response: Codeunit "AOAI Operation Response";        FunctionResponse: Codeunit "AOAI Function Response";        FeatureTelemetry: Codeunit "Feature Telemetry";        EDocImpSessionTelemetry: Codeunit "E-Doc. Imp. Session Telemetry";        RecordRef: RecordRef;        MistakesCount: Integer;        MatchedCount: Integer;        TelemetryDimensions: Dictionary of [Text, Text];        ActivityLogTitleTxt: Label 'GL Account %1', Comment = '%1 = G/L Account No.';        AIAccountMatchEventTok: Label 'GL Account AI Match', Locked = true;    begin        if GLAccount.IsEmpty() then            exit;        if not EDocumentAIProcessor.Setup(this) then            exit;        if not EDocumentAIProcessor.Process(CreateUserMessage(Rec), Response) then            exit;        foreach FunctionResponse in Response.GetFunctionResponses() do begin            TempEDocLineMatchBuffer := FunctionResponse.GetResult();            OnGetGLAccountMatchFunctionResponse(TempEDocLineMatchBuffer);            if not Rec.Get(Rec."E-Document Entry No.", TempEDocLineMatchBuffer."Line No.") then begin                MistakesCount += 1;                continue;            end;            if TryValidateGLAccountNo(Rec, TempEDocLineMatchBuffer."GL Account No.") then begin                if not GLAccount.Get(TempEDocLineMatchBuffer."GL Account No.") then begin                    MistakesCount += 1;                    continue;                end;                MatchedCount += 1;                Rec.Modify(true);                RecordRef.GetTable(GLAccount);                EDocActivityLogBuilder                    .Init(Database::"E-Document Purchase Line", Rec.FieldNo("[BC] Purchase Type No."), Rec.SystemId)                    .SetExplanation(TempEDocLineMatchBuffer."GL Account Reason")                    .SetConfidence(GetConfidenceForNumberOfProposedAccounts(TempEDocLineMatchBuffer."GL Account Candidate Count"))                    .SetType(Enum::"Activity Log Type"::"AI")                    .SetReferenceSource(Page::"G/L Account Card", RecordRef)                    .SetReferenceTitle(StrSubstNo(ActivityLogTitleTxt, Rec."[BC] Purchase Type No."))                    .Log();                EDocImpSessionTelemetry.SetLineBool(Rec.SystemId, AIAccountMatchEventTok, true);            end;        end;        TelemetryDimensions.Add('Total lines', Format(Rec.Count()));        TelemetryDimensions.Add('Proposed accounts', Format(Response.GetFunctionResponses().Count));        TelemetryDimensions.Add('Matched accounts', Format(MatchedCount));        TelemetryDimensions.Add('Processing mistakes', Format(MistakesCount));        FeatureTelemetry.LogUsage('0000PUN', EDocumentAIProcessor.GetEDocumentMatchingAssistanceName(), GetFeatureName(), TelemetryDimensions);    end;    [TryFunction]    local procedure TryValidateGLAccountNo(var EDocumentPurchaseLine: Record "E-Document Purchase Line"; ValueSuggested: Code[20])    begin        EDocumentPurchaseLine."[BC] Purchase Line Type" := EDocumentPurchaseLine."[BC] Purchase Line Type"::"G/L Account";        EDocumentPurchaseLine.Validate("[BC] Purchase Type No.", ValueSuggested);    end;    /// <summary>    /// Gets confidence score based on number of proposed accounts.    /// If only one account is proposed, confidence is set to 2 (medium).    /// If more than one account is proposed, confidence is set to 3 (low).    /// </summary>    /// <param name="NumberOfProposedAccounts"></param>    /// <returns></returns>    local procedure GetConfidenceForNumberOfProposedAccounts(NumberOfProposedAccounts: Integer): Text    begin        exit(NumberOfProposedAccounts <= 1 ? 'Medium' : 'Low');    end;    local procedure CreateUserMessage(var EDocumentPurchaseLine: Record "E-Document Purchase Line"): Text    var        EDocumentPurchaseHeader: Record "E-Document Purchase Header";        Vendor: Record Vendor;        UserMessage: JsonArray;        UserMessageTxt: Text;    begin        if EDocumentPurchaseLine.FindFirst() then;        EDocumentPurchaseHeader.SetRange("E-Document Entry No.", EDocumentPurchaseLine."E-Document Entry No.");        if EDocumentPurchaseHeader.FindFirst() then            if Vendor.Get(EDocumentPurchaseHeader."[BC] Vendor No.") then;        UserMessage.Add(BuildContext(Vendor));        UserMessage.Add(BuildGLAccounts());        UserMessage.Add(BuildEDocumentPurchaseLines(EDocumentPurchaseLine));        UserMessage.WriteTo(UserMessageTxt);        OnUserMessageCreated(UserMessageTxt);        exit(UserMessageTxt);    end;    procedure BuildContext(Vendor: Record Vendor) Context: JsonObject    var        CompanyInformation: Record "Company Information";    begin        CompanyInformation.Get();        Context.Add('companyName', CompanyInformation.Name);        Context.Add('companyCountry', CompanyInformation."Country/Region Code");        if CompanyInformation.County <> '' then            Context.Add('companyCountyState', CompanyInformation.County);        if Vendor."No." <> '' then begin            Context.Add('vendorName', Vendor.Name);            Context.Add('vendorCountry', Vendor."Country/Region Code");            if Vendor.County <> '' then                Context.Add('vendorCountyState', Vendor.County);        end;    end;    procedure BuildGLAccounts() GLAccounts: JsonObject    var        GLAccount: Record "G/L Account";        JsonObject: JsonObject;        GLAccountArray: JsonArray;    begin        GLAccount.SetRange("Direct Posting", true);        GLAccount.SetRange("Account Type", GLAccount."Account Type"::"Posting");        GLAccount.SetAutoCalcFields("Account Subcategory Descript.");        if GLAccount.FindSet() then            repeat                Clear(JsonObject);                JsonObject.Add('accountNumber', GLAccount."No.");                JsonObject.Add('chartOfAccountName', BuildGLAccountName(GLAccount));                JsonObject.Add('accountPostingType', Format(GLAccount."Gen. Posting Type"));                JsonObject.Add('accountCategory', Format(GLAccount."Account Category"));                if GLAccount."Account Subcategory Entry No." <> 0 then                    JsonObject.Add('accountSubcategory', GLAccount."Account Subcategory Descript.");                GLAccountArray.Add(JsonObject);            until (GLAccount.Next() = 0);        GLAccounts.Add('chartOfAccounts', GLAccountArray);    end;    local procedure BuildGLAccountName(GLAccount: Record "G/L Account") Name: Text    var        GLAccount2: Record "G/L Account";        I, CurrentIndentation : Integer;        Categories: List of [Text];    begin        GLAccount2.SetCurrentKey("No.");        GlAccount2.SetAscending("No.", false);        GLAccount2.SetFilter("No.", '<%1', GLAccount."No.");        GlAccount2.SetFilter(Indentation, '<%1', GLAccount.Indentation);        CurrentIndentation := GLAccount.Indentation;        if GLAccount2.FindSet() then            repeat                if GLAccount2.Indentation < CurrentIndentation then                    Categories.Add(GLAccount2.Name);                CurrentIndentation := GLAccount2.Indentation;                if CurrentIndentation = 0 then                    break;            until GLAccount2.Next() = 0;        for I := Categories.Count() downto 1 do            Name += Categories.Get(I) + ' > ';        Name += GLAccount.Name;    end;    local procedure BuildEDocumentPurchaseLines(var EDocumentPurchaseLine: Record "E-Document Purchase Line") EDocumentPurchaseLinesJson: JsonObject    var        JsonObject: JsonObject;        EDocumentPurchaseLineArray: JsonArray;    begin        EDocumentPurchaseLine.Ascending(true);        if EDocumentPurchaseLine.FindSet() then            repeat                Clear(JsonObject);                JsonObject.Add('lineId', EDocumentPurchaseLine."Line No.");                JsonObject.Add('lineDescription', EDocumentPurchaseLine.Description);                JsonObject.Add('unitPrice', EDocumentPurchaseLine."Unit Price");                EDocumentPurchaseLineArray.Add(JsonObject);            until EDocumentPurchaseLine.Next() = 0;        EDocumentPurchaseLinesJson.Add('purchaseLinesToMatch', EDocumentPurchaseLineArray);    end;    #region "AOAI Function" interface implementation    procedure GetPrompt(): JsonObject    var        ToolDefinition: JsonObject;        FunctionDefinition: JsonObject;        ParametersDefinition: JsonObject;        FunctionDescriptionTok: Label 'Matches invoice lines with G/L Accounts.', Locked = true;    begin        ParametersDefinition.ReadFrom(NavApp.GetResourceAsText('AITools/GLAccountClassifier-ToolDef.txt'));        FunctionDefinition.Add('name', GetName());        FunctionDefinition.Add('description', FunctionDescriptionTok);        FunctionDefinition.Add('parameters', ParametersDefinition);        ToolDefinition.Add('type', 'function');        ToolDefinition.Add('function', FunctionDefinition);        exit(ToolDefinition);    end;    procedure Execute(Arguments: JsonObject): Variant    var        TempEDocMatchLineBuffer: Record "EDoc Line Match Buffer";    begin        TempEDocMatchLineBuffer."Line No." := Arguments.GetInteger('lineId');        TempEDocMatchLineBuffer."GL Account No." := CopyStr(Arguments.GetText('accountId'), 1, MaxStrLen(TempEDocMatchLineBuffer."GL Account No."));        TempEDocMatchLineBuffer."GL Account Reason" := CopyStr(Arguments.GetText('reasoning'), 1, MaxStrLen(TempEDocMatchLineBuffer."GL Account Reason"));        TempEDocMatchLineBuffer."GL Account Candidate Count" := Arguments.GetInteger('totalNumberOfPotentialAccounts');        exit(TempEDocMatchLineBuffer);    end;    procedure GetName(): Text    begin        exit('match_gl_account');    end;    #endregion "AOAI Function" interface implementation    #region "E-Document AI System" interface implementation    procedure GetSystemPrompt(UserLanguage: Text): SecretText    var        AzureKeyVault: Codeunit "Azure Key Vault";        SecurityPromptSecretText, CompletePromptSecretText : SecretText;        GLAccountMatchingPromptText: Text;        GLAccountMatchingPromptTok: Label 'Prompts/GLAccountMatching-SystemPrompt.md', Locked = true;        SecurityPromptTok: Label 'GLAccountMatching-SecurityPrompt', Locked = true;    begin        GLAccountMatchingPromptText := NavApp.GetResourceAsText(GLAccountMatchingPromptTok, TextEncoding::UTF8);        if AzureKeyVault.GetAzureKeyVaultSecret(SecurityPromptTok, SecurityPromptSecretText) then            CompletePromptSecretText := SecretText.SecretStrSubstNo(GLAccountMatchingPromptText, SecurityPromptSecretText, UserLanguage)        else begin            Session.LogMessage('0000QPZ', 'Failed to retrieve security prompt', Verbosity::Error, DataClassification::SystemMetadata, TelemetryScope::All, 'Category', GetFeatureName());            CompletePromptSecretText := SecretStrSubstNo('');        end;        exit(CompletePromptSecretText);    end;    procedure GetTools(): List of [Interface "AOAI Function"]    var        List: List of [Interface "AOAI Function"];    begin        List.Add(this);        exit(List);    end;    procedure GetFeatureName(): Text    begin        exit('EDocument GL Account Matching')    end;    #endregion "E-Document AI System" interface implementation    [IntegrationEvent(false, false)]    local procedure OnGetGLAccountMatchFunctionResponse(TempEDocMatchLineBuffer: Record "EDoc Line Match Buffer" temporary)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnUserMessageCreated(UserMessageTxt: Text)    begin    end;}