「400庫存單之因應對策」:修訂間差異
跳至導覽
跳至搜尋
| (未顯示同一使用者於中間所作的 1 次修訂) | |||
| 第10行: | 第10行: | ||
###轉完製令後以訂單變更建立作業,整張結案及寫明原因。 | ###轉完製令後以訂單變更建立作業,整張結案及寫明原因。 | ||
##開正式訂單註明銷製令 | ##開正式訂單註明銷製令 | ||
##正式訂單要 | ##正式訂單要注意不要被轉成製令 | ||
==ERP玩法一== | ==ERP玩法一== | ||
| 第17行: | 第17行: | ||
##LRP轉製令 | ##LRP轉製令 | ||
##開立正式 | ##開立正式 | ||
==進階玩法之分析== | |||
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 | |||
於 2015年8月5日 (三) 19:02 的最新修訂
APR作業情形
- 作業步驟
- 建立庫存單400及數量之工單
- 建立正式訂單,備註銷400工及數量
- 缺點
ERP彷APR作業
- 作業步驟
- 開立庫存訂單
- 庫存訂單轉製令
- 轉完製令後以訂單變更建立作業,整張結案及寫明原因。
- 開正式訂單註明銷製令
- 正式訂單要注意不要被轉成製令
- 開立庫存訂單
ERP玩法一
- 作業步驟
- 開立銷售預測
- LRP轉製令
- 開立正式
進階玩法之分析
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