Hello all,
The native Trial Balance Summary report (GL632000.rpx) does not have the options to show all the GL account. The option ‘Suppress Zero Balances’ does address the requirement.
Has anyone developed a generic inquiry or report that has options that meets the requirements below?
Include ALL Accounts (Including Zero-Balance)
This is considered the best practice for completeness, auditing, and data consistency.
- Audit & Review: It confirms that an account should be zero and hasn't been omitted by mistake. Seeing a "zero" is different from not seeing the account at all.
- Data Consistency: When exporting trial balances to Excel or other software for consolidation or period-over-period comparison, having a consistent list of all accounts (a standard "chart of accounts" template) is critical. It ensures that rows align correctly for formulas and analysis.
- Completeness Check: It provides a full view of the entire chart of accounts, which is useful for end-of-period reviews.
