Codeunit 906 SO Activities Calculate
src/Layers/W1/BaseApp/Sales/RoleCenters/SOActivitiesCalculate.Codeunit.al93 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.RoleCenters;/// <summary>/// Calculates sales order activity metrics for the Sales Cue in background tasks./// </summary>codeunit 906 "SO Activities Calculate"{ Permissions = tabledata "Sales Cue" = r; var Results: Dictionary of [Text, Text]; trigger OnRun() var Parameters: Dictionary of [Text, Text]; begin Parameters := Page.GetBackgroundParameters(); CalculateFieldValues(Parameters, Results); Page.SetBackgroundTaskResult(Results); end; /// <summary> /// Calculates sales order activity field values based on the provided parameters and returns the results in a dictionary. /// </summary> /// <param name="Parameters">Specifies the input parameters dictionary containing the view filter for the sales cue.</param> /// <param name="ReturnResults">Returns the calculated field values as key-value pairs in a dictionary.</param> procedure CalculateFieldValues(Parameters: Dictionary of [Text, Text]; var ReturnResults: Dictionary of [Text, Text]) var SalesCue: Record "Sales Cue"; begin if SalesCue.Get() then; SalesCue.SetView(Parameters.Get('View')); CalculateCueFieldValues(SalesCue); ReturnResults.Add(SalesCue.FieldName("Average Days Delayed"), Format(SalesCue."Average Days Delayed")); ReturnResults.Add(SalesCue.FieldName("Avg. Days Delayed Updated On"), Format(SalesCue."Avg. Days Delayed Updated On", 0, 9)); ReturnResults.Add(SalesCue.FieldName("Ready to Ship"), Format(SalesCue."Ready to Ship")); ReturnResults.Add(SalesCue.FieldName("Partially Shipped"), Format(SalesCue."Partially Shipped")); ReturnResults.Add(SalesCue.FieldName(Delayed), Format(SalesCue.Delayed)); ReturnResults.Add(SalesCue.FieldName("S. Ord. - Reserved From Stock"), Format(SalesCue."S. Ord. - Reserved From Stock")); end; /// <summary> /// Evaluates the results dictionary from a background task and updates the sales cue record with the calculated values. /// </summary> /// <param name="ResultsDictionary">Specifies the dictionary containing the calculated field values from the background task.</param> /// <param name="SalesCue">Specifies the sales cue record to update with the evaluated results.</param> procedure EvaluateResults(var ResultsDictionary: Dictionary of [Text, Text]; var SalesCue: Record "Sales Cue") var ResultValue: Text; begin if ResultsDictionary.Count() = 0 then exit; if TryGetDictionaryValue(ResultsDictionary, SalesCue.FieldName("Average Days Delayed"), ResultValue) then Evaluate(SalesCue."Average Days Delayed", ResultValue); if TryGetDictionaryValue(ResultsDictionary, SalesCue.FieldName("Avg. Days Delayed Updated On"), ResultValue) then Evaluate(SalesCue."Avg. Days Delayed Updated On", ResultValue, 9); if TryGetDictionaryValue(ResultsDictionary, SalesCue.FieldName("Ready to Ship"), ResultValue) then Evaluate(SalesCue."Ready to Ship", ResultValue); if TryGetDictionaryValue(ResultsDictionary, SalesCue.FieldName("Partially Shipped"), ResultValue) then Evaluate(SalesCue."Partially Shipped", ResultValue); if TryGetDictionaryValue(ResultsDictionary, SalesCue.FieldName(Delayed), ResultValue) then Evaluate(SalesCue.Delayed, ResultValue); if TryGetDictionaryValue(ResultsDictionary, SalesCue.FieldName("S. Ord. - Reserved From Stock"), ResultValue) then Evaluate(SalesCue."S. Ord. - Reserved From Stock", ResultValue); end; [TryFunction] local procedure TryGetDictionaryValue(var ResultsDictionary: Dictionary of [Text, Text]; DictionaryKey: Text; var ReturnValue: Text) begin ReturnValue := ResultsDictionary.Get(DictionaryKey); end; local procedure CalculateCueFieldValues(var SalesCue: Record "Sales Cue") begin if SalesCue."Avg. Days Delayed Updated On" < CurrentDateTime - 5 * 60000 then begin SalesCue."Average Days Delayed" := SalesCue.CalculateAverageDaysDelayed(); SalesCue."Avg. Days Delayed Updated On" := CurrentDateTime(); end; SalesCue."Ready to Ship" := SalesCue.CountOrders(SalesCue.FieldNo("Ready to Ship")); SalesCue."Partially Shipped" := SalesCue.CountOrders(SalesCue.FieldNo("Partially Shipped")); SalesCue.Delayed := SalesCue.CountOrders(SalesCue.FieldNo(Delayed)); SalesCue."S. Ord. - Reserved From Stock" := SalesCue.CalcNoOfReservedFromStockSalesOrders(); end;}