SupplierID showing up in Item table, but not in manager

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi all,

I am helping a customer recover data from a corrupted database using the QSC import tool.

I have imported their Item table from a .csv export, and all of the data I needed copied over into the new database. If I select the table through Administrator, using SQL queries, all of the information shows including SupplierID. When I go into RMS Manager to check everything out all of the important information is showing in the items, except for their Supplier.

How do I get this information which is present in the table to show up in RMS?

Thank you,

ahasken

*This post is locked for comments

All responses (8)

Answers (2)

Community Member Microsoft Employee on at

Like (0)

Report

RE: SupplierID showing up in Item table, but not in manager

That did the trick, Thank you again for all of your help!
Suggested answer

RMS Wizard 1,205 on at

Like (0)

Report

RE: SupplierID showing up in Item table, but not in manager

It has been awhile since I have used QSC import tool but if I remember correctly to populate primary supplier under item properties you must first import the suppliers, then import items with match on supplier name not supplier code. Is that how you imported the items?

The import tool also only works for Store Operations single store databases not an HQ database.
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: SupplierID showing up in Item table, but not in manager

Sorry about that . I left off a piece for the statement. Need to define the columns we are inserting into because we cant insert in ID column and timestamp auto populates.

insert into supplierlist

(MinimumOrder ,ItemID, SupplierID, Cost, ReorderNumber ,MasterPackQuantity ,TaxRate )

select 0, ID as ItemID , SupplierID , 0,'',0, 0.00 from [item]

where item.SupplierID is not null and item.SupplierID <> 0
Community Member Microsoft Employee on at

Like (0)

Report

RE: SupplierID showing up in Item table, but not in manager

Thank you everyone for the replies,

Ed,

Yours seems like the solution for the problem I am having; however, when I try to run that query I am getting an error message stating,

Insert Error: Column name or number of supplied values does not match table definition.

What would cause this message?
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: SupplierID showing up in Item table, but not in manager

There is a supplierlist crosslink table.

This table some of the information like Minimum Order, MPQ, Cost, Tax Rate, and reorder number.

Also more importantly stores the links between supplier and item.

This table is probably empty.

So the hard part is to populate that table. We have to insert each item with a supplierid into the supplierlist table.

Try the following. Please backup first.

insert into supplierlist

select 0, ID as ItemID , SupplierID , 0,'',0,0.00 from [item]

where item.SupplierID is not null and item.SupplierID <> 0

Note: this will only work for the primary supplier since this pulls only the primary supplier from the item table.
Suggested answer

Mohammed ElQadi 130 on at

Like (0)

Report

RE: SupplierID showing up in Item table, but not in manager

Seems like you are using one store no HQ,

try checking one item and its SupplierID and check that id at supplier table.

also check records duplications at all tables.
Community Member Microsoft Employee on at

Like (0)

Report

RE: SupplierID showing up in Item table, but not in manager

I'm not sure that this answer is for my question.
Community Member Microsoft Employee on at

Like (0)

Report

RE: SupplierID showing up in Item table, but not in manager

Mercury does not support EMV for RMS yet but they likely will come August.