I'm a problem in sap about FMS.
I have created a new PO.
I have a setting AR itemcode FMS search by saved Query:
SELECT itemcode,dscription,quantity from por1 T0 where T0.docentry = [%0]
I created a New AR
hope as follow:
but actually as follow:
Please give me advice.
István Kőrös replied
To copy the data from a purchase order to an AR document, you should use two FMS:
The first should be connected to the item code field without setting auto refresh:
Select T0.ItemCode, T0.Dscription,T0.Quantity From POR1 T0 INNER JOIN OPOR T1 ON T0.DocEntry = T1.DocEntry WHERE T1.DocNum = $[$1004.1]
The second should be connected to the quantity field, setting auto refresh when exiting altered column Item No. and display saved user defined value:
Select T0.Quantity From POR1 T0 INNER JOIN OPOR T1 ON T0.DocEntry = T1.DocEntry WHERE T1.DocNum = $[$1004.1] and T0.ItemCode=$[$38.1]
To use this FS-s, the user should
1. enter the document number of the purchase order into the Manual Number field,
2. on the first item code field use the Shft+F2 combination and select all the item codes displayed.
The system will then copy the item code and the quantity values from the source purchase order document.