List of Blocked BP Code

[caviles]

How can I run a query in the system that shows me a list of BP which BP Code is blocked/disable ( in other words a list of BP that I'm not allowed to change the BP Code )

[YatseaLi · Accepted solution]

Hi Cesar,

When the BP has been involved with any invoice or etc transaction, then its code will be disabled for changing. in other word, the BP's balance will not be Zero.

please try the following SQL to get the BP list you want.

SELECT CardCode, CardName FROM OCRD WHERE BALANCE <> 0

regards

yatsea

[former_member201110]

Hi Cesar,

I'm not sure what you are asking. The UI does not allow you to change a BP Code once it has been set (you can delete it if no transactions exist for the BP but you cannot change it directly). To see a list of BP codes that have already been used you can do a lookup in the BP Master window or run a query in the Query Generator like the following:

select CardCode, CardName from OCRD order by CardCode

Kind Regards,

Owen