Supplier List and Sales Report

Posted by Holly C on June 24, 2005, 2:26 pm

Please log in for more thread options

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

Posted by Jason Hunt on June 24, 2005, 3:06 pm

Please log in for more thread options

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.

Posted by Holly C on June 24, 2005, 5:24 pm

Please log in for more thread options

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.

> 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.

Posted by Glenn Adams [MVP - Retail Mgmt on June 24, 2005, 5:58 pm

Please log in for more thread options

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.
--
Glenn Adams
Tiber Creek Consulting
http://www.tibercreek.com
glenn@tibercreek.com
----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information

>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