Report 5622 Insurance Journal - Test
- App
- Base Application
- Namespace
- Microsoft.FixedAssets.Insurance
- Versions
- 17-28
Versions171819202122232425262728
Source29
Source in 29
src/Layers/W1/BaseApp/FixedAssets/Insurance/InsuranceJournalTest.Report.al236 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.FixedAssets.Insurance;
using Microsoft.Finance.Dimension;
using Microsoft.FixedAssets.FixedAsset;
using Microsoft.FixedAssets.Setup;
using System.Utilities;
report 5622 "Insurance Journal - Test"
{
Caption = 'Insurance Journal - Test';
DefaultRenderingLayout = RDLCLayout;
dataset
{
dataitem("Insurance Journal Batch"; "Insurance Journal Batch")
{
DataItemTableView = sorting("Journal Template Name", Name);
RequestFilterFields = "Journal Template Name", Name;
column(Insurance_Journal_Batch_Journal_Template_Name; "Journal Template Name")
{
}
dataitem("Integer"; "Integer")
{
DataItemTableView = sorting(Number) where(Number = const(1));
PrintOnlyIfDetail = true;
column(Insurance_Journal_Batch__Name; "Insurance Journal Batch".Name)
{
}
column(Insurance_Journal_Batch___Journal_Template_Name_; "Insurance Journal Batch"."Journal Template Name")
{
}
column(COMPANYNAME; COMPANYPROPERTY.DisplayName())
{
}
column(FORMAT_TODAY_0_4_; Format(Today, 0, 4))
{
}
column(Insurance_Journal_Line__TABLECAPTION__________InsuranceJnlLineFilter; "Insurance Journal Line".TableCaption + ': ' + InsuranceJnlLineFilter)
{
}
column(InsuranceJnlLineFilter; InsuranceJnlLineFilter)
{
}
column(Insurance_Journal_Batch__NameCaption; Insurance_Journal_Batch__NameCaptionLbl)
{
}
column(Insurance_Journal_Batch___Journal_Template_Name_Caption; "Insurance Journal Batch".FieldCaption("Journal Template Name"))
{
}
column(Insurance_Journal___TestCaption; Insurance_Journal___TestCaptionLbl)
{
}
column(CurrReport_PAGENOCaption; CurrReport_PAGENOCaptionLbl)
{
}
column(Insurance_Journal_Line__Posting_Date_Caption; Insurance_Journal_Line__Posting_Date_CaptionLbl)
{
}
column(Insurance_Journal_Line__Document_Type_Caption; "Insurance Journal Line".FieldCaption("Document Type"))
{
}
column(Insurance_Journal_Line__Document_No__Caption; "Insurance Journal Line".FieldCaption("Document No."))
{
}
column(Insurance_Journal_Line__FA_No__Caption; "Insurance Journal Line".FieldCaption("FA No."))
{
}
column(Insurance_Journal_Line_DescriptionCaption; "Insurance Journal Line".FieldCaption(Description))
{
}
column(Insurance_Journal_Line_AmountCaption; "Insurance Journal Line".FieldCaption(Amount))
{
}
column(Insurance_Journal_Line__Insurance_No__Caption; "Insurance Journal Line".FieldCaption("Insurance No."))
{
}
dataitem("Insurance Journal Line"; "Insurance Journal Line")
{
DataItemLink = "Journal Template Name" = field("Journal Template Name"), "Journal Batch Name" = field(Name);
DataItemLinkReference = "Insurance Journal Batch";
DataItemTableView = sorting("Journal Template Name", "Journal Batch Name", "Line No.");
RequestFilterFields = "Posting Date";
column(Insurance_Journal_Line__Posting_Date_; Format("Posting Date"))
{
}
column(Insurance_Journal_Line__Document_Type_; "Document Type")
{
}
column(Insurance_Journal_Line__Document_No__; "Document No.")
{
}
column(Insurance_Journal_Line__FA_No__; "FA No.")
{
}
column(Insurance_Journal_Line_Description; Description)
{
}
column(Insurance_Journal_Line_Amount; Amount)
{
}
column(Insurance_Journal_Line__Insurance_No__; "Insurance No.")
{
}
column(Insurance_Journal_Line_Line_No_; "Line No.")
{
}
dataitem(ErrorLoop; "Integer")
{
DataItemTableView = sorting(Number);
column(ErrorText_Number_; ErrorText[Number])
{
}
column(Warning_Caption; Warning_CaptionLbl)
{
}
trigger OnPostDataItem()
begin
ErrorCounter := 0;
end;
trigger OnPreDataItem()
begin
SetRange(Number, 1, ErrorCounter);
end;
}
trigger OnAfterGetRecord()
begin
if "Insurance No." <> '' then begin
if "Posting Date" = 0D then
AddError(
StrSubstNo(
Text000,
FieldCaption("Posting Date")));
if "FA No." = '' then
AddError(
StrSubstNo(
Text000,
FieldCaption("FA No.")))
else
if not FA.Get("FA No.") then
AddError(
StrSubstNo(
Text001, FA.TableCaption(), FA.FieldCaption("No.")));
if "Document No." = '' then
AddError(StrSubstNo(Text000, FieldCaption("Document No.")));
end;
if not DimMgt.CheckDimIDComb("Dimension Set ID") then
AddError(DimMgt.GetDimCombErr());
TableID[1] := DATABASE::Insurance;
No[1] := "Insurance No.";
if not DimMgt.CheckDimValuePosting(TableID, No, "Dimension Set ID") then
AddError(DimMgt.GetDimValuePostingErr());
end;
trigger OnPreDataItem()
begin
InsuranceJnlTempl.Get("Insurance Journal Batch"."Journal Template Name");
Clear(Amount);
end;
}
}
}
}
requestpage
{
layout
{
}
actions
{
}
}
rendering
{
layout(RDLCLayout)
{
Type = RDLC;
LayoutFile = './FixedAssets/Insurance/InsuranceJournalTest.rdlc';
Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.';
}
}
labels
{
}
trigger OnPreReport()
begin
InsuranceJnlLineFilter := "Insurance Journal Line".GetFilters();
FASetup.Get();
FASetup.TestField("Automatic Insurance Posting", true);
end;
var
InsuranceJnlTempl: Record "Insurance Journal Template";
FA: Record "Fixed Asset";
FASetup: Record "FA Setup";
DimMgt: Codeunit DimensionManagement;
ErrorCounter: Integer;
ErrorText: array[50] of Text[250];
InsuranceJnlLineFilter: Text;
TableID: array[10] of Integer;
No: array[10] of Code[20];
#pragma warning disable AA0074
#pragma warning disable AA0470
Text000: Label '%1 must be specified.';
Text001: Label '%1 %2 does not exist.';
#pragma warning restore AA0470
#pragma warning restore AA0074
Insurance_Journal_Batch__NameCaptionLbl: Label 'Journal Batch';
Insurance_Journal___TestCaptionLbl: Label 'Insurance Journal - Test';
CurrReport_PAGENOCaptionLbl: Label 'Page';
Insurance_Journal_Line__Posting_Date_CaptionLbl: Label 'Posting Date';
Warning_CaptionLbl: Label 'Warning!';
local procedure AddError(Text: Text[250])
begin
ErrorCounter := ErrorCounter + 1;
ErrorText[ErrorCounter] := Text;
end;
}