Codeunit 8071 Sub. Billing Activities Cue
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;}