I have imported items in item table through SQL , my problem is that the supplier ID is not displaying in item properties when i checked in HQ.
when i checked in SQL there is no problem with supplier ID it is showing all the supplier ID's for corresponding items.
is there any way to get supplier id in HQ. please help me i am new to MRMS
Does the Item.SupplierID = the Supplier.ID?
Did you re-index after the import? HQ Admin | Database | re-index
Jeff HobbsCheck Point Software
can u please explain about the "re-index after the import"?
thanks for ur reply....
SO/HQ Admin | File Connect and enter your password | Database | Re-index
While there, you can check the integrity of the database ;
Database | Check
jeff ur formula works successfully,and supplier id comming in HQ, but problem was,when the 250 worksheet
under processing it will showing the warnings.why it is happening please conform the reply
the following sreen shot for 250 worksheet under processing
I would create a 206 worksheet and select all of the Suppliers. I know its a pain to do each one, but I think its the only way.
Remember how RMS handles worksheets, the lower number ones must complete without errors before the higher numbered ones. If there is an error with a lower number one, all higher numbers will fail with info a higher one needs. If the 206 errors, so will any 250 that counts on the info of the 206, in your case.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13