Dear sir,
I am trying to create a report that give me the volume for all the sales line in document.
I create the formula for Quantity*unit volume per line with result name "volume per line".
How do i sum up the result for individual document no?
Dercha
Date
Votes
3 comments
-
Jet Reports Historic Posts The easiest way would be to build a grouping report where the main category is the document number and the second grouping is the line.
You could then hide the line and the anchor row and put the subtotal on the document number line to sum up the line totals.
See the attached. -
Jet Reports Historic Posts thank you Jet-btr, but that would have to either manually stated the group or extract all.
My condition is the document with item purchase that is coming in within the date range and the showing the volume require. -
Jet Reports Historic Posts My example was just to give you an idea of how you could build the report. Since I didn't know your filters, my example is built without filters.
That said, you can add filters that you need. In the main grouping using the sales header, you can filter on the date and you can link to the sales line table to set filters on the item number.
On the Sales Line replicator, you can add filters as well for the item number and dates.
If you wish to keep the report that you appears to have been built using the Table Builder, you can add a formula that multiplies your Quantity times Unit Volume. Personally, I don't see the Table Builder as the best tool for this report though since my understanding is that you don't want to see every line on every document but a summation of some information of the lines but you know the report better than I do.
Please sign in to leave a comment.