Trouble deleting Vendors that are old

(0) Share

Report

Posted on by kgibbons

I have already viewed another's issue and it appears to be similar, I did see the reply:

Santhosh Dharmar responded on 26 Jan 2014 1:49 AM

You can specify the Vendor Status as "One Time" under Vendor Maintenance screen. This status facilitates deleting unneeded vendor records in future periods. The software deletes one-time vendor information from the database when the vendor’s account has no open documents.

Vendors with the one-time status will be deleted when the following conditions are met:

1) Accounts payable detail is deleted.

2) All documents have exceeded the retention period specified in AP Setup (03.950.00).

3) The account has no open documents, outstanding checks, or purchase orders.

4) There is no 1099 box total.

Hope this will helps you.

Thanks & Regards

Thanks & Regards

Santhosh D

I reviewed everything they stated here and I still can't delete the vendor, it states this:

"This vendor cannot be deleted, It is in use somewhere else in the system"

Does anyone have any ideas what else may need to be done?

There are no open documents, no pending checks, they are set at one time, the period is set for 14 months and this vendor was last used in 2011. They have nothing outstanding in 1099.

*This post is locked for comments

All responses (3)

Answers (0)

Community Member on at

Like (0)

Report

RE: Trouble deleting Vendors that are old

as much as i hate reawakening year+ old threads, what did you discover?

my exposure:

I have a SL db that has never been archived. 300,000 vendors where only about 68k are in use in last 3 years, and 4 million rows of APTran records.

Once I found all the vendors that were < 2013, i updated them in sql to "O" One-Time. I found them using the Vendors report and checking for the last check paid date in the report.

in a test environment and after approval from Accounting bosses:

set the retention to 36 months and ran "Delete AP Detail"

and it ran for 200 hours before crashing and rolling back the data.

set retention to 2009, and let it run for a few minutes, then 2010, same, 2011, a hour or two, etc.

till i caught up.

4,000,000 rows are not 1,300,000. for AP tables

300,000 vendors is now 65,000 vendors. more should fall out as we archive each year.
kgibbons 35 on at

Like (0)

Report

RE: Trouble deleting Vendors that are old

I had not done so, I just did and they do not appear there either
Community Member on at

Like (0)

Report

RE: Trouble deleting Vendors that are old

Did you try printing the Vendor Trial Balance > All Documents to double check if there are any documents that SL thinks are hanging out somewhere? That report should pull anything that it's still seeing for the vendors you're looking for.

Community site session details

Trouble deleting Vendors that are old

Helpful resources

News and Announcements

Quick Links

Jainam Kothari – Community Spotlight

Congratulations to the May Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Featured topics

Product updates

Community site session details

Trouble deleting Vendors that are old

Helpful resources

News and Announcements

Quick Links

Jainam Kothari – Community Spotlight

Congratulations to the May Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Featured topics

Product updates