Page 9106 Customer Ledger Entry FactBox

Base Application, Microsoft.Sales.Receivables

src/Layers/W1/BaseApp/Sales/Receivables/CustomerLedgerEntryFactBox.Page.al247 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.Sales.Receivables;using Microsoft.Finance.GeneralLedger.Ledger;using Microsoft.Sales.FinanceCharge;/// <summary>/// Displays key details for a customer ledger entry in a FactBox, including due date, applied entries count, and reminder information./// </summary>page 9106 "Customer Ledger Entry FactBox"{    Caption = 'Customer Ledger Entry Details';    PageType = CardPart;    SourceTable = "Cust. Ledger Entry";    layout    {        area(content)        {            field(DocumentHeading; DocumentHeading)            {                ApplicationArea = Basic, Suite;                Caption = 'Document';                DrillDown = true;                ToolTip = 'Specifies the document that the entry represents.';                trigger OnDrillDown()                var                    GLEntry: Record "G/L Entry";                begin                    if not Rec.ShowDoc() then begin                        GLEntry.SetCurrentKey("Document No.", "Posting Date");                        GLEntry.SetRange("Document No.", Rec."Document No.");                        GLEntry.SetRange("Posting Date", Rec."Posting Date");                        PAGE.Run(PAGE::"General Ledger Entries", GLEntry);                    end;                end;            }            field("Due Date"; Rec."Due Date")            {                ApplicationArea = Basic, Suite;            }            field("Pmt. Discount Date"; Rec."Pmt. Discount Date")            {                ApplicationArea = Basic, Suite;            }            field(NoOfReminderFinEntries; NoOfReminderFinEntries)            {                ApplicationArea = Suite;                Caption = 'Reminder/Fin. Charge Entries';                DrillDown = true;                ToolTip = 'Specifies reminder entries or finance charge entries for the customer ledger entry.';                trigger OnDrillDown()                var                    ReminderFinEntry: Record "Reminder/Fin. Charge Entry";                begin                    ReminderFinEntry.SetRange("Customer Entry No.", Rec."Entry No.");                    PAGE.Run(PAGE::"Reminder/Fin. Charge Entries", ReminderFinEntry);                end;            }            field(NoOfAppliedEntries; NoOfAppliedEntries)            {                ApplicationArea = Basic, Suite;                Caption = 'Applied Entries';                DrillDown = true;                ToolTip = 'Specifies applied entries for the customer ledger entry.';                trigger OnDrillDown()                var                    AppliedCustomerEntriesList: Page "Applied Customer Entries";                begin                    AppliedCustomerEntriesList.SetTempCustLedgEntry(Rec."Entry No.");                    AppliedCustomerEntriesList.Run();                end;            }            field(NoOfDetailedCustomerEntries; NoOfDetailedCustomerEntries)            {                ApplicationArea = Basic, Suite;                Caption = 'Detailed Ledger Entries';                DrillDown = true;                ToolTip = 'Specifies detailed ledger entries for the customer ledger entry.';                trigger OnDrillDown()                var                    DetailedCustLedgEntry: Record "Detailed Cust. Ledg. Entry";                begin                    DetailedCustLedgEntry.SetRange("Cust. Ledger Entry No.", Rec."Entry No.");                    DetailedCustLedgEntry.SetRange("Customer No.", Rec."Customer No.");                    PAGE.Run(PAGE::"Detailed Cust. Ledg. Entries", DetailedCustLedgEntry);                end;            }        }    }    actions    {    }    trigger OnAfterGetRecord()    begin        DocumentHeading := GetDocumentHeading(Rec);        CalcNoOfRecords();    end;    trigger OnFindRecord(Which: Text): Boolean    begin        NoOfReminderFinEntries := 0;        NoOfAppliedEntries := 0;        DocumentHeading := '';        exit(Rec.Find(Which));    end;    trigger OnOpenPage()    begin        DocumentHeading := GetDocumentHeading(Rec);        CalcNoOfRecords();    end;    var        NoOfReminderFinEntries: Integer;        NoOfAppliedEntries: Integer;        NoOfDetailedCustomerEntries: Integer;        DocumentHeading: Text[250];#pragma warning disable AA0074        Text000: Label 'Document';#pragma warning restore AA0074    local procedure CalcNoOfRecords()    var        ReminderFinChargeEntry: Record "Reminder/Fin. Charge Entry";        DetailedCustLedgEntry: Record "Detailed Cust. Ledg. Entry";    begin        ReminderFinChargeEntry.Reset();        ReminderFinChargeEntry.SetRange("Customer Entry No.", Rec."Entry No.");        NoOfReminderFinEntries := ReminderFinChargeEntry.Count();        NoOfAppliedEntries := 0;        if Rec."Entry No." <> 0 then            NoOfAppliedEntries := GetNoOfAppliedEntries(Rec);        DetailedCustLedgEntry.Reset();        DetailedCustLedgEntry.SetRange("Cust. Ledger Entry No.", Rec."Entry No.");        DetailedCustLedgEntry.SetRange("Customer No.", Rec."Customer No.");        NoOfDetailedCustomerEntries := DetailedCustLedgEntry.Count();    end;    local procedure GetNoOfAppliedEntries(CustLedgerEntry: Record "Cust. Ledger Entry"): Integer    var        IsHandled: Boolean;        ReturnedValue: Integer;    begin        IsHandled := false;        OnBeforeGetNoOfAppliedEntries(CustLedgerEntry, ReturnedValue, IsHandled);        if IsHandled then            exit(ReturnedValue);        GetAppliedEntries(CustLedgerEntry);        exit(CustLedgerEntry.Count);    end;    local procedure GetAppliedEntries(var CustLedgerEntry: Record "Cust. Ledger Entry")    var        DtldCustLedgEntry1: Record "Detailed Cust. Ledg. Entry";        DtldCustLedgEntry2: Record "Detailed Cust. Ledg. Entry";        CreateCustLedgEntry: Record "Cust. Ledger Entry";    begin        CreateCustLedgEntry := CustLedgerEntry;        DtldCustLedgEntry1.SetCurrentKey("Cust. Ledger Entry No.");        DtldCustLedgEntry1.SetRange("Cust. Ledger Entry No.", CreateCustLedgEntry."Entry No.");        DtldCustLedgEntry1.SetRange(Unapplied, false);        if DtldCustLedgEntry1.FindSet() then            repeat                if DtldCustLedgEntry1."Cust. Ledger Entry No." =                   DtldCustLedgEntry1."Applied Cust. Ledger Entry No."                then begin                    DtldCustLedgEntry2.Init();                    DtldCustLedgEntry2.SetCurrentKey("Applied Cust. Ledger Entry No.", "Entry Type");                    DtldCustLedgEntry2.SetRange(                      "Applied Cust. Ledger Entry No.", DtldCustLedgEntry1."Applied Cust. Ledger Entry No.");                    DtldCustLedgEntry2.SetRange("Entry Type", DtldCustLedgEntry2."Entry Type"::Application);                    DtldCustLedgEntry2.SetRange(Unapplied, false);                    if DtldCustLedgEntry2.Find('-') then                        repeat                            if DtldCustLedgEntry2."Cust. Ledger Entry No." <>                               DtldCustLedgEntry2."Applied Cust. Ledger Entry No."                            then begin                                CustLedgerEntry.SetCurrentKey("Entry No.");                                CustLedgerEntry.SetRange("Entry No.", DtldCustLedgEntry2."Cust. Ledger Entry No.");                                if CustLedgerEntry.FindFirst() then                                    CustLedgerEntry.Mark(true);                            end;                        until DtldCustLedgEntry2.Next() = 0;                end else begin                    CustLedgerEntry.SetCurrentKey("Entry No.");                    CustLedgerEntry.SetRange("Entry No.", DtldCustLedgEntry1."Applied Cust. Ledger Entry No.");                    if CustLedgerEntry.FindFirst() then                        CustLedgerEntry.Mark(true);                end;            until DtldCustLedgEntry1.Next() = 0;        CustLedgerEntry.SetCurrentKey("Entry No.");        CustLedgerEntry.SetRange("Entry No.");        if CreateCustLedgEntry."Closed by Entry No." <> 0 then begin            CustLedgerEntry."Entry No." := CreateCustLedgEntry."Closed by Entry No.";            CustLedgerEntry.Mark(true);        end;        CustLedgerEntry.SetCurrentKey("Closed by Entry No.");        CustLedgerEntry.SetRange("Closed by Entry No.", CreateCustLedgEntry."Entry No.");        if CustLedgerEntry.FindSet() then            repeat                CustLedgerEntry.Mark(true);            until CustLedgerEntry.Next() = 0;        CustLedgerEntry.SetCurrentKey("Entry No.");        CustLedgerEntry.SetRange("Closed by Entry No.");        CustLedgerEntry.MarkedOnly(true);    end;    local procedure GetDocumentHeading(CustLedgerEntry: Record "Cust. Ledger Entry"): Text[50]    var        Heading: Text[50];    begin        if CustLedgerEntry."Document Type" = CustLedgerEntry."Document Type"::" " then            Heading := Text000        else            Heading := Format(CustLedgerEntry."Document Type");        Heading := Heading + ' ' + CustLedgerEntry."Document No.";        exit(Heading);    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeGetNoOfAppliedEntries(CustLedgerEntry: Record "Cust. Ledger Entry"; var ReturnedValue: Integer; var IsHandled: Boolean)    begin    end;}