Glfrcreportsb

@Test void testGenerateReportB_FiltersZeroBalances() { // Arrange GLReportRepository mockRepo = Mockito.mock(GLReportRepository.class); GLFinancialReportService service = new GLFinancialReportService(mockRepo);

Understanding and querying GL_FRC_REPORTS_B is highly beneficial for: 1. Catalog Auditing and Cleanup glfrcreportsb

Is it a:

public List<FinancialReportRecord> findLedgerEntries(String ledgerId, LocalDate startDate, LocalDate endDate) String sql = "SELECT account_code, account_name, " + "SUM(debit) as debit, SUM(credit) as credit, " + "SUM(opening_bal) as opening, SUM(closing_bal) as closing " + "FROM gl_journal_entries " + "WHERE ledger_id = ? AND entry_date BETWEEN ? AND ? " + "GROUP BY account_code, account_name"; " + "SUM(debit) as debit

package com.enterprise.finance.gl;

At first glance, glfrcreportsb does not match: SUM(credit) as credit