Delete a Vendor Group

(0) Share

Report

Posted on by Community Member

Hello everyone,

I am in the process of a mass master data cleanup and Vendors are being tackled at the moment. We have deleted some Vendor Groups that will no longer be used and defined a set of Vendor Groups for future use. All vendors have been reclassified into these groups.

For some reason, there is a Vendor Group called Default that I am unable to delete. The error message says "Vendor groups cannot be deleted while dependent Vendors exist. Delete dependent Vendors and try again."

The problem is that there are no vendors assigned to this group at all so I am not sure why I keep getting this error. I have looked at the VendTable in AOT as well but there is no Vendor listed under Default group.

How can I solve this besides have a big DO NOT USE in the description for default! :)

Thanks

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

RE: Delete a Vendor Group

Hi Satrangi

if no vendor assigned to this vendor group, this error is not logical.

so try to check vendtable from SQL and AOT, if any vendors related to this group

if no vendor assigned, I suggest to run consistency check from system administration

if the same problem, you need to debug this issue

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

RE: Delete a Vendor Group

@Mahmoud Hakim I checked AOT tables and ran the consistency checks but everything was fine. No Vendors are listed under that DEF vendor group. To do another check, I ran an account statement for the group but it came up with zero records. Debugging next. Hopefully, that helps.

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report

RE: Delete a Vendor Group

Hi,

Please check the deleteActions node on VendGroup table. By default it has two tables InventTestAssociationTable and VendTable with deleteAction as restricted.So, see if any vendor is associated with that default vendor group (or) any data lying in table InventTestAssociationTable (or) any custom tables with restricted action that is causing the blockage.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Delete a Vendor Group

Hi Chaitanya,

I just checked and the deleteAction node does not exist in the VendTable. As for the InventTestAssociationTable, it is completely empty.

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (1)

Report

RE: Delete a Vendor Group

Hi,

I am speaking about deleteactions node on vendgroup table.Anyway if you are sure no vendor is connected to vendgroup, you can use dodelete() in a job as below.

Vendgroup vendgroup;

Select vendgroup where vendgroup.vendgroup == "default";

Ttsbegin;

Vendgroup.selectforupdate (true)

Vendgroup.dodelete();

Ttscommit;

Was this reply helpful? Yes No
Mahmoud Hakim 17,887 on at

Like (0)

Report

RE: Delete a Vendor Group

As Chaitanya Golla mention you for the above job

I suggest checking all scenarios on test server firstly

after issue solved, you can execute the valid solution on life

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Delete a Vendor Group

Hi Sarrangi

Why you want to spend time trying to delete this group? It seems somehow difficult in your system and I'm wondering whether it would be sufficient not including this group in the posting profiles. If somebody assigns this wrong group then they would receive an error at the latest when they try posting something.

Best regards

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

RE: Delete a Vendor Group

Thank you everyone. I found the solution. My vendor group was being shared across multiple entities. Once I cleaned them up, I was able to delete the group.

Was this reply helpful? Yes No