report for all sales orders by date

Cass_10165949
Cass_10165949 Member Posts: 4 Novice Member Novice Member
edited October 2024 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: 4,208 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert
    edited September 2019

    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


  • Cass_10165949
    Cass_10165949 Member Posts: 4 Novice Member Novice Member
    edited August 2019
    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 Novice Member Novice Member
    edited September 2019
    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: 4,208 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert
    edited September 2019
    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

  • Cass_10165949
    Cass_10165949 Member Posts: 4 Novice Member Novice Member
    edited September 2019
    Thank you for your time Shaz, very much appreciated.  I will put my suggestion forward to Reckon :)
  • cosmic
    cosmic Reckon Developer Partner Posts: 1,009 Reckon Hall of Famer Reckon Hall of Famer
    edited September 2019
    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

This discussion has been closed.