This modification adds a new Interactive View to the General Ledger that resembles a checkbook check register. It shows the beginning balance (GL balance) for a period and then lists all the activity for that account with a running balance.
How to Use
Select a Bank Account and a period range and click Refresh or Apply. The view calculates the beginning GL balance for the GL account associated with that bank account. It then lists every journal entry in that account (sorted by transaction date and then entry number) along with a running balance.
You can also drill into data by double-clicking an entry and the appropriate interactive view is displayed based on the source of the transaction:
- If AR/SO you are drilled into the AR Detail History to show the payment detail (each cash receipt) making up the deposit.
- If AP/PO you are drilled into the AP Payment History view where you can see each invoice paid by that particular check and can then also drill into the invoice detail if needed.
- If PA you are drilled into the PA Check History view where you can see each employee check that was part of the check run
This modification requires Traverse to be running on SQL 2012.