35
Hi Everybody,
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
*This post is locked for comments
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.
thanx jeff,
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
SO/HQ Admin | File Connect and enter your password | Database | Re-index
While there, you can check the integrity of the database ;
Database | Check
can u please explain about the "re-index after the import"?
thanks for ur reply....
Does the Item.SupplierID = the Supplier.ID?
Did you re-index after the import? HQ Admin | Database | re-index
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (