Additional Blogs by Members
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member
0 Kudos

Apreciados Compañeros:

Necesito agregar el campo de Titular que aparece en la orden de compra, trate pero solo saque el codigo interno.

Gracias por su colaboración,

saludos, Araiz

SELECT TOP 1 T0.DocNum, T0.DocDate, T0.CardCode, T0.CardName, T0.NumAtCard, T1.ItemCode, T1.Quantity

FROM OPDN T0 INNER JOIN PDN1 T1 ON T1.DocEntry = T0.DocEntry WHERE T1.BaseEntry IS NOT NULL ORDER BY T0.DocNum DESC