<div>
<div class="content wysiwyg-content">
We have 55,000 vendors and 46,500 of these have never had any activity. These vendors are not in a certain range so I would probably need to delete them in SQL. &nbsp;Is there more than one table involved.
</div>
</div>


We have 55,000 vendors and 46,500 of these have never had any activity. These vendors are not in a certain range so I would probably need to delete them in SQL.  Is there more than one table involved.

Great Plains (GP 2010) Accounts Payable -- vendors with no activity

Microsoft Dynamics is a line of enterprise resource planning (ERP) and customer relationship management (CRM) software applications. Dynamics can be used with other Microsoft solutions, such as SharePoint, Yammer, Office 365, Azure and Outlook. Dynamics ERP comprises a group of enterprise-resource-planning products includes Dynamics AX (formerly Axapta), a multi-language, multi-currency enterprise software with business management features for financial, human resources, and operations management; Dynamics GP (formerly Great Plains Software); Dynamics NAV (formerly Navision) for financials, supply chain, and people; Dynamics SL (formerly Solomon IV)for project-driven organizations; Dynamics C5 (formerly Concorde C5) for manufacturing, supply chains, analytics and electronic commerce; and Dynamics CRM.

Microsoft Dynamics

The tax and financial software topic covers both personal and organizational software, ranging from checkbook managers and tax calculation systems to sophisticated general ledger, accounts receivable and payable, payroll, inventory and planning packages. Two of the most common titles are Quickbooks and Microsoft Dynamics.