Prefer Vendor

[Former Member]

Hi,

When we create the Item master data in Purchasing tab we select the vendor name from which we bought the material.

I want to display this vendor name in the Purchase order. How can I do that.

[former_member187989]

hi sandy,

As a simple solution,copy and paste preferred vendor name

in the remarks field of item master.

Update item master.

It will automatically populate in item details field of

purchase order.

Jeyakanthan.

[former_member187989]

hi sandy,

Define UDF in item master for vendor name and

assign formatted search to populate vendor name in it.

Define a UDF in purchase order row level and

define formatted search in it.

Jeyakanthan

[former_member187989]

Sandy,

You can display vendor name in Purchase order PLD.

1. Create a database field in repetitive area,

Select table Item,Coloumn Type Preferred Vendor.

2.Creat a User Defined Field in item master.

Assign formatted search to populate vendor name in it.

3.Create a database field in repetitive area,

Select table Item,Column Type UDF(Ex. U_vname).

Hope above answer will solve your problem.

Jeyakanthan

[former_member583013]

Sandy,

What do you mean by I want to display this vendor name in the Purchase order. How can I do that.

Is it on the Screen or on the PLD?

When you create a PO there is already going to be a Vendor Name. Are you saying if the Vendor is other than the Preferred one, you want the Preferred Vendor's name somewhere?

Please confirm

Suda

[Former Member]

I mean to say when we create an Item we mention the preferred vendor in the Purchasing tab from which we bought this item.

And in the Purchase Order we will select the vendor and the items. And I want to display the Preferred Vendor Name for the Item whcih I has selected at time of creation of the item in Purchase Order.

The both vendors will be different. The vendor for Purchase Order and vendor for Items.

[former_member583013]

Where do want the Preferred Vendors Name on the PO? Is it in a User field at the PO Rows where they can correspond to an Item or on the PLD?

[Former Member]

Its Not an UDF, The Preferred vendor which I assigned at the Item I want it to be displayed at Purchased Order Rows level.

[former_member583013]

Sandy,

You mentioned The Preferred vendor which I assigned at the Item I want it to be displayed at Purchased Order Rows level.

Is it on the screen or PLD?

I asked the same question on my previous reply, I would really appreciate if you could read the question completely and answer them to help us help you.

Best wishes

Suda

[Former Member]

Is it on the screen not on PLD.

[former_member583013]

Sandy,

The Preferred Vendor is not available as a option to display. You will need to Pull this information from the Joining the Item Master > CardCode field with the OCRD > CardName through a formatted Search.

You can link this Formatted Search Query to a un-used column on the Document Lines / create a UDF and display it there.

The SQL for the formatted Search would be

If you just want the Vendor Code then it will be simple.

SELECT T0.CARDCODE FROM [DBO\].[OITM\] T0 WHERE T0.ITEMCODE = $\[$38.1.0]

If you want the Vendor Name then use

SELECT T1.CARDNAME FROM [DBO\].[OITM\] T0 INNER JOIN [DBO\].[OCRD\] T1 ON T1.CARDCODE = T0.CARDCODE WHERE T0.ITEMCODE = $\[$38.1.0]

SUDA

[former_member187989]

hi sandy,

Select preferred vendor for a item and update item master.

Create a sales order item linked with a vendor.

Tick mark Purchase order in Logistic tab

After saving sales order.

Screen will appear for creation of purchase order

select vendor and items of left screen and move it

to right side screen and clik OK.

Now purchase order is created for preferred vendor.

Vendor Name will be in purchase order.

You can display vendor name in print layout designer.

Jeyakanthan

[Former Member]

Hi,

The Preferred Supplier in Item Master is used when you create a Purchase Order from a Sales Order automatically (using 'Purchase Orders' field on the Logistics tab of Sales Order).

When you create the PO first you need to choose a supplier, prior to choosing the item so it is not possible to create a formatted search on the Supplier field to populate it automatically, however I think it should be possible to create one to update it after choosing the item.

Hope it makes sense.

Regards,

Nat