I would like to ask if you can help on creating a query which can show BP with no transaction.
I've actually done partially the query, but the tricky part is to know which BP has '0' transaction.
My query is only for BP with "0" balance and not with 0 transaction.
Kindly find bellow the query I did.
SELECT T0.[CardCode], T0.[CardName], T0.[FatherCard], T0.[BalanceSys], T0.[BalanceFC], T0.[SefazCheck] FROM OCRD T0 WHERE T0.[BalanceSys] ='0' and T0.[validFor] = 'Y'