Report 512 IC Transactions

Base Application, Microsoft.Intercompany.Reports

src/Layers/W1/BaseApp/Finance/Intercompany/Reports/ICTransactions.Report.al573 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.Intercompany.Reports;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Finance.GeneralLedger.Ledger;using Microsoft.Intercompany.Partner;using Microsoft.Purchases.Payables;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Customer;using Microsoft.Sales.Receivables;using System.Utilities;/// <summary>/// Generates comprehensive intercompany transaction report showing G/L entries, customer ledger entries, and vendor ledger entries for specified partners and date ranges./// Provides detailed transaction analysis for intercompany reconciliation and financial consolidation processes./// </summary>/// <remarks>/// Data sources: G/L Entry, Customer Ledger Entry, Vendor Ledger Entry filtered by IC Partner Code./// Shows beginning balances, detailed transactions, and running balances for each partner and account./// Supports date range filtering and partner selection for targeted intercompany analysis./// </remarks>report 512 "IC Transactions"{    DefaultLayout = RDLC;    RDLCLayout = './Finance/Intercompany/Reports/ICTransactions.rdlc';    ApplicationArea = Intercompany;    Caption = 'Intercompany Transactions';    UsageCategory = ReportsAndAnalysis;    dataset    {        dataitem(HeaderInt; "Integer")        {            DataItemTableView = sorting(Number) order(ascending) where(Number = const(1));            column(USERID; UserId)            {            }            column(COMPANYNAME; COMPANYPROPERTY.DisplayName())            {            }            column(STRSUBSTNO___1___2__ICPartner1_TABLECAPTION_ICPartnerFilter_; StrSubstNo('%1: %2', ICPartner1.TableCaption(), ICPartnerFilter))            {            }            column(ICPartnerFilter; ICPartnerFilter)            {            }            column(STRSUBSTNO___1___2___3__Text004_StartingDate_EndingDate_; StrSubstNo('%1: %2..%3', Text004, StartingDate, EndingDate))            {            }            column(CurrReport_PAGENOCaption; CurrReport_PAGENOCaptionLbl)            {            }            column(Intercompany_TransactionsCaption; Intercompany_TransactionsCaptionLbl)            {            }            dataitem(ICPartner1; "IC Partner")            {                PrintOnlyIfDetail = true;                RequestFilterFields = "Code";                column(STRSUBSTNO___1__2__3__TABLECAPTION_Code_Name_; StrSubstNo('%1 %2 %3', TableCaption(), Code, Name))                {                }                column(ICPartner1_Code; Code)                {                }                column(TempGLEntry__Credit_Amount__Control38Caption; TempGLEntry__Credit_Amount__Control38CaptionLbl)                {                }                column(TempGLEntry__Debit_Amount__Control14Caption; TempGLEntry__Debit_Amount__Control14CaptionLbl)                {                }                column(TempGLEntry__VAT_Amount__Control20Caption; TempGLEntry__VAT_Amount__Control20CaptionLbl)                {                }                column(TempGLEntry_DescriptionCaption; TempGLEntry_DescriptionCaptionLbl)                {                }                column(TempGLEntry__Document_No__Caption; TempGLEntry__Document_No__CaptionLbl)                {                }                column(FORMAT_TempGLEntry__Document_Type__Caption; FORMAT_TempGLEntry__Document_Type__CaptionLbl)                {                }                column(TempGLEntry__Posting_Date_Caption; TempGLEntry__Posting_Date_CaptionLbl)                {                }                column(TempGLEntry__External_Document_No__Caption; TempGLEntry__External_Document_No__CaptionLbl)                {                }                column(BalanceAmountCaption; BalanceAmountCaptionLbl)                {                }                column(General_LedgerCaption; General_LedgerCaptionLbl)                {                }                dataitem("Integer"; "Integer")                {                    DataItemTableView = sorting(Number);                    column(STRSUBSTNO___1__2__3__GLAcc_TABLECAPTION_GLAcc__No___GLAcc_Name_; StrSubstNo('%1 %2 %3', GLAcc.TableCaption(), GLAcc."No.", GLAcc.Name))                    {                    }                    dataitem(Integer2; "Integer")                    {                        DataItemTableView = sorting(Number);                        column(TempGLEntry__Credit_Amount_; TempGLEntry."Credit Amount")                        {                        }                        column(TempGLEntry__Debit_Amount_; TempGLEntry."Debit Amount")                        {                        }                        column(TempGLEntry__VAT_Amount_; TempGLEntry."VAT Amount")                        {                        }                        column(TempGLEntry__Debit_Amount__Control14; TempGLEntry."Debit Amount")                        {                        }                        column(TempGLEntry__VAT_Amount__Control20; TempGLEntry."VAT Amount")                        {                        }                        column(TempGLEntry_Description; TempGLEntry.Description)                        {                        }                        column(TempGLEntry__Document_No__; TempGLEntry."Document No.")                        {                        }                        column(FORMAT_TempGLEntry__Document_Type__; Format(TempGLEntry."Document Type"))                        {                        }                        column(TempGLEntry__Posting_Date_; TempGLEntry."Posting Date")                        {                        }                        column(TempGLEntry__Credit_Amount__Control38; TempGLEntry."Credit Amount")                        {                        }                        column(TempGLEntry__External_Document_No__; TempGLEntry."External Document No.")                        {                        }                        column(BalanceAmount; BalanceAmount)                        {                        }                        column(STRSUBSTNO___1__2___3__GLAcc__No___GLAcc_Name_Text001_; StrSubstNo('%1 %2, %3', GLAcc."No.", GLAcc.Name, Text001))                        {                        }                        trigger OnAfterGetRecord()                        begin                            if Number = 1 then begin                                if TempGLEntry.Find('-') then;                            end else                                if TempGLEntry.Next() = 0 then;                            TempGLEntry.Delete();                            BalanceAmount += TempGLEntry.Amount;                        end;                        trigger OnPreDataItem()                        begin                            TempGLEntry.SetCurrentKey("G/L Account No.");                            TempGLEntry.SetRange("G/L Account No.", TempTotGLEntry."G/L Account No.");                            SetRange(Number, 1, TempGLEntry.Count);                            BalanceAmount := 0;                        end;                    }                    trigger OnAfterGetRecord()                    begin                        if Number = 1 then begin                            if TempTotGLEntry.Find('-') then;                        end else                            if TempTotGLEntry.Next() = 0 then;                        GLAcc.Get(TempTotGLEntry."G/L Account No.");                        TempTotGLEntry.Delete();                    end;                    trigger OnPreDataItem()                    begin                        SetRange(Number, 1, TempTotGLEntry.Count);                    end;                }                trigger OnAfterGetRecord()                var                    GLEntry: Record "G/L Entry";                begin                    GLEntry.SetCurrentKey("IC Partner Code");                    GLEntry.SetRange("IC Partner Code", Code);                    GLEntry.SetFilter("Posting Date", '..%1', EndingDate);                    TempTotGLEntry.SetCurrentKey("G/L Account No.");                    if GLEntry.Find('-') then                        repeat                            TempTotGLEntry.SetRange("G/L Account No.", GLEntry."G/L Account No.");                            if not TempTotGLEntry.Find('-') then begin                                TempTotGLEntry.Init();                                TempTotGLEntry."Entry No." := GLEntry."Entry No.";                                TempTotGLEntry."G/L Account No." := GLEntry."G/L Account No.";                                TempTotGLEntry.Amount := 0;                                TempTotGLEntry.Insert();                            end;                            TempTotGLEntry.Amount := TempTotGLEntry.Amount + GLEntry.Amount;                            TempTotGLEntry."Debit Amount" := TempTotGLEntry."Debit Amount" + GLEntry."Debit Amount";                            TempTotGLEntry."Credit Amount" := TempTotGLEntry."Credit Amount" + GLEntry."Credit Amount";                            if (TempTotGLEntry.Amount = 0) and (GLEntry."Posting Date" < StartingDate) then                                TempTotGLEntry.Delete()                            else                                TempTotGLEntry.Modify();                            if GLEntry."Posting Date" < StartingDate then begin                                TempGLEntry.SetRange("G/L Account No.", GLEntry."G/L Account No.");                                if not TempGLEntry.Find('-') then begin                                    TempGLEntry.Init();                                    TempGLEntry."Entry No." := GLEntry."Entry No.";                                    TempGLEntry."G/L Account No." := GLEntry."G/L Account No.";                                    TempGLEntry."Posting Date" := 0D;                                    TempGLEntry.Description := Text002Lbl;                                    TempGLEntry.Insert();                                end;                                TempGLEntry.Amount := TempGLEntry.Amount + GLEntry.Amount;                                TempGLEntry."Debit Amount" := TempGLEntry."Debit Amount" + GLEntry."Debit Amount";                                TempGLEntry."Credit Amount" := TempGLEntry."Credit Amount" + GLEntry."Credit Amount";                                if (TempGLEntry."Debit Amount" = 0) and (TempGLEntry."Credit Amount" = 0) then                                    TempGLEntry.Delete()                                else                                    TempGLEntry.Modify();                                TempGLEntry.SetRange("G/L Account No.");                            end;                            if GLEntry."Posting Date" >= StartingDate then begin                                TempGLEntry := GLEntry;                                TempGLEntry.Insert();                            end;                        until GLEntry.Next() = 0;                    TempTotGLEntry.SetRange("G/L Account No.");                end;            }            dataitem(ICPartner2; "IC Partner")            {                DataItemTableView = sorting(Code) order(ascending);                PrintOnlyIfDetail = true;                column(ICPartner2_Code; Code)                {                }                column(Cust__Ledger_Entry_DescriptionCaption; "Cust. Ledger Entry".FieldCaption(Description))                {                }                column(Cust__Ledger_Entry__External_Document_No__Caption; "Cust. Ledger Entry".FieldCaption("External Document No."))                {                }                column(Cust__Ledger_Entry__Document_No__Caption; "Cust. Ledger Entry".FieldCaption("Document No."))                {                }                column(Cust__Ledger_Entry__Document_Type_Caption; "Cust. Ledger Entry".FieldCaption("Document Type"))                {                }                column(Cust__Ledger_Entry__Posting_Date_Caption; "Cust. Ledger Entry".FieldCaption("Posting Date"))                {                }                column(Cust__Ledger_Entry__Amount__LCY___Control55Caption; "Cust. Ledger Entry".FieldCaption("Amount (LCY)"))                {                }                column(Cust__Ledger_Entry__Currency_Code_Caption; "Cust. Ledger Entry".FieldCaption("Currency Code"))                {                }                column(Cust__Ledger_Entry_AmountCaption; "Cust. Ledger Entry".FieldCaption(Amount))                {                }                column(BalanceAmount_Control62Caption; BalanceAmount_Control62CaptionLbl)                {                }                column(Customer_LedgerCaption; Customer_LedgerCaptionLbl)                {                }                dataitem(Customer; Customer)                {                    DataItemLink = "No." = field("Customer No.");                    DataItemTableView = sorting("No.") order(ascending);                    PrintOnlyIfDetail = true;                    column(STRSUBSTNO___1__2__3___4__5___TABLECAPTION__No___Name_ICPartner2_TABLECAPTION_ICPartner2_Code_; StrSubstNo('%1 %2 %3 (%4 %5)', TableCaption(), "No.", Name, ICPartner2.TableCaption(), ICPartner2.Code))                    {                    }                    dataitem(CustInt; "Integer")                    {                        DataItemTableView = sorting(Number) order(ascending) where(Number = const(1));                        column(Text002; Text002Lbl)                        {                        }                        column(BalanceAmount_Control65; BalanceAmount)                        {                        }                        trigger OnPreDataItem()                        begin                            DtldCustLedgEntry.SetCurrentKey("Customer No.", "Posting Date");                            DtldCustLedgEntry.SetRange("Customer No.", Customer."No.");                            DtldCustLedgEntry.SetFilter("Posting Date", '<%1', StartingDate);                            DtldCustLedgEntry.CalcSums("Amount (LCY)");                            BalanceAmount := DtldCustLedgEntry."Amount (LCY)";                        end;                    }                    dataitem("Cust. Ledger Entry"; "Cust. Ledger Entry")                    {                        CalcFields = Amount, "Amount (LCY)";                        DataItemLink = "Customer No." = field("No.");                        DataItemTableView = sorting("Customer No.", "Posting Date", "Currency Code") order(ascending);                        column(Cust__Ledger_Entry__Amount__LCY__; "Amount (LCY)")                        {                        }                        column(Cust__Ledger_Entry__Posting_Date_; "Posting Date")                        {                        }                        column(Cust__Ledger_Entry__Document_Type_; "Document Type")                        {                        }                        column(Cust__Ledger_Entry__Document_No__; "Document No.")                        {                        }                        column(Cust__Ledger_Entry_Description; Description)                        {                        }                        column(Cust__Ledger_Entry__External_Document_No__; "External Document No.")                        {                        }                        column(Cust__Ledger_Entry__Amount__LCY___Control55; "Amount (LCY)")                        {                        }                        column(Cust__Ledger_Entry_Amount; Amount)                        {                        }                        column(Cust__Ledger_Entry__Currency_Code_; "Currency Code")                        {                        }                        column(BalanceAmount_Control62; BalanceAmount)                        {                        }                        column(STRSUBSTNO___1__2__3___4__Customer_TABLECAPTION_Customer__No___Customer_Name_Text001_; StrSubstNo('%1 %2 %3, %4', Customer.TableCaption(), Customer."No.", Customer.Name, Text001))                        {                        }                        trigger OnAfterGetRecord()                        begin                            BalanceAmount += "Amount (LCY)";                        end;                        trigger OnPreDataItem()                        begin                            SetRange("Posting Date", StartingDate, EndingDate);                        end;                    }                }                trigger OnPreDataItem()                begin                    CopyFilters(ICPartner1);                end;            }            dataitem(ICPartner3; "IC Partner")            {                DataItemTableView = sorting(Code) order(ascending);                PrintOnlyIfDetail = true;                column(Vendor_Ledger_Entry_DescriptionCaption; "Vendor Ledger Entry".FieldCaption(Description))                {                }                column(Vendor_Ledger_Entry__External_Document_No__Caption; "Vendor Ledger Entry".FieldCaption("External Document No."))                {                }                column(Vendor_Ledger_Entry__Document_No__Caption; "Vendor Ledger Entry".FieldCaption("Document No."))                {                }                column(Vendor_Ledger_Entry__Document_Type_Caption; "Vendor Ledger Entry".FieldCaption("Document Type"))                {                }                column(Vendor_Ledger_Entry__Posting_Date_Caption; "Vendor Ledger Entry".FieldCaption("Posting Date"))                {                }                column(Vendor_Ledger_Entry__Amount__LCY___Control96Caption; "Vendor Ledger Entry".FieldCaption("Amount (LCY)"))                {                }                column(Vendor_Ledger_Entry__Currency_Code_Caption; "Vendor Ledger Entry".FieldCaption("Currency Code"))                {                }                column(Vendor_Ledger_Entry_AmountCaption; "Vendor Ledger Entry".FieldCaption(Amount))                {                }                column(BalanceAmount_Control97Caption; BalanceAmount_Control97CaptionLbl)                {                }                column(Vendor_LedgerCaption; Vendor_LedgerCaptionLbl)                {                }                dataitem(Vendor; Vendor)                {                    DataItemLink = "No." = field("Vendor No.");                    DataItemTableView = sorting("No.") order(ascending);                    PrintOnlyIfDetail = true;                    column(STRSUBSTNO___1__2__3___4__5___TABLECAPTION__No___Name_ICPartner3_TABLECAPTION_ICPartner3_Code_; StrSubstNo('%1 %2 %3 (%4 %5)', TableCaption(), "No.", Name, ICPartner3.TableCaption(), ICPartner3.Code))                    {                    }                    column(Vendor_No_; "No.")                    {                    }                    dataitem(VendInt; "Integer")                    {                        DataItemTableView = sorting(Number) order(ascending) where(Number = const(1));                        column(Text002_Control87; Text002Lbl)                        {                        }                        column(BalanceAmount_Control88; BalanceAmount)                        {                        }                        trigger OnPreDataItem()                        begin                            DtldVendLedgEntry.SetCurrentKey("Vendor No.", "Posting Date");                            DtldVendLedgEntry.SetRange("Vendor No.", Vendor."No.");                            DtldVendLedgEntry.SetFilter("Posting Date", '<%1', StartingDate);                            DtldVendLedgEntry.CalcSums("Amount (LCY)");                            BalanceAmount := DtldVendLedgEntry."Amount (LCY)";                        end;                    }                    dataitem("Vendor Ledger Entry"; "Vendor Ledger Entry")                    {                        CalcFields = Amount, "Amount (LCY)";                        DataItemLink = "Vendor No." = field("No.");                        DataItemTableView = sorting("Vendor No.", "Posting Date", "Currency Code") order(ascending);                        column(Vendor_Ledger_Entry__Amount__LCY__; "Amount (LCY)")                        {                        }                        column(Vendor_Ledger_Entry__Posting_Date_; "Posting Date")                        {                        }                        column(Vendor_Ledger_Entry__Document_Type_; "Document Type")                        {                        }                        column(Vendor_Ledger_Entry__Document_No__; "Document No.")                        {                        }                        column(Vendor_Ledger_Entry_Description; Description)                        {                        }                        column(Vendor_Ledger_Entry__External_Document_No__; "External Document No.")                        {                        }                        column(Vendor_Ledger_Entry__Currency_Code_; "Currency Code")                        {                        }                        column(Vendor_Ledger_Entry_Amount; Amount)                        {                        }                        column(Vendor_Ledger_Entry__Amount__LCY___Control96; "Amount (LCY)")                        {                        }                        column(BalanceAmount_Control97; BalanceAmount)                        {                        }                        column(STRSUBSTNO___1__2__3___4__Vendor_TABLECAPTION_Vendor__No___Vendor_Name_Text001_; StrSubstNo('%1 %2 %3, %4', Vendor.TableCaption(), Vendor."No.", Vendor.Name, Text001))                        {                        }                        trigger OnAfterGetRecord()                        begin                            BalanceAmount += "Amount (LCY)";                        end;                        trigger OnPreDataItem()                        begin                            SetRange("Posting Date", StartingDate, EndingDate);                        end;                    }                }                trigger OnPreDataItem()                begin                    CopyFilters(ICPartner1);                end;            }        }    }    requestpage    {        AboutTitle = 'About IC Transactions';        AboutText = 'The **Intercompany Transactions** report lists all posted intercompany sales, purchases, and journal entries between internal entities. Use it for reviewing and reconciling intercompany activity before financial consolidation to ensure transparency and balance across companies.';        SaveValues = true;        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(StartingDate; StartingDate)                    {                        ApplicationArea = Intercompany;                        Caption = 'Starting Date';                        ToolTip = 'Specifies the beginning of the period covered by the report that shows posted intercompany transactions.';                        trigger OnValidate()                        begin                            if (EndingDate > 0D) and (EndingDate < StartingDate) then                                EndingDate := StartingDate;                        end;                    }                    field(EndingDate; EndingDate)                    {                        ApplicationArea = Intercompany;                        Caption = 'Ending Date';                        ToolTip = 'Specifies the end of the period covered by the report.';                        trigger OnValidate()                        begin                            if (EndingDate > 0D) and (EndingDate < StartingDate) then                                Error(Text003);                        end;                    }                }            }        }        actions        {        }    }    labels    {    }    trigger OnPreReport()    begin        ICPartnerFilter := ICPartner1.GetFilters();        if EndingDate = 0D then            EndingDate := DMY2Date(31, 12, 9999);    end;    var        TempGLEntry: Record "G/L Entry" temporary;        TempTotGLEntry: Record "G/L Entry" temporary;        GLAcc: Record "G/L Account";        DtldCustLedgEntry: Record "Detailed Cust. Ledg. Entry";        DtldVendLedgEntry: Record "Detailed Vendor Ledg. Entry";        EndingDate: Date;        StartingDate: Date;#pragma warning disable AA0074        Text001: Label 'Total';#pragma warning restore AA0074        BalanceAmount: Decimal;#pragma warning disable AA0074        Text003: Label 'Ending date must not be before starting date.';        Text004: Label 'Period';#pragma warning restore AA0074        ICPartnerFilter: Text;        CurrReport_PAGENOCaptionLbl: Label 'Page';        Intercompany_TransactionsCaptionLbl: Label 'Intercompany Transactions';        TempGLEntry__Credit_Amount__Control38CaptionLbl: Label 'Credit Amount';        TempGLEntry__Debit_Amount__Control14CaptionLbl: Label 'Debit Amount';        TempGLEntry__VAT_Amount__Control20CaptionLbl: Label 'VAT Amount';        TempGLEntry_DescriptionCaptionLbl: Label 'Description';        TempGLEntry__Document_No__CaptionLbl: Label 'Document No.';        FORMAT_TempGLEntry__Document_Type__CaptionLbl: Label 'Document Type';        TempGLEntry__Posting_Date_CaptionLbl: Label 'Posting Date';        TempGLEntry__External_Document_No__CaptionLbl: Label 'External Doc. No.';        BalanceAmountCaptionLbl: Label 'Balance';        General_LedgerCaptionLbl: Label 'General Ledger';        BalanceAmount_Control62CaptionLbl: Label 'Balance (LCY)';        Customer_LedgerCaptionLbl: Label 'Customer Ledger';        Text002Lbl: Label 'Beginning balance';        BalanceAmount_Control97CaptionLbl: Label 'Balance (LCY)';        Vendor_LedgerCaptionLbl: Label 'Vendor Ledger';}