Report 92 Import Consolidation from File
src/Layers/W1/BaseApp/Finance/Consolidation/ImportConsolidationfromFile.Report.al321 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.Consolidation;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Finance.GeneralLedger.Journal;using Microsoft.Finance.GeneralLedger.Ledger;using Microsoft.Finance.GeneralLedger.Setup;using System.Environment;using System.IO;using System.Utilities;/// <summary>/// Imports consolidation data from external files (XML or text format) for subsidiary company consolidation processing./// Supports multiple file formats and handles G/L accounts, entries, dimensions, and currency exchange rates./// </summary>/// <remarks>/// File-based consolidation import supporting legacy and modern file formats for offline consolidation scenarios./// Processes comprehensive consolidation data including chart of accounts mapping, transaction details, and dimension information./// Alternative to database and API-based import methods for environments with file-based data exchange requirements./// </remarks>report 92 "Import Consolidation from File"{ Caption = 'Import Consolidation from File'; ProcessingOnly = true; dataset { dataitem("G/L Account"; "G/L Account") { DataItemTableView = sorting("No.") where("Account Type" = const(Posting)); trigger OnAfterGetRecord() begin "Consol. Debit Acc." := "No."; "Consol. Credit Acc." := "No."; "Consol. Translation Method" := "Consol. Translation Method"::"Average Rate (Manual)"; Consolidate.InsertGLAccount("G/L Account"); end; trigger OnPostDataItem() var TempGLEntry: Record "G/L Entry" temporary; TempDimBuf: Record "Dimension Buffer" temporary; begin if FileFormat = FileFormat::"Version 4.00 or Later (.xml)" then CurrReport.Break(); // Import G/L entries while GLEntryFile.Pos <> GLEntryFile.Len do begin GLEntryFile.Read(TextLine); case CopyStr(TextLine, 1, 4) of '<02>': begin TempGLEntry.Init(); Evaluate(TempGLEntry."G/L Account No.", CopyStr(TextLine, 5, 20)); Evaluate(TempGLEntry."Posting Date", CopyStr(TextLine, 26, 9)); Evaluate(TempGLEntry.Amount, CopyStr(TextLine, 36, 22)); if TempGLEntry.Amount > 0 then TempGLEntry."Debit Amount" := TempGLEntry.Amount else TempGLEntry."Credit Amount" := -TempGLEntry.Amount; TempGLEntry."Entry No." := Consolidate.InsertGLEntry(TempGLEntry); end; '<03>': begin TempDimBuf.Init(); TempDimBuf."Table ID" := DATABASE::"G/L Entry"; TempDimBuf."Entry No." := TempGLEntry."Entry No."; TempDimBuf."Dimension Code" := CopyStr(TextLine, 5, 20); TempDimBuf."Dimension Value Code" := CopyStr(TextLine, 26, 20); Consolidate.InsertEntryDim(TempDimBuf, TempDimBuf."Entry No."); end; end; end; Consolidate.SelectAllImportedDimensions(); end; trigger OnPreDataItem() begin if FileFormat = FileFormat::"Version 4.00 or Later (.xml)" then CurrReport.Break(); end; } } requestpage { layout { area(content) { group(Options) { Caption = 'Options'; field(FileFormat; FileFormat) { ApplicationArea = Suite; Caption = 'File Format'; ToolTip = 'Specifies the format of the file that you want to use for consolidation.'; } field(FileNameControl; FileName) { ApplicationArea = Suite; Caption = 'File Name'; ToolTip = 'Specifies the name of the file that you want to use for consolidation.'; trigger OnAssistEdit() var FileManagement: Codeunit "File Management"; ClientTypeMgt: Codeunit "Client Type Management"; begin FilePath := FileManagement.UploadFile(Text031, FileName); if ClientTypeMgt.GetCurrentClientType() in [CLIENTTYPE::Web, CLIENTTYPE::Tablet, CLIENTTYPE::Phone, CLIENTTYPE::Desktop] then ServerFileName := FilePath; FileName := GetFileName(FilePath); end; } field(GLDocNo; GLDocNo) { ApplicationArea = Suite; Caption = 'Document No.'; ToolTip = 'Specifies the document number to be used on all new ledger entries created from the consolidation.'; } } } } actions { } } labels { } trigger OnPostReport() begin if FileFormat = FileFormat::"Version 3.70 or Earlier (.txt)" then Consolidate.SetGlobals( '', '', BusUnit."Company Name", SubsidCurrencyCode, AdditionalCurrencyCode, ParentCurrencyCode, 0, ConsolidStartDate, ConsolidEndDate); Consolidate.UpdateGLEntryDimSetID(); Consolidate.SetDocNo(GLDocNo); GLSetup.GetRecordOnce(); if GLSetup."Journal Templ. Name Mandatory" then Consolidate.SetGenJnlBatch(GenJnlBatch); Consolidate.Run(BusUnit); end; trigger OnPreReport() var BusUnit2: Record "Business Unit"; ConfirmManagement: Codeunit "Confirm Management"; begin if GLDocNo = '' then Error(Text015); if FileFormat = FileFormat::"Version 4.00 or Later (.xml)" then begin Consolidate.ImportFromXML(ServerFileName); Consolidate.GetGlobals( ProductVersion, FormatVersion, BusUnit."Company Name", SubsidCurrencyCode, AdditionalCurrencyCode, ParentCurrencyCode, CheckSum, ConsolidStartDate, ConsolidEndDate); CalculatedCheckSum := Consolidate.CalcCheckSum(); if CheckSum <> CalculatedCheckSum then Error(Text036, CheckSum, CalculatedCheckSum); TransferPerDay := true; end else begin Clear(GLEntryFile); GLEntryFile.TextMode := true; GLEntryFile.Open(ServerFileName); GLEntryFile.Read(TextLine); if CopyStr(TextLine, 1, 4) = '<01>' then begin BusUnit."Company Name" := DelChr(CopyStr(TextLine, 5, 30), '>'); Evaluate(ConsolidStartDate, CopyStr(TextLine, 36, 9)); Evaluate(ConsolidEndDate, CopyStr(TextLine, 46, 9)); Evaluate(TransferPerDay, CopyStr(TextLine, 56, 3)); end; end; if (BusUnit."Company Name" = '') or (ConsolidStartDate = 0D) or (ConsolidEndDate = 0D) then Error(Text001); if not ConfirmManagement.GetResponseOrDefault( StrSubstNo(Text023, ConsolidStartDate, ConsolidEndDate), true) then CurrReport.Quit(); BusUnit.SetCurrentKey("Company Name"); BusUnit.SetRange("Company Name", BusUnit."Company Name"); BusUnit.Find('-'); if BusUnit.Next() <> 0 then Error( Text005 + Text006, BusUnit.FieldCaption("Company Name"), BusUnit."Company Name"); BusUnit.TestField(Consolidate, true); BusUnit2."File Format" := FileFormat; if BusUnit."File Format" <> FileFormat then if not ConfirmManagement.GetResponseOrDefault( StrSubstNo( FileFormatQst, BusUnit.FieldCaption("File Format"), BusUnit2."File Format", BusUnit.TableCaption(), BusUnit."File Format"), true) then CurrReport.Quit(); if FileFormat = FileFormat::"Version 4.00 or Later (.xml)" then begin if SubsidCurrencyCode = '' then SubsidCurrencyCode := BusUnit."Currency Code"; GLSetup.GetRecordOnce(); if (SubsidCurrencyCode <> BusUnit."Currency Code") and (SubsidCurrencyCode <> GLSetup."LCY Code") and not ((BusUnit."Currency Code" = '') and (GLSetup."LCY Code" = '')) then Error( Text002, BusUnit.FieldCaption("Currency Code"), SubsidCurrencyCode, BusUnit.TableCaption(), BusUnit."Currency Code"); end else begin SubsidCurrencyCode := BusUnit."Currency Code"; Window.Open( '#1###############################\\' + Text024 + Text025 + Text026); Window.Update(1, Text027); Window.Update(2, BusUnit.Code); Window.Update(3, ''); end; end; var BusUnit: Record "Business Unit"; GLSetup: Record "General Ledger Setup"; GenJnlBatch: Record "Gen. Journal Batch"; Consolidate: Codeunit Consolidate; Window: Dialog; GLEntryFile: File; FileName: Text; FilePath: Text; FileFormat: Enum "Business Unit File Format"; TextLine: Text[250]; GLDocNo: Code[20]; ConsolidStartDate: Date; ConsolidEndDate: Date; TransferPerDay: Boolean; CheckSum: Decimal; CalculatedCheckSum: Decimal; ParentCurrencyCode: Code[10]; SubsidCurrencyCode: Code[10]; AdditionalCurrencyCode: Code[10]; ProductVersion: Code[10]; FormatVersion: Code[10]; ServerFileName: Text;#pragma warning disable AA0074 Text001: Label 'The file to be imported has an unknown format.';#pragma warning disable AA0470 Text002: Label 'The %1 in the file to be imported (%2) does not match the %1 in the %3 (%4).'; Text005: Label 'The business unit %1 %2 is not unique.\\'; Text006: Label 'Delete %1 in the extra records.';#pragma warning restore AA0470 Text015: Label 'Enter a document number.';#pragma warning disable AA0470 Text023: Label 'Do you want to consolidate in the period from %1 to %2?'; Text024: Label 'Business Unit Code #2##########\'; Text025: Label 'G/L Account No. #3##########\'; Text026: Label 'Date #4######';#pragma warning restore AA0470 Text027: Label 'Reading File...'; Text031: Label 'Import from File';#pragma warning disable AA0470 Text036: Label 'Imported checksum (%1) does not equal the calculated checksum (%2). The file may be corrupt.';#pragma warning restore AA0470#pragma warning restore AA0074 FileFormatQst: Label 'The entered %1, %2, does not equal the %1 on this %3, %4.\Do you want to continue?', Comment = '%1 - field caption, %2 - field value, %3 - table captoin, %4 - field value'; /// <summary> /// Sets consolidation import parameters for file-based data processing. /// Configures file format, file path, and document number for consolidation import from file. /// </summary> /// <param name="NewFileFormat">File format enum for consolidation data import processing</param> /// <param name="NewFilePath">File path location for consolidation data file import</param> /// <param name="NewGLDocNo">G/L document number for imported consolidation transactions</param> procedure SetParameters(NewFileFormat: Enum "Business Unit File Format"; NewFilePath: Text; NewGLDocNo: Code[20]) begin FileFormat := NewFileFormat; FilePath := NewFilePath; FileName := GetFileName(FilePath); GLDocNo := NewGLDocNo; end; /// <summary> /// Sets general journal batch for consolidation import processing. /// Associates imported consolidation transactions with specific journal batch for posting. /// </summary> /// <param name="NewGenJnlBatch">General Journal Batch record for consolidation transaction posting</param> procedure SetGenJnlBatch(NewGenJnlBatch: Record "Gen. Journal Batch") begin GenJnlBatch := NewGenJnlBatch; end; local procedure GetFileName(FilePath: Text): Text var FileManagement: Codeunit "File Management"; begin exit(FileManagement.GetFileName(FilePath)); end;}