Codeunit 108 Net Cust/Vend Balances Mgt.

Base Application, Microsoft.Finance.ReceivablesPayables

src/Layers/W1/BaseApp/Finance/ReceivablesPayables/NetCustVendBalancesMgt.Codeunit.al646 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.Finance.ReceivablesPayables;using Microsoft.Finance.GeneralLedger.Journal;using Microsoft.Purchases.Payables;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Customer;using Microsoft.Sales.Receivables;/// <summary>/// Manages the netting of customer and vendor balances for linked business partners./// Calculates net amounts, creates offsetting journal entries, and handles application logic./// </summary>/// <remarks>/// Core processing engine for Net Customer/Vendor Balances functionality./// Identifies customer-vendor relationships, calculates remaining amounts, and generates journal entries./// Provides extensibility through integration events for custom processing logic./// </remarks>codeunit 108 "Net Cust/Vend Balances Mgt."{    var        NetBalancesParameters: Record "Net Balances Parameters";        GenJnlBatch: Record "Gen. Journal Batch";        GenJnlTemplate: Record "Gen. Journal Template";        VendorGenJnlLine: Record "Gen. Journal Line";        CustomerGenJnlLine: Record "Gen. Journal Line";        GlobalCustLedgEntry: Record "Cust. Ledger Entry";        GlobalVendLedgEntry: Record "Vendor Ledger Entry";        Window: Dialog;        NetAmount: Decimal;        FirstLineNo: Integer;        LastLineNo: Integer;        IncreaseDocNo: Boolean;        ProcessingMsg: Label 'Processing vendors #1########## @2@@@@@@@@@@@@@', Comment = '#1 - vendor code, @2 - processing bar';        DuplicateLineExistsErr: Label 'There is the duplicate journal line in journal template name %2, journal batch name %3, document number %1 applied to %4 %5.',            Comment = '%1 - document no., %2 - template name, %3 - batch name, %4 - document type, %5 - document no.';        CustomerBlockedErr: Label 'Customer %1 is blocked', Comment = '%1 - customer no.';    /// <summary>    /// Processes vendors to identify linked customers and creates netted balance journal entries.    /// Calculates net amounts between customer and vendor balances for the same business partner.    /// </summary>    /// <param name="Vendor">Vendor record set to process for netting operations</param>    /// <param name="NewNetBalancesParameters">Parameters controlling posting date, document numbering, and journal settings</param>    procedure NetCustVendBalances(var Vendor: Record Vendor; NewNetBalancesParameters: Record "Net Balances Parameters")    var        Customer: Record Customer;        VendorCount: Integer;    begin        NetBalancesParameters := NewNetBalancesParameters;        NetBalancesParameters.Verify();        Initialize();        Window.Open(ProcessingMsg);        Vendor.SetLoadFields(Blocked);        if Vendor.FindSet() then            repeat                Window.Update(1, Vendor."No.");                VendorCount := VendorCount + 1;                Window.Update(2, ROUND(VendorCount / Vendor.Count() * 10000, 1));                if FindLinkedCustomer(Vendor, Customer) then                    HandleVendor(Vendor."No.", Customer."No.");            until Vendor.Next() = 0;        Window.Close();    end;    local procedure FindLinkedCustomer(Vendor: Record Vendor; var Customer: Record Customer): Boolean;    var        CustomerNo: Code[20];    begin        CustomerNo := Vendor.GetLinkedCustomer();        if CustomerNo <> '' then begin            Customer.Reset();            Customer.SetLoadFields(Blocked);            Customer.Get(CustomerNo);            if Customer.Blocked = Customer.Blocked::" " then                exit(true)            else                Message(CustomerBlockedErr, Customer."No.");        end;    end;    local procedure Initialize()    var        GenJournalLine: Record "Gen. Journal Line";    begin        GenJournalLine.LockTable();        NetBalancesParameters.TestField("Journal Template Name");        NetBalancesParameters.TestField("Journal Batch Name");        GenJnlTemplate.Get(NetBalancesParameters."Journal Template Name");        GenJnlBatch.Get(NetBalancesParameters."Journal Template Name", NetBalancesParameters."Journal Batch Name");        GenJournalLine.Validate("Journal Template Name", NetBalancesParameters."Journal Template Name");        GenJournalLine.Validate("Journal Batch Name", NetBalancesParameters."Journal Batch Name");        SetGenJnlLine(GenJournalLine);        GenJournalLine.SetRange("Journal Template Name", NetBalancesParameters."Journal Template Name");        GenJournalLine.SetRange("Journal Batch Name", NetBalancesParameters."Journal Batch Name");        if GenJournalLine.FindLast() then begin            FirstLineNo := GenJournalLine."Line No.";            LastLineNo := GenJournalLine."Line No.";        end;        IncreaseDocNo := false;    end;    local procedure HandleVendor(VendorNo: Code[20]; CustomerNo: Code[20])    var        Customer: Record Customer;        VendLedgEntry: Record "Vendor Ledger Entry";        CurrencyCode: Code[10];    begin        if CustomerNo <> '' then begin            Customer.Get(CustomerNo);            if FindVendLedgEntries(VendorNo, VendLedgEntry) then begin                CurrencyCode := VendLedgEntry."Currency Code";                repeat                    if CurrencyCode <> VendLedgEntry."Currency Code" then                        NetCustVendBalances(VendorNo, CustomerNo, CurrencyCode);                    CurrencyCode := VendLedgEntry."Currency Code";                until VendLedgEntry.Next() = 0;                NetCustVendBalances(VendorNo, CustomerNo, CurrencyCode);                if IncreaseDocNo then begin                    NetBalancesParameters."Document No." := INCSTR(NetBalancesParameters."Document No.");                    IncreaseDocNo := false;                end;            end;        end;    end;    local procedure SetNetAmount(VendorNo: Code[20]; CustomerNo: Code[20]; CurrencyCode: Code[10]);    var        VendorRemainingAmount: Decimal;        CustomerRemainingAmount: Decimal;    begin        NetAmount := 0;        VendorRemainingAmount := SumVendorRemainingAmount(VendorNo, CurrencyCode);        if VendorRemainingAmount < 0 then begin            CustomerRemainingAmount := SumCustomerRemainingAmount(CustomerNo, CurrencyCode);            if CustomerRemainingAmount > 0 then                NetAmount := MinDec(CustomerRemainingAmount, -VendorRemainingAmount);        end;    end;    local procedure NetCustVendBalances(VendorNo: Code[20]; CustomerNo: Code[20]; CurrencyCode: Code[10]);    var        VendLedgEntry: Record "Vendor Ledger Entry";        CustLedgEntry: Record "Cust. Ledger Entry";        VendDocNetAmount: Decimal;        CustDocNetAmount: Decimal;        VendNetAmount: Decimal;        CustNetAmount: Decimal;        SmallerNetAmount: Decimal;        VendorRemainingAmount: Decimal;        CustomerRemainingAmount: Decimal;    begin        SetNetAmount(VendorNo, CustomerNo, CurrencyCode);        if NetAmount > 0 then begin            if not IncreaseDocNo then                IncreaseDocNo := true;            GlobalVendLedgEntry.SetRange(Positive, false);            GlobalCustLedgEntry.SetRange(Positive, true);            VendLedgEntry.Copy(GlobalVendLedgEntry);            CustLedgEntry.Copy(GlobalCustLedgEntry);            case NetBalancesParameters."Order of Suggestion" of                "Net Cust/Vend Balances Order"::"Fin. Ch. Memo First":                    CalcPartNetAmount(VendLedgEntry, CustLedgEntry, VendDocNetAmount, CustDocNetAmount, "Gen. Journal Document Type"::"Finance Charge Memo");                "Net Cust/Vend Balances Order"::"Invoices First":                    CalcPartNetAmount(VendLedgEntry, CustLedgEntry, VendDocNetAmount, CustDocNetAmount, "Gen. Journal Document Type"::Invoice);                else begin                    GlobalVendLedgEntry.SetCurrentKey("Entry No.");                    GlobalCustLedgEntry.SetCurrentKey("Entry No.");                end;            end;            if NetAmount < VendDocNetAmount then                VendDocNetAmount := NetAmount;            if NetAmount < CustDocNetAmount then                CustDocNetAmount := NetAmount;            VendNetAmount := NetAmount - VendDocNetAmount;            CustNetAmount := NetAmount - CustDocNetAmount;            case true of                (VendDocNetAmount = 0) and (CustDocNetAmount = 0):                    begin                        SmallerNetAmount := MinDec(VendNetAmount, CustNetAmount);                        NetBalances(GlobalVendLedgEntry, GlobalCustLedgEntry, VendorRemainingAmount, CustomerRemainingAmount, SmallerNetAmount);                    end;                (VendDocNetAmount > 0) and (CustDocNetAmount = 0):                    begin                        SmallerNetAmount := MinDec(VendDocNetAmount, CustNetAmount);                        NetBalances(VendLedgEntry, GlobalCustLedgEntry, VendorRemainingAmount, CustomerRemainingAmount, SmallerNetAmount);                        CustNetAmount := CustNetAmount - VendDocNetAmount;                        SmallerNetAmount := MinDec(VendNetAmount, CustNetAmount);                        if SmallerNetAmount > 0 then begin                            VendorRemainingAmount := 0;                            NetBalances(GlobalVendLedgEntry, GlobalCustLedgEntry, VendorRemainingAmount, CustomerRemainingAmount, SmallerNetAmount);                        end;                    end;                (VendDocNetAmount = 0) and (CustDocNetAmount > 0):                    begin                        SmallerNetAmount := MinDec(VendNetAmount, CustDocNetAmount);                        NetBalances(GlobalVendLedgEntry, CustLedgEntry, VendorRemainingAmount, CustomerRemainingAmount, SmallerNetAmount);                        VendNetAmount := VendNetAmount - CustDocNetAmount;                        SmallerNetAmount := MinDec(VendNetAmount, CustNetAmount);                        if SmallerNetAmount > 0 then begin                            CustomerRemainingAmount := 0;                            NetBalances(GlobalVendLedgEntry, GlobalCustLedgEntry, VendorRemainingAmount, CustomerRemainingAmount, SmallerNetAmount);                        end;                    end;                else                    case true of                        VendDocNetAmount > CustDocNetAmount:                            begin                                SmallerNetAmount := CustDocNetAmount;                                NetBalances(VendLedgEntry, CustLedgEntry, VendorRemainingAmount, CustomerRemainingAmount, SmallerNetAmount);                                VendDocNetAmount := VendDocNetAmount - CustDocNetAmount;                                SmallerNetAmount := MinDec(VendDocNetAmount, CustNetAmount);                                if SmallerNetAmount > 0 then begin                                    CustomerRemainingAmount := 0;                                    NetBalances(VendLedgEntry, GlobalCustLedgEntry, VendorRemainingAmount, CustomerRemainingAmount, SmallerNetAmount);                                    CustNetAmount := CustNetAmount - VendDocNetAmount;                                    SmallerNetAmount := MinDec(VendNetAmount, CustNetAmount);                                    if SmallerNetAmount > 0 then begin                                        VendorRemainingAmount := 0;                                        NetBalances(GlobalVendLedgEntry, GlobalCustLedgEntry, VendorRemainingAmount, CustomerRemainingAmount, SmallerNetAmount);                                    end;                                end;                            end;                        VendDocNetAmount < CustDocNetAmount:                            begin                                SmallerNetAmount := VendDocNetAmount;                                NetBalances(VendLedgEntry, CustLedgEntry, VendorRemainingAmount, CustomerRemainingAmount, SmallerNetAmount);                                CustDocNetAmount := CustDocNetAmount - VendDocNetAmount;                                SmallerNetAmount := MinDec(VendNetAmount, CustDocNetAmount);                                if SmallerNetAmount > 0 then begin                                    VendorRemainingAmount := 0;                                    NetBalances(GlobalVendLedgEntry, CustLedgEntry, VendorRemainingAmount, CustomerRemainingAmount, SmallerNetAmount);                                    VendNetAmount := VendNetAmount - CustDocNetAmount;                                    SmallerNetAmount := MinDec(VendNetAmount, CustNetAmount);                                    if SmallerNetAmount > 0 then begin                                        CustomerRemainingAmount := 0;                                        NetBalances(GlobalVendLedgEntry, GlobalCustLedgEntry, VendorRemainingAmount, CustomerRemainingAmount, SmallerNetAmount);                                    end;                                end;                            end;                        else begin                            SmallerNetAmount := VendDocNetAmount;                            NetBalances(VendLedgEntry, CustLedgEntry, VendorRemainingAmount, CustomerRemainingAmount, SmallerNetAmount);                            SmallerNetAmount := MinDec(VendNetAmount, CustNetAmount);                            if SmallerNetAmount > 0 then                                NetBalances(GlobalVendLedgEntry, GlobalCustLedgEntry, VendorRemainingAmount, CustomerRemainingAmount, SmallerNetAmount);                        end;                    end;            end;        end;    end;    local procedure InsertGenJnlLine(var GenJnlLine: Record "Gen. Journal Line"; VendLedgEntry: Record "Vendor Ledger Entry"; CustLedgEntry: Record "Cust. Ledger Entry"; ForVLE: Boolean);    begin        InitGenJnlLine(GenJnlLine, VendLedgEntry);        if ForVLE then            FillGenJnlLineFromVendLedgEntry(GenJnlLine, VendLedgEntry)        else            FillGenJnlLineFromCustledgEntry(GenJnlLine, CustLedgEntry);        FailIfDuplicateLineExists(GenJnlLine);        GenJnlLine.Insert();    end;    local procedure FailIfDuplicateLineExists(GenJournalLine: Record "Gen. Journal Line")    begin        GenJournalLine.SetLoadFields("Document No.");        GenJournalLine.SetRange("Account Type", GenJournalLine."Account Type");        GenJournalLine.SetRange("Account No.", GenJournalLine."Account No.");        GenJournalLine.SetRange("Applies-to Doc. Type", GenJournalLine."Applies-to Doc. Type");        GenJournalLine.SetRange("Applies-to Doc. No.", GenJournalLine."Applies-to Doc. No.");        if GenJournalLine.FindFirst() then            Error(                DuplicateLineExistsErr,                GenJournalLine."Document No.",                GenJournalLine."Journal Template Name", GenJournalLine."Journal Batch Name",                GenJournalLine."Applies-to Doc. Type", GenJournalLine."Applies-to Doc. No.");    end;    local procedure NetBalances(var VendLedgEntry: Record "Vendor Ledger Entry"; var CustLedgEntry: Record "Cust. Ledger Entry"; var VendorRemainingAmount: Decimal; var CustomerRemainingAmount: Decimal; var TempNetAmount: Decimal);    var        MinNetAmount: Decimal;    begin        NetAmount := NetAmount - TempNetAmount;        if VendorRemainingAmount = 0 then            VendLedgEntry.FindFirst();        if CustomerRemainingAmount = 0 then            CustLedgEntry.FindFirst();        repeat            if VendorRemainingAmount <= 0 then begin                SetOnHold(VendLedgEntry);                VendLedgEntry.CalcFields("Remaining Amount");                OnNetBalancesBeforeSetVendorRemainingAmount(VendLedgEntry);                VendorRemainingAmount := -VendLedgEntry."Remaining Amount";                InsertGenJnlLine(VendorGenJnlLine, VendLedgEntry, CustLedgEntry, true);            end;            repeat                if CustomerRemainingAmount <= 0 then begin                    SetOnHold(CustLedgEntry);                    CustLedgEntry.CalcFields("Remaining Amount");                    OnNetBalancesBeforeSetCustomerRemainingAmount(CustLedgEntry);                    CustomerRemainingAmount := CustLedgEntry."Remaining Amount";                end;                MinNetAmount := MinDec(VendorRemainingAmount, CustomerRemainingAmount);                if MinNetAmount > TempNetAmount then                    MinNetAmount := TempNetAmount;                TempNetAmount -= MinNetAmount;                VendorRemainingAmount -= MinNetAmount;                CustomerRemainingAmount -= MinNetAmount;                if CustomerRemainingAmount <= 0 then begin                    InsertGenJnlLine(CustomerGenJnlLine, VendLedgEntry, CustLedgEntry, false);                    CustLedgEntry.Next();                end;                if VendorRemainingAmount <= 0 then                    VendLedgEntry.Next();            until (VendorRemainingAmount <= 0) or (TempNetAmount <= 0);        until (TempNetAmount <= 0);        if (TempNetAmount <= 0) and (NetAmount <= 0) then begin            if VendorRemainingAmount > 0 then begin                VendorGenJnlLine.Validate(Amount, VendorGenJnlLine.Amount - VendorRemainingAmount);                VendorGenJnlLine.Modify();            end;            if CustomerRemainingAmount > 0 then begin                InsertGenJnlLine(CustomerGenJnlLine, VendLedgEntry, CustLedgEntry, false);                CustomerGenJnlLine.Validate(Amount, CustomerGenJnlLine.Amount + CustomerRemainingAmount);                CustomerGenJnlLine.Modify();            end;        end;    end;    /// <summary>    /// Sets the general journal line template for both vendor and customer journal entries.    /// Copies line information to be used for creating netted balance entries.    /// </summary>    /// <param name="NewGenJnlLine">General journal line to use as template for new entries</param>    procedure SetGenJnlLine(NewGenJnlLine: Record "Gen. Journal Line");    begin        VendorGenJnlLine := NewGenJnlLine;        CustomerGenJnlLine := NewGenJnlLine;    end;    local procedure CalcPartNetAmount(var VendLedgEntry: Record "Vendor Ledger Entry"; var CustLedgEntry: Record "Cust. Ledger Entry"; var VendNetAmount: Decimal; var CustNetAmount: Decimal; DocType: Enum "Gen. Journal Document Type");    var        IsHandled: Boolean;    begin        GlobalVendLedgEntry.SetFilter("Document Type", '<>%1', DocType);        GlobalCustLedgEntry.SetFilter("Document Type", '<>%1', DocType);        IsHandled := false;        OnCalcPartNetAmountAfterSetDocumentType(VendLedgEntry, CustLedgEntry, VendNetAmount, CustNetAmount, DocType, IsHandled);        if IsHandled then            exit;        VendLedgEntry.SetRange("Document Type", DocType);        VendLedgEntry.SetAutoCalcFields("Remaining Amount");        if VendLedgEntry.FindSet() then            repeat                VendNetAmount -= VendLedgEntry."Remaining Amount";            until VendLedgEntry.Next() = 0;        CustLedgEntry.SetRange("Document Type", DocType);        CustLedgEntry.SetAutoCalcFields("Remaining Amount");        if CustLedgEntry.FindSet() then            repeat                CustNetAmount += CustLedgEntry."Remaining Amount";            until CustLedgEntry.Next() = 0;    end;    local procedure FillGenJnlLineFromVendLedgEntry(var GenJnlLine: Record "Gen. Journal Line"; var VendLedgEntry: Record "Vendor Ledger Entry")    begin        GenJnlLine."External Document No." := VendLedgEntry."External Document No.";        GenJnlLine."Account Type" := GenJnlLine."Account Type"::Vendor;        GenJnlLine.Validate("Account No.", VendLedgEntry."Vendor No.");        GenJnlLine.Description :=            STRSUBSTNO(                NetBalancesParameters.Description,                NetBalancesParameters."Document No.",                NetBalancesParameters."Posting Date");        GenJnlLine.Validate("Bal. Account No.");        GenJnlLine.Validate("Currency Code", VendLedgEntry."Currency Code");        VendLedgEntry.CalcFields("Remaining Amount");        OnFillGenJnlLineFromVendLedgEntryBeforeValidateAmount(VendLedgEntry);        GenJnlLine.Validate(Amount, -VendLedgEntry."Remaining Amount");        GenJnlLine."Posting Group" := VendLedgEntry."Vendor Posting Group";        GenJnlLine."Applies-to Doc. Type" := VendLedgEntry."Document Type";        GenJnlLine."Applies-to Doc. No." := VendLedgEntry."Document No.";        GenJnlLine."Dimension Set ID" := VendLedgEntry."Dimension Set ID";        OnAfterFillGenJnlLineFromVendLedgEntry(GenJnlLine, VendLedgEntry);    end;    local procedure FillGenJnlLineFromCustledgEntry(var GenJnlLine: Record "Gen. Journal Line"; var CustLedgEntry: Record "Cust. Ledger Entry")    begin        GenJnlLine."External Document No." := CustLedgEntry."Document No.";        GenJnlLine."Account Type" := GenJnlLine."Account Type"::Customer;        GenJnlLine.Validate("Account No.", CustLedgEntry."Customer No.");        GenJnlLine.Description :=            STRSUBSTNO(                NetBalancesParameters.Description,                NetBalancesParameters."Document No.",                NetBalancesParameters."Posting Date");        GenJnlLine.Validate("Bal. Account No.");        GenJnlLine.Validate("Currency Code", CustLedgEntry."Currency Code");        CustLedgEntry.CalcFields("Remaining Amount");        OnFillGenJnlLineFromCustledgEntryBeforeValidateAmount(CustLedgEntry);        GenJnlLine.Validate(Amount, -CustLedgEntry."Remaining Amount");        GenJnlLine."Posting Group" := CustLedgEntry."Customer Posting Group";        GenJnlLine."Applies-to Doc. Type" := CustLedgEntry."Document Type";        GenJnlLine."Applies-to Doc. No." := CustLedgEntry."Document No.";        GenJnlLine."Dimension Set ID" := CustLedgEntry."Dimension Set ID";        OnAfterFillGenJnlLineFromCustLedgEntry(GenJnlLine, CustLedgEntry);    end;    local procedure InitGenJnlLine(var GenJnlLine: Record "Gen. Journal Line"; var VendLedgEntry: Record "Vendor Ledger Entry")    begin        GenJnlLine.Init();        LastLineNo := LastLineNo + 10000;        GenJnlLine."Line No." := LastLineNo;        GenJnlLine.Validate("Posting Date", NetBalancesParameters."Posting Date");        GenJnlLine."Document Type" := "Gen. Journal Document Type"::" ";        GenJnlLine."Posting No. Series" := GenJnlBatch."Posting No. Series";        GenJnlLine."Document No." := NetBalancesParameters."Document No.";        GenJnlLine."Gen. Posting Type" := GenJnlLine."Gen. Posting Type"::" ";        GenJnlLine."Gen. Bus. Posting Group" := '';        GenJnlLine."Gen. Prod. Posting Group" := '';        GenJnlLine."VAT Bus. Posting Group" := '';        GenJnlLine."VAT Prod. Posting Group" := '';        GenJnlLine."Shortcut Dimension 1 Code" := VendLedgEntry."Global Dimension 1 Code";        GenJnlLine."Shortcut Dimension 2 Code" := VendLedgEntry."Global Dimension 2 Code";        GenJnlLine."Source Code" := GenJnlTemplate."Source Code";        GenJnlLine."Reason Code" := GenJnlBatch."Reason Code";        GenJnlLine."On Hold" := NetBalancesParameters."On Hold";        OnAfterInitGenJnlLine(GenJnlLine, VendLedgEntry);    end;    local procedure SetOnHold(var CustLedgEntry: Record "Cust. Ledger Entry")    var        CustEntryEdit: Codeunit "Cust. Entry-Edit";    begin        CustEntryEdit.SetOnHold(CustLedgEntry, NetBalancesParameters."On Hold");    end;    local procedure SetOnHold(var VendorLedgerEntry: Record "Vendor Ledger Entry")    var        VendEntryEdit: Codeunit "Vend. Entry-Edit";    begin        VendEntryEdit.SetOnHold(VendorLedgerEntry, NetBalancesParameters."On Hold");    end;    local procedure MinDec(Decimal1: Decimal; Decimal2: Decimal): Decimal    begin        if Decimal1 < Decimal2 then            exit(Decimal1);        exit(Decimal2);    end;    local procedure SumCustomerRemainingAmount(CustomerNo: Code[20]; CurrencyCode: Code[10]) Result: Decimal    var        IsHandled: Boolean;    begin        GlobalCustLedgEntry.Reset();        GlobalCustLedgEntry.SetLoadFields("Remaining Amount", "On Hold");        GlobalCustLedgEntry.SetRange("Customer No.", CustomerNo);        GlobalCustLedgEntry.SetRange(Open, true);        GlobalCustLedgEntry.SetRange("Currency Code", CurrencyCode);        GlobalCustLedgEntry.SetRange("Posting Date", 0D, NetBalancesParameters."Posting Date");        GlobalCustLedgEntry.SetFilter("On Hold", '%1|%2', '', NetBalancesParameters."On Hold");        IsHandled := false;        OnSumCustomerRemainingAmountBeforeCalcResult(GlobalCustLedgEntry, Result, IsHandled);        if IsHandled then            exit(Result);        GlobalCustLedgEntry.SetAutoCalcFields("Remaining Amount");        if GlobalCustLedgEntry.FindSet() then            repeat                Result += GlobalCustLedgEntry."Remaining Amount";            until GlobalCustLedgEntry.Next() = 0;    end;    local procedure SumVendorRemainingAmount(VendorNo: Code[20]; CurrencyCode: Code[10]) Result: Decimal    var        IsHandled: Boolean;    begin        GlobalVendLedgEntry.Reset();        GlobalVendLedgEntry.SetLoadFields("Remaining Amount", "On Hold");        GlobalVendLedgEntry.SetRange("Vendor No.", VendorNo);        GlobalVendLedgEntry.SetRange(Open, true);        GlobalVendLedgEntry.SetRange("Currency Code", CurrencyCode);        GlobalVendLedgEntry.SetRange("Posting Date", 0D, NetBalancesParameters."Posting Date");        GlobalVendLedgEntry.SetFilter("On Hold", '%1|%2', '', NetBalancesParameters."On Hold");        IsHandled := false;        OnSumVendorRemainingAmountBeforeCalcResult(GlobalVendLedgEntry, Result, IsHandled);        if IsHandled then            exit(Result);        GlobalVendLedgEntry.SetAutoCalcFields("Remaining Amount");        if GlobalVendLedgEntry.FindSet() then            repeat                Result += GlobalVendLedgEntry."Remaining Amount";            until GlobalVendLedgEntry.Next() = 0;    end;    local procedure FindVendLedgEntries(VendorNo: code[20]; var VendLedgEntry: Record "Vendor Ledger Entry"): Boolean    begin        VendLedgEntry.Reset();        VendLedgEntry.SetCurrentKey("Vendor No.", "Currency Code", "Posting Date");        VendLedgEntry.SetRange("Vendor No.", VendorNo);        VendLedgEntry.SetRange(Open, true);        VendLedgEntry.SetRange(Positive, false);        VendLedgEntry.SetRange("Posting Date", 0D, NetBalancesParameters."Posting Date");        VendLedgEntry.SetFilter("On Hold", '%1|%2', '', NetBalancesParameters."On Hold");        exit(VendLedgEntry.FindSet());    end;    /// <summary>    /// Integration event raised after initializing a general journal line from vendor ledger entry data.    /// Enables custom modifications to journal line fields during net balance processing.    /// </summary>    /// <param name="GenJnlLine">General journal line being initialized</param>    /// <param name="VendLedgEntry">Source vendor ledger entry providing data</param>    [IntegrationEvent(false, false)]    local procedure OnAfterInitGenJnlLine(var GenJnlLine: Record "Gen. Journal Line"; VendLedgEntry: Record "Vendor Ledger Entry")    begin    end;    /// <summary>    /// Integration event raised after filling general journal line from customer ledger entry.    /// Allows customization of journal line fields based on customer ledger entry data.    /// </summary>    /// <param name="GenJnlLine">General journal line being populated</param>    /// <param name="CustLedgEntry">Source customer ledger entry providing data</param>    [IntegrationEvent(false, false)]    local procedure OnAfterFillGenJnlLineFromCustLedgEntry(var GenJnlLine: Record "Gen. Journal Line"; CustLedgEntry: Record "Cust. Ledger Entry");    begin    end;    /// <summary>    /// Integration event raised after filling general journal line from vendor ledger entry.    /// Enables modification of journal line fields derived from vendor ledger entry data.    /// </summary>    /// <param name="GenJnlLine">General journal line being populated</param>    /// <param name="VendLedgEntry">Source vendor ledger entry providing data</param>    [IntegrationEvent(false, false)]    local procedure OnAfterFillGenJnlLineFromVendLedgEntry(var GenJnlLine: Record "Gen. Journal Line"; VendLedgEntry: Record "Vendor Ledger Entry");    begin    end;    /// <summary>    /// Integration event raised after calculating partial net amounts and setting document type.    /// Allows custom logic for determining net amounts and handling special document type scenarios.    /// </summary>    /// <param name="VendorLedgerEntry">Vendor ledger entry being processed</param>    /// <param name="CustLedgerEntry">Customer ledger entry being processed</param>    /// <param name="VendNetAmount">Calculated vendor net amount</param>    /// <param name="CustNetAmount">Calculated customer net amount</param>    /// <param name="DocType">Document type for the journal entries</param>    /// <param name="IsHandled">Set to true to skip standard calculation logic</param>    [IntegrationEvent(false, false)]    local procedure OnCalcPartNetAmountAfterSetDocumentType(var VendorLedgerEntry: Record "Vendor Ledger Entry"; var CustLedgerEntry: Record "Cust. Ledger Entry"; var VendNetAmount: Decimal; var CustNetAmount: Decimal; DocType: Enum "Gen. Journal Document Type"; var IsHandled: Boolean)    begin    end;    /// <summary>    /// Integration event raised before validating amount on journal line created from customer ledger entry.    /// Enables custom amount calculation or validation logic for customer entries.    /// </summary>    /// <param name="CustLedgerEntry">Customer ledger entry being processed</param>    [IntegrationEvent(false, false)]    local procedure OnFillGenJnlLineFromCustledgEntryBeforeValidateAmount(var CustLedgerEntry: Record "Cust. Ledger Entry")    begin    end;    /// <summary>    /// Integration event raised before validating amount on journal line created from vendor ledger entry.    /// Allows custom amount calculation or validation logic for vendor entries.    /// </summary>    /// <param name="VendorLedgerEntry">Vendor ledger entry being processed</param>    [IntegrationEvent(false, false)]    local procedure OnFillGenJnlLineFromVendLedgEntryBeforeValidateAmount(var VendorLedgerEntry: Record "Vendor Ledger Entry")    begin    end;    /// <summary>    /// Integration event raised before setting customer remaining amount during net balance processing.    /// Enables custom logic for determining customer remaining amount calculations.    /// </summary>    /// <param name="CustLedgerEntry">Customer ledger entry being evaluated</param>    [IntegrationEvent(false, false)]    local procedure OnNetBalancesBeforeSetCustomerRemainingAmount(var CustLedgerEntry: Record "Cust. Ledger Entry")    begin    end;    /// <summary>    /// Integration event raised before setting vendor remaining amount during net balance processing.    /// Allows custom logic for determining vendor remaining amount calculations.    /// </summary>    /// <param name="VendorLedgerEntry">Vendor ledger entry being evaluated</param>    [IntegrationEvent(false, false)]    local procedure OnNetBalancesBeforeSetVendorRemainingAmount(var VendorLedgerEntry: Record "Vendor Ledger Entry")    begin    end;    /// <summary>    /// Integration event raised before calculating the sum of customer remaining amounts.    /// Enables custom calculation logic for customer remaining amount totals.    /// </summary>    /// <param name="CustLedgerEntry">Customer ledger entry being summed</param>    /// <param name="Result">Calculated result amount</param>    /// <param name="IsHandled">Set to true to use custom calculation result</param>    [IntegrationEvent(false, false)]    local procedure OnSumCustomerRemainingAmountBeforeCalcResult(var CustLedgerEntry: Record "Cust. Ledger Entry"; var Result: Decimal; var IsHandled: Boolean)    begin    end;    /// <summary>    /// Integration event raised before calculating the sum of vendor remaining amounts.    /// Allows custom calculation logic for vendor remaining amount totals.    /// </summary>    /// <param name="VendorLedgerEntry">Vendor ledger entry being summed</param>    /// <param name="Result">Calculated result amount</param>    /// <param name="IsHandled">Set to true to use custom calculation result</param>    [IntegrationEvent(false, false)]    local procedure OnSumVendorRemainingAmountBeforeCalcResult(var VendorLedgerEntry: Record "Vendor Ledger Entry"; var Result: Decimal; var IsHandled: Boolean)    begin    end;}