I am trying to build a report that lists all items for a given supplier, and then lists sales quantities (including zeros for items not sold) within a given timeframe. My attempts so far have allowed be to list all items for a supplier with sales for all time, but the minute I put a timeframe for the sales in place I lose items that have not been sold from the list.
Does anyone know where I can find such a report or have any suggestions that would allow me to complete it?
Thanks, Holly
What report did you base it off of? Detailed Sales with a filter on the Supplier field will give you the sales for items from that supplier.
How are you trying to filter the dates? The DateSold field should do the trick.
I actually created a report from scratch that combines the Item Price List (to get the complete list of items by a supplier) and the Summary Sales Report (downloaded from the reports library) to give the total sales by item without the duplication of specific transactions.
The problem with the detailed sales report is that it only displays items that have been sold, not ones that haven't been.
All those items that have never sold have NULLs for the sold dates. Once you try to filter by date, they are all going to come up false. You might try grouping by date rather than filtering by date - but this is going to be hard to get out of active reports.
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.