Supplier Query

Dear All,

im trying to select the balances of the supplier  and i have excluded the employee suplier but still im getting some supplier that i dont want to show in my list

so how can i exclude a specif category from my list

i tried to add this line in my code but im not sure if this correct :

and (vendor_site_code not like  '%OFFICE%' and  vendor_site_code not like  '%PAY%')

the supplier are divided into category, the external supplier have a specific one , please advise

just for more clarification below is my query :