Codeunit 36954 Finance Filter Helper
src/Apps/W1/PowerBIReports/App/Finance/FinanceFilterHelper.Codeunit.al71 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.PowerBIReports;using Microsoft.Foundation.AuditCodes;using Microsoft.PowerBIReports;codeunit 36954 "Finance Filter Helper"{ Access = Internal; procedure GenerateVLEReportDateFilter(): Text var PBISetup: Record "PowerBI Reports Setup"; FilterRangeLbl: Label '%1..%2', Locked = true; FilterTxt: Text; begin if PBISetup.Get() then begin if (PBISetup."Vend. Ledger Entry Start Date" = 0D) and (PBISetup."Vend. Ledger Entry End Date" = 0D) then exit(''); FilterTxt := StrSubstNo(FilterRangeLbl, Format(PBISetup."Vend. Ledger Entry Start Date"), Format(PBISetup."Vend. Ledger Entry End Date")); exit(FilterTxt); end; exit(''); end; procedure GenerateCLEReportDateFilter(): Text var PBISetup: Record "PowerBI Reports Setup"; FilterRangeLbl: Label '%1..%2', Locked = true; FilterTxt: Text; begin if PBISetup.Get() then begin if (PBISetup."Cust. Ledger Entry Start Date" = 0D) and (PBISetup."Cust. Ledger Entry End Date" = 0D) then exit(''); FilterTxt := StrSubstNo(FilterRangeLbl, Format(PBISetup."Cust. Ledger Entry Start Date"), Format(PBISetup."Cust. Ledger Entry End Date")); exit(FilterTxt); end; exit(''); end; procedure GenerateFinanceReportDateFilter(): Text var PBISetup: Record "PowerBI Reports Setup"; FilterRangeLbl: Label '%1..%2', Locked = true; FilterTxt: Text; begin if PBISetup.Get() then begin if (PBISetup."Finance Start Date" = 0D) and (PBISetup."Finance End Date" = 0D) then exit(''); FilterTxt := StrSubstNo(FilterRangeLbl, Format(PBISetup."Finance Start Date"), Format(PBISetup."Finance End Date")); exit(FilterTxt); end; exit(''); end; procedure GenerateFinanceReportSourceCodeFilter(): Code[10] var SourceCodeSetup: Record "Source Code Setup"; begin SourceCodeSetup.Get(); SourceCodeSetup.TestField("Close Income Statement"); exit(SourceCodeSetup."Close Income Statement"); end;}