Report extension 8008 Contract Standard Sales Inv.

Subscription Billing, Microsoft.SubscriptionBilling

src/Apps/W1/Subscription Billing/App/Billing/Report Extensions/ContractStandardSalesInv.ReportExt.al239 lines, Copyright (c) Microsoft Corporation. MIT

namespace Microsoft.SubscriptionBilling;using Microsoft.Projects.Project.Ledger;using Microsoft.Sales.Customer;using Microsoft.Sales.History;using System.Text;using System.Utilities;reportextension 8008 "Contract Standard Sales Inv." extends "Standard Sales - Invoice"{    dataset    {        add(Header)        {            column(RecurringBilling; "Recurring Billing")            {            }        }        modify(Header)        {            trigger OnAfterAfterGetRecord()            begin                ContractBillingPrintout.FillContractBillingDetailsBufferFromSalesInvoice(Header, TempContractBillingDetailsBuffer, ColumnHeaders);                FillTempContractBillingDetailsGroupingBuffer();            end;        }        add(Line)        {            column(ContractLineNo; "Subscription Contract Line No.")            {            }            column(ContractNo; "Subscription Contract No.")            {            }            column(RecurringBillingfrom; "Recurring Billing from")            {            }            column(RecurringBillingto; "Recurring Billing to")            {            }        }        addafter(ReportTotalsLine)        {            dataitem(ContractBillingDetailsMapping; Integer)            {                MaxIteration = 1;                DataItemTableView = sorting(Number);                column(ContractBillingDetailsContractNoLbl; ContractNoLbl) { }                column(ContractBillingDetailsPositionNoLbl; PositionLbl) { }                column(ContractBillingDetailsPositionDescriptionLbl; SalesInvoiceLine.FieldCaption(Description)) { }                column(ContractBillingDetailsCustomerLbl; CustomerLbl) { }                dataitem(ContractBillingDetailsGrouping; Integer)                {                    DataItemTableView = sorting(Number);                    column(ContractBillingDetailsContractNo; TempContractBillingDetailsBuffer."External Document No.") { }                    column(ContractBillingDetailsPositionDescription; SalesInvoiceLine.Description) { }                    column(ContractBillingDetailsPositionNo; SalesInvoiceLine."Line No.") { }                    column(ContractBillingDetailsCustomerName; Customer2.Name) { }                    column(ContractBillingDetailsStartDateLbl; StartDateLbl) { }                    column(ContractBillingDetailsEndDateLbl; EndDateLbl) { }                    column(ContractBillingDetailsDaysLbl; DaysLbl) { }                    column(ContractBillingDetailsQtyLbl; SalesInvoiceLine.FieldCaption(Quantity)) { }                    column(ContractBillingDetailsSalesPriceLbl; SalesPriceLblTxt) { }                    column(ContractBillingDetailsDiscountPercentLbl; DiscountPercentLblText) { }                    column(ContractBillingDetailsDiscountAmountLbl; DiscountAmountLblText) { }                    column(ContractBillingDetailsAmountLbl; AmountLblText) { }                    column(ContractBillingDetailsCurrencyCodeLbl; CurrencyLblText) { }                    column(ContractBillingDetailsDescriptionLbl; ServiceDescriptionLbl) { }                    dataitem(ContractBillingDetails; Integer)                    {                        DataItemTableView = sorting(Number);                        column(ContractBillingDetailsStartDate; Format(TempContractBillingDetailsBuffer."Document Date")) { }                        column(ContractBillingDetailsEndDate; Format(TempContractBillingDetailsBuffer."Posting Date")) { }                        column(ContractBillingDetailsDays; Days) { }                        column(ContractBillingDetailsQuantity; Format(TempContractBillingDetailsBuffer.Quantity)) { }                        column(ContractBillingDetailsSalesPrice; FormattedUnitPrice)                        {                            AutoFormatExpression = Line.GetCurrencyCode();                            AutoFormatType = 2;                        }                        column(ContractBillingDetailsDiscountPercent; LineDiscountPctText) { }                        column(ContractBillingDetailsBillingAmount; FormattedLineAmount)                        {                            AutoFormatExpression = Line.GetCurrencyCode();                            AutoFormatType = 1;                        }                        column(ContractBillingDetailsBillingDiscountAmount; FormattedLineDiscountAmount)                        {                            AutoFormatExpression = Line.GetCurrencyCode();                            AutoFormatType = 1;                        }                        column(ContractBillingDetailsCurrencyCode; TempContractBillingDetailsBuffer."Currency Code") { }                        column(ContractBillingDetailsDescription; TempContractBillingDetailsBuffer.Description) { }                        trigger OnPreDataItem()                        begin                            TempContractBillingDetailsBuffer.SetRange("Document No.", TempContractBillingDetailsGroupingBuffer."Document No.");                            TempContractBillingDetailsBuffer.SetRange("Ledger Entry No.", TempContractBillingDetailsGroupingBuffer."Ledger Entry No.");                            if TempContractBillingDetailsBuffer.IsEmpty() then                                CurrReport.Break();                            SetRange(Number, 1, TempContractBillingDetailsBuffer.Count());                            if Header."Currency Code" <> '' then                                CurrencyLblText := CurrencyLbl;                        end;                        trigger OnAfterGetRecord()                        var                            AutoFormatType: Enum "Auto Format";                        begin                            if Number = 1 then                                TempContractBillingDetailsBuffer.FindSet()                            else                                TempContractBillingDetailsBuffer.Next();                            ContractBillingPrintout.FormatContractBillingDetails(TempContractBillingDetailsBuffer, SalesInvoiceLine);                            if not Customer2.Get(TempContractBillingDetailsBuffer."Resource Group No.") then                                Customer2.Init();                            ReportFormatting.FormatTextVariableFromDecimalValue(FormattedUnitPrice, TempContractBillingDetailsBuffer."Unit Price", AutoFormatType::UnitAmountFormat, TempContractBillingDetailsBuffer."Currency Code");                            ReportFormatting.FormatTextVariableFromDecimalValue(FormattedLineAmount, TempContractBillingDetailsBuffer."Line Amount", AutoFormatType::AmountFormat, TempContractBillingDetailsBuffer."Currency Code");                            ReportFormatting.FormatTextVariableFromDecimalValue(FormattedLineDiscountAmount, TempContractBillingDetailsBuffer."Line Discount Amount", AutoFormatType::AmountFormat, TempContractBillingDetailsBuffer."Currency Code");                            LineDiscountPctText := '';                            if TempContractBillingDetailsBuffer."Line Discount %" <> 0 then                                LineDiscountPctText := Format(-Round(TempContractBillingDetailsBuffer."Line Discount %", 0.1));                            SalesPriceLblTxt := ColumnHeaders[1];                            DiscountPercentLblText := ColumnHeaders[2];                            DiscountAmountLblText := ColumnHeaders[3];                            AmountLblText := ColumnHeaders[4];                            Days := 0;                            if (TempContractBillingDetailsBuffer."Document Date" <> 0D) and (TempContractBillingDetailsBuffer."Posting Date" <> 0D) then                                Days := TempContractBillingDetailsBuffer."Posting Date" - TempContractBillingDetailsBuffer."Document Date" + 1;                        end;                    }                    trigger OnPreDataItem()                    begin                        if TempContractBillingDetailsGroupingBuffer.IsEmpty() then                            CurrReport.Break();                        SetRange(Number, 1, TempContractBillingDetailsGroupingBuffer.Count());                    end;                    trigger OnAfterGetRecord()                    begin                        if Number = 1 then                            TempContractBillingDetailsGroupingBuffer.FindSet()                        else                            TempContractBillingDetailsGroupingBuffer.Next();                        ContractBillingPrintout.FormatContractBillingDetails(TempContractBillingDetailsGroupingBuffer, SalesInvoiceLine);                    end;                }                trigger OnPreDataItem()                begin                    if TempContractBillingDetailsBuffer.Count > 0 then                        SetRange(Number, 1)                    else                        CurrReport.Break();                end;                trigger OnAfterGetRecord()                begin                    if TempContractBillingDetailsBuffer.Count = 0 then                        CurrReport.Break();                end;            }        }    }    rendering    {        layout("SalesInvoiceForSubscriptionBilling.rdlc")        {            Type = RDLC;            LayoutFile = './Billing/Report Extensions/Layouts/SalesInvoiceForSubscriptionBilling.rdlc';            Caption = 'Sales Invoice for Subscription Billing (RDLC)';            Summary = 'The Sales Invoice for Subscription Billing (RDLC) is the most detailed layout and provides most flexible layout options.';        }        layout("SalesInvoiceForSubscriptionBilling.docx")        {            Type = Word;            LayoutFile = './Billing/Report Extensions/Layouts/SalesInvoiceForSubscriptionBilling.docx';            Caption = 'Sales Invoice for Subscription Billing (Word)';            Summary = 'The Sales Invoice for Subscription Billing (Word) provides a simple layout that is also relatively easy for an end-user to modify.';        }    }    protected var        TempContractBillingDetailsBuffer: Record "Job Ledger Entry" temporary;        TempContractBillingDetailsGroupingBuffer: Record "Job Ledger Entry" temporary;    var                SalesInvoiceLine: Record "Sales Invoice Line";        Customer2: Record Customer;        ContractBillingPrintout: Codeunit "Sub. Contract Billing Printout";        ReportFormatting: Codeunit "Report Formatting";        CustomerLbl: Label 'Customer';        ContractNoLbl: Label 'Contract No.';        PositionLbl: Label 'Pos.';        StartDateLbl: Label 'Start Date';        EndDateLbl: Label 'End Date';        DaysLbl: Label 'Days';        Days: Integer;        ServiceDescriptionLbl: Label 'Subscription';        CurrencyLbl: Label 'Currency';        SalesPriceLblTxt: Text;        CurrencyLblText: Text;        DiscountPercentLblText: Text;        DiscountAmountLblText: Text;        AmountLblText: Text;        ColumnHeaders: array[5] of Text;        FormattedLineDiscountAmount: Text;    local procedure FillTempContractBillingDetailsGroupingBuffer()    begin        TempContractBillingDetailsGroupingBuffer.Reset();        TempContractBillingDetailsGroupingBuffer.DeleteAll();        TempContractBillingDetailsBuffer.Reset();        if TempContractBillingDetailsBuffer.FindSet() then            repeat                TempContractBillingDetailsGroupingBuffer.SetRange("Document No.", TempContractBillingDetailsBuffer."Document No.");                TempContractBillingDetailsGroupingBuffer.SetRange("Ledger Entry No.", TempContractBillingDetailsBuffer."Ledger Entry No.");                if not TempContractBillingDetailsGroupingBuffer.FindFirst() then begin                    TempContractBillingDetailsGroupingBuffer := TempContractBillingDetailsBuffer;                    TempContractBillingDetailsGroupingBuffer.Insert(false);                end;            until TempContractBillingDetailsBuffer.Next() = 0;        TempContractBillingDetailsGroupingBuffer.Reset();    end;}