ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> PURCH YTD AND PURCH LYR
http://www.istechforum.com/YaBB.pl?num=1462829357

Message started by DSWAZE on 05/09/16 at 14:29:17

Title: PURCH YTD AND PURCH LYR
Post by DSWAZE on 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

Title: Re: PURCH YTD AND PURCH LYR
Post by Kelloggs on 05/09/16 at 16:06:35

select bkap_purch_ytd, bkap_purch_lyr from BKAPVEND where BKAP_VENDCODE = 'donaldtrump';

:P

Kelloggs

Title: Re: PURCH YTD AND PURCH LYR
Post by DSWAZE on 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

Title: Re: PURCH YTD AND PURCH LYR
Post by Lynn_Pantic on 05/10/16 at 08:24:21

It is based on invoices and to be accurate needs to be recalculated using SM-J-O.

Title: Re: PURCH YTD AND PURCH LYR
Post by DSWAZE on 05/10/16 at 08:32:20

Thank you, Lynn :)