Skip to Content
0
Nov 21, 2009 at 01:56 AM

Error in Formated Search in Purchase Order

21 Views

Hello Everyone

I have made a formated search to get a price from a UDF. The formated search its working fine. But after i create the order if open it again i get new price, not the one that i have saved. But the funny thing is that if i copy to a purchase invoice i get the correct values.

This is the query iam using:

SELECT CAST(U_SYS_CORE AS VARCHAR)' 'U_SYS_CMOCR FROM OITM WHERE ITEMCODE= $[POR1.ITEMCODE]

U_SYS_CORE its a price and U_SYS_CMOCR its the currency.

I have configured the formated search to automaticaly update, when the item code changes.

Is this a system error??

Thank you very much.

Jacobo