Check BP group

[Former Member]

Hi All,

we would like to check the BP group in our database and we would like to delete it. Please give advice.

B'Regards,

Andres

[former_member583013 · Accepted solution]

Andres,

When you are logged into Business One ....go to Admin > Setup > Business Partners > Customer Groups / Vendor Groups click inside the row you want to delete ...Right Mouse Click....REMOVE (or click Data Menu on the top > Remove)

NOTE: The Customer / Vendor Group should not be linked to any Business Partner

[Former Member]

Hi All,

sorry that I forgot to mention the version. it is 6.0 that used by one of our end user. I will consider to upgrade.

Thanks Jimmy, Suda and Gordon for the answers.

B'Regards,

Andres

[Former Member]

Hi Andres,

Suda's suggestion is the correct way. Jimmy's note only applied to version 6.0 in 2003. Delete should not be used under query manager in current B1 version.

Thanks,

Gordon

[former_member186095]

Andres,

beside the 2 other solutions, try to consider this following solution from SAP note 606507:

Delete Customer/Vendor Group which is not connected to a BP
Symptom
The system does not have an option to delete Business Partners Groups
Other terms
Delete, Group Code, Business Partners Master Data, Delete Card Groups, SAP BusinessOne
Reason and Prerequisites
Need for information
Solution
To delete the Customer/Vendor Group please do the following:
   1. Check if there is a "Business Partner Master Data (BP)" connected to the group you wish to delete.
   2. Todo this use the query below from the Query Interface:
      SELECT T0.CardCode, T0.CardName FROM OCRD T0 INNER JOIN OCRG T1 ON T0.GroupCode=T1.GroupCode WHERE T1.GroupName ='[%0]' FOR BROWSE
      !!! The input for the veriable [%0] should be the group name you wish to delete
   3. Run the query for each of the Group Names for each Business Partner
   4. Run the query again to make sure that no Business Partner is relating to the Group Name you wish to delete
   5. Open the Query Analyzer and run the following query:
      DELETE FROM OCRG WHERE OCRG.GROUPCODE NOT IN (SELECT GROUPCODE FROM OCRD)AND OCRG.GROUPNAME='ENTER GROUPNAME'
      !!! Replace the text ENTER GROUPNAME with the group name you wish to delete.

Rgds,

[Former Member]

u dont should delete table entry etc directly from your database. therefor you won't get advice.