Codeunit 439 Export F/O Consolidation
src/Layers/W1/BaseApp/Finance/Consolidation/ExportFOConsolidation.Codeunit.al288 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.Budget;using Microsoft.Finance.GeneralLedger.Ledger;using Microsoft.Finance.GeneralLedger.Setup;/// <summary>/// Exports consolidation data in Finance and Operations (F&O) format for external system integration./// Handles G/L entry processing, dimension management, and F&O-specific data formatting requirements./// </summary>codeunit 439 "Export F/O Consolidation"{ trigger OnRun() begin end; var TempGLAcc: Record "G/L Account" temporary; TempGLEntry: Record "G/L Entry" temporary; TempGLBudgetEntry: Record "G/L Budget Entry" temporary; TempDimBuf: Record "Dimension Buffer" temporary; TempDimensionIDBuffer: Record "Dimension ID Buffer" temporary; CompanyCurrencyCode: Code[10]; FOLegalEntityID: Code[4]; DimConflictErr: Label 'It is not possible to consolidate ledger entry dimensions for G/L Entry No. %1, because there are conflicting dimension values %2 and %3 for consolidation dimension %4.', Comment = '%1 - entry number, %2 and %3 - dimension values, %4 - dimension code'; LegalEntityIDLineTok: Label '4,"%1"', Comment = '%1 text value'; DimensionLineTok: Label '6,"%1",%2', Comment = '%2 - number, %1 - text value'; DimensionValueLineTok: Label '7,"%1",%2,%3', Comment = '%1 text value, %2, %3 - number'; GLEntryLineTok: Label '2,"%1","%2",%3,"%4",%5,%6,%7,%8,%9', Comment = '%3, %5, %6, %7, %8, %9 - numbers, %1,%4 - text value, %2 - date'; GLAccountLineTok: Label '1,"%1","%2",%3', Comment = '%1, %2 - text value, %3 - number'; /// <summary> /// Sets the Finance and Operations Legal Entity ID for consolidation export processing. /// </summary> /// <param name="NewFOLegalEntityID">Legal Entity ID for F&O system integration</param> procedure SetFOLegalEntityID(NewFOLegalEntityID: Code[4]) begin FOLegalEntityID := NewFOLegalEntityID; end; /// <summary> /// Inserts G/L Entry record into temporary processing table for F&O consolidation export. /// Creates entry with sequential numbering and validates account configuration. /// </summary> /// <param name="NewGLEntry">G/L Entry record to insert for consolidation export</param> /// <returns>Entry number assigned to the inserted G/L entry</returns> procedure InsertGLEntry(NewGLEntry: Record "G/L Entry"): Integer var GLAccount: Record "G/L Account"; NextEntryNo: Integer; begin NextEntryNo := TempGLEntry.GetLastEntryNo() + 1; TempGLEntry.Init(); TempGLEntry."Entry No." := NextEntryNo; GLAccount.Get(NewGLEntry."G/L Account No."); if NewGLEntry."Debit Amount" <> 0 then begin GLAccount.TestField("Consol. Debit Acc."); TempGLEntry."G/L Account No." := GLAccount."Consol. Debit Acc."; end else begin GLAccount.TestField("Consol. Credit Acc."); TempGLEntry."G/L Account No." := GLAccount."Consol. Credit Acc."; end; InsertGLAccount(TempGLEntry."G/L Account No.", GLAccount.Name); TempGLEntry."Posting Date" := NewGLEntry."Posting Date"; TempGLEntry.Amount := NewGLEntry.Amount; TempGLEntry."Debit Amount" := NewGLEntry."Debit Amount"; TempGLEntry."Credit Amount" := NewGLEntry."Credit Amount"; TempGLEntry.Insert(); exit(NextEntryNo); end; local procedure InsertGLAccount(AccountNo: Code[20]; AccountName: Text[100]) begin if not TempGLAcc.Get(AccountNo) then begin TempGLAcc.Init(); TempGLAcc."No." := AccountNo; TempGLAcc.Name := AccountName; TempGLAcc.Insert(); end; end; /// <summary> /// Inserts entry dimension into temporary dimension buffer with conflict validation. /// Validates dimension consistency and creates dimension buffer entries for GL entry processing. /// </summary> /// <param name="NewDimBuf">Dimension buffer record containing dimension data to insert</param> /// <param name="GLEntryNo">G/L Entry number for dimension association</param> procedure InsertEntryDim(NewDimBuf: Record "Dimension Buffer"; GLEntryNo: Integer) begin if TempDimBuf.Get(NewDimBuf."Table ID", GLEntryNo, NewDimBuf."Dimension Code") then begin if NewDimBuf."Dimension Value Code" <> TempDimBuf."Dimension Value Code" then Error( DimConflictErr, GLEntryNo, NewDimBuf."Dimension Value Code", TempDimBuf."Dimension Value Code", NewDimBuf."Dimension Code"); end else begin TempDimBuf.Init(); TempDimBuf := NewDimBuf; TempDimBuf."Entry No." := GLEntryNo; TempDimBuf.Insert(); end; end; local procedure CreateDimensionBuffer() var Id: Integer; begin if TempDimBuf.FindSet() then repeat if not TempDimensionIDBuffer.get(0, TempDimBuf."Dimension Code", '') then begin Id += 1; TempDimensionIDBuffer.Init(); TempDimensionIDBuffer."Dimension Code" := TempDimBuf."Dimension Code"; TempDimensionIDBuffer.ID := Id; TempDimensionIDBuffer.Insert(); end; until TempDimBuf.Next() = 0; end; /// <summary> /// Processes G/L budget entries for specified account and date range during consolidation export. /// Creates temporary budget entry records for Finance & Operations consolidation format. /// </summary> /// <param name="AccountNo">G/L Account number to process budget entries</param> /// <param name="StartDate">Starting date for budget entry processing range</param> /// <param name="EndDate">Ending date for budget entry processing range</param> procedure ProcessGLBugdetEntries(AccountNo: Code[20]; StartDate: Date; EndDate: Date) var GLBudgetEntry: Record "G/L Budget Entry"; GLAccount: Record "G/L Account"; begin GLBudgetEntry.SetRange(Date, StartDate, EndDate); GLBudgetEntry.SetRange("G/L Account No.", AccountNo); if GLBudgetEntry.FindSet() then repeat TempGLBudgetEntry := GLBudgetEntry; if GLBudgetEntry.Amount > 0 then begin GLAccount.Get(GLBudgetEntry."G/L Account No."); GLAccount.TestField("Consol. Debit Acc."); TempGLBudgetEntry."G/L Account No." := GLAccount."Consol. Debit Acc."; end else begin GLAccount.Get(GLBudgetEntry."G/L Account No."); GLAccount.TestField("Consol. Credit Acc."); TempGLBudgetEntry."G/L Account No." := GLAccount."Consol. Credit Acc."; end; TempGLBudgetEntry.Insert(); until GLBudgetEntry.Next() = 0; end; [Scope('OnPrem')] procedure ExportFile(FileName: Text) var OutputFile: File; begin CreateDimensionBuffer(); CompanyCurrencyCode := GetCompanyCurrencyCode(); OutputFile.TextMode(true); OutputFile.WriteMode(true); OutputFile.Create(FileName); WriteHeader(OutputFile); WriteDimensions(OutputFile); WriteGLEntries(OutputFile); WriteDimensionValues(OutputFile); WriteGLAccounts(OutputFile); OutputFile.Close(); end; local procedure WriteHeader(var OutputFile: File) begin OutputFile.Write(StrSubstNo(LegalEntityIDLineTok, FOLegalEntityID)); end; local procedure WriteDimensions(var OutputFile: File) var Dimension: Record Dimension; begin if TempDimensionIDBuffer.FindSet() then repeat Dimension.Get(TempDimBuf."Dimension Code"); OutputFile.Write(StrSubstNo(DimensionLineTok, Dimension.Name, TempDimensionIDBuffer.ID)); until TempDimensionIDBuffer.Next() = 0; end; local procedure WriteDimensionValues(var OutputFile: File) begin if TempGLEntry.FindSet() then repeat TempDimBuf.SetRange("Entry No.", TempGLEntry."Entry No."); if TempDimBuf.FindSet() then repeat TempDimensionIDBuffer.get(0, TempDimBuf."Dimension Code", ''); OutputFile.Write( StrSubstNo( DimensionValueLineTok, TempDimBuf."Dimension Value Code", TempDimensionIDBuffer.ID, TempGLEntry."Entry No.")); until TempDimBuf.Next() = 0; until TempGLEntry.Next() = 0; end; local procedure WriteGLEntries(var OutputFile: File) begin if TempGLEntry.FindSet() then repeat OutputFile.Write( StrSubstNo( GLEntryLineTok, TempGLEntry."G/L Account No.", FormatDate(TempGLEntry."Posting Date"), GetFiscalPeriodType(), CompanyCurrencyCode, BooleanToInt(TempGLEntry."Debit Amount" <> 0), GetPostingLayer(), FormatDecimal(TempGLEntry.Amount), FormatDecimal(TempGLEntry.Quantity), TempGLEntry."Entry No.")); until TempGLEntry.Next() = 0; end; local procedure WriteGLAccounts(var OutputFile: File) begin if TempGLAcc.FindSet() then repeat OutputFile.Write( StrSubstNo( GLAccountLineTok, TempGLAcc."No.", TempGLAcc.Name, GetGLAccountType())); until TempGLAcc.Next() = 0; end; local procedure FormatDate(DateToFormat: Date): Text begin exit(Format(DateToFormat, 0, '<Year4>/<Month,2>/<Day,2>')); end; local procedure FormatDecimal(Amount: Decimal): Text begin exit(Format(Amount, 0, 9)); end; local procedure GetFiscalPeriodType(): Integer begin exit(1); end; local procedure GetGLAccountType(): Integer begin exit(1); end; local procedure GetPostingLayer(): Integer begin exit(0); end; local procedure GetCompanyCurrencyCode(): Code[10] var GLSetup: Record "General Ledger Setup"; begin GLSetup.Get(); GLSetup.TestField("LCY Code"); exit(GLSetup."LCY Code"); end; local procedure BooleanToInt(IsPositive: Boolean): Integer begin if IsPositive then exit(0); exit(1); end;}