Automatic Generation of BP Code
I have searched the forum and have found a number of queries that may be used as a FMS in order to automatically create a BP Code in the Business Partner Master Data.
My customer has had the following query set up and has been using it as a FMS for a couple of years:
SELECT MAX(T0. CardCode)+1 FROM OCRD T0 WHERE T0.CARDTYPE = $[OCRD.CARDTYPE] FOR BROWSE
He mentioned the last time I was at their facility that the formatted search no longer works. It pulls up 1000 everytime even though there's already a customer code 1000 assigned to a BP. So, he's been manually entering the BP code.
Has anybody had issues with this query failing eventually? Is there anyway to edit this query so it works again for the customer? Perhaps this cannot be answerd on the forum since you don't have thier data to look at, but I'm hoping somebody can at least point me in the correct direction.
I noticed there were a few variations of this query available on the forum. I have tried a number of them without success.
I appreciate anybody's help.