Skip to main content

Notifications

Microsoft Dynamics SL forum
Unanswered

How to mass delete vendors

Posted on by 90

We are trying to cleanup our vendors.  To do so, we are trying to use the Delete AP Detail (03.540.00) screen.  When we run it in our test environment, we are successful in deleting the detail and history, however the vendors themselves are not being deleted.  Does anyone have any experience with this process...are we doing something wrong or not doing something we should be?

Thanks,

Corey

  • Re: How to mass delete vendors

    Hi Corey,

    Some criteria needs to be met in order for the system to delete vendors.  You can delete a one time vendor in the vendor maintenance screen, even if documents and history are still within the retention period.  You will get a message asking if you are sure you want to delete the vendor, even though the retention period has not been met, but it will let you delete the vendor.  This is assuming the vendor has no open documents.

    For a one time vendor to be deleted in the AP Delete Detail screen, it has to meet several criteria.   The delete detail  is really three separate processes.  One deletes documents based on a comparison of the number of periods you are retaining detail, and the period the document was closed.  There is a complicating factor in Accounts Payable.  If you are retaining AP checks for reconciliation, the system will assume that if the check is not reconciled, it cannot be deleted.  So even if you had a voucher that was paid in period 01-2005 and you are only retaining detail for 24 periods, if the check was never cleared and is still outstanding, then the check cannot be deleted, and if the check cannot be deleted, the voucher the check paid cannot be deleted and thus the vendor cannot be deleted either.

    A second process deletes vendor history based on a comparison of the number of years history is being retained, and the oldest history record for the vendor.

    The third process, which is optional, deletes vendors with no activity subsequent to the date entered.  This of course assumes that the documents and history either can be deleted or have already been deleted.

    I hope this information provides a little insight as to why your vendors may have not been deleted.  it helps to take one vendor as an example, and see if that vendor has any history or uncleared checks or other documents remaining in the system which would prevent that vendor from being deleted.

    You could print the Vendor Trial Balance, All Documents to see if the vendors you are hoping to delete have any documents in the system.  

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,469 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans