Welcome, Guest. Please Login.
04/19/24 at 21:15:02
News:
Home Help Search Login


Pages: 1
Send Topic Print
Top Vender List Report (Read 845 times)
ddlong
Full Member
***




Posts: 205
Gender: female
Top Vender List Report
06/25/15 at 09:38:34
 
Can someone tell me an easy way to get a top vender list for a previous year.  I'm not too good at Queries.
 
Back to top
 
 

Darla Long
Catalytic Industrial Group, Inc.
Independence Ks
dba 2004.1 client/server EVO Version 2020.0 08/07/20 Build Pervasive 11.3
  IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 785
Gender: male
Re: Top Vender List Report
Reply #1 - 06/25/15 at 13:27:06
 
You don't now how to use them? or how to create them?
 
Queries are the best !!!
 
SELECT BKAP_PO_VNDNME, SUM(BKAP_PO_SUBTOT) AS TP FROM BKAPHPO  
WHERE BKAP_PO_ORDDTE > '2013-12-31' AND BKAP_PO_ORDDTE < '2015-01-01'
GROUP BY BKAP_PO_VNDNME ORDER BY TP DESC;
 
It will show all 2014 purchases, order by top to bottom (biggest vendor)
 
Have fun  
 
Tongue
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Pages: 1
Send Topic Print