Vendor Mass Delete Error

(0) Share

Report

Posted on by Tiffany Lou

615

I'm trying to use the Vendor Mass Delete utility in Dynamics GP to delete a vendor but I keep getting the message "Vendor has related WORK records." I've already removed Transaction History for the vendor and when I do a Vendor Inquiry by Transaction nothing appears. What am I missing? How can I get this vendor deleted?

*This post is locked for comments

All responses (4)

Answers (0)

soma 24,406 on at

Like (0)

Report

RE: Vendor Mass Delete Error

Any updates?
soma 24,406 on at

Like (1)

Report

RE: Vendor Mass Delete Error

Run the below query against your company database to see if any records returns.

select *from payablestransactions where vendorid in('yourvendorid1','yourvendorid2','yourvendorid3',..)

Your reply is much appreciated.
Tiffany Lou 615 on at

Like (0)

Report

RE: Vendor Mass Delete Error

I've already deleted the transaction history so there is no current balance, 1099 amount, unposted/posted transactions. I've also done check links to clean things up.

Any other suggestions?
Suggested answer

soma 24,406 on at

Like (1)

Report

RE: Vendor Mass Delete Error

You can't delete the vendor card if it contains any of the following information:

• A current balance

• A 1099 amount for the current year (United States only)

• Unposted and posted transactions

• An Active or Inactive vendor has transactions in the history table

Please verify your vendor transactions.

Hope this helps!!!