400庫存單之因應對策
跳至導覽
跳至搜尋
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