鼎捷TIPTOP GP PPT-MRP报表.ppt

MRP報表王廣州一、MRP报表名词定义受订量：客户订单需求，主要指原物料销售给其他厂商的出货数量。计划备料：MPS需求。工单备料：工单欠料和已开立未发的物料需求。库存量：程序定议可用库存量总和.如00库,59库,甚至PEND库等等在验量：已收料未入账，IQC正在检验物料。替代量：当主料库存不满足需求，系统根据BOM表自动根据需求数量撷取替代料的库存量。可用量：（库存量＋在验量）－（计划备料＋工单备料）。请购量：请购开立未转成P/O所有总和。在采量：采购单开立未发出所有总和。在外量：采购发出未交货所有总和，包括在途量。在制量：工单在制量。交期调整：系统根据需求，建议做交期调整数量与日期。预计结存：（库存量＋在验量＋请购量＋在采量＋在外量＋在制量)－(计划备料＋工单备料+受定量）PLM/PLP：PlanningManufacture/PlanningPurchase，系统根据需求除去供给，建议制造或采购的数备注：行动日期.系统根据需求日期减去设定L/T,建议下单的日期（据L/T,系统可提前2周左右建议下一、MRP報表名詞定義受訂量：客戶訂單需求，主要指原物料銷售給其他廠商的出貨數量。計劃備料：MPS需求。工單備料：工單欠料和已開立未發的物料需求。庫存量：程式定議可用庫存量總和.如00庫,59庫,甚至PEND庫等等在驗量：已收料未入帳，IQC正在檢驗物料。替代量：當主料庫存不滿足需求，系統根据BOM表自動根據需求數量擷取替代料的庫存量。可用量：（庫存量＋在驗量）－（計劃備料＋工單備料）。請購量：請購開立未轉成P/O所有總和。在采量：采購單開立未發出所有總和。在外量：采購發出未交貨所有總和，包括在途量。在制量：工單在制量。交期調整：系統根据需求，建議做交期調整數量與日期。預計結存：（庫存量＋在驗量＋請購量＋在采量＋在外量＋在制量)－(計劃備料＋工單備料+受定量PLM/PLP：PlanningManufacture/PlanningPurchase，系統根据需求除去供給，建議制造或采購的數備注：行動日期.系統根据需求日期減去設定L/T,建議下單的日期（據L/T,系統可提前2周左右建議下二、I2reportTIPTOPSH使用者:W10600310+--------------------------------------------------------------+/11/16|條件正確,開始列表<^C>放棄列表,離開作業||*x*,<,<=,>,>=,<>,=,x:y,x|y,?x?,[x-y]*||=====I2MRP模擬彙總表(244)(aiir700)(PB)SH==================||1.料號範圍.....:[]||2.來源碼範圍...:[]||3.M.C.Code範圍.:[4I]||4.Sourcer......:[]||--------------------------------------------------------------||6.KEYPARTS分類.....:[]||7.截止時距日........:[]||8.時距:[0]日(7的倍數)[30]週[4]月||9.版本.......:[06/11/16]10.報表別(1.MRP3.ATP):[1]||11.廠別(NA/PB).......:[PB](空白:全廠*:合併)||12.依同類替代料排序..:[Y]13.是否從可用量<0開始印.:[N]||14.是否只印有需求者..:[N]15.是否依Vendor跳頁.....:[N]||16.展BOM時加印半成品.:[N](展BOM才有效，只允許設定料號條件)||17.Excel格式列印....:[N]18.其它特殊列印條件:[N](Y/N)||19.是否顯示其它BUexcess數量:[N]||20.AvailibleW/HRange:[?*]||============================(204)===^Y可輸入展BOM料號======|||+--------------------------------------------------------------+I2報表（1）PrintDate:06/11/1710:11:46---------------------------------------------------------------------------------------------------------------料號/品名L/TSS廠日期受訂量計劃備料工單備料替代量庫存量在驗量可用量-------------------------------------------------------------------------===========================-M.C.code:4I王丹丹08G20VL10207280B11/13004,35030000-4,050A4INVERTERBOARDR2.011/20006,000000-10,050協峰5.383*5.954,(10),2L,1.0mm11/27004,000000-14,050未承認:[N]12/0401,5422,000000-17,59212/1104,0000000-21,59212/1804,0000000-25,59212/2504,0000000-29,59201/0104,0000000-33,59201/0803,0000000-36,59201/1502,1000000-38,69201/2203,0000000-41,69201/2903,0000000-44,69202/0503,0000000-47,692===============================================================================================================08G20VL1020Q280BPassdue00003000300A4INVERTERBOARDR2.011/13000-300000百碩5.383*5.954,(10),2L,1.0m11/200000000未承認:[N]12/040000000===============================================================================================================08G21VJ3210I280BPassdue00005280528V1JTPMBOARD(SINOSUN)R1.011/200250000503瀚宇博德5.7*3.9,(30),2L,1.2mm11/270453000050未承認:[N]12/040477042700012/110503050300012/180669066900012/250669066900001/010666013200-53401/0802660000-800===============================================================================================================08G21VJ3210Q350BPassdue00002,40002,400V1JTPMBOARD(SINOSUN)R1.012/04000-427001,973百碩5.7*3.9,(30),2L,1.2MM12/11000-503001,470未承認:[N]12/18000-6690080112/25000-6690013201/01000-132000===============================================================================================================FROM:W10600310I2MRP模擬彙總表Ver:06/11/17廠:B報表別:MRPPage:1-------------------------------------------------------------------------------------------------------------------------------------------可用量在製/PR未發採購量發出採購量預計結存PO交期調整調整結存建議WO/PO行動日分群POCANCEL庫別數量HO單採購數量=========-----------------------------========----------=========---------------------------------------------------------4,050000-4,0500-4,0504,050*06/10/1600-10,050000-10,0500-10,0506,000*06/10/2300-14,050000-14,0500-14,0504,000*06/10/3000-17,592000-17,5920-17,5923,542*06/11/0600-21,592000-21,5920-21,5924,000*06/11/1300-25,592000-25,5920-25,5924,000*06/11/2000-29,592000-29,5920-29,5928,00006/11/2700-33,592000-33,5920-33,592006/12/0400-36,592000-36,5920-36,5923,00006/12/1100-38,692000-38,6920-38,6922,10006/12/1800-41,692000-41,6920-41,6923,00006/12/2500-44,692000-44,6920-44,6923,00007/01/0100-47,692000-47,6920-47,6923,00007/01/0800TOTAL47692===========================================================================================================================================3000003000300000PBY003000000000000PBYPEND002,5006,00008,50008,500000PBY590004,00020,00032,500032,500000PBYWAIT0===========================================================================================================================================5280005280528000PBY004805031,200001,70301,703000PBY5948500001,25001,250000PBYPEND000001,20001,200000PBYWAIT000001,20001,20000000001,20001,20000000001,20001,20053400-5340006660666000-800000400040026600TOTAL800?===========================================================================================================================================2,4000002,40002,400000PBY002,4001,9730001,97301,973000PBYWAIT01,4700001,47001,470000801000801080100013200013201320000000000000I2報表（2）I2計算邏輯報表顯示（1）I2計算邏輯報表顯示I2計算邏輯報表顯示（2）I2計算邏輯報表顯示（3）I2計算邏輯報表顯示（4）三、I3reportTIPTOP昌碩科技(上海)有限公司(PROTEK)SH使用者:王廣州+-----------------------------------------------------+06/11/18|條件正確,開始列表<^C>放棄列表,離開作業||*x*,<,<=,>,>=,<>,=,x:y,x|y,?x?,[x-y]*||=====I3MRP模擬彙總表(233)(amrr501)(PB)SH========||1.料號範圍..:[]||來源碼範圍:[]M.C.Code範圍:[4I]||2.廠牌範圍..:[]||3.Sourcer:[]||---------------------------------------------------||4.截止時距日........:[]||.周轉天數計算截止日:[06/12/18]||5.版本........................:[BG]||6.是否依同類替代料排序.........:[Y](Y/N)||7.彙總方式....................:[2](1/2)||(1)依'料號+廠商'||(2)依'料號+廠商+時距日'||8.是否列印金額.................:[Y](Y/N)||9.是否僅列印有PLP/PLM量者.....:[N](Y/N)||10.是否將結果拷貝至公共報表區以便他人查詢.:[N](Y/N)||11.列印庫存量範圍(空白不列印):[?*](?00,?60...)||=======================(204)=======================|||+-----------------------------------------------------+I3報表（1）昌碩科技(上MRPPrintDate:06/11/1813:17:55-----------------------------------------------------------------------------------------------------------------料號L/T廠牌序日期受訂量計劃備料工單備料庫存量在驗量替代量可用量-----------------------------------------------------------------====================================M.C.code:4I王丹丹08G20VL10207028UNKNOWN461811/1304,0500000-4,050A4INVERTERBOARDR2.0461911/2006,0000000-10,050協峰5.383*5.954,(10),2L,1.0MM462011/2703,4880000-13,538簡稱:比率:%462112/0404,0000000-17,538462212/1104,0000000-21,538462312/1804,0000000-25,538462412/2508,0000000-33,538462501/0803,0000000-36,538462601/1502,1000000-38,638462701/2203,0000000-41,638462801/2903,0000000-44,638462902/0503,0000000-47,6380.00Amt：0=================================================================================================================08G20VL1020Q0281300611/200000000A4INVERTERBOARDR2.00.00Amt：0百碩5.383*5.954,(10),2L,1.0M簡稱:華碩比率:%08G20VL1020Q0282701511/060000000A4INVERTERBOARDR2.00.00Amt：0百碩5.383*5.954,(10),2L,1.0M簡稱:百碩比率:%=================================================================================同組替代料累計加總:11/0600000011/2000000008G21VJ3210I0281300611/200000000V1JTPMBOARD(SINOSUN)R1.00.00Amt：0瀚宇博德5.7*3.9,(30),2L,1.2MM簡稱:華碩比率:%08G21VJ3210I02816094463012/2501,7400000-1,740V1JTPMBOARD(SINOSUN)R1.0463101/0802660000-2,006瀚宇博德5.7*3.9,(30),2L,1.2MM0.00Amt：0簡稱:瀚宇博德比率:%=================================================================================同組替代料累計加總:11/2000000012/2501,740000-1,74001/080266000-2,006MRP模擬彙總表Ver:BGPage:1----------------------------------------------------------------------------------------------------------------------------------可用量請購量在採量在外量在製量計劃產交期調整預計結存PLM/PLP備註PR庫別:數量=======---------------------------------------------===========================-----------------------------------4,050000000-4,0504,050*06/11/1600-10,050000000-6,0006,000*06/11/1600-13,538000000-3,4883,488*06/11/1600-17,538000000-4,0004,000*06/11/1600-21,538000000-4,0004,000*06/11/1600-25,538000000-4,0004,000*06/11/2000-33,538000000-8,0008,000*06/11/2700-36,538000000-3,0003,00006/12/1100-38,638000000-2,1002,10006/12/1800-41,638000000-3,0003,00006/12/2500-44,638000000-3,0003,00007/01/0100-47,638000000-3,0003,00007/01/08000Amt：0=======================================================================================02,500000000000PBY003000Amt：00001,0100000000PBY003000Amt：0=======================================================================================0001,010001,01002,50000003,51001,200000000000PBY00480PBY59480Amt：0-1,740000000-1,7401,740*06/11/2700PBY00480-2,006000000-26626606/12/1100PBY59480Amt：0=======================================================================================01,20000001,200-1,74000000-540-2,00600000-806I3報表（2）I3分配比例邏輯（1）i2report中的PLM/PLP量如下：I3分配比例邏輯（2）i2中的PLM/PLP在I3分配后顯示為計劃備料1.I3自動轉單維護資料（1）只有收貨方式為1*VMI時才可以轉BHO*單（2）其餘收貨方式只能轉BPO*單TIPTOP昌碩科技(上海)有限公司(PROTEK)SH使用者:王廣州06/11/18+-----------------------------------------------------------------------------+|A.輸入Q.查詢U.更改Esc.結束||||====================料件出貨方式維護作業(apmi480)===|1652|==================||廠商廠商料件收貨生效失效||代碼簡稱編號方式日期:日期:PullUnit||----------------------------------------------------------|||81|13006|華碩|04G130002000|3|||3||||82|13006|華碩|04G132052400|3|||3||||83|17080|泰格斯|04G140000401|2|||3||||84|13054|安富利|04G231010300|1|||2||||85|50031|一揚|04G231020400|1|||1||||86|07060|光寶科技|04G250064100|2|||3||||87|09059|中達|04G266003163|3|||2||||88|09059|中達|04G266003164|3|||2||||89|09059|中達|04G266003183|3|||2||||90|09059|中達|04G266006000|3|||2|||收貨方式:1.VMI2.DirectShipment3.結轉4.BLP5.Others||Pullunit:1.reel2.box3.carton4.bag||=============================================================================|||+-----------------------------------------------------------------------------2.aiii700按Q后輸入MCcode何MRP版本（1）版本有專人確認（2）建議按照vendor進行轉單作業。（3）根據實際需求調整交期和數量TIPTOP昌碩電腦-備份資料SH使用者:王廣州+--------------------------------------------------------------------------+8|Q.查詢N.下筆P.上筆B.單身G.產生M.版本確認...||||===============I3MRP建議PR維護作業(aiii700)(PB)SH========[1]====||I2版本:[06/11/16]MRP版本:[BG]M.C:[3I][]||資料產生日期/時間:[2006-11-1606:29:50]||------------------------------------------------------[0]/[68]------||NOQVL廠商編號名稱採購料號建議交期Forecast量||最小採購量品名行動日轉PO否/EPO確認量||-------------------------------------------------------------||[N][050031][WPI(HK)][11G015210757][06/12/25][2000.000]||[0][CAPTAN100UF/6.3V(3528/B)20%][06/11/16][P][P][0.000]||[N][050031][WPI(HK)][11G015210757][07/01/08][6000.000]||[0][CAPTAN100UF/6.3V(3528/B)20%][06/11/16][P][P][0.000]||[N][050031][WPI(HK)][11G015210757][07/01/15][8000.000]||[0][CAPTAN100UF/6.3V(3528/B)20%][06/11/20][P][P][0.000]||[N][03008][台灣佐鳥][11G01521075A][06/12/18][2000.000]||[2000][CAPTAN100UF/6.3V(3528)20%][06/11/16][P][P][0.000]||[N][03008][台灣佐鳥][11G01521075A][06/12/25][2000.000]||[2000][CAPTAN100UF/6.3V(3528)20%][06/11/16][P][P][0.000]||===版本確認:[Y]==EPO確認:[N]===============[TIPTOP][06/11/16][W1060031]==|||+--------------------------------------------------------------------------+3.I3自動轉BHO*單（1）按G產生如下界面。（2）先轉BHO*單（3）送貨地址為VMI.（4）選擇適當的建議行動日-------------------------------------------+齷H使用者:王廣州||-------------------------------+8||M.版本確認...||===========================================|||請輸入採購單別(?AH,?HO,?PO):[BHO]|00)(PB)SH========[1]====||請輸入送貨地址:[VMI]|3I][]||行動日期範圍:[06/11/18]--[06/11/25]|||===========================================|-----------[0]/[68]------|||建議交期Forecast量|+-------------------------------------------+行動日轉PO否/EPO確認量||-------------------------------------------------------------||[N][050031][WPI(HK)][11G015210757][06/12/25][2000.000]||[0][CAPTAN100UF/6.3V(3528/B)20%][06/11/16][P][P][0.000]||[N][050031][WPI(HK)][11G015210757][07/01/08][6000.000]||[0][CAPTAN100UF/6.3V(3528/B)20%][06/11/16][P][P][0.000]||[N][050031][WPI(HK)][11G015210757][07/01/15][8000.000]||[0][CAPTAN100UF/6.3V(3528/B)20%][06/11/20][P][P][0.000]||[N][03008][台灣佐鳥][11G01521075A][06/12/18][2000.000]||[2000][CAPTAN100UF/6.3V(3528)20%][06/11/16][P][P][0.000]||[N][03008][台灣佐鳥][11G01521075A][06/12/25][2000.000]||[2000][CAPTAN100UF/6.3V(3528)20%][06/11/16][P][P][0.000]||===版本確認:[Y]==EPO確認:[N]===============[TIPTOP][06/11/16][W1060031]==|||+--------------------------------------------------------------------------+4.非VMI出貨方式轉BPO單，送貨地址位PF1-------------------------------------------+齷H使用者:王廣州||-------------------------------+8||M.版本確認...||===========================================|||請輸入採購單別(?AH,?HO,?PO):[BPO]|00)(PB)SH========[1]====||請輸入送貨地址:[PF1]|3I][]||行動日期範圍:[06/11/18]--[06/12/25]|||===========================================|-----------[0]/[59]------|||建議交期Forecast量|+-------------------------------------------+行動日轉PO否/EPO確認量||-------------------------------------------------------------||[N][050031][WPI(HK)][11G015210757][07/01/22][7283.000]||[0][CAPTAN100UF/6.3V(3528/B)20%][06/11/27][Y][P][0.000]||[N][050031][WPI(HK)][11G015210757][07/01/29][10560.000]||[0][CAPTAN100UF/6.3V(3528/B)20%][06/12/04][Y][P][0.000]||[N][050031][WPI(HK)][11G015210757][07/02/05][9120.000]||[0][CAPTAN100UF/6.3V(3528/B)20%][06/12/11][Y][P][0.000]||[N][050031][WPI(HK)][11G015210757][07/05/07][48.000]||[0][CAPTAN100UF/6.3V(3528/B)20%][07/03/12][P][P][0.000]||[N][03008][台灣佐鳥][11G01521075A][06/12/18][2000.000]||[2000][CAPTAN100UF/6.3V(3528)20%][06/11/17][P][P][0.000]||===版本確認:[Y]==EPO確認:[N]===============[TIPTOP][06/11/18][W1060031]==|||+--------------------------------------------------------------------------+5.轉出結果如下界面TIPTOP昌碩電腦-備份資料SH使用者:鄭媛+--------------------------------------------------------------------------+8|Q.查詢N.下筆P.上筆B.單身G.產生M.版本確認...||||===============I3MRP建議PR維護作業(aiii700)(PB)SH========[1]====||I2版本:[06/11/17]MRP版本:[BH]M.C:[3I][]||資料產生日期/時間:[2006-11-1705:30:11]||------------------------------------------------------[0]/[132]------||NOQVL廠商編號名稱採購料號建議交期Forecast量||最小採購量品名行動日轉PO否/EPO確認量||-------------------------------------------------------------||[N][050031][WPI(HK)][11G015210757][07/01/22][7283.000]||[0][CAPTAN100UF/6.3V(3528/B)20%][06/11/27][P][P][0.000]||[N][050031][WPI(HK)][11G015210757][07/01/29][10560.000]||[0][CAPTAN100UF/6.3V(3528/B)20%][06/12/04][P][P][0.000]||[N][050031][WPI(HK)][11G015210757][07/02/05][9120.000]||[0][CAPTAN100UF/6.3V(3528/B)20%][06/12/11][P][P][0.000]||[N][050031][WPI(HK)][11G015210757][07/05/07][48.000]||[0][CAPTAN100UF/6.3V(3528/B)20%][07/03/12][P][P][0.000]||[N][03008][台灣佐鳥][11G01521075A][06/12/18][2000.000]||[2000][CAPTAN100UF/6.3V(3528)20%][06/11/17][P][P][0.000]||===版本確認:[Y]==EPO確認:[N]===============[TIPTOP][06/11/18][W1060031]==||PRfrom:BPRP6B1120to:BPRP6B1135POfrom:BPOP6B1006to:BPOP6B1021|+--------------------------------------------------------------------------+