Need Report to Show Items that have no associated Supplier

Posted by Bud Izen on November 6, 2006, 4:48 pm

Please log in for more thread options

We just ran a Top Suppliers report. Much to our surprise, our third top
Supplier was blank. No Name. This No-Name supplier managed to account for 263
items, so we still have a few holes to plug. We have THOUSANDS of SKUS, so a
manual search is out of the question. Is there a report out there that will
do this?

Thanks

Bud

Posted by Nashat on November 7, 2006, 12:12 am

Please log in for more thread options

run this query
******************
SELECT Itemlookupcode,Description
FROM Item LEFT JOIN Supplier ON Item.SupplierID=Supplier.ID
where Supplier.ID is null
*******************

> We just ran a Top Suppliers report. Much to our surprise, our third top

> Supplier was blank. No Name. This No-Name supplier managed to account for

> 263

> items, so we still have a few holes to plug. We have THOUSANDS of SKUS, so

> a

> manual search is out of the question. Is there a report out there that

> will

> do this?

> Thanks

> Bud

Posted by Bud Izen on November 7, 2006, 4:52 pm

Please log in for more thread options

Thank you very much!

Bud

"Nashat" wrote:

> run this query

> ******************

> SELECT Itemlookupcode,Description

> FROM Item LEFT JOIN Supplier ON Item.SupplierID=Supplier.ID

> where Supplier.ID is null

> *******************

> > We just ran a Top Suppliers report. Much to our surprise, our third top

> > Supplier was blank. No Name. This No-Name supplier managed to account for

> > 263

> > items, so we still have a few holes to plug. We have THOUSANDS of SKUS, so

> > a

> > manual search is out of the question. Is there a report out there that

> > will

> > do this?

> >

> > Thanks

> >

> > Bud

Posted by Jeff @ Check Point Software on November 7, 2006, 1:52 am

Please log in for more thread options

Bud,

Item Price List | add a filter | Supplier = <Not Assigned>

Then while in the report, you can double click on the ILC and add a
supplier.

--
Jeff
Check Point Software

=====================================================

You must be using Outlook Express or some other type of newsgroup reader to
see and download the file attachment(s). If you are not using a reader,
follow
the link below to setup Outlook Express. Click on "Open with newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz
=====================================================

> We just ran a Top Suppliers report. Much to our surprise, our third top

> Supplier was blank. No Name. This No-Name supplier managed to account for

> 263

> items, so we still have a few holes to plug. We have THOUSANDS of SKUS, so

> a

> manual search is out of the question. Is there a report out there that

> will

> do this?

> Thanks

> Bud

Posted by Bud Izen on November 7, 2006, 4:53 pm

Please log in for more thread options

Thank you very much!

Bud

"Jeff @ Check Point Software" wrote:

> Bud,

> Item Price List | add a filter | Supplier = <Not Assigned>

> Then while in the report, you can double click on the ILC and add a

> supplier.

> --

> Jeff

> Check Point Software

> =====================================================

> You must be using Outlook Express or some other type of newsgroup reader to

> see and download the file attachment(s). If you are not using a reader,

> follow

> the link below to setup Outlook Express. Click on "Open with newsreader"

> under the MS Retail Management System on the right.

> http://tinyurl.com/75bgz

> =====================================================

> > We just ran a Top Suppliers report. Much to our surprise, our third top

> > Supplier was blank. No Name. This No-Name supplier managed to account for

> > 263

> > items, so we still have a few holes to plug. We have THOUSANDS of SKUS, so

> > a

> > manual search is out of the question. Is there a report out there that

> > will

> > do this?

> >

> > Thanks

> >

> > Bud