customer/vendor specific item list

[former_member187989]

Hi all,

How to get all items pertaining to a customer/vendor?,While doing sales/purchase

transactions ?

For example,

In sale order creation,selecting a customer all items pertaining to customer get

populated in row level ?

Thanks,

With regards,

A.Jeyakanthan

[former_member187989]

Question was answered.

[former_member187989]

hi Istvan Koros ,

Thanks for your reply.

Problem was solved.

With Regards,

Jeyakanthan

[former_member204969]

Hi Jeyakanthan,

Another solution to define catalog numbers for the business partner.

When you set for the document to show catalog numbers, the system will show only those items, for that you had defined catalog number for the customer/vendor.

(You can define the item code as catalog number!)

Best regards

[former_member583013]

Jeyakanthan,

There is no such functionality out of the box where selecting a Customer/Vendor can pull their Items.

You can do it through a quick customization.

Step 1: You need to have an association between the Item and Customer/Vendor.

the association to the Vendor can be done by setting the default Vendor for an Item in the <b>Purchasing Data</b> tab in the Item Master. For a Customer you need to probably create a User defined field, where you associate the Customer Code.

Step 2: Set-up a Formatted Seach Query on the ItemCode of the Sales Order which will filter all the Items having the CardCode selected in the Sales Order.

Example:

SELECT T0.ITEMCODE FROM [DBO].[OITM] T0

WHERE T0.U_CUSTCODE = $[$4.0.0]

<i>U_CUSTCODE is the user field you would create to store the Customer Code in the Item Master.</i> Please change the User field name as per your definition.

Suda