Skip to Content
avatar image
Former Member

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

Hi Experts,

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

Thanks.

Regards,

Danny

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 15, 2009 at 11:58 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 15, 2009 at 05:49 AM

    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

    Add comment
    10|10000 characters needed characters exceeded