GL Transaction Search Page Enhancements
What is it?
Two important usability improvements have been added to the GL Transaction Search page:
-
Total Row – A new row at the bottom of the search results now displays summarized totals for key financial columns.
-
Opening Balance Filter – Users can now filter by Accounting Month 00 to easily view opening balance transactions.
Why it matters
These changes make the GL Transaction Search page more functional and insightful:
-
The Total Row provides quick access to financial totals without the need to export or manually calculate them.
-
The Opening Balance Filter helps finance teams quickly locate starting balances for reconciliation and reporting tasks—something that was previously harder to isolate.
Together, these features reduce the time users spend compiling or reviewing transactional data and improve accuracy.
How it works
-
The Total Row appears at the bottom of the search results and displays values for:
-
Office Currency Amount
-
Display Currency Amount
-
Balance Amount
-
Reconciled Amount
Totals are based on the filters applied. Users should be aware that totals may appear illogical if results span multiple offices or currencies.
-
-
The Opening Balance Filter allows users to select Accounting Month 00, which will return only transactions that contribute to a job or account’s opening balance.
Both features are now available in the test environment and will be included in the upcoming production release.
When is it needed?
Use these enhancements when:
-
You want to validate or sum totals for a filtered set of GL transactions.
-
You're preparing opening balance reports or doing month-end reconciliation.
-
You need to confirm transaction data without exporting to Excel.
These changes are especially useful for finance, accounting, and audit users who rely heavily on the GL Transaction Search tool for detailed analysis.
New Option to Hide Fully Transferred Job Costs on Summaries and Reports
What is it?
A new system-wide setting “Suppress Full Transfers on Job Summaries and Reports” has been introduced under Set Up Options > Other Options. When enabled, this option hides job cost transactions that have been fully transferred out of a job. It applies across selected financial and cost-related reports and summaries.
Why it matters
Job summaries and cost reports often include both the original transaction and its transfer, which can clutter reports and confuse users especially account managers or project leads who only need to see the current financial state of a job. This feature streamlines job views, making reports cleaner, clearer, and easier to understand at a glance.
How it works
When this setting is turned on in the Set Up Options:
-
Only full transfers are hidden. Partial transfers will still appear in reports.
-
Both the original transaction and its corresponding transfer are excluded from summaries and reports, provided they meet specific criteria (e.g., not linked to an invoice or income).
-
The change is applied through backend logic, with no need for new checkboxes or filters on individual report pages.
This update affects reports such as:
-
Job Financial Summary
-
Job Cost & Billing Summary
-
Job Transaction Summary
-
Job Financial Status Summary
-
Job External Costs Summary
-
Job Financial Status Time Summary
-
Client Job Invoicing Center
-
Client Job Invoicing Detail
When is it needed?
Enable this option when you want to:
-
Reduce report clutter by hiding transactions no longer relevant to the current job.
-
Help users focus on active, accurate job costs.
-
Avoid confusion about costs that have already been moved elsewhere.
This feature is especially useful for account teams, producers, or managers who don't need full transaction history but do need a clear view of a job’s current financials.