ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> Automatic Entries to Vendor Price File
http://www.istechforum.com/YaBB.pl?num=1174423797

Message started by kevind on 03/20/07 at 12:49:57

Title: Automatic Entries to Vendor Price File
Post by kevind on 03/20/07 at 12:49:57

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. [smiley=thumbsup.gif]

Thanks!

Title: Re: Automatic Entries to Vendor Price File
Post by JEMM on 03/22/07 at 07:16:18

The fields populated when it adds records to BKARQUOT are the following, BKRFQ.PROD=Item Number, BKRFQ.VEND=Vendor Number, BKRFQ.EXP = Todays Date + 10 years, BKRFQ.PCONV = Conversion factor, BKRFQ.QTY[1]= 99999999.99, BKRFQ.COST[1] = Item Price, BKRFQ.QTY[2]=0, BKRFQ.COST[2]=0.

Hope this helps.

Mike

Title: Re: Automatic Entries to Vendor Price File
Post by kevind on 03/22/07 at 07:43:42

Yes, thank you, that is exactly what I need!! [smiley=2vrolijk_08.gif]