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. |