emi_sastra
asked on
QUERY TO ASSIGN TRANSACTION AMOUNT TO DEBIT OR CREDIT
Hi All,
I have transaction which are :
1. Money Receive.
2. Money Pay.
Query Condition :
1. When Receive then Debet.
2. When Receive and Minus Then Credit
3. When Pay then Credit.
4. When Pay and Minus Then Debit
Below are my code :
CASE WHEN RIGHT(A.TipeTransaksi, 1) = 'D' THEN B.TransactionAmount ELSE 0.00 END AS Debit"
CASE WHEN RIGHT(A.TipeTransaksi, 1) = 'C' THEN B.TransactionAmount ELSE 0.00 END AS Credit"
How to add condition for minus TransactionAmount to the right place, Debit or Credit?
Thank you.
I have transaction which are :
1. Money Receive.
2. Money Pay.
Query Condition :
1. When Receive then Debet.
2. When Receive and Minus Then Credit
3. When Pay then Credit.
4. When Pay and Minus Then Debit
Below are my code :
CASE WHEN RIGHT(A.TipeTransaksi, 1) = 'D' THEN B.TransactionAmount ELSE 0.00 END AS Debit"
CASE WHEN RIGHT(A.TipeTransaksi, 1) = 'C' THEN B.TransactionAmount ELSE 0.00 END AS Credit"
How to add condition for minus TransactionAmount to the right place, Debit or Credit?
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It works.
Thank you very much for your help.