https://netsuiteprofessionals.com logo
m

mbucklaew

05/02/2017, 12:09 PM
There are several of them. Quantity is the basic field. Main Line has to be false (or either) to get line/row level details.
m

mattb

05/02/2017, 10:26 PM
mbucklaew: I’m more after the total number of lines or rows per transaction. I think I just need to get the maximum of the Line Sequence Number field and group the remaining columns.
actually that won’t work for me either. this report calls for main line = false (i.e. display each transaction row) but within each row, i need a cell that lists the total rows for the transaction
m

mbucklaew

05/03/2017, 12:17 PM
@mattb I see. Try adding a results column of "Line Sequence Number" with a summary type of "Count". Then group the other columns you need to display. You may need to do some other filtering depending on the lines you need to count (or ignore) for instance we use Avalara and we get an AVATAX line added to the transactions.