To produce a trial balance for specific general ledger accounts that are not in a range or not by department you can use the customize feature to create your own filter. - GL, Reports, Trial Balance, Detailed
- Select the Customize button to bring up the Report Builder
- From the menu select Database, Filter Criteria, Standard Filter
- For the 'Relationship' select WHERE
- For the 'Data Field', using the drop-down arrow select <XGLHeaderData>GLAccountNumber
- For the 'Operator' select Equals
- Use the drop-down arrow in the Value field to select the GL Account Number you wish to use in your filter
- Click the Add button to continue adding fields in your filter criteria using OR for the 'Relationship' so the filter will not be too specific
- Click OK when you have added all the accounts
- Close out of the Report Builder screen and preview or print your report.
NOTE: You can select to save your report for future use by selecting SAVE and giving your report a name such as 'TRIAL BALANCE FILTERED'. The report will be available from the drop-down list the next time you access the GL, Reports, Trial Balance. In addition, you can change the account numbers on this report when necessary by selecting the Customize button, then Database, Standard Filter, and change the account numbers you wish to filter on your report. [BCB:163:Chat BusinessWorks US:ECB]
|