Codeunit 1328 Top Customers By Sales Job

Base Application, Microsoft.Sales.Customer

src/Layers/W1/BaseApp/Sales/Customer/TopCustomersBySalesJob.Codeunit.al115 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.Customer;using Microsoft.Sales.Receivables;using System.Threading;using System.Visualization;/// <summary>/// Updates the top customers by sales buffer table via job queue processing./// </summary>codeunit 1328 "Top Customers By Sales Job"{    TableNo = "Job Queue Entry";    trigger OnRun()    begin        UpdateCustomerTopList();    end;    var        AllOtherCustomersTxt: Label 'All Other Customers';    [EventSubscriber(ObjectType::Table, Database::"Job Queue Entry", 'OnFindingIfJobNeedsToBeRun', '', false, false)]    local procedure OnFindingIfJobNeedsToBeRun(var Sender: Record "Job Queue Entry"; var Result: Boolean)    var        TopCustomersBySalesBuffer: Record "Top Customers By Sales Buffer";        LastCustLedgerEntry: Record "Cust. Ledger Entry";    begin        if Sender."Object Type to Run" <> Sender."Object Type to Run"::Codeunit then            exit;        if Sender."Object ID to Run" <> CODEUNIT::"Top Customers By Sales Job" then            exit;        if not LastCustLedgerEntry.FindLast() then            exit;        if TopCustomersBySalesBuffer.FindFirst() then            if TopCustomersBySalesBuffer.LastCustLedgerEntryNo = LastCustLedgerEntry."Entry No." then                exit;        Result := true;    end;    /// <summary>    /// Updates the top customers by sales buffer table with the latest sales data from customer ledger entries.    /// </summary>    [Scope('OnPrem')]    procedure UpdateCustomerTopList()    var        LastCustLedgerEntry: Record "Cust. Ledger Entry";        CustLedgerEntry: Record "Cust. Ledger Entry";        TopCustomersBySalesBuffer: Record "Top Customers By Sales Buffer";        TempTopCustomersBySalesBuffer: Record "Top Customers By Sales Buffer" temporary;        Customer: Record Customer;        ChartManagement: Codeunit "Chart Management";        Top10CustomerSalesQry: Query "Top 10 Customer Sales";        CustomerCounter: Integer;        OtherCustomersSalesLCY: Decimal;        DTUpdated: DateTime;        LastCustomerLedgerEntryNo: Integer;    begin        if ChartManagement.TopCustomerListUpdatedRecently(LastCustomerLedgerEntryNo) then            exit;        if not LastCustLedgerEntry.FindLast() then            exit;        if LastCustLedgerEntry."Entry No." = LastCustomerLedgerEntryNo then            exit;        DTUpdated := CurrentDateTime;        if Top10CustomerSalesQry.Open() then            while Top10CustomerSalesQry.Read() do                if Customer.Get(Top10CustomerSalesQry.Customer_No) then begin                    CustomerCounter += 1;                    InsertRow(TempTopCustomersBySalesBuffer, CustomerCounter, Customer."No.", Customer.Name, Top10CustomerSalesQry.Sum_Sales_LCY, LastCustLedgerEntry."Entry No.", DTUpdated);                    OtherCustomersSalesLCY -= Top10CustomerSalesQry.Sum_Sales_LCY;                end;        if Customer.Count > 10 then begin            CustLedgerEntry.CalcSums("Sales (LCY)");            OtherCustomersSalesLCY += CustLedgerEntry."Sales (LCY)";            CustomerCounter += 1;            InsertRow(TempTopCustomersBySalesBuffer,              CustomerCounter, '', AllOtherCustomersTxt, OtherCustomersSalesLCY, LastCustLedgerEntry."Entry No.", DTUpdated);        end;        if TempTopCustomersBySalesBuffer.FindSet() then begin            TopCustomersBySalesBuffer.LockTable();            TopCustomersBySalesBuffer.DeleteAll();            repeat                TopCustomersBySalesBuffer.TransferFields(TempTopCustomersBySalesBuffer);                TopCustomersBySalesBuffer.Insert();            until TempTopCustomersBySalesBuffer.Next() = 0        end;    end;    local procedure InsertRow(var TempTopCustomersBySalesBuffer: Record "Top Customers By Sales Buffer" temporary; Ranking: Integer; CustomerNo: Code[20]; CustomerName: Text[100]; SalesLCY: Decimal; LastCustLedgEntryNo: Integer; DTUpdated: DateTime)    begin        TempTopCustomersBySalesBuffer.Ranking := Ranking;        TempTopCustomersBySalesBuffer.CustomerNo := CustomerNo;        TempTopCustomersBySalesBuffer.CustomerName := CustomerName;        TempTopCustomersBySalesBuffer.SalesLCY := SalesLCY;        TempTopCustomersBySalesBuffer.LastCustLedgerEntryNo := LastCustLedgEntryNo;        TempTopCustomersBySalesBuffer.DateTimeUpdated := DTUpdated;        TempTopCustomersBySalesBuffer.Insert();    end;}