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:
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.