I know about the Inventory Quantity report but it lists all items I’ve sold during any particular period. That’s fine but it doesn’t allow me to ask for items only from a specific transaction code (we have two divisions and I’d like to see the sales for only 1 division) and/or select for specific inventory items (one division sells items to the other division and I’d like to see total sales of just those items).
I’ve tried to rig this in a custom report but have failed miserably. I could get a report that showed me which items were sold during any period of time but couldn’t get the quantity number. It also appeared that I couldn’t do an ‘either or’ in the ‘contains’ option.
Am I doing this all wrong (likely) or is this particular request not supported? I know that I can do the Quantity report for all items sold in the month, then take it to Excel and delete everything I don’t want/need but that seems like a lot of extra work and opens up the option of my deleting something accidentally that I shouldn’t.