12M sales volume report

I wish to write up a  quantity report via JET. The report would consists of 12 months sales volume for a particular customer/account. It would have:

Item No.



I though about using posted sales invoice lines but this does every line as one would expect. How would group the items together to get a total no. of sales per item. I assume I would have to use another table but I am unsure which one and how to link both tables together to get the correct format. I have been using Table builder.


Hope this all makes sense.


Please sign in to leave a comment.