0

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.

Description

 Quantity

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.

4 comments

Please sign in to leave a comment.