Sales Reports in Reckon Hosted

agofarm
agofarm Member Posts: 78 Reckoner Reckoner

I have a transaction Sales report in which I am trying to get a Total on the quantity of product sold. The Amount and Balance both give me a Total.

thanks

Teresa

Answers

  • Zappy
    Zappy Accredited Partner Posts: 5,256 Accredited Partner Accredited Partner

    That's great. If you want to talk, im always here.

    Zappy 0407 744 914

  • Acctd4
    Acctd4 Accredited Partner Posts: 4,216 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert

    Hi Teresa

    Add the Qty column ☺️

  • agofarm
    agofarm Member Posts: 78 Reckoner Reckoner

    I am not sure how to do that, the report that I am using is the Transaction Details by Account Report.

    the Amount and Balance columns have auto total but the Qty does not.

    Can you advise how to add the Qty Coloumn


    thanks

  • Acctd4
    Acctd4 Accredited Partner Posts: 4,216 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert

    Hi Teresa

    I'd suggest using the Sales by Customer Detail report instead as this includes (& totals) the Qty column by default:

    image.png

    You can add/remove Columns, add/remove other Filters & also change how it Sorts & Subtotals too 😊

    This report is under the Reports dropdown menu > Sales

  • agofarm
    agofarm Member Posts: 78 Reckoner Reckoner

    Thankyou for your help. It is all working well now

  • Acctd4
    Acctd4 Accredited Partner Posts: 4,216 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert

    Good to hear Teresa ☺️