08-23-2022 5:32 AM
Hi all
i want to ADD Debit and Credit into sing Colum
maybe there is way to make custom Column
do you guys know how to do it?
08-23-2022 5:48 AM
08-23-2022 5:51 AM
08-23-2022 5:51 AM
08-23-2022 5:56 AM
Hi hswy11
SELECT T1.Refdate, T1.account,
T1.Ocrcode3,
(T1.debit + T1.credit) as "Amount"
CASE WHEN T1.DEBIT > 0 THEN "DR" ELSE "CR" END AS "DRCR"
FROM OJDT T0 INNER JOIN JDT1 T1
ON T0.TRANSID = T1.TRANSID
08-23-2022 6:08 AM
08-23-2022 6:13 AM
If Credit Amount into single line Mark should be Reverse
do you know how to reverse Mark?
08-23-2022 6:15 AM
08-23-2022 6:25 AM
CASE WHEN T1."Debit" > 0 THEN T1."DEBIT" ELSE (-1*T1."CREDIT") END AS "DRCR"
Amount > 0 "==== is the correction