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.
Here’s what I was doing with the custom report. ‘Code’ appears to be both what I would consider the SKU on an invoice and can also mean a tracking code. What I really need is shown in the report I tried to make:
When I actually run that report I get nothing at all since the invoices would not have both items in them (that was my comment about an ‘and/or’ option for the report. It seems to be an all or nothing.
If I take out the last line in the custom report (the contains DA MS), I do get a report but it only shows me invoices that include those items, no quantity of the items sold.
This is where I get very confused. Saying I ‘need to expose’ those items might as well be in Aramaic to me. So - I tried what I thought you might be suggesting:
I don’t need the dates for the sales, I just really want the total of any particular item for the month. I couldn’t figure a way to get rid of the individual sales dates. Can that be done?
