Codeunit 407 Adjust Gen. Journal Balance
src/Layers/W1/BaseApp/Finance/GeneralLedger/Journal/AdjustGenJournalBalance.Codeunit.al198 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.GeneralLedger.Journal;using Microsoft.Finance.Currency;/// <summary>/// Provides functionality to insert LCY rounding correction lines in general journals to balance foreign currency transactions./// Calculates and creates rounding adjustment entries when foreign currency amounts don't balance perfectly in local currency./// </summary>/// <remarks>/// Core functionality for multi-currency journal posting accuracy. Ensures journal batches balance correctly in local currency/// when foreign currency transactions create minor rounding differences during currency conversion./// Key features: Automatic rounding detection, correction line creation, currency-specific rounding account assignment./// Integration: Uses currency setup rounding accounts and general ledger posting groups for correction entries./// </remarks>codeunit 407 "Adjust Gen. Journal Balance"{ TableNo = "Gen. Journal Line"; trigger OnRun() var GenJnlLine: Record "Gen. Journal Line"; PrevGenJnlLine: Record "Gen. Journal Line"; CorrectionEntry: Boolean; TotalAmountLCY: Decimal; begin TempCurrTotalBuffer.DeleteAll(); GenJnlLine.SetRange("Journal Template Name", Rec."Journal Template Name"); GenJnlLine.SetRange("Journal Batch Name", Rec."Journal Batch Name"); OnRunOnBeforeGenJnlLineFind(GenJnlLine); if not GenJnlLine.Find('-') then exit; PrevGenJnlLine := GenJnlLine; CorrectionEntry := true; TotalAmountLCY := 0; repeat if (GenJnlLine."Posting Date" <> PrevGenJnlLine."Posting Date") or (GenJnlLine."Document No." <> PrevGenJnlLine."Document No.") then begin if CheckCurrBalance() and (TotalAmountLCY <> 0) then begin PrevGenJnlLine.Correction := CorrectionEntry; InsertCorrectionLines(GenJnlLine, PrevGenJnlLine); end; TotalAmountLCY := 0; TempCurrTotalBuffer.DeleteAll(); CorrectionEntry := true; PrevGenJnlLine := GenJnlLine; end; TotalAmountLCY := TotalAmountLCY + GenJnlLine."Amount (LCY)"; if GenJnlLine."Bal. Account No." = '' then begin if TempCurrTotalBuffer.Get(GenJnlLine."Currency Code") then begin TempCurrTotalBuffer."Total Amount" := TempCurrTotalBuffer."Total Amount" + GenJnlLine.Amount; TempCurrTotalBuffer."Total Amount (LCY)" := TempCurrTotalBuffer."Total Amount (LCY)" + GenJnlLine."Amount (LCY)"; TempCurrTotalBuffer.Modify(); end else begin TempCurrTotalBuffer."Currency Code" := GenJnlLine."Currency Code"; TempCurrTotalBuffer."Total Amount" := GenJnlLine.Amount; TempCurrTotalBuffer."Total Amount (LCY)" := GenJnlLine."Amount (LCY)"; TempCurrTotalBuffer.Insert(); end; CorrectionEntry := CorrectionEntry and GenJnlLine.Correction; end; if GenJnlLine."Document Type" <> PrevGenJnlLine."Document Type" then GenJnlLine."Document Type" := GenJnlLine."Document Type"::" "; if GenJnlLine."Business Unit Code" <> PrevGenJnlLine."Business Unit Code" then GenJnlLine."Business Unit Code" := ''; if GenJnlLine."Reason Code" <> PrevGenJnlLine."Reason Code" then GenJnlLine."Reason Code" := ''; if GenJnlLine."Recurring Method" <> PrevGenJnlLine."Recurring Method" then GenJnlLine."Recurring Method" := GenJnlLine."Recurring Method"::" "; if GenJnlLine."Recurring Frequency" <> PrevGenJnlLine."Recurring Frequency" then Evaluate(GenJnlLine."Recurring Frequency", '<>'); PrevGenJnlLine := GenJnlLine; until GenJnlLine.Next() = 0; Clear(PrevGenJnlLine); if CheckCurrBalance() and (TotalAmountLCY <> 0) then begin GenJnlLine.Correction := CorrectionEntry; InsertCorrectionLines(PrevGenJnlLine, GenJnlLine); end; end; var TempCurrTotalBuffer: Record "Currency Total Buffer" temporary;#pragma warning disable AA0074#pragma warning disable AA0470 Text000: Label 'The program cannot find a key between line number %1 and line number %2.'; Text002: Label 'Rounding correction for %1';#pragma warning restore AA0470#pragma warning restore AA0074 local procedure CheckCurrBalance(): Boolean var InBalance: Boolean; begin InBalance := true; if TempCurrTotalBuffer.Find('-') then repeat InBalance := InBalance and (TempCurrTotalBuffer."Total Amount" = 0) until (not InBalance) or (TempCurrTotalBuffer.Next() = 0); exit(InBalance); end; local procedure InsertCorrectionLines(var GenJnlLine2: Record "Gen. Journal Line"; var PrevGenJnlLine2: Record "Gen. Journal Line") var Currency: Record Currency; NewGenJnlLine: Record "Gen. Journal Line"; begin NewGenJnlLine := PrevGenJnlLine2; TempCurrTotalBuffer.SetFilter("Currency Code", '<>%1', ''); TempCurrTotalBuffer.SetRange("Total Amount", 0); if TempCurrTotalBuffer.Find('-') then repeat Currency.Get(TempCurrTotalBuffer."Currency Code"); NewGenJnlLine.Init(); if GenJnlLine2."Line No." = 0 then NewGenJnlLine."Line No." := NewGenJnlLine."Line No." + 10000 else if GenJnlLine2."Line No." >= NewGenJnlLine."Line No." + 2 then NewGenJnlLine."Line No." := (NewGenJnlLine."Line No." + GenJnlLine2."Line No.") div 2 else Error( Text000, PrevGenJnlLine2."Line No.", GenJnlLine2."Line No."); NewGenJnlLine."Document Type" := PrevGenJnlLine2."Document Type"; NewGenJnlLine."Account Type" := NewGenJnlLine."Account Type"::"G/L Account"; NewGenJnlLine.Correction := PrevGenJnlLine2.Correction; if NewGenJnlLine.Correction xor (TempCurrTotalBuffer."Total Amount (LCY)" <= 0) then NewGenJnlLine.Validate("Account No.", Currency.GetConvLCYRoundingDebitAccount()) else NewGenJnlLine.Validate("Account No.", Currency.GetConvLCYRoundingCreditAccount()); NewGenJnlLine."Posting Date" := PrevGenJnlLine2."Posting Date"; NewGenJnlLine."Document No." := PrevGenJnlLine2."Document No."; NewGenJnlLine.Description := StrSubstNo(Text002, TempCurrTotalBuffer."Currency Code"); NewGenJnlLine.Validate(Amount, -TempCurrTotalBuffer."Total Amount (LCY)"); NewGenJnlLine."Source Code" := PrevGenJnlLine2."Source Code"; NewGenJnlLine."Business Unit Code" := PrevGenJnlLine2."Business Unit Code"; NewGenJnlLine."Reason Code" := PrevGenJnlLine2."Reason Code"; NewGenJnlLine."Recurring Method" := PrevGenJnlLine2."Recurring Method"; NewGenJnlLine."Recurring Frequency" := PrevGenJnlLine2."Recurring Frequency"; NewGenJnlLine."Posting No. Series" := PrevGenJnlLine2."Posting No. Series"; OnBeforeGenJnlLineInsert(NewGenJnlLine, GenJnlLine2, PrevGenJnlLine2); if TempCurrTotalBuffer."Total Amount (LCY)" <> 0 then begin OnInsertCorrectionLinesOnBeforeNewGenJnlLineInsert(GenJnlLine2, PrevGenJnlLine2, NewGenJnlLine); NewGenJnlLine.Insert(); end; until TempCurrTotalBuffer.Next() = 0; end; /// <summary> /// Integration event raised before inserting currency rounding correction lines into the general journal. /// Enables custom modification of correction line data before insertion. /// </summary> /// <param name="NewGenJnlLine">Correction journal line being prepared for insertion</param> /// <param name="GenJnlLine2">Current journal line context</param> /// <param name="PrevGenJnlLine2">Previous journal line used as template</param> [IntegrationEvent(false, false)] local procedure OnBeforeGenJnlLineInsert(var NewGenJnlLine: Record "Gen. Journal Line"; GenJnlLine2: Record "Gen. Journal Line"; PrevGenJnlLine2: Record "Gen. Journal Line") begin end; /// <summary> /// Integration event raised in correction line insertion process before the new correction line is inserted. /// Provides final opportunity to modify correction line data based on journal context. /// </summary> /// <param name="GenJnlLine2">Current journal line context for correction</param> /// <param name="PrevGenJnlLine2">Previous journal line used as template</param> /// <param name="NewGenJnlLine">Correction line ready for insertion</param> [IntegrationEvent(false, false)] local procedure OnInsertCorrectionLinesOnBeforeNewGenJnlLineInsert(var GenJnlLine2: Record "Gen. Journal Line"; var PrevGenJnlLine2: Record "Gen. Journal Line"; var NewGenJnlLine: Record "Gen. Journal Line") begin end; /// <summary> /// Integration event raised in the main process before finding general journal lines for balance adjustment. /// Enables custom filtering or setup of journal line selection criteria. /// </summary> /// <param name="GenJnlLine">General journal line record with filters applied</param> [IntegrationEvent(false, false)] local procedure OnRunOnBeforeGenJnlLineFind(var GenJnlLine: Record "Gen. Journal Line") begin end;}