Codeunit 8073 Sales Report Printout Mgmt.
src/Apps/W1/Subscription Billing/App/Service Commitments/Codeunits/SalesReportPrintoutMgmt.Codeunit.al207 lines, Copyright (c) Microsoft Corporation. MIT
namespace Microsoft.SubscriptionBilling;using Microsoft.Finance.Currency;using Microsoft.Inventory.Item;using Microsoft.Sales.Document;using Microsoft.Utilities;using System.Text;codeunit 8073 "Sales Report Printout Mgmt."{ SingleInstance = true; var ReportFormattingGlobal: Codeunit "Report Formatting"; RecurringServicesTotalLbl: Label 'Subscriptions (* Part of Subscription Billing)'; RecurringServicesPerLineLbl: Label 'Subscriptions*'; TotalTextTok: Label 'TotalText', Locked = true; [IntegrationEvent(false, false)] local procedure OnBeforeFormatSalesLineExcludeLineInTotals(var SalesLine: Record "Sales Line"; var IncludeLineInTotals: Boolean; var IsHandled: Boolean) begin end; procedure ExcludeItemFromTotals(var SalesLine: Record "Sales Line"; var TotalSubTotal: Decimal; var TotalInvDiscAmount: Decimal; var TotalAmount: Decimal; var TotalAmountVAT: Decimal; var TotalAmountInclVAT: Decimal) var Item: Record Item; ContractRenewalMgt: Codeunit "Sub. Contract Renewal Mgt."; ContractsItemManagement: Codeunit "Sub. Contracts Item Management"; IsHandled: Boolean; IncludeLineInTotals: Boolean; begin IncludeLineInTotals := true; IsHandled := false; OnBeforeFormatSalesLineExcludeLineInTotals(SalesLine, IncludeLineInTotals, IsHandled); if IsHandled then exit; if ContractRenewalMgt.IsContractRenewal(SalesLine) then IncludeLineInTotals := false; if SalesLine.Type <> SalesLine.Type::Item then exit; if not Item.Get(SalesLine."No.") then exit; if ContractsItemManagement.IsServiceCommitmentItem(Item."No.") then IncludeLineInTotals := false; if not IncludeLineInTotals then ReduceTotalsForSalesLine(SalesLine, TotalSubTotal, TotalInvDiscAmount, TotalAmount, TotalAmountVAT, TotalAmountInclVAT); end; local procedure ReduceTotalsForSalesLine(var SalesLine: Record "Sales Line"; var TotalSubTotal: Decimal; var TotalInvDiscAmount: Decimal; var TotalAmount: Decimal; var TotalAmountVAT: Decimal; var TotalAmountInclVAT: Decimal) begin TotalSubTotal -= SalesLine."Line Amount"; TotalInvDiscAmount += SalesLine."Inv. Discount Amount"; TotalAmount -= SalesLine.Amount; TotalAmountVAT -= (SalesLine."Amount Including VAT" - SalesLine.Amount); TotalAmountInclVAT -= SalesLine."Amount Including VAT"; end; [EventSubscriber(ObjectType::Report, Report::"Standard Sales - Order Conf.", OnLineOnAfterGetRecordOnBeforeCalcVATAmountLines, '', false, false)] local procedure SalesOrderOnBeforeCalcVATAmountLines(var SalesLine: Record "Sales Line") begin SalesLine.SetRange("Exclude from Doc. Total", false); end; [EventSubscriber(ObjectType::Report, Report::"Standard Sales - Order Conf.", OnHeaderOnAfterGetRecordOnAfterUpdateVATOnLines, '', false, false)] local procedure SalesOrderOnAfterUpdateVATOnLines(var SalesLine: Record "Sales Line") begin SalesLine.SetRange("Exclude from Doc. Total"); end; procedure FillServiceCommitmentsGroups(var SalesHeader: Record "Sales Header"; var ServCommGroupPerPeriod: Record "Name/Value Buffer"; var ServCommGroup: Record "Name/Value Buffer") begin FillServiceCommitmentsGroupPerPeriod(SalesHeader, ServCommGroupPerPeriod); if ServCommGroupPerPeriod.FindSet() then begin repeat ServCommGroup.SetRange("Value Long", ServCommGroupPerPeriod."Value Long"); if ServCommGroup.IsEmpty then begin ServCommGroup.Reset(); ReportFormattingGlobal.AddValueToBuffer(ServCommGroup, '', '', ServCommGroupPerPeriod."Value Long"); end else ServCommGroup.Reset(); until ServCommGroupPerPeriod.Next() = 0; ServCommGroup.Reset(); end; end; local procedure FillServiceCommitmentsGroupPerPeriod(var SalesHeader: Record "Sales Header"; var GroupPerPeriod: Record "Name/Value Buffer") var SalesServiceCommitment: Record "Sales Subscription Line"; TempSalesServiceCommitmentBuff: Record "Sales Service Commitment Buff." temporary; FormatDocument: Codeunit "Format Document"; TotalText: Text[50]; TotalInclVATText: Text[50]; TotalExclVATText: Text[50]; UniqueRhythmDictionary: Dictionary of [Code[20], Text]; IsHandled: Boolean; begin FormatDocument.SetTotalLabels(SalesHeader.GetCurrencySymbol(), TotalText, TotalInclVATText, TotalExclVATText); SalesServiceCommitment.CalcVATAmountLines(SalesHeader, TempSalesServiceCommitmentBuff, UniqueRhythmDictionary); OnBeforeFillSubscriptionLinesGroupPerPeriod(SalesHeader, TempSalesServiceCommitmentBuff, GroupPerPeriod, UniqueRhythmDictionary, TotalText, TotalInclVATText, TotalExclVATText, IsHandled); if not IsHandled then FillServiceCommitmentsGroupPerPeriod(TempSalesServiceCommitmentBuff, GroupPerPeriod, UniqueRhythmDictionary, SalesHeader."Currency Code", TotalInclVATText, TotalExclVATText); end; procedure FillServiceCommitmentsForLine(var SalesHeader: Record "Sales Header"; var SalesLineServiceCommitments: Record "Sales Line"; var SalesLineServiceCommitmentsCaption: Record "Name/Value Buffer") var SalesServiceCommitment: Record "Sales Subscription Line"; SalesLine: Record "Sales Line"; begin SalesServiceCommitment.FilterOnDocument(SalesHeader."Document Type", SalesHeader."No."); SalesServiceCommitment.SetRange(Partner, Enum::"Service Partner"::Customer); SalesServiceCommitment.SetRange("Invoicing via", SalesServiceCommitment."Invoicing via"::Contract); if SalesServiceCommitment.FindSet() then begin repeat SalesLine.Get(SalesServiceCommitment."Document Type", SalesServiceCommitment."Document No.", SalesServiceCommitment."Document Line No."); SalesLineServiceCommitments.Init(); SalesLineServiceCommitments."Document Type" := SalesServiceCommitment."Document Type"; SalesLineServiceCommitments."Document No." := Format(SalesServiceCommitment."Document Line No."); SalesLineServiceCommitments."Line No." := SalesServiceCommitment."Line No."; SalesLineServiceCommitments.Description := SalesServiceCommitment.Description; SalesLineServiceCommitments."Line Discount %" := Round(SalesServiceCommitment."Discount %", 0.1); SalesLineServiceCommitments."Unit Price" := SalesServiceCommitment.Price; SalesLineServiceCommitments.Insert(false); until SalesServiceCommitment.Next() = 0; // Adds captions for Line Details ReportFormattingGlobal.AddValueToBuffer(SalesLineServiceCommitmentsCaption, TotalTextTok, RecurringServicesTotalLbl); ReportFormattingGlobal.AddValueToBuffer(SalesLineServiceCommitmentsCaption, SalesLineServiceCommitments.FieldName(Description), RecurringServicesPerLineLbl); end; end; local procedure FillServiceCommitmentsGroupPerPeriod(var TempSalesServiceCommitmentBuff: Record "Sales Service Commitment Buff." temporary; var GroupPerPeriod: Record "Name/Value Buffer"; var UniqueRhythmDictionary: Dictionary of [Code[20], Text]; CurrencyCode: Code[10]; TotalInclVATText: Text[50]; TotalExclVATText: Text[50]) var Currency: Record Currency; AutoFormat: Codeunit "Auto Format"; ContractRenewalMgt: Codeunit "Sub. Contract Renewal Mgt."; ReportFormatting: Codeunit "Report Formatting"; RhythmIdentifier: Code[20]; AutoFormatType: Enum "Auto Format"; BillingRhythmLbl: Label 'Per %1', Comment = '%1 = Billing Rhythm Text'; PlaceholderLbl: Label '%1', Comment = '%1 = Billing Rhythm Text', Locked = true; VATAmountLbl: Label 'VAT Amount'; TaxAmountLbl: Label 'Tax Amount'; BillingRhythmPlaceholderTxt: Text; FormatTotal: Text[50]; FormatDecimal: Text[50]; begin Currency.Initialize(CurrencyCode); foreach RhythmIdentifier in UniqueRhythmDictionary.Keys() do begin TempSalesServiceCommitmentBuff.Reset(); TempSalesServiceCommitmentBuff.SetRange("Rhythm Identifier", RhythmIdentifier); TempSalesServiceCommitmentBuff.CalcSums("VAT Base"); BillingRhythmPlaceholderTxt := BillingRhythmLbl; if RhythmIdentifier = ContractRenewalMgt.GetContractRenewalIdentifierLabel() then BillingRhythmPlaceholderTxt := PlaceholderLbl; // Set VAT Header with Total FormatTotal := Format(TempSalesServiceCommitmentBuff."VAT Base", 0, AutoFormat.ResolveAutoFormat(AutoFormatType::AmountFormat, Currency.Code)); ReportFormatting.AddValueToBuffer(GroupPerPeriod, TotalExclVATText, FormatTotal, StrSubstNo(BillingRhythmPlaceholderTxt, UniqueRhythmDictionary.Get(RhythmIdentifier))); // Set Body with VAT entries if TempSalesServiceCommitmentBuff.FindSet() then repeat FormatDecimal := Format(TempSalesServiceCommitmentBuff."VAT Amount", 0, AutoFormat.ResolveAutoFormat(AutoFormatType::AmountFormat, Currency.Code)); if TempSalesServiceCommitmentBuff."VAT Calculation Type" = TempSalesServiceCommitmentBuff."VAT Calculation Type"::"Sales Tax" then ReportFormatting.AddValueToBuffer(GroupPerPeriod, TaxAmountLbl, FormatDecimal, StrSubstNo(BillingRhythmPlaceholderTxt, UniqueRhythmDictionary.Get(RhythmIdentifier))) else ReportFormatting.AddValueToBuffer(GroupPerPeriod, VATAmountLbl + ' [' + Format(TempSalesServiceCommitmentBuff."VAT %") + '%]', FormatDecimal, StrSubstNo(BillingRhythmPlaceholderTxt, UniqueRhythmDictionary.Get(RhythmIdentifier))); until TempSalesServiceCommitmentBuff.Next() = 0; // Set VAT Footer with Total TempSalesServiceCommitmentBuff.CalcSums("Amount Including VAT"); FormatTotal := Format(TempSalesServiceCommitmentBuff."Amount Including VAT", 0, AutoFormat.ResolveAutoFormat(AutoFormatType::AmountFormat, Currency.Code)); ReportFormatting.AddValueToBuffer(GroupPerPeriod, TotalInclVATText, FormatTotal, StrSubstNo(BillingRhythmPlaceholderTxt, UniqueRhythmDictionary.Get(RhythmIdentifier))); end; end; [IntegrationEvent(false, false)] local procedure OnBeforeFillSubscriptionLinesGroupPerPeriod(SalesHeader: Record "Sales Header"; var TempSalesSubscriptionLineBuff: Record "Sales Service Commitment Buff." temporary; var GroupPerPeriod: Record "Name/Value Buffer"; var UniqueRhythmDictionary: Dictionary of [Code[20], Text]; TotalText: Text[50]; TotalInclVATText: Text[50]; TotalExclVATText: Text[50]; var IsHandled: Boolean) begin end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Format Document", OnAfterSetSalesLine, '', false, false)] local procedure SalesLineAddMarkToFormattedLineAmount(var SalesLine: Record "Sales Line"; var FormattedUnitPrice: Text; var FormattedLineAmount: Text) var SalesLine2: Record "Sales Line"; AutoFormat: Codeunit "Auto Format"; AutoFormatType: Enum "Auto Format"; begin if CheckAppendAsteriskToFormattedLineAmount(SalesLine) then if SalesLine2.Get(SalesLine."Document Type", SalesLine."Document No.", SalesLine."Line No.") then begin FormattedUnitPrice := Format(SalesLine2."Unit Price", 0, AutoFormat.ResolveAutoFormat(AutoFormatType::UnitAmountFormat, SalesLine2."Currency Code")); FormattedLineAmount := Format(SalesLine2."Line Amount", 0, AutoFormat.ResolveAutoFormat(AutoFormatType::AmountFormat, SalesLine2."Currency Code")); AppendAsteriskToText(FormattedLineAmount); end; end; local procedure CheckAppendAsteriskToFormattedLineAmount(SalesLine: Record "Sales Line"): Boolean begin if not (SalesLine."Document Type" in [SalesLine."Document Type"::Quote, SalesLine."Document Type"::Order]) then exit(false); exit(SalesLine.IsServiceCommitmentItem()); end; local procedure AppendAsteriskToText(var TextToAppendAsterisk: Text) begin if DelChr(TextToAppendAsterisk) = '' then exit; TextToAppendAsterisk += '*'; end;}