Codeunit 1328 Top Customers By Sales Job
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;}