Report exclusions - each sub total - debtors or suppliers

Options
Cathy Purcell
Cathy Purcell Member Posts: 8 ✭
edited January 2020 in Reckon Accounts (Desktop)
Reckon Accounts Premier Edition 2019 - Using the Unpaid Bills Detail report - can I remove the default header for each supplier  in this report  - I don't want to see  each supplier, then sub total.I will add the supplier into the field of the report. (Not the header of the report)  





Comments

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,408 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited January 2020
    Options

    Hi Cathy

     

    There’s not a default report in that format however the beauty of RA is that you can create your own custom reports from specific searches!

     

    • Click on Edit (along top toolbar) then on Find in the dropdown menu
    • On the Advanced tab, set the following Filters:

    * Transaction Type   >  Multiple …  > “Bill” & “Bill Credit”

    * Detail Level             >  Summary

    * Paid Status             > Open                         

     

    • Click on “Find” then on “Report“ to create/view results accordingly
    • You can click on “Modify Report” to further customise including - on the Display tab - adding/removing Columns (I’d untick (left margin), Clr, Split & Amount & add in Debit & Credit)

    You can also choose to “Total by” & “Sort by” / in specific parameters too (eg Supplier, date ranges A-Z v Z-A etc)

    • On the Header/Footer tab, you can give this report a relevant name (eg “Unpaid Bills by …”) in the Report Title field
    • Once happy, click on “OK” to refresh
    • Once customised to your specific requirements, you can click on “Memorise” to add it to your Memorised Reports
    • You can also add it to your Icon Bar for 1-click access by clicking on View (along top toolbar) then on Add Find Report to Icon Bar in the dropdown menu.  (Tip: Keep the name short – eg Unpd Bills – to avoid taking up to much space along your icon bar!)

     

      

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    Reckon Accredited Professional Partner Bookkeeper / Registered BAS Agent (No: 92314 015)

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    0422 886 003

    shazinoz2@bigpond.com

    www.accounted4bs.com


    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

    * Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    shaz@accounted4.com.au

    https://accounted4.com.au

    (NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)

Categories