How Can I Get a List of New Vendors Set Up Since a Certain Date?

How Can I Get a List of New Vendors Set Up Since a Certain Date?

Q: Is there a table within Elliot that will show when a new vendor was set up in the system? We have a request from our corporate office to provide a list of all new vendors set up in 2014. I was hoping there is a table with a field that contains this information so I can run a query from the tables.
A: Yes, there is a table for this purpose. It is APVENADT (A/P Vendor Audit Trail). You can use the following sample SQL statement to retrieve the data you need:
     
SELECT * FROM APVENADT WHERE v_aud_date >= 20140101 and v_aud_action = 'A'
You can also go into Elliott, A/P -> Reports -> Vendor Audit Trail Report, and pick the proper range. The Vendor Audit Trail Report will result in showing both Add and Change records, so if you know how to access the data in the APVENADT table through ODBC directly, it might suit your needs better. It's possible that your Vendor Audit Trail feature is not turned on.  In that case, you will need to go to A/P -> Util-Setup -> A/P Setup, and change the following flag to ""Y"":
    17. Keep Vendor File Audit Trail ?
This won't retroactively create the vendor audit trail record for you.  But in the future, as a vendor is added or changed, an audit trail record will be written to APVENADT for future reporting.



    • Related Articles

    • Can I Get Alert When Sales Order Ship Date Is Changed?

      Release Date: 8/21/2018 Q - Is there a system of alerts in Elliot? We need a way to alert Billing that a certain customer order has had its shipping date updated. A - If we understand your intention correctly, you would like someone to get ...

    • Developing a New Elliott V8.6 Report Desk User Defined Report (UDR)

      'Release Date: 6/20/2018 Version: 8.6 & Up This document is written for licensed Elliott Software developers. It is not relevant for regular Elliott users. Overview With proper licensing, Elliott developers can follow these three steps to create a ...

    • Elliott V7.4 Release Notes: What's New Since Elliott V7.3

      What’s New Since Elliott V7.3 Use ATP as MRP The ATP (Available to Promise) feature has been in Elliott since V6.7. Initially, ATP only supported parent items and was mainly used by importers to view scheduled sales orders and purchase orders ...

    • Elliott V7.5 Release Notes: What's New Since Elliott V7.4

      What’s New Since Elliott V7.4 Elliott 7.5 Overview Netcellent has rewritten all the legacy manufacturing modules for Elliott V7.5 and consolidated them into the BOMP module. It simplifies manufacturing data collection while providing powerful ...

    • Algorithm to Speed Up eContacts List in Elliott V8

      In Elliott 7.5, we use the MAPI interface to send e-mail. The MAPI interface allows Elliott to interact with a desktop e-mail client, such as Outlook. Therefore, in the print option screen, we allow users to interact with the Outlook address book. In ...