Edit the Period Trial Balance To include records with no transactions - Click Nominal codes, then click Reports.
- Click Trial balance and click Period Trial Balance.
- Click Edit, then on the menu bar, click Report.
- Click Report Properties and enter a new name and description.
- Click OK.
- Select the Details header, then in Properties, click Filter.
- Click the finder button . If a Modify Filters window appears click Use Advanced Filter.
- Click Clear, then click OK.
To show zero values - If you want to show zero values, select the debit and credit value expressions and click Properties, then click Formatting.
- Click the finder button, then click Numeric.
- Clear the Suppress if zero check box, then click OK.
- On the menu bar click File, click Save As.
- Enter a new file name then click Save.
- On the menu bar click File, then click Exit.
Edit the Transactional Trial Balance To include records with no transactions - Click Nominal codes, then click Reports.
- Click Trial balance and click Transactional Trial Balance.
- Click Edit, then on the menu bar, click Report.
- Click Report Properties and enter a new name and description.
- Click OK.
- Click Properties, then from the Include Records with no Transactions drop-down, choose True.
- Click Report, then click Joins.
- Select the Join between NOMINAL_LEDGER and AUDIT_JOURNAL.
- In the Properties window, ensure the Conditional Join Type is set to ParentOuter.
- Click OK.
TIP: If the Properties button is not showing by default, this can be enabled by selecting View, then Properties. To show zero values - If you want to show zero values, select the debit and credit value expressions and click Properties, then click Formatting >
- Click the finder button, then click Numeric.
- Clear the Suppress if zero check box, then click OK.
- On the menu bar click File, click Save As.
- Enter a new file name then click Save.
- On the menu bar click File, then click Exit.
TIP: If the Properties button is not showing by default, this can be enabled by selecting View, then Properties. [BCB:19:UK - Sales message :ECB] |