ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> AP Vendor List
http://www.istechforum.com/YaBB.pl?num=1109180836

Message started by friske13 on 02/23/05 at 09:47:16

Title: AP Vendor List
Post by friske13 on 02/23/05 at 09:47:16

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

Title: Re: AP Vendor List
Post by Tim Keating on 02/23/05 at 15:38:38

I don't see any report with that info.  If you were to export using DE-A;

File is BKAPVEND.Bxx

Fields are
BKAP_VENDCODE (Vender Code)
BKAP_VENDNAME (Vendor Name)
BKAP_TERMS_NUM (Terms ID Number)

I could not locate that file that links the terms ID number to the text.  Maybe someone else knows.

Title: Re: AP Vendor List
Post by kevind on 02/24/05 at 09:32:44

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


ISTech Support Forum » Powered by YaBB 2.1!
YaBB © 2000-2005. All Rights Reserved.