Skip to Content


Hi Experts,

In the next Business Partners query I need to add a filed for the date of the first invoice in the history of each BP.

I tried with FIRST_VALUE Function and with TOP 1 Function too, but i got so many errors.

Can you help me please.

SELECT T0."CardCode" ,T0."CardName" ,T1."GroupName" ,T2."SlpName" ,T3."ListName" FROM "PAF_LIVE"."OCRD" T0 INNER JOIN "PAF_LIVE"."OCRG" T1 ON T0."GroupCode" = T1."GroupCode" INNER JOIN "PAF_LIVE"."OSLP" T2 ON T0."SlpCode" = T2."SlpCode" INNER JOIN OPLN T3 ON T0."ListNum" = T3."ListNum" WHERE T0."CardType" = 'C' ORDER BY T0."CardCode"

Thank you.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers