ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Manufacturing >> Average Delivery Time for PO
http://www.istechforum.com/YaBB.pl?num=1334848701

Message started by Kelloggs on 04/19/12 at 08:18:21

Title: Average Delivery Time for PO
Post by Kelloggs on 04/19/12 at 08:18:21

Does Evo has such type of report?
If not, is there a way to calculate it?

:-[

Kelloggs

Title: Re: Average Delivery Time for PO
Post by Lynn_Pantic on 04/19/12 at 10:48:20

Nothing currently exists. Would you want by Vendor, Part or what?

Title: Re: Average Delivery Time for PO
Post by Kelloggs on 04/19/12 at 11:16:32

by vendor would be nice..

;)

Kelloggs

Title: Re: Average Delivery Time for PO
Post by Kelloggs on 04/20/12 at 09:57:56

There ya go!!!

SELECT
BKAP_PO_VNDCOD,
BKAP_POL_PONM,
BKAP_POL_CNTR,
BKAP_POL_PCODE,
BKAP_POL_ERD,
BKAP_POL_ARD,
(BKAP_POL_ARD - BKAP_POL_ERD) AS DF,
IF((BKAP_POL_ARD - BKAP_POL_ERD)<0,1,0) AS EA,
IF((BKAP_POL_ARD - BKAP_POL_ERD)=0,1,0) AS OT,
IF((BKAP_POL_ARD - BKAP_POL_ERD)>0,1,0) AS LA
FROM BKAPHPO INNER JOIN BKAPHPOL ON BKAPHPO.BKAP_PO_NUM = BKAPHPOL.BKAP_POL_PONM WHERE
ASCII(LTrim(BKAP_POL_PCODE)) <> 0
AND BKAP_POL_ARD >= '2011-01-01'
AND BKAP_POL_ARD <= '2011-12-31'

EA = Early
OT = On Time
LA = Late

Group them, add the Vendor's Name, some percentages, and you sir have a report

:P

Kelloggs