cancel
Showing results for 
Search instead for 
Did you mean: 

Incoming Payment - How to show return value 1 row with ORCT Inner Join RCT2 ?

Former Member
0 Kudos

Incoming Payment - How to show return value 1 row with ORCT Inner Join RCT2 ?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

You can try this query:

SELECT T0.[DocNum], CASE WHEN T1.[InvoiceId] = 0 THEN T0.[DocTotal] ELSE NULL END AS DocTotal, T1.[DocNum], T1.[SumApplied] FROM ORCT T0  INNER JOIN RCT2 T1 ON T0.DocEntry = T1.DocNum

Regards,

Former Member
0 Kudos

MG S , Thankyou so much

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Suphajak,

If you got the correct answer, please close the thread by marking Helpful or Correct answer.

Regards,

Former Member
0 Kudos

Thankyou for your reply example as attached a picture

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Use Sum function for t1.sumapplied field and group all other fields.

select t0.docnum, t0.doctotal, t1.docnum, sum(t1.sumapplied)

from

ORCT t0 inner join RCT2....

Where...

Group by t0.docnum, t0.doctotal, t1.docnum

Thanks.

Former Member
0 Kudos

Nagarajan K , Thankyou so much

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

What you mean by return value 1 row? Any example?

Thanks.