4
R

Need to add Setcurrentkey to speedup accessing customer ledger entry

Rama Mathanmohan on 11/29/2023 10:16:05 PM

Please add Setcurrentkey for index “Document Type", Open, "Posting Date", "Closed at Date" to CalcAverageCollectionDays function in "Activities Mgt."(CodeUnit 1311) as calculation accessing Customer ledger entry is very slow.

Category: Development
STATUS DETAILS
New

Comments

R

R

RE: Need to add Setcurrentkey to speedup accessing customer ledger entry

Ram G on 11/29/2023 10:38:13 PM

I have included the missing setcurrentkey command in the comment below

Category: Development

R

R

RE: Need to add Setcurrentkey to speedup accessing customer ledger entry

Ram G on 11/29/2023 10:36:26 PM

    local procedure GetPaidSalesInvoices(var CustLedgerEntry: Record "Cust. Ledger Entry")

    begin

CustLedgerEntry.Setcurrentkey(“Document Type", Open, "Posting Date", "Closed at Date");

        CustLedgerEntry.SetRange("Document Type", CustLedgerEntry."Document Type"::Invoice);

        CustLedgerEntry.SetRange(Open, false);

        CustLedgerEntry.SetRange("Posting Date", CalcDate('', GetDefaultWorkDate()), GetDefaultWorkDate());

        CustLedgerEntry.SetRange("Closed at Date", CalcDate('', GetDefaultWorkDate()), GetDefaultWorkDate());

    end;

Category: Development

R

R

RE: Need to add Setcurrentkey to speedup accessing customer ledger entry

Ram G on 11/29/2023 10:17:19 PM

The following AL code is slow as a result


AppObjectType: CodeUnit

 AppObjectId: 1311

 AL CallStack: "Activities Mgt."(CodeUnit 1311).CalcAverageCollectionDays line 8 - Base Application by Microsoft

"O365 Activities Dictionary"(CodeUnit 1310).OnRun(Trigger) line 9 - Base Application by Microsoft

Category: Development