web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Trouble deleting Vendo...
Microsoft Dynamics SL (Archived)

Trouble deleting Vendors that are old

(0) ShareShare
ReportReport
Posted on by kgibbons 35

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

Hi

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

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    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.

  • kgibbons Profile Picture
    kgibbons 35 on at

    I had not done so, I just did and they do not appear there either

  • Community Member Profile Picture
    Community Member on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans