Report Restriction Account Due Report

This question has suggested answer(s)

I am trying to add a Restriction to my report to block all Zero balances from printing.

Asking it to Exclude the Zero Balances thru the Sales Analysis Report Options is not excluding ALL the zeros.

I get no accounts listed.

TY again for your assistance.  Y'all are life savers.

mary

All Replies
  • Try using the Current Trx Amount field in the RM Open table.

    Kind regards,

    Leslie

    Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITS
    ASCI, Inc.    *    PO Box 600965   *   Dallas, TX 75360    *   972-814-8550   *   leslievail@earthlink.net

  • I used the Customer Balance filed from the Customer Master Summary table.

    Of course now the report does not give me a total.  Is this a calculated field?

    How do I give this report a total?

    TY

  • Mary,

    Are you printing the report in Summary, or in Detail?

    If you are printing in Detail, I think you will be better served by using the Current Trx Amount field in the RM Open table.

    Kind regards,

    Leslie

    Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITS
    ASCI, Inc.    *    PO Box 600965   *   Dallas, TX 75360    *   972-814-8550   *   leslievail@earthlink.net

  • Hi Mary

    If you are still having problems with this, I would be happy to take a peek at it for you. If you would like me to do that, please e-mail me the package file.  leslievail@earthlink.net

    Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITS
    ASCI, Inc.    *    PO Box 600965   *   Dallas, TX 75360    *   972-814-8550   *   leslievail@earthlink.net