Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A


Hi Experts,

I need cumulative balance sub query or SQL query running total in the financial report query. I use table OJDT and JDT1 including document tables.

I use this query sample but not success:

SELECT counter, emp_short, trans_date, debit, credit,

(SELECT SUM(COALESCE(debit,0) - COALESCE(credit,0))

FROM trans02 tr2

WHERE tr2.counter <= tr1.counter and

tr2.emp_short = tr1.emp_short) AS 'Running balance'

FROM trans02 tr1

ORDER BY emp_short, counter

I replace trans02 with jdt1 and execute the query but the result is different with cumulative balance like in the G/L report cumulative balance field. Pls help.



Hi Steve,

Crystal report is really handy than the SQL query in this type of reports...

Whats ur SAP B1 version and PL?



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question