Welcome, Guest. Please Login.
05/11/25 at 14:15:50
News:
Home Help Search Login


Pages: 1
Send Topic Print
Automatic Entries to Vendor Price File (Read 525 times)
kevind
Active Member
*****


I was more than
willing to
"pony up",
how b'out U?

Posts: 634
Gender: male
Automatic Entries to Vendor Price File
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!!   cry
 
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
 
Thanks!
Back to top
 
 

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
JEMM
Administrator
*****


In two days from
now, tomorrow will
be yesterday.

Posts: 225
Gender: male
Re: Automatic Entries to Vendor Price File
Reply #1 - 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
Back to top
 
 

Mike
ISTechSupport
Email   IP Logged
kevind
Active Member
*****


I was more than
willing to
"pony up",
how b'out U?

Posts: 634
Gender: male
Re: Automatic Entries to Vendor Price File
Reply #2 - 03/22/07 at 07:43:42
 
Yes, thank you, that is exactly what I need!!   Smiley
Back to top
 
 

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
Pages: 1
Send Topic Print