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
run this query
****************** SELECT Itemlookupcode,Description FROM Item LEFT JOIN Supplier ON Item.SupplierID=Supplier.ID where Supplier.ID is null *******************Bud,
Item Price List | add a filter | Supplier Then while in the report, you can double click on the ILC and add a supplier.
Thank you very much!
Bud
"Nashat" wrote:
Thank you very much!
Bud
"Jeff @ Check Po> Bud,
Have something to add? Share your thoughts — no account required.
Ask the community — no account required