Lynn / Allen,
I got myself in trouble by enabling automatic updates / additions to the vendor price file. Purchasing had updated many costs in the Vendor price file. We had many open POs out that were honored at the old price. As those POs were received, and vendor invoices entered for them, the vendor price file was
'UPDATED' to the
OLD PRICE!!
I have since turned off this nifty feature. Now, I want to identify the records that were ADDED to the vendor price file and the ones that were UPDATED. I noticed that I have tons of records that do not have an Entry date, Item Description, Unit identifier, etc. I also have several records where the expiration date is out way further than we ever set it.
When the Enter Vendor Invoice function automatically ADDS records to the vendor price file, specifically which fields are populated? Is the expiration date set to some fixed offset on UPDATED records? Knowing this will allow me to identify all the automatic records that I do not want.
Thanks!