Sales by item summary but include zero sold items too?

Ian_8365621
Ian_8365621 Member Posts: 14 Reckoner Reckoner
in Reckon Accounts (Desktop)

I would like to generate a report for a selected number of items but include items with zero sales. Is this possible?

Comments

  • Lucas
    Lucas Reckon Staff Posts: 563 Reckon Staff Reckon Staff

    Hi @Ian_8365621,

    You would need to create a custom report and modify it to change the amount to any or certain value in the filter tab.

    image.png

    Unfortunately, it will take some tinkering until your preferences are met for the report. If you do however still require further assistance, please reach out to me.

    Thank you.

    Cheers,

    Lucas

    Lucas.png
  • Ian_8365621
    Ian_8365621 Member Posts: 14 Reckoner Reckoner

    Thanks Lucas.

    I don't seem to be able to get a filter that will work on Qty, only value.

    Screenshot 2024-05-17 130519.png
  • Lucas
    Lucas Reckon Staff Posts: 563 Reckon Staff Reckon Staff

    Hi @Ian_8365621,

    Could you please try advance settings in the display tab and let me know if that helps you? Sorry, I'm not sure of the answer for your report building, but I can try my best to find the answer for you.

    image.png

    Thank you and speak soon.

    Cheers,

    Lucas

    Lucas.png
  • Ian_8365621
    Ian_8365621 Member Posts: 14 Reckoner Reckoner

    Hi Lucas

    This will work. The report has added a bunch of items not needed but I can export the report and delete these lines. Importantly it has included the selected inventory that has had zero sales.

    Screenshot 2024-05-17 133851.png

    Thank you.

Categories