ERPNext Foundation ERPNext Cloud Chat Blog Discuss Frappé* Donate

Report to show total qty of items sold from one date to another?


#1

Hi there-
Is there a way to easily report on the total qty of items sold from X date to Y date?

For instance, ITEM 123 - we sold 500 between 01/01/18 - 12/31/18. This would total from all sales invoices for one item. Thoughts on how to accomplish this on ERPNext Cloud?


#2

You can write a query report to accomplish this


#3

Unfortunately, you can’t write query reports on ERPNext cloud. :frowning:


#4

Does anyone else know how to do this? This isn’t currently an urgent issue for us but it will become one as we pass the one year mark of using the software. We often order seasonaly and we need to look back at the season prior to determine our quantities. Again, I need a way to see TOTAL number of XXXX item that was ordered or invoiced within a range of dates.


#5

Hello, @charlie-cook
Greetings from Frappe! Thanks for reaching out.
Your need to view item wise sales between X date to Y date can be catered by standard reports of ERPNext such as Sales Invoice Report, Item-wise Sales Register Report.

Hope this helps. Let us know if you require any additional information.


#6

Have you explored Item-wise Sales Register ?