Welcome, Guest. Please Login.
04/18/24 at 18:59:11
News:
Home Help Search Login


Pages: 1
Send Topic Print
PURCH YTD AND PURCH LYR (Read 1742 times)
DSWAZE
Browser
*




Posts: 36
Gender: female
PURCH YTD AND PURCH LYR
05/09/16 at 14:29:17
 
Hello,
Could someone help to tell me where YTD and LYR information in Vendor statistics is coming from?
Is this for items that were invoiced and paid for the year?
 
Thank you kindly
Doreen
Back to top
 
 

Doreen Swaze
Choose Manufacturing Co LLC
WWW   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 785
Gender: male
Re: PURCH YTD AND PURCH LYR
Reply #1 - 05/09/16 at 16:06:35
 
select bkap_purch_ytd, bkap_purch_lyr from BKAPVEND where BKAP_VENDCODE = 'donaldtrump';
 
Tongue
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
DSWAZE
Browser
*




Posts: 36
Gender: female
Re: PURCH YTD AND PURCH LYR
Reply #2 - 05/10/16 at 08:22:32
 
Kelloggs, thank you for your response.
Perhaps I should clarify my question for the value shown in bkap_purch_ytd, bkap_purch_lyr , where is that value coming from?
Is it the total items purchased for the year and invoice, or just total invoiced...?
 
Thank you
Doreen
Back to top
 
 

Doreen Swaze
Choose Manufacturing Co LLC
WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: PURCH YTD AND PURCH LYR
Reply #3 - 05/10/16 at 08:24:21
 
It is based on invoices and to be accurate needs to be recalculated using SM-J-O.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
DSWAZE
Browser
*




Posts: 36
Gender: female
Re: PURCH YTD AND PURCH LYR
Reply #4 - 05/10/16 at 08:32:20
 
Thank you, Lynn  Smiley
Back to top
 
 

Doreen Swaze
Choose Manufacturing Co LLC
WWW   IP Logged
Pages: 1
Send Topic Print