Codeunit 8071 Sub. Billing Activities Cue

Subscription Billing, Microsoft.SubscriptionBilling

src/Apps/W1/Subscription Billing/App/Base/Codeunits/SubBillingActivitiesCue.Codeunit.al153 lines, Copyright (c) Microsoft Corporation. MIT

namespace Microsoft.SubscriptionBilling;using Microsoft.Purchases.History;using Microsoft.Sales.History;codeunit 8071 "Sub. Billing Activities Cue"{    Access = Internal;    Permissions = tabledata "Subscription Billing Cue" = r;    var        ResultsGlobal: Dictionary of [Text, Text];    trigger OnRun()    begin        CalculateFieldValues(ResultsGlobal);        Page.SetBackgroundTaskResult(ResultsGlobal);    end;    local procedure CalculateFieldValues(var ReturnResults: Dictionary of [Text, Text])    var        SubscriptionBillingCue: Record "Subscription Billing Cue";    begin        if SubscriptionBillingCue.Get() then;        CalculateCueFieldValues(SubscriptionBillingCue);        ReturnResults.Add(SubscriptionBillingCue.FieldName("Revenue current Month"), Format(SubscriptionBillingCue."Revenue current Month", 0, '<Precision,0:0><Standard Format,9>'));        ReturnResults.Add(SubscriptionBillingCue.FieldName("Cost current Month"), Format(SubscriptionBillingCue."Cost current Month", 0, '<Precision,0:0><Standard Format,9>'));        ReturnResults.Add(SubscriptionBillingCue.FieldName("Revenue previous Month"), Format(SubscriptionBillingCue."Revenue previous Month", 0, '<Precision,0:0><Standard Format,9>'));        ReturnResults.Add(SubscriptionBillingCue.FieldName("Cost previous Month"), Format(SubscriptionBillingCue."Cost previous Month", 0, '<Precision,0:0><Standard Format,9>'));        ReturnResults.Add(SubscriptionBillingCue.FieldName(Overdue), Format(SubscriptionBillingCue.Overdue));        ReturnResults.Add(SubscriptionBillingCue.FieldName("Last Updated On"), Format(SubscriptionBillingCue."Last Updated On", 0, 9));    end;    local procedure CalculateCueFieldValues(var SubscriptionBillingCue: Record "Subscription Billing Cue")    var        TemporaryOverdueServiceCommitments: Record "Overdue Subscription Line" temporary;    begin        SubscriptionBillingCue."Revenue current Month" := RevenueCurrentMonth();        SubscriptionBillingCue."Cost current Month" := CostCurrentMonth();        SubscriptionBillingCue."Revenue previous Month" := RevenuePreviousMonth();        SubscriptionBillingCue."Cost previous Month" := CostPreviousMonth();        SubscriptionBillingCue.Overdue := TemporaryOverdueServiceCommitments.CountOverdueServiceCommitments();        SubscriptionBillingCue."Last Updated On" := CurrentDateTime();    end;    internal procedure EvaluateResults(var Results: Dictionary of [Text, Text]; var SubscriptionBillingCue: Record "Subscription Billing Cue")    var        ResultValue: Text;    begin        if Results.Count() = 0 then            exit;        if TryGetDictionaryValue(Results, SubscriptionBillingCue.FieldName("Revenue current Month"), ResultValue) then            Evaluate(SubscriptionBillingCue."Revenue current Month", ResultValue);        if TryGetDictionaryValue(Results, SubscriptionBillingCue.FieldName("Cost current Month"), ResultValue) then            Evaluate(SubscriptionBillingCue."Cost current Month", ResultValue, 9);        if TryGetDictionaryValue(Results, SubscriptionBillingCue.FieldName("Revenue previous Month"), ResultValue) then            Evaluate(SubscriptionBillingCue."Revenue previous Month", ResultValue);        if TryGetDictionaryValue(Results, SubscriptionBillingCue.FieldName("Cost previous Month"), ResultValue) then            Evaluate(SubscriptionBillingCue."Cost previous Month", ResultValue);        if TryGetDictionaryValue(Results, SubscriptionBillingCue.FieldName(Overdue), ResultValue) then            Evaluate(SubscriptionBillingCue.Overdue, ResultValue);        if TryGetDictionaryValue(Results, SubscriptionBillingCue.FieldName("Last Updated On"), ResultValue) then            Evaluate(SubscriptionBillingCue."Last Updated On", ResultValue, 9);    end;    [TryFunction]    local procedure TryGetDictionaryValue(var Results: Dictionary of [Text, Text]; DictionaryKey: Text; var ReturnValue: Text)    begin        ReturnValue := Results.Get(DictionaryKey);    end;    internal procedure DrillDownOverdueServiceCommitments()    var        TemporaryOverdueServiceCommitments: Record "Overdue Subscription Line" temporary;    begin        TemporaryOverdueServiceCommitments.FillOverdueServiceCommitments();        Page.Run(Page::"Overdue Service Commitments", TemporaryOverdueServiceCommitments);    end;    local procedure RevenueCurrentMonth(): Decimal    begin        exit(GetRevenue(true));    end;    local procedure CostCurrentMonth(): Decimal    begin        exit(GetCost(true));    end;    local procedure RevenuePreviousMonth(): Decimal    begin        exit(GetRevenue(false));    end;    local procedure CostPreviousMonth(): Decimal    begin        exit(GetCost(false));    end;    local procedure GetRevenue(CurrentMonth: Boolean): Decimal    var        SalesInvLine: Record "Sales Invoice Line";        SalesCrMemoLine: Record "Sales Cr.Memo Line";        DateFilterFrom: Text;        DateFilterTo: Text;    begin        GetDateFilterFormulas(CurrentMonth, DateFilterFrom, DateFilterTo);        SalesInvLine.SetFilter("Subscription Contract No.", '<>%1', '');        SalesInvLine.SetRange("Posting Date", CalcDate(DateFilterFrom, WorkDate()), CalcDate(DateFilterTo, WorkDate()));        SalesInvLine.CalcSums(Amount);        SalesCrMemoLine.SetFilter("Subscription Contract No.", '<>%1', '');        SalesCrMemoLine.SetRange("Posting Date", CalcDate(DateFilterFrom, WorkDate()), CalcDate(DateFilterTo, WorkDate()));        SalesCrMemoLine.CalcSums(Amount);        exit(SalesInvLine.Amount - SalesCrMemoLine.Amount);    end;    local procedure GetCost(CurrentMonth: Boolean): Decimal    var        PurchInvLine: Record "Purch. Inv. Line";        PurchCrMemoLine: Record "Purch. Cr. Memo Line";        DateFilterFrom: Text;        DateFilterTo: Text;    begin        GetDateFilterFormulas(CurrentMonth, DateFilterFrom, DateFilterTo);        PurchInvLine.SetFilter("Subscription Contract No.", '<>%1', '');        PurchInvLine.SetRange("Posting Date", CalcDate(DateFilterFrom, WorkDate()), CalcDate(DateFilterTo, WorkDate()));        PurchInvLine.CalcSums(Amount);        PurchCrMemoLine.SetFilter("Subscription Contract No.", '<>%1', '');        PurchCrMemoLine.SetRange("Posting Date", CalcDate(DateFilterFrom, WorkDate()), CalcDate(DateFilterTo, WorkDate()));        PurchCrMemoLine.CalcSums(Amount);        exit(PurchInvLine.Amount - PurchCrMemoLine.Amount);    end;    internal procedure GetDateFilterFormulas(CurrentMonth: Boolean; var DateFilterFrom: Text; var DateFilterTo: Text)    begin        if CurrentMonth then begin            DateFilterFrom := '<-CM>';            DateFilterTo := '<CM>';        end else begin            DateFilterFrom := '<-1M-CM>';            DateFilterTo := '<-1M+CM>';        end;    end;}