cancel
Showing results for 
Search instead for 
Did you mean: 

Copy items from sales quotation to purchase request

fahissapb1
Explorer
0 Kudos

Hi,

I have a requirement in the Purchase request to copy one UDF value from the quotation. ( From QUT1 to PRQ1).

I have a field (U_PURCOST) in Sales Quotation and while creating the entry, the user will be entering values in this. I have the same UDF in the Purchase Request.

As part of testing, Iam selecting the quotation number in the reference document(PRQ21) of the Purchase Request and am able to fetch some other UDF in the quotation in the header(OQUT) through SP_Post Transaction. I understood the logic that there is no connection between the lines of both tables directly.

But is it possible to achieve like, once Sales Quotation is selected in the Reference documents ( Or select a value in a UDF that links to System objects), display items (User Defined Values) that are in that quotation only?

Waiting for your valuable suggestions

Fahis T

Accepted Solutions (0)

Answers (2)

Answers (2)

narayanis
Active Contributor
0 Kudos

Hi,

Select procure non drop ship items option under the logistics tab of sales quotation. When sales quotation is added, system will start procurement confirmation wizard wherein all the data in quotation including UDF will get copied to any of the target documents (Purchase request, purchase quotation, purchase order).

You can try this if suits your requirement.

Best Regards

Johan_H
Active Contributor
0 Kudos

Hi Fahis T,

One way that you could test, is to put a formatted search in the Item Code field, and another one in the Quantity field.

The fms in the ItemCode field would show the user the list of items in the Sales Quotation. They would then choose all items. This will enter all items in sequence to the Purchase Request.

The fms in the Quantity field would refresh automatically when the ItemCode changes.

Regards,

Johan