Open Forum

Statements

  • 1.  Statements

    BRONZE CONTRIBUTOR
    Posted Feb 28, 2019 11:07 AM
    When running Statements (08.600.00) am I able to choose only customers who have activity/balances for the month?
    When I run it, it is bringing up 133 customers and 57 of them have no activity nor balances.  I only want the statements for those with activity and balances.

    ------------------------------
    Jill Boyce
    Accounts Receivable
    Ace Asphalt / Brown Brothers Asphalt and Concrete
    Centennial, CO
    ------------------------------


  • 2.  RE: Statements

    SILVER CONTRIBUTOR
    Posted Feb 28, 2019 11:34 AM
    Hi Jill,

    If you click on the Select tab in the report, hit F3 and chose AR08600_wrk.Cust_TotStmtBal not equal 0, this will eliminate any that have a 0 balance....you can save it as a template then if you want...

    Hope this helps.

    Thanks,
    Michael

    ------------------------------
    Michael O'Neill
    Controller
    Eastex Telephone Cooperative
    Henderson TX
    ------------------------------



  • 3.  RE: Statements

    BRONZE CONTRIBUTOR
    Posted Feb 28, 2019 11:49 AM
    Thank you, Michael!

    ------------------------------
    Jill Boyce
    Accounts Receivable
    Ace Asphalt / Brown Brothers Asphalt and Concrete
    Phoenix AZ
    ------------------------------



  • 4.  RE: Statements

    BRONZE CONTRIBUTOR
    Posted Mar 05, 2019 08:44 AM
    You can try this in the select statement:
    AR08600_wrk.Cust_TotStmtBal not equal 0

    ------------------------------
    Jenny Dinh
    CFO
    Noble Resources Corp
    Tampa FL
    ------------------------------