Query - display the ref no (UDF) from PCH1 to Journal to Ref3

[Former Member]

Hi Experts,

By using query to display the ref no (UDF) from PCH1 to Journal to Ref3?

Thanks.

Regards,

Danny

[Former Member · Accepted solution]

Hi Danny,

It is not possible through query.Use SDK Code to acheive your requirement.

After adding the document you capture the UDF field data in one variable and

open the system passed journal entry against that AP invoice and using update

method you put the data in REF 3 coloumn of journal

so better you post the message to SDK forum.

*Close the thread if issue solved.

Regards

Jambulingam.P

[Former Member]

Hi Danny,

Use the following query sample and change the table name OPCH,PCH1 Instead of OINV.INV1

SELECT T0.[DocNum], 
T2.[BaseRef], 
T3.[Ref3Line], 
T1.[U_PRICE] FROM OINV T0  INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry 
INNER JOIN OJDT T2 ON T0.TransId = T2.TransId 
INNER JOIN JDT1 T3 ON T2.TransId = T3.TransId
 WHERE T0.[DocNum] = T2.[BaseRef] AND  T0.[DocNum] = '2982'

*Close the thread if issue solved.

Regards

Jambulingam.P

Edited by: Jambulingam P on Jul 15, 2009 7:50 AM

[Former Member]

Hi Jambulingam P ,

I tried to do this:-

SELECT T0.U_TRFREMARK

FROM OPCH T0 INNER JOIN PCH1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OJDT T2 ON T0.TransId = T2.TransId INNER JOIN JDT1 T3 ON T2.TransId = T3.TransId

WHERE T0.DocNum = T2.BaseRef AND T2.TransType ='18'

But i still having error...

I want when i click Add button at AP Invoice, the U_TRFREMARK Field's data will auto update to this AP Invoice's Journal Entry's Ref3 Field....

Thanks.

Regards,

Danny

[former_member204969]

There is no possibility to activate an FS on an automatically generated journal entry transaction.

You could activate FS-s only on the AP invoice. And the system copies data from there to the journal entry. (I think nothing to the Ref3 field.)