Generate BP Code
I have created a formatted search which generates the business code automatically. Essentially it works with following query:
SELECT MAX(T0. CardCode)+1 FROM OCRD T0 WHERE T0.CARDTYPE= $[OCRD.CARDTYPE] FOR BROWSE
I want that the BP code only increases when I add a new data record. But currently the BP code also increases when Iu2019m just viewing the data record.