Hi,
I'm having trouble making searches for the actual impact that a transaction has to our stock on hand. If I create a search for transactions with an impact on stock like IRs, IFs, IAs, Worksheets - taking main line, COGS line, etc. off the search - if I include quantity as a result column, I still get multiple lines for the quantity impact on different accounts. I can't seem to find a way to filter it to just include the quantity impact on stock on hand for that item (like you would see in an activity detail report for example), can anyone help?
Cheers,
Will