Report 24 Sales Taxes Collected

Base Application, Microsoft.Finance.SalesTax

src/Layers/W1/BaseApp/Finance/SalesTax/SalesTaxesCollected.Report.al362 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.Finance.SalesTax;using Microsoft.Finance.VAT.Ledger;using Microsoft.Foundation.Company;using System.Utilities;/// <summary>/// Generates sales tax collection reports with detailed tax amounts by jurisdiction and tax group./// Supports summary, normal, and detailed report formats with optional use tax inclusion./// </summary>report 24 "Sales Taxes Collected"{    Caption = 'Sales Taxes Collected';    DefaultRenderingLayout = RDLCLayout;    dataset    {        dataitem(ReportToJurisdiction; "Tax Jurisdiction")        {            DataItemTableView = sorting("Report-to Jurisdiction");            trigger OnAfterGetRecord()            begin                if "Report-to Jurisdiction" = '' then                    CurrReport.Skip();                if "Report-to Jurisdiction" <> TempTaxJurisdiction.Code then begin                    TempTaxJurisdiction.Code := "Report-to Jurisdiction";                    if LookupTaxJurisdiction.Get("Report-to Jurisdiction") then                        TempTaxJurisdiction.Description := LookupTaxJurisdiction.Description                    else                        TempTaxJurisdiction.Description := Text003;                    TempTaxJurisdiction.Insert();                end;            end;            trigger OnPostDataItem()            begin                NumReportTo := TempTaxJurisdiction.Count();            end;            trigger OnPreDataItem()            begin                TempTaxJurisdiction.DeleteAll();                TempTaxJurisdiction.Init();                SetFilter("Report-to Jurisdiction", ReportToFilter);            end;        }        dataitem(CurReportTo; "Integer")        {            DataItemTableView = sorting(Number);            dataitem("Tax Jurisdiction"; "Tax Jurisdiction")            {                DataItemTableView = sorting(Code);                RequestFilterFields = "Code", "Report-to Jurisdiction", "Tax Group Filter", "Date Filter";                column(Title; Title)                {                }                column(Time; Time)                {                }                column(CompanyInfoName; CompanyInfo.Name)                {                }                column(SubTitle; SubTitle)                {                }                column(JurisFilters_TaxJurisdiction; TableCaption + ': ' + JurisFilters)                {                }                column(JurisFilters; JurisFilters)                {                }                column(RepType; ReportType)                {                }                column(TblCptnCode; TableCaption + ' ' + FieldCaption(Code) + ': ' + Code)                {                }                column(Desc_TaxJurisdiction; Description)                {                }                column(Rep_TaxJurisdiction; "Report-to Jurisdiction")                {                }                column(RepJurisdiction; StrSubstNo(Text004, FieldCaption("Report-to Jurisdiction"), "Report-to Jurisdiction"))                {                }                column(SalesTaxAmt; SalesTaxAmount)                {                    AutoFormatType = 1;                }                column(Code_TaxJurisdiction; Code)                {                }                column(DateFilter_TaxJurisdiction; "Date Filter")                {                }                column(CurrReportPAGENOCaption; CurrReportPAGENOCaptionLbl)                {                }                column(SalesTaxAmountControl3Caption; SalesTaxAmountControl3CaptionLbl)                {                }                column(TaxableSalesAmountCaption; TaxableSalesAmountCaptionLbl)                {                }                column(NonTaxableSalesAmountCaption; NonTaxableSalesAmountCaptionLbl)                {                }                column(ExemptSalesAmountCaption; ExemptSalesAmountCaptionLbl)                {                }                column(TaxJurisdictionDescriptionCaption; TaxJurisdictionDescriptionCaptionLbl)                {                }                column(VATEntryTaxGroupUsedCaption; VATEntryTaxGroupUsedCaptionLbl)                {                }                column(VATEntryPostingDateCaption; VATEntryPostingDateCaptionLbl)                {                }                dataitem("VAT Entry"; "VAT Entry")                {                    DataItemLink = "Tax Jurisdiction Code" = field(Code), "Tax Group Used" = field("Tax Group Filter"), "Posting Date" = field("Date Filter");                    DataItemTableView = sorting("Tax Jurisdiction Code", "Tax Group Used", "Tax Type", "Use Tax", "Posting Date") where("Tax Type" = const("Sales Tax"));                    column(Code_TaxGroupUsed; FieldCaption("Tax Group Code") + ': ' + "Tax Group Used")                    {                    }                    column(TaxGroupDesc; TaxGroup.Description)                    {                    }                    column(SalesTaxAmtControl3; SalesTaxAmount)                    {                        AutoFormatType = 1;                    }                    column(VATEntryBilltoPaytoNo; "Bill-to/Pay-to No.")                    {                        IncludeCaption = true;                    }                    column(TaxableSalesAmt; TaxableSalesAmount)                    {                        AutoFormatType = 1;                    }                    column(NonTaxableSalesAmt; NonTaxableSalesAmount)                    {                        AutoFormatType = 1;                    }                    column(ExemptSalesAmt; ExemptSalesAmount)                    {                        AutoFormatType = 1;                    }                    column(VATEntryDocNo; "Document No.")                    {                        IncludeCaption = true;                    }                    column(VATEntryDocType; "Document Type")                    {                        IncludeCaption = true;                    }                    column(VATEntryPostingDate; Format("Posting Date"))                    {                    }                    column(VATEntryUseTax; "Use Tax")                    {                        IncludeCaption = true;                    }                    column(UseTaxtxt; UseTaxtxt)                    {                    }                    column(VATEntryTaxGroupUsed; "Tax Group Used")                    {                    }                    column(TaxGroupUsed; StrSubstNo(Text005, FieldCaption("Tax Group Code"), "Tax Group Used"))                    {                    }                    column(VATEntryTaxJurisdictionCode; "Tax Jurisdiction Code")                    {                        IncludeCaption = true;                    }                    column(CodeCaptn_TaxJurisdiction; StrSubstNo(Text005, FieldCaption("Tax Jurisdiction Code"), "Tax Jurisdiction Code"))                    {                    }                    column(VATEntryPostingDate1; "Posting Date")                    {                    }                    trigger OnAfterGetRecord()                    begin                        ClearTaxAmounts();                        if ((Type = Type::Purchase) and IncludeUseTax and "Use Tax") or (Type = Type::Sale) then begin                            if Type = Type::Sale then begin                                Amount := -Amount;                                Base := -Base;                            end;                            SalesTaxAmount := Amount;                            if Amount = 0 then                                if "Tax Liable" then                                    NonTaxableSalesAmount := Base                                else                                    ExemptSalesAmount := Base                            else                                TaxableSalesAmount := Base;                        end else                            CurrReport.Skip();                        if ReportType <> ReportType::Summary then                            if "Tax Group Used" <> '' then                                TaxGroup.Get("Tax Group Used")                            else                                TaxGroup.Init();                        UseTaxtxt := Format("Use Tax");                    end;                }                trigger OnAfterGetRecord()                begin                    ClearTaxAmounts();                end;                trigger OnPreDataItem()                begin                    SetRange("Report-to Jurisdiction", TempTaxJurisdiction.Code);                end;            }            trigger OnAfterGetRecord()            begin                if Number = 1 then                    TempTaxJurisdiction.Find('-')                else                    TempTaxJurisdiction.Next();                SubTitle := TempTaxJurisdiction.FieldCaption("Report-to Jurisdiction") +                  ': ' +                  TempTaxJurisdiction.Code +                  '  (' +                  TempTaxJurisdiction.Description +                  ')';            end;            trigger OnPreDataItem()            begin                SetRange(Number, 1, NumReportTo);            end;        }    }    requestpage    {        SaveValues = true;        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(ReportType; ReportType)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Report Type';                        OptionCaption = 'Summary,Normal,Detail';                        ToolTip = 'Specifies one of the available report types to determine how detailed you want the report to be.';                    }                    field(IncludeUseTax; IncludeUseTax)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Include Use Tax';                        ToolTip = 'Specifies if you want the report to include tax entries on which the tax amounts are marked as use tax.';                    }                }            }        }        actions        {        }    }    rendering    {        layout(RDLCLayout)        {            Type = RDLC;            LayoutFile = './Finance/SalesTax/SalesTaxesCollected.rdlc';            Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.';        }    }    labels    {    }    trigger OnPreReport()    begin        CompanyInfo.Get();        ReportToFilter := "Tax Jurisdiction".GetFilter("Report-to Jurisdiction");        "Tax Jurisdiction".SetRange("Report-to Jurisdiction");        JurisFilters := "Tax Jurisdiction".GetFilters();        case ReportType of            ReportType::Summary:                Title := Text000;            ReportType::Normal:                Title := Text001;            ReportType::Detail:                Title := Text002;        end;    end;    var        CompanyInfo: Record "Company Information";        TempTaxJurisdiction: Record "Tax Jurisdiction" temporary;        LookupTaxJurisdiction: Record "Tax Jurisdiction";        TaxGroup: Record "Tax Group";        ReportType: Option Summary,Normal,Detail;        JurisFilters: Text;        ReportToFilter: Text[250];        Title: Text[132];        SubTitle: Text[132];        NumReportTo: Integer;        NonTaxableSalesAmount: Decimal;        TaxableSalesAmount: Decimal;        ExemptSalesAmount: Decimal;        SalesTaxAmount: Decimal;        IncludeUseTax: Boolean;        UseTaxtxt: Text[30];#pragma warning disable AA0074        Text000: Label 'Sales Taxes Collected, Summary';        Text001: Label 'Sales Taxes Collected';        Text002: Label 'Sales Taxes Collected, Detail';        Text003: Label 'Unknown Jurisdiction';#pragma warning disable AA0470        Text004: Label 'Total Sales Taxes Collected for %1: %2';        Text005: Label 'Total for %1: %2';#pragma warning restore AA0470#pragma warning restore AA0074        CurrReportPAGENOCaptionLbl: Label 'Page';        SalesTaxAmountControl3CaptionLbl: Label 'Sales Tax Amount';        TaxableSalesAmountCaptionLbl: Label 'Taxable Sales Amount';        NonTaxableSalesAmountCaptionLbl: Label 'Nontaxable Sales Amount';        ExemptSalesAmountCaptionLbl: Label 'Exempt Sales Amount';        TaxJurisdictionDescriptionCaptionLbl: Label 'Description';        VATEntryTaxGroupUsedCaptionLbl: Label 'Tax Group Code';        VATEntryPostingDateCaptionLbl: Label 'Posting Date';    local procedure ClearTaxAmounts()    begin        NonTaxableSalesAmount := 0;        TaxableSalesAmount := 0;        ExemptSalesAmount := 0;        SalesTaxAmount := 0;    end;}