Report 1128 Cost Acctg. Journal
- App
- Base Application
- Namespace
- Microsoft.CostAccounting.Reports
- Versions
- 17-28
Versions171819202122232425262728
Source29
Source in 29
src/Layers/W1/BaseApp/CostAccounting/Reports/CostAcctgJournal.Report.al249 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.CostAccounting.Reports;
using Microsoft.CostAccounting.Account;
using Microsoft.CostAccounting.Journal;
using System.Utilities;
report 1128 "Cost Acctg. Journal"
{
DefaultLayout = RDLC;
RDLCLayout = './CostAccounting/Reports/CostAcctgJournal.rdlc';
ApplicationArea = CostAccounting;
Caption = 'Cost Acctg. Journal';
ToolTip = 'Run the Cost Acctg. Journal report.';
UsageCategory = ReportsAndAnalysis;
dataset
{
dataitem("Cost Journal Line"; "Cost Journal Line")
{
DataItemTableView = sorting("Journal Template Name", "Journal Batch Name", "Line No.");
RequestFilterFields = "Journal Template Name", "Journal Batch Name", "Posting Date", "Line No.", "Cost Center Code", "Cost Object Code";
column(CompanyName; COMPANYPROPERTY.DisplayName())
{
}
column("Filter"; Text011 + GetFilters)
{
}
column(CostTypeNo_CostJourLine; "Cost Type No.")
{
}
column(PostingDate_CostJourLine; Format("Posting Date"))
{
}
column(DocNo_CostJourLine; "Document No.")
{
IncludeCaption = true;
}
column(Text_CostJourLine; Description)
{
IncludeCaption = true;
}
column(BalCostTypeNo_CostJourLine; "Bal. Cost Type No.")
{
}
column(Amount_CostJourLine; Amount)
{
IncludeCaption = true;
}
column(CostCentCode_CostJourLine; "Cost Center Code")
{
}
column(CostObjCode_CostJourLine; "Cost Object Code")
{
}
column(BlCostCntCode_CostJourLine; "Bal. Cost Center Code")
{
IncludeCaption = true;
}
column(BlCostObjCode_CostJourLine; "Bal. Cost Object Code")
{
IncludeCaption = true;
}
column(Balance_CostJourLine; Balance)
{
}
column(JourBatchName_CostJourLine; "Journal Batch Name")
{
}
column(LineNo_CostJourLine; "Line No.")
{
}
column(CAJournalCaption; CAJournalCaptionLbl)
{
}
column(BalCTCaption; BalCTCaptionLbl)
{
}
column(COCaption; COCaptionLbl)
{
}
column(CCCaption; CCCaptionLbl)
{
}
column(CostTypeCaption; CostTypeCaptionLbl)
{
}
column(PostingDateCaption; PostingDateCaptionLbl)
{
}
column(BalanceCaption; BalanceCaptionLbl)
{
}
column(TotalAmountCaption; TotalAmountCaptionLbl)
{
}
dataitem("Integer"; "Integer")
{
DataItemTableView = sorting(Number);
column(ErrorlineNumber; Errorline[Number])
{
}
trigger OnAfterGetRecord()
begin
if Errorline[Number] = '' then
CurrReport.Skip();
end;
trigger OnPreDataItem()
begin
if not WithError then
CurrReport.Break();
SetRange(Number, 1, 20);
end;
}
trigger OnAfterGetRecord()
begin
if WithError then begin
Lineno := 0;
Clear(Errorline);
if "Posting Date" = 0D then
WriteErrorLine(Text000);
if "Document No." = '' then
WriteErrorLine(Text001);
if ("Cost Type No." = '') and ("Bal. Cost Type No." = '') then
WriteErrorLine(Text002);
if "Cost Type No." <> '' then begin
CostType.Get("Cost Type No.");
if CostType.Blocked then
WriteErrorLine(Text003);
if CostType.Type <> CostType.Type::"Cost Type" then
WriteErrorLine(StrSubstNo(Text004, CostType.Type));
if ("Cost Center Code" = '') and ("Cost Object Code" = '') then
WriteErrorLine(Text005);
if ("Cost Center Code" <> '') and ("Cost Object Code" <> '') then
WriteErrorLine(Text006);
end;
if "Bal. Cost Type No." <> '' then begin
CostType.Get("Bal. Cost Type No.");
if CostType.Blocked then
WriteErrorLine(Text007);
if CostType.Type <> CostType.Type::"Cost Type" then
WriteErrorLine(StrSubstNo(Text008, CostType.Type));
if ("Bal. Cost Center Code" = '') and ("Bal. Cost Object Code" = '') then
WriteErrorLine(Text009);
if ("Bal. Cost Center Code" <> '') and ("Bal. Cost Object Code" <> '') then
WriteErrorLine(Text010);
end;
end;
end;
trigger OnPreDataItem()
begin
Clear(Amount);
Clear(Balance);
end;
}
}
requestpage
{
AboutTitle = 'About Cost Acctg. Journal';
AboutText = 'The **Cost Acctg. Journal** report displays cost entries recorded in journals, including amounts, dates, and dimensions. Use it for validating posted cost transactions by reviewing journalized entries and ensuring accuracy in cost postings.';
SaveValues = true;
layout
{
area(content)
{
group(Options)
{
Caption = 'Options';
field(WithErrorMessages; WithError)
{
ApplicationArea = CostAccounting;
Caption = 'With Error Messages';
ToolTip = 'Specifies that a plausibility check has been performed, with the appropriate message is displayed.';
}
}
}
}
actions
{
}
}
labels
{
}
var
CostType: Record "Cost Type";
WithError: Boolean;
Errorline: array[20] of Text[80];
Lineno: Integer;
#pragma warning disable AA0074
Text000: Label 'Posting date is not defined.';
Text001: Label 'Document no. is not defined.';
Text002: Label 'Define cost type or balance cost type.';
Text003: Label 'Cost type is blocked.';
#pragma warning disable AA0470
Text004: Label 'Cost type must not be line type %1.';
#pragma warning restore AA0470
Text005: Label 'Cost center or cost object must be defined.';
Text006: Label 'Cost center and cost object cannot be both defined concurrently.';
Text007: Label 'Balance cost type is blocked.';
#pragma warning disable AA0470
Text008: Label 'Balance cost type must have line type %1.';
#pragma warning restore AA0470
Text009: Label 'Balance cost center or cost object must be defined.';
Text010: Label 'Balance cost center and cost object cannot be both defined concurrently.';
Text011: Label 'Filter: ';
#pragma warning restore AA0074
CAJournalCaptionLbl: Label 'Cost Accounting Journal';
BalCTCaptionLbl: Label 'Balance CT';
COCaptionLbl: Label 'CO';
CCCaptionLbl: Label 'CC';
CostTypeCaptionLbl: Label 'CostType';
PostingDateCaptionLbl: Label 'Posting Date';
BalanceCaptionLbl: Label 'Balance';
TotalAmountCaptionLbl: Label 'Total Amount';
local procedure WriteErrorLine(ErrorTxt: Text[80])
begin
Lineno := Lineno + 1;
Errorline[Lineno] := ErrorTxt;
end;
}