Skip to Content

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

balance

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.

Steve

Former Member
Former Member replied

Hi Steve,

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

Whats ur SAP B1 version and PL?

Regards,

Bala

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