Does anyone know how to print a complete list of vendors that shows each vendor's payment terms?
 
Thanks, and have a great day!
 
Bonnie

The Terms Text is contained in the 1 record of BKSYMSTR.Bxx.
 
They are in the BKSY_TERMS array (1 - 20).
 
In the ODBC world, these field names are:
BKSY_TERMS_1
BKSY_TERMS_2
.
.
BKSY_TERMS_20
 
To get to these values in Crystal, you can do a != link between the BKAPVEND.BKAP_VENDCODE and BKSYMSTR.BKSY_TERMS_1.  This will cause this one record in BKSYMSTR to be returned in the result set.
 
Next, you make a Crystal function that assigns all the BKSY_TERMS_X values to a global crystal stringvar array.
 
To display the Terms text, make another crystal function that returns the BKAP_TERMS_NUM element of the global array.
 
 
Here is a sample in Crystal V10:
http://spectronics.com/dba/venterms.zip