Hide invoices with no balance from the A/R Ledger section on an invoice or statement format

  1. Select
    Setup
    , then select
    Custom Formats
    .
  2. Open the invoice or statement format.
  3. Select the
    A/R Ledger
    tab (for invoices) or
    A/R Period Current
    tab (for statements).
  4. Select the
    Detail
    section of the A/R Ledger or A/R Period Current sub-report.
  5. Change the following properties of this section as follows:
    1. In the Behavior section, change the
      CanShrink
      field to
      True
      .
    2. In the Suppression section, add the following formula to the
      PrintWhen
      field:
      [Ledger Entry Amount(Ledger Entry) <> 0]