Report Designer - Including records with no transactions on the Trial Balance report
Description

The trial balance reports only show the nominal codes that have transactions in the period for which the report is run. If you want to see the unused nominal codes on the trial balance reports, you must amend the reports to make them appear.

Cause
Resolution

Edit the Period Trial Balance

To include records with no transactions

  1. Click Nominal codes, then click Reports.
  2. Click Trial balance and click Period Trial Balance.
  3. Click Edit, then on the menu bar, click Report.
  4. Click Report Properties and enter a new name and description.
  5. Click OK.
  6. Select the Details header, then in Properties, click Filter.
  7. Click the finder button . If a Modify Filters window appears click Use Advanced Filter.
  8. Click Clear, then click OK.

To show zero values

  1. If you want to show zero values, select the debit and credit value expressions and click Properties, then click Formatting.
  2. Click the finder button, then click Numeric.
  3. Clear the Suppress if zero check box, then click OK.
  4. On the menu bar click File, click Save As.
  5. Enter a new file name then click Save.
  6. On the menu bar click File, then click Exit.

Edit the Transactional Trial Balance

To include records with no transactions

  1. Click Nominal codes, then click Reports.
  2. Click Trial balance and click Transactional Trial Balance.
  3. Click Edit, then on the menu bar, click Report.
  4. Click Report Properties and enter a new name and description.
  5. Click OK.
  6. Click Properties, then from the Include Records with no Transactions drop-down, choose True.
  7. Click Report, then click Joins.
  8. Select the Join between NOMINAL_LEDGER and AUDIT_JOURNAL.
  9. In the Properties window, ensure the Conditional Join Type is set to ParentOuter.
  10. 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

  1. If you want to show zero values, select the debit and credit value expressions and click Properties, then click Formatting >
  2. Click the finder button, then click Numeric.
  3. Clear the Suppress if zero check box, then click OK.
  4. On the menu bar click File, click Save As.
  5. Enter a new file name then click Save.
  6. 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]

 

Steps to duplicate
Related Solutions