Codeunit 6232 E-Doc. MLLM Schema Helper

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

src/Apps/W1/EDocument/App/src/Processing/Import/StructureReceivedEDocument/EDocMLLMSchemaHelper.Codeunit.al367 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.Import;using Microsoft.eServices.EDocument;using Microsoft.eServices.EDocument.Processing.Import.Purchase;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Foundation.Company;codeunit 6232 "E-Doc. MLLM Schema Helper"{    Access = Internal;    InherentEntitlements = X;    InherentPermissions = X;    procedure GetDefaultSchema() Value: Text    var        DefaultSchemaFileLbl: Label 'AITools/ubl_example.json', Locked = true;        SchemaJson: JsonObject;    begin        SchemaJson := NavApp.GetResourceAsJson(DefaultSchemaFileLbl, TextEncoding::UTF8);        PrefillCustomerFromCompanyInfo(SchemaJson);        SchemaJson.WriteTo(Value);    end;    local procedure PrefillCustomerFromCompanyInfo(var SchemaJson: JsonObject)    var        CompanyInformation: Record "Company Information";        CustomerPartyObj: JsonObject;        PartyObj: JsonObject;        PartyNameObj: JsonObject;        PostalAddressObj: JsonObject;        CountryObj: JsonObject;        TaxSchemeObj: JsonObject;        PartyTaxSchemeObj: JsonObject;    begin        if not CompanyInformation.Get() then            exit;        PartyNameObj.Add('name', CompanyInformation.Name);        CountryObj.Add('identification_code', CompanyInformation."Country/Region Code");        PostalAddressObj.Add('street_name', CompanyInformation.Address);        PostalAddressObj.Add('additional_street_name', CompanyInformation."Address 2");        PostalAddressObj.Add('city_name', CompanyInformation.City);        PostalAddressObj.Add('postal_zone', CompanyInformation."Post Code");        PostalAddressObj.Add('country', CountryObj);        TaxSchemeObj.Add('id', 'VAT');        PartyTaxSchemeObj.Add('company_id', CompanyInformation."VAT Registration No.");        PartyTaxSchemeObj.Add('tax_scheme', TaxSchemeObj);        PartyObj.Add('party_name', PartyNameObj);        PartyObj.Add('postal_address', PostalAddressObj);        PartyObj.Add('party_tax_scheme', PartyTaxSchemeObj);        CustomerPartyObj.Add('party', PartyObj);        SchemaJson.Replace('accounting_customer_party', CustomerPartyObj);    end;#pragma warning disable AA0139    procedure MapHeaderFromJson(HeaderObj: JsonObject; var TempHeader: Record "E-Document Purchase Header" temporary)    var        NestedObj: JsonObject;        NestedObj2: JsonObject;        NestedObj3: JsonObject;        CurrencyText: Text;    begin        GetString(HeaderObj, 'id', MaxStrLen(TempHeader."Sales Invoice No."), TempHeader."Sales Invoice No.");        GetDate(HeaderObj, 'issue_date', TempHeader."Document Date");        GetDate(HeaderObj, 'issue_date', TempHeader."Invoice Date");        GetDate(HeaderObj, 'due_date', TempHeader."Due Date");        GetString(HeaderObj, 'document_currency_code', MaxStrLen(TempHeader."Currency Code"), CurrencyText);        SetCurrencyCode(CurrencyText, TempHeader."Currency Code");        if GetNestedObject(HeaderObj, 'order_reference', NestedObj) then            GetString(NestedObj, 'id', MaxStrLen(TempHeader."Purchase Order No."), TempHeader."Purchase Order No.");        if GetNestedObject(HeaderObj, 'payment_terms', NestedObj) then            GetString(NestedObj, 'note', MaxStrLen(TempHeader."Payment Terms"), TempHeader."Payment Terms");        if GetNestedObject(HeaderObj, 'accounting_supplier_party', NestedObj) then            if GetNestedObject(NestedObj, 'party', NestedObj2) then begin                if GetNestedObject(NestedObj2, 'party_name', NestedObj3) then                    GetString(NestedObj3, 'name', MaxStrLen(TempHeader."Vendor Company Name"), TempHeader."Vendor Company Name");                if GetNestedObject(NestedObj2, 'postal_address', NestedObj3) then                    BuildAddress(NestedObj3, MaxStrLen(TempHeader."Vendor Address"), TempHeader."Vendor Address");                if GetNestedObject(NestedObj2, 'party_tax_scheme', NestedObj3) then                    GetString(NestedObj3, 'company_id', MaxStrLen(TempHeader."Vendor VAT Id"), TempHeader."Vendor VAT Id");                if GetNestedObject(NestedObj2, 'contact', NestedObj3) then                    GetString(NestedObj3, 'name', MaxStrLen(TempHeader."Vendor Contact Name"), TempHeader."Vendor Contact Name");            end;        if GetNestedObject(HeaderObj, 'accounting_customer_party', NestedObj) then            if GetNestedObject(NestedObj, 'party', NestedObj2) then begin                if GetNestedObject(NestedObj2, 'party_name', NestedObj3) then                    GetString(NestedObj3, 'name', MaxStrLen(TempHeader."Customer Company Name"), TempHeader."Customer Company Name");                if GetNestedObject(NestedObj2, 'postal_address', NestedObj3) then                    BuildAddress(NestedObj3, MaxStrLen(TempHeader."Customer Address"), TempHeader."Customer Address");                if GetNestedObject(NestedObj2, 'party_tax_scheme', NestedObj3) then                    GetString(NestedObj3, 'company_id', MaxStrLen(TempHeader."Customer VAT Id"), TempHeader."Customer VAT Id");            end;        if GetNestedObject(HeaderObj, 'delivery', NestedObj) then begin            if GetNestedObject(NestedObj, 'delivery_location', NestedObj2) then                if GetNestedObject(NestedObj2, 'address', NestedObj3) then                    BuildAddress(NestedObj3, MaxStrLen(TempHeader."Shipping Address"), TempHeader."Shipping Address");            if GetNestedObject(NestedObj, 'delivery_party', NestedObj2) then                if GetNestedObject(NestedObj2, 'party_name', NestedObj3) then                    GetString(NestedObj3, 'name', MaxStrLen(TempHeader."Shipping Address Recipient"), TempHeader."Shipping Address Recipient");        end;        if GetNestedObject(HeaderObj, 'payment_means', NestedObj) then            if GetNestedObject(NestedObj, 'payee_financial_account', NestedObj2) then                GetString(NestedObj2, 'name', MaxStrLen(TempHeader."Remittance Address Recipient"), TempHeader."Remittance Address Recipient");        if GetNestedObject(HeaderObj, 'tax_total', NestedObj) then            GetDecimal(NestedObj, 'tax_amount', TempHeader."Total VAT");        if GetNestedObject(HeaderObj, 'legal_monetary_total', NestedObj) then begin            GetDecimal(NestedObj, 'tax_exclusive_amount', TempHeader."Sub Total");            GetDecimal(NestedObj, 'allowance_total_amount', TempHeader."Total Discount");            GetDecimal(NestedObj, 'payable_amount', TempHeader.Total);            GetDecimal(NestedObj, 'payable_amount', TempHeader."Amount Due");        end;    end;    procedure MapLinesFromJson(LinesArray: JsonArray; EDocEntryNo: Integer; var TempLine: Record "E-Document Purchase Line" temporary; CurrencyCode: Code[10])    var        EDocumentImportHelper: Codeunit "E-Document Import Helper";        LineToken: JsonToken;        LineObj: JsonObject;        NestedObj: JsonObject;        NestedObj2: JsonObject;        LineNumber: Integer;        DiscountPct: Decimal;        RoundingPrecision: Decimal;        QuantityProvided: Boolean;    begin        TempLine.DeleteAll();        RoundingPrecision := EDocumentImportHelper.GetCurrencyRoundingPrecision(CurrencyCode);        for LineNumber := 0 to LinesArray.Count() - 1 do            if LinesArray.Get(LineNumber, LineToken) then begin                Clear(TempLine);                TempLine."E-Document Entry No." := EDocEntryNo;                TempLine."Line No." := 10000 + (LineNumber * 10000);                LineObj := LineToken.AsObject();                if GetNestedObject(LineObj, 'item', NestedObj) then begin                    GetString(NestedObj, 'name', MaxStrLen(TempLine.Description), TempLine.Description);                    if GetNestedObject(NestedObj, 'sellers_item_identification', NestedObj2) then                        GetString(NestedObj2, 'id', MaxStrLen(TempLine."Product Code"), TempLine."Product Code");                    if GetNestedObject(NestedObj, 'classified_tax_category', NestedObj2) then                        GetDecimal(NestedObj2, 'percent', TempLine."VAT Rate");                end;                QuantityProvided := false;                if GetNestedObject(LineObj, 'invoiced_quantity', NestedObj) then begin                    QuantityProvided := GetDecimal(NestedObj, 'value', TempLine.Quantity);                    GetString(NestedObj, 'unit_code', MaxStrLen(TempLine."Unit of Measure"), TempLine."Unit of Measure");                end;                if GetNestedObject(LineObj, 'price', NestedObj) then                    GetDecimal(NestedObj, 'price_amount', TempLine."Unit Price");                GetDecimal(LineObj, 'line_extension_amount', TempLine."Sub Total");                if not QuantityProvided then                    TempLine.Quantity := 1                else                    if TempLine.Quantity < 0 then                        TempLine.Quantity := 0;                if GetNestedObject(LineObj, 'allowance_charge', NestedObj) then begin                    if GetNestedObject(NestedObj, 'amount', NestedObj2) then                        GetDecimal(NestedObj2, 'value', TempLine."Total Discount");                    if TempLine."Total Discount" = 0 then begin                        DiscountPct := 0;                        GetDecimal(NestedObj, 'percent', DiscountPct);                        if DiscountPct <> 0 then                            TempLine."Total Discount" := Round(TempLine."Unit Price" * TempLine.Quantity * DiscountPct / 100, RoundingPrecision);                    end;                end;                TempLine.Insert();            end;    end;#pragma warning restore AA0139    internal procedure GetDocumentTypeCode(SourceJsonObject: JsonObject): Text    var        TypeCode: Text;    begin        GetString(SourceJsonObject, 'invoice_type_code', 10, TypeCode);        exit(DelChr(TypeCode, '<>', ' '));    end;    internal procedure IsCreditNote(SourceJsonObject: JsonObject): Boolean    begin        exit(GetDocumentTypeCode(SourceJsonObject) = CreditNoteTypeCodeTok);    end;    internal procedure GetDocumentTypeCodeForTelemetry(SourceJsonObject: JsonObject): Text    var        TypeCode: Text;    begin        TypeCode := GetDocumentTypeCode(SourceJsonObject);        if TypeCode in [InvoiceTypeCodeTok, CreditNoteTypeCodeTok] then            exit(TypeCode);        if TypeCode = '' then            exit('None');        exit('Other');    end;    internal procedure GetInvoiceReferences(SourceJsonObject: JsonObject; OwnDocumentNo: Text) InvoiceReferences: List of [Text]    var        ReferencesToken: JsonToken;        ReferenceToken: JsonToken;        ReferencesArray: JsonArray;        DocumentReferenceObj: JsonObject;        Reference: Text;    begin        if not SourceJsonObject.Get('billing_reference', ReferencesToken) then            exit;        if ReferencesToken.IsArray() then            ReferencesArray := ReferencesToken.AsArray()        else            if ReferencesToken.IsObject() then                ReferencesArray.Add(ReferencesToken)            else                exit;        foreach ReferenceToken in ReferencesArray do            if ReferenceToken.IsObject() then                if GetNestedObject(ReferenceToken.AsObject(), 'invoice_document_reference', DocumentReferenceObj) then begin                    Clear(Reference);                    GetString(DocumentReferenceObj, 'id', 250, Reference);                    Reference := DelChr(Reference, '<>', ' ');                    if (Reference <> '') and (Reference <> OwnDocumentNo) and not InvoiceReferences.Contains(Reference) then                        InvoiceReferences.Add(Reference);                end;    end;    local procedure GetString(JsonObj: JsonObject; PropertyName: Text; MaxLen: Integer; var FieldValue: Text)    var        JsonToken: JsonToken;        TextValue: Text;    begin        if not JsonObj.Get(PropertyName, JsonToken) then            exit;        if JsonToken.AsValue().IsNull() then            exit;        TextValue := JsonToken.AsValue().AsText();        if StrLen(TextValue) > MaxLen then            TextValue := CopyStr(TextValue, 1, MaxLen);        FieldValue := TextValue;    end;    local procedure GetDate(JsonObj: JsonObject; PropertyName: Text; var FieldValue: Date)    var        JsonToken: JsonToken;        DateText: Text;        DateValue: Date;    begin        if not JsonObj.Get(PropertyName, JsonToken) then            exit;        if JsonToken.AsValue().IsNull() then            exit;        DateText := JsonToken.AsValue().AsText();        if DateText = '' then            exit;        if Evaluate(DateValue, DateText, 9) then            FieldValue := DateValue;    end;    local procedure GetDecimal(JsonObj: JsonObject; PropertyName: Text; var FieldValue: Decimal): Boolean    var        JsonToken: JsonToken;        DecimalValue: Decimal;        DecimalParseFailedLbl: Label 'Could not parse decimal value returned by the model for property %1.', Comment = '%1 = JSON property name';    begin        if not JsonObj.Get(PropertyName, JsonToken) then            exit(false);        if JsonToken.AsValue().IsNull() then            exit(false);        if Evaluate(DecimalValue, JsonToken.AsValue().AsText(), 9) then begin            FieldValue := DecimalValue;            exit(true);        end;        Session.LogMessage('0000UAR', StrSubstNo(DecimalParseFailedLbl, PropertyName), Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::All, 'Category', 'E-Document');        exit(false);    end;    local procedure GetNestedObject(JsonObj: JsonObject; PropertyName: Text; var NestedObj: JsonObject): Boolean    var        JsonToken: JsonToken;    begin        if not JsonObj.Get(PropertyName, JsonToken) then            exit(false);        if not JsonToken.IsObject() then            exit(false);        NestedObj := JsonToken.AsObject();        exit(true);    end;    local procedure BuildAddress(PostalAddressObj: JsonObject; MaxLen: Integer; var FieldValue: Text)    var        CountryObj: JsonObject;        Street: Text;        AdditionalStreet: Text;        City: Text;        PostalZone: Text;        CountryCode: Text;        Address: Text;    begin        GetString(PostalAddressObj, 'street_name', 250, Street);        GetString(PostalAddressObj, 'additional_street_name', 250, AdditionalStreet);        GetString(PostalAddressObj, 'city_name', 250, City);        GetString(PostalAddressObj, 'postal_zone', 250, PostalZone);        if GetNestedObject(PostalAddressObj, 'country', CountryObj) then            GetString(CountryObj, 'identification_code', 250, CountryCode);        Address := Street;        AppendToAddress(Address, AdditionalStreet, ', ');        AppendToAddress(Address, City, ', ');        AppendToAddress(Address, PostalZone, ' ');        AppendToAddress(Address, CountryCode, ', ');        if StrLen(Address) > MaxLen then            Address := CopyStr(Address, 1, MaxLen);        FieldValue := Address;    end;    local procedure AppendToAddress(var Address: Text; Part: Text; Separator: Text)    begin        if Part = '' then            exit;        if Address <> '' then            Address += Separator;        Address += Part;    end;    local procedure SetCurrencyCode(CurrencyText: Text; var CurrencyCode: Code[10])    var        GeneralLedgerSetup: Record "General Ledger Setup";    begin        if CurrencyText = '' then            exit;        GeneralLedgerSetup.Get();        if UpperCase(CurrencyText) = GeneralLedgerSetup."LCY Code" then            exit;        CurrencyCode := CopyStr(UpperCase(CurrencyText), 1, MaxStrLen(CurrencyCode));    end;    var        CreditNoteTypeCodeTok: Label '381', Locked = true;        InvoiceTypeCodeTok: Label '380', Locked = true;}