cancel
Showing results for 
Search instead for 
Did you mean: 

Item Preferred Vendors DTW- 8,81 patch 4

Former Member
0 Kudos

Hello Experts,

I got SB1 8.81 patch 4. I want to update the table for item preffered vendors and I can't find the template.

Is there one?

Please advise

Accepted Solutions (0)

Answers (3)

Answers (3)

0 Kudos

Hello Renata,

To upload preferred vendors using DTW, you have to make a two columns csv file:

1) ItemCode
2) Mainsupplier

Attach this sheet on Item Master and you job will be done.

Regards,

Shehzad

Former Member
0 Kudos

Can anyone help?

I have import Preferred Suppliers through DTW but they are not Set As Default.

How can I set Preferred Suppliers as Default through DTW or a mass change. I got single supplier for each product.

Regards,

Former Member
0 Kudos

Hello friend,

Template is not available then you can create from DTW.

Run DTW and login in your database.

now you have three option in menu bar(File,Tools,Advance,Help)

1.Select>Advance >Maintain Interface

2.Here select oItems

now there are five templat available

Select your oItemsPreferdVendors and do right click now you get a option to create teplate(Create Template for the structure) for same and save it now your template is ready to use.

Thanks

Manvendra Singh Niranjan

Edited by: Manvendra Singh Niranjan on Jun 4, 2011 7:14 AM

Former Member
0 Kudos

Hello Manvedra,

Thank you very much. Your suggestions was excellent!

Former Member
0 Kudos

Hi,

Item Preferred Vendors is under OITM.

If you mean to upload those Vendors data, you need OCRD.

What do you want to upload?

Thanks,

Gordon

Former Member
0 Kudos

MMhh it is not under OITM.

I can see it is under ITM2, however on the DTW templates it is not included.

Former Member
0 Kudos

I don't have 8.81 so that I can not see this ITM2. What is it called?

From 8.8 and below. Preferred vendor is CardCode in OITM only.

Former Member
0 Kudos

It is called Item Preferred Vendors table. Thanks

Former Member
0 Kudos

You may try to add it to DTW. If you can't, you have to wait until the latest DTW can include this new table.