Question Status

Suggested Answer
mguyder asked a question on 30 Jan 2014 7:18 AM

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

Reply
Suggested Answer
Leslie Vail responded on 30 Jan 2014 5:59 PM

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

Reply
Suggested Answer
Leslie Vail responded on 30 Jan 2014 5:59 PM

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

Reply
mguyder responded on 31 Jan 2014 9:00 AM

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

Reply
Leslie Vail responded on 1 Feb 2014 6:20 AM

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

Reply
Leslie Vail responded on 1 Feb 2014 7:26 AM

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

Reply