Skip to Content
author's profile photo Former Member
Former Member

Prefer Vendor

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 13, 2008 at 10:28 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 13, 2008 at 11:06 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 13, 2008 at 04:01 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • Posted on Jun 14, 2008 at 11:09 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 16, 2008 at 06:39 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 16, 2008 at 06:51 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.