SQL Linking Delivery, AR Invoice and JE

[former_member557544]

Hello Everyone

I have made a query as follows but the linked AR invoice which is a UDF in Delivery is not getting displayed.

SELECT T2.[TransId], T0.[DocNum] AS 'DL' ,T3.[Account],T3.[Debit], T3.[Credit],T0.[U_UO_LINK_INV] FROM ODLN T0 INNER JOIN DLN1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OJDT T2 ON T0.TransId = T2.TransId INNER JOIN JDT1 T3 ON T2.TransId = T3.TransId GROUP BY T0.[DocNum],T1.[BaseRef], T2.[TransId], T3.[Account],T3.[Debit], T3.[Credit],T0.[U_UO_LINK_INV]

Can you please help me out.

Thanks & BR

Anushka

[former_member557544]

Hi Mr.Nagarjan

Yes this UDF is on the Delivery form and the linked AR invoice field is as shown in the new attached file.udf-delivery.png

But when i use this UDF in my query it is blank.

How can I get this delivery linked AR invoice in my query.

Thanks & BR

Anushka

[kothandaraman_nagarajan]

Hi,

Do you have any value in UDF field?

Regards,

Nagarajan