report for all sales orders by date

Options
Cass_10165949
Cass_10165949 Member Posts: 4
edited September 2019 in Reckon Accounts (Desktop)
Hi, I am needing a report to show all sales orders created each day/month. I have no problem creating the open sales orders but  i need it to also show the orders that have been invoiced and therefore closed.

Comments

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,408 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited September 2019
    Options

    Hi Cass

     

    You can create, modify & memorise your own customised report for this:

     

    • Click on Find (Under Edit along top toolbar)
    • On the “Advanced” tab, select “Transaction Type” in the Filter list then “Sales Order” from the dropdown list
    • Under “Detail Level” in the Filter list, select “Summary only” & click on “Find
    • Click on “Report” to view your search results in report format
    • Click on “Modify Report” & add/remove applicable “Columns”

    (I would specifically tick “Paid” & “Open Balance” & untick “Split”, “Clear” & “Account”)

    Under “Total by”, select “Month” & “Sort by” “Date

    • On the “Header/Footer” tab, you can rename this report (in the “Report Title” box) to “Daily SOs by Month” or similar
    • Click OK to refresh your updates
    • Click on “Memorise” to save this customised report for re-use.

    You can also select “View” along top toolbar & choose to “Add …to Icon Bar” to create a 1-click Icon to access it  :)

      

    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!)
  • Cass_10165949
    Cass_10165949 Member Posts: 4
    edited August 2019
    Options
    Thank you so much Shaz, you have saved my day!!!!!
    I knew there had to be a way!
    Thanks heaps Cass
  • Cass_10165949
    Cass_10165949 Member Posts: 4
    edited September 2019
    Options
    Hi Shaz,
    You where so awesome last question (I use the above report every day!!).
    Would there be a way to create a report on Estimates converted to Sales Orders per month?
    I have followed the same way above  but i am just getting the estimates my report has
    • Type
    • Date
    • Number
    • Name 
    • Class
    • Rep
    • Amount 
    I have tried to add SO# thinking this would link the Estimate and the Sales Order (as i create the SO's from the estimate), but that column just comes out blank. 

    Thanks heaps
    Cass
  • Acctd4
    Acctd4 Accredited Partner Posts: 3,408 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited September 2019
    Options
    Hi Cass

    Unfortunately, whilst a SO can be created from an Estimate, the "link" itself isn't reportable.

    It's possible to generate a report showing the 2 (SO & Estimate) but the transactions don't reflect on a report as being linked & therefore appear on separate lines :(

    .... Might be worth adding to the Reckon Wishlist!
    (Click on the "Help" dropdown menu in your program then click on "Suggest New Features").
    Reckon try to incorporate new features/updates into future releases - where possible - based on User feedback.

    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!)
  • Cass_10165949
    Cass_10165949 Member Posts: 4
    edited September 2019
    Options
    Thank you for your time Shaz, very much appreciated.  I will put my suggestion forward to Reckon :)
  • cosmic
    cosmic Reckon Developer Partner Posts: 1,075 ✭✭✭
    edited September 2019
    Options
    Cass, 
    We could get this Report Tool  developed if this is  very crucial issue with your company.
    Talk to me on 0407068942.
    The wish list is never ending for Reckon Hosted and desktop.

    Cosmic Accounting Group

    Accountants and Tax Agents 22397009