Skip to Content
Jun 10, 2016 at 11:57 AM

Business Partner query


Hey Experts,

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'

Best regards