on 05-31-2011 6:51 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.