Shulou(Shulou.com)06/02 Report--

1. Problem description

According to the explanation of the textbook, the on-time delivery rate is defined as the quantity (or amount, or number of order lines) delivered by the supplier on time, divided by the quantity (or amount, or number of order lines) that should be delivered within that time. In actual work, our statistical method is calculated on the basis of the number of orders, that is, the same customer with the same delivery date is an order, and the calculation methods may be slightly different. But it's pretty much the same.

2. Implementation method

2.1 use grouping to count the number of orders, represented by a serial number, and a serial number represents an order:

2.2 use SQL to extract the production task order and product inventory order data corresponding to the sales order, provided that the MRP operation must be performed, and the relevant demand documents are not allowed to be merged manually and the production task order cannot be issued manually, otherwise the data cannot be obtained because there is no correlation between the documents, as shown in the following sentence:

SELECT * FROM (SELECT t1.FBillNogramme u1.FName AS FCustID,case when u1.FNamekeeper 'then' Forecast order 'else' sales order 'end as FCustID1,t1.FDate,u2.FName AS FEmpID,case when t1.FMultiCheckLevel1=16403 or t1.FMultiCheckLevel1=16507 then' Kunyu Road Factory 'else' fourth production Road Factory 'endAS fparentid,t2.FEntryID,t100.FNumber,t100.FName,t100.FModel,CASE WHEN t2.FUnitID=0 THEN' 'ELSE u4.FName END AS FUnitID,t2.FAuxQty As FQty,t2.FDate AS FOutStockDate,t2.FAdviceConsignDate U5.FBOMNumberreum t1.FInterID as FStockQty,t51.FName as FCUUnitID,t2.FQty/t51.FCoefficient as FCUQty,t2.FStockQty/t51.FCoefficient as FCUStockQty,cast 2.FAuxStockQty as FStockQty,t51.FName as FCUUnitID,t2.FQty/t51.FCoefficient as FCUQty,t2.FStockQty/t51.FCoefficient as FCUStockQty,cast (t2.finterid as varchar) + cast (t2.fentryid as varchar) finteridfentryid,t800.fqty fstockqty1,t800.fcheckdate,t2.FHaveMrp,t1.FExchangeRate,t2.fauxpricediscount,t900.fqty fqty900FROM SEOrder T1 INNER JOIN SEOrderEntry T2 ON t1.FInterID = t2.FInterID and t1.fstatus in (1meme 2m 3) and t1.FChangeMark=0 AND Isnull (t1.FClassTypeID) 0) 1007100 and t2.FMrpAutoClosed in ${whether the manual line is closed} left outer join icmo t900 on t900.FOrderInterID = t2.FInterID and t900.FSourceEntryID=t2.FEntryID and t900.fitemid=t2.fitemidleft outer join (select b.FICMOInterID reportb.fitemidreb. Fqty A.fdate as fcheckdate from icstockbill a join icstockbillentry bon a.finterid=b.finterid where a.ftrantype=2 and a.fstatus=1) T800 on t800.FICMOInterID=t900.finteridLEFT OUTER JOIN t_Organization U1 ON t1.FCustID=u1.FItemIDLEFT OUTER JOIN t_Emp U2 ON t1.FEmpID=u2.FItemIDLEFT OUTER JOIN t_ICItem T100 ON t2.FItemID = t100.FItemIDLEFT OUTER JOIN t_MeasureUnit U4 ON t2.FUnitID = u4.FItemIDLEFT OUTER JOIN t_MeasureUnit T51 ON t100.FProductUnitID=t51.FItemIDLEFT OUTER JOIN ICBOM U5 ON t2.FBomInterID = u5.FInterID) ttWHERE 1 starts 1 and tt.FOutStockDate > ='${start Date} 'and tt.FOutStockDate'3.01'$ {if (len (fparentid) = = 0 "", "and fparentid ='" + fparentid+ "')} orderby ${cname} ${orderby}

3. Effect display

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.