We are currently exploring options to identify contra entries for individual ledger rows, particularly in cases where a single voucher contains multiple line items:
- If we select a debit entry, we want to identify which account was credited against it.
- Conversely, if we select a credit entry, we want to see which account was debited against it.
Additionally, we are seeking a comprehensive report that provides the following details:
- Opening balance at the start of the period for a specified account or filter criteria.
- Debit and credit entries at the line level, showing all transactions impacting the account.
- Line-level balances after each entry.
- Closing balance at the end of the period.
It would also be highly beneficial if the report supports drill-down functionality:
- Clicking on a line-level entry should display all subsequent effective entries that impact the General Ledger (GL).
- The report should also show the corresponding vouchers or transactions associated with those entries, providing full traceability and transparency.
This functionality will ensure accurate reconciliation, complete visibility of transaction flows, and facilitate auditing for complex accounting scenarios.