EAShortenLedgerChangeToAccountCurrency

This document was generated using Claude.ai

Overview

Ensures ledger transaction lines use the same currency as their associated accounts. Automatically converts currencies when account currency matches the legal entity's main currency.

When This Action Runs

  • Trigger: Automatic during PreSendRequest event
  • Target: Ledger transactions with currency mismatches
  • Purpose: Align transaction line currencies with account currencies
  • Timing: Before ledger transaction processing

How It Works

Currency Validation Process

  1. Identifies mismatches between account currency and transaction line currency
  2. Validates account currency matches legal entity's main currency
  3. Converts currency when conditions are met
  4. Optimizes transaction by consolidating duplicate lines

Conversion Rules

  • Account currency ≠ Transaction currency AND
  • Account currency = Legal entity main currency
  • Transaction has debit or credit amount

Field Updates

When currency conversion occurs:

  • money.rate = 1.0 (exchange rate)
  • money.currency = account.currency (currency alignment)
  • money.amount = money.localAmount (amount update)

Business Use Cases

  1. Multi-Currency Operations: Standardize currencies across accounting lines
  2. Main Currency Alignment: Ensure consistency with legal entity's base currency
  3. Transaction Optimization: Consolidate lines after currency alignment

SQL Troubleshooting

Find Currency Mismatches

SELECT lt.id, a.currency_id AS AccountCurrency, 
       CASE WHEN ltl.debit_amount IS NOT NULL 
            THEN ltl.debit_currency_id
            ELSE ltl.credit_currency_id END AS LineCurrency
FROM LedgerTrans lt
INNER JOIN LedgerTransLine ltl ON lt.id = ltl.ledgerTrans_id  
INNER JOIN Account a ON ltl.account_id = a.id
WHERE a.currency_id != CASE WHEN ltl.debit_amount IS NOT NULL 
                           THEN ltl.debit_currency_id
                           ELSE ltl.credit_currency_id END;

Important Warnings

⚠️ Currency Requirements

  • Main Currency Only: Only processes accounts with legal entity's main currency
  • Exchange Rate Override: Sets rate to 1.0, assuming no conversion needed
  • Automatic Processing: Cannot be manually controlled per transaction

⚠️ Data Impact

  • Transaction Modification: Amounts and currencies changed before processing
  • Line Optimization: May combine or remove lines during shortenLines() call
  • Audit Trail: Track currency conversion effects in reports
  • EAShortenLedger - Consolidates lines after currency alignment
  • EAGenJournalEntry - Generates lines that may need currency alignment
  • EAClearLedgerLines - Clears lines before processing

Module: accounting

Full Class Name: com.namasoft.modules.accounting.domain.utils.actions.EAShortenLedgerChangeToAccountCurrency