400庫存單之因應對策

出自TSK WIKI
跳至導覽 跳至搜尋

APR作業情形

  1. 作業步驟
    1. 建立庫存單400及數量之工單
    2. 建立正式訂單,備註銷400工及數量
  2. 缺點

ERP彷APR作業

  1. 作業步驟
    1. 開立庫存訂單
      1. 庫存訂單轉製令
      2. 轉完製令後以訂單變更建立作業,整張結案及寫明原因。
    2. 開正式訂單註明銷製令
    3. 正式訂單要注意不要被轉成製令

ERP玩法一

  1. 作業步驟
    1. 開立銷售預測
    2. LRP轉製令
    3. 開立正式

進階玩法之分析

SELECT Y.*,AA.TA003,AA.TA069,AA.TA025,AA.TA027,AA.CREATOR,Y.TD004 AS MB001 FROM(SELECT TC006,TD001,TD002,TD003,
RTRIM(X.TA002) AS XTA02,TC012,X.UDF02,(select CASE WHEN X.UDF02 = THEN TC012 ELSE X.UDF02 END) AS TC012X,
TD014,TC004,MA002,COPMA.MA003 AS CUSTOMER,TD004,TD005,TD006,TD008,TD009,
TD010,TD011,TD012,TC008,TD012*TC009 AS TWM,TC018,MB007,MA019,TD013,TD020,X.UDF01,X.UDF05,
TC027,TD021,TD016,X.TA001,X.TA002,X.TA003 AS MA003,
X.TA010,X.TA014,X.TA015,X.TA017,X.TA013,X.TA011,TH001,TH002,TH003,TH008,TH037,TH018,X.UDF04
,TG003,TG023,TH020,TG022,TB001,TB002,TB003,TB019,MA043,TB011,TB012,COPMA.UDF01 AS COPMAU01
FROM (SELECT TC006,TD001,TD002,TD003,TD014,TD004,TD005,TD006,TD008,TD009,
TD010,TD011,TD012,TC008,TC009,TD013,TC018,TD020,COPTD.UDF05,COPTD.UDF01,TC027,TD021,TD016,TC004,TC012,COPTD.UDF02,
MA.TA001,MA.TA002,MA.TA003,MA.TA010,MA.TA014,MA.TA015,MA.TA017,MA.TA013,MA.TA011,
v_COPTGH.*
FROM COPTD LEFT JOIN COPTC ON TD001=TC001 AND TD002=TC002 
LEFT JOIN v_COPTGH ON TH014=TD001 AND TH015=TD002 AND TH016=TD003
LEFT JOIN v_MOCTANOTV AS MA ON MA.TA026=TD001 AND MA.TA027=TD002 AND MA.TA028=TD003) X
LEFT JOIN COPMA ON MA001=TC004 
LEFT JOIN ACRTB ON TB005=TH001 AND TB006=TH002 AND TB007=TH003
JOIN INVMB ON X.TD004=MB001)Y 
LEFT JOIN ACRTA AS AA ON AA.TA001=TB001 AND AA.TA002=TB002