Im having an issue with one of my clients databases. Their report shows the supplier in the Reports -> Items -> Price list, and when I go to Management Studio, the supplier id is linked in the items table, but when they go to Manager, and view the Suppliers tab, there is nothing there. Any ideas?
Thanks
Phil
Hi Phil
Check the supplier ID aga> Im having an issue with one of my clients databases. Their report shows the
Phil, my 2 cents on this is that if you're going to resell RMS, you need to learn some basic SQL, since it allows you to help your client quickly clean up a mess and some clients will pay for this. There's dozens of free tutorials on the net, and countless good books (free at your local library) that can get you started.
First BACKUP THE DATABASE, then run
select * from supplierlist
- - if the list is empty then run the following
select itemlookupcode, description, suppliername from item inner join supplier on item.supplierid = supplier.id
- - this will show you items that have a supplierid referenced in the item table
your insert query is insert into supplierlist (itemid, supplierid, cost) select id, supplierid, cost from item where supplierid 0
If your select query against the supplierlist shows some items, running the insert query will duplicate those entries. If the current supplierlist table is not too populated, have the client delete the duplicates manually - run this query to jot down these items that are already in the supplierlist select itemlookupcode, description from item inner join supplierlist on item.id = supplierlist.itemid
Test these queries first on a database created from your client's current backup. If the updates look good, then apply them to the production database.
Remember....pigs get fat, hogs get slaughtered, especially on free lunches.
Good luck
"Phil V" wrote:
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.