Microsoft Dynamics RMS

Forums

Home » Microsoft Dynamics RMS » Microsoft Dynamics RMS Forum
Related Search Results

Need to add supplier in all the items

by
on 13 Jan 2012
  • Verified Answer

Inserting Item through SQL and setting Supplier List Table Data

by
on 8 Feb 2012
  • Suggested Answer

Zero Out Inventory Totals

by
on 30 Dec 2008
  • Not Answered

Supplier id is not coming in items properties in HQ when imported through SQL

This question is not answered
Surya
Posted by
on 16 Jun 2012 2:32 AM

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 
All Replies
  • Jeff @ Check Point Software
    Posted by
    on 20 Jun 2012 3:24 PM

    Does the Item.SupplierID = the Supplier.ID?

    Did you re-index after the import?  HQ Admin | Database | re-index

    -- Regards,

    Jeff Hobbs
    Check Point Software
  • dharmendra eadumyakala
    Posted by
    on 9 Aug 2012 3:19 AM

    can u please explain about the "re-index after the import"?

    thanks for ur reply....
  • Jeff @ Check Point Software
    Posted by
    on 9 Aug 2012 4:13 PM

    SO/HQ Admin | File Connect and enter your password | Database | Re-index

    While there, you can check the integrity of the database ;

    Database | Check

    -- Regards,

    Jeff Hobbs
    Check Point Software
  • dharmendra eadumyakala
    Posted by
    on 21 Aug 2012 6:53 AM

    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

     
  • Jeff @ Check Point Software
    Posted by
    on 21 Aug 2012 7:30 PM

    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.

    -- Regards,

    Jeff Hobbs
    Check Point Software