庫存系統(tǒng)及IT行業(yè)管理知識分析課件

OracleInventory講師：莫明鳳2003/11/142003/11/141OracleInventoryOracleInventory講師：莫明鳳2003/11/BeforeInventory

在庫存系統(tǒng)之前ERP到底有什麼樣的流程2003/11/142OracleInventoryBeforeInventory

在庫存系統(tǒng)之前ERP到底OutlineInventoryOverview庫存概觀Inventoryintroduction庫存簡介Inventorycomponents庫存要素Inventorytheory庫存理論OracleInventoryFlowProcess庫存流程InventoryEnterpriseStructure企業(yè)結(jié)構(gòu)Item物料InventoryControl庫存控制MiscellaneousTransaction雜項交易Accuracycontrol正確性控制Planning規(guī)劃2003/11/143OracleInventoryOutlineInventoryOverview庫存概InventoryOverview2003/11/144OracleInventoryInventoryOverview2003/11/144OInventoryOverview庫存概觀Inventoryintroduction庫存簡介Inventorycomponents庫存要素Inventorytheory庫存理論2003/11/145OracleInventoryInventoryOverview庫存概觀InventoInventoryIntroduction庫存簡介主要任務(wù)適時掌握正確的存貨狀況效益提高帳務(wù)處理的作業(yè)效率與正確性掌握正確即時的庫存資訊掌握存貨異動狀況及料件呆滯情形提高盤點(diǎn)作業(yè)的效率2003/11/146OracleInventoryInventoryIntroduction庫存簡介主要任InventoryOverview庫存概觀Inventoryintroduction庫存簡介Inventorycomponents庫存要素Item物料Inventory倉庫Inventorytheory庫存理論2003/11/147OracleInventoryInventoryOverview庫存概觀InventoInventoryComponents–ItemType分類Numberschema編碼原則Engineeringaspect工程面Inventoryaspect庫存面Purchasingaspect採購面2003/11/148OracleInventoryInventoryComponents–ItemTypInventoryComponents-ItemType分類Rawmaterial原物料WIP(workinprocess)在製品Semi-finishedgoods半成品Finishedgoods(enditem)成品MRO(Maintenance,RepairandOperationSupplies)間接物料NumberschemaEngineeringaspectInventoryaspectPurchasingaspect2003/11/149OracleInventoryInventoryComponents-ItemTypInventoryComponents-ItemTypeNumberschema編碼原則PartnumberorItemnumber品號、料號原則：簡單性、單一性、易記性、組織性、充足性EngineeringaspectInventoryaspectPurchasingaspect2003/11/1410OracleInventoryInventoryComponents-ItemTypInventoryComponents-ItemTypeNumberschemaEngineeringaspect工程面Revision版本EC工程變更Drawing圖面InventoryaspectPurchasingaspect2003/11/1411OracleInventoryInventoryComponents-ItemTypInventoryComponents-ItemTypeNumberschemaEngineeringaspectInventoryaspect

庫存面Locator儲位Safetystock安全庫存On-handquantity在手量Purchasingaspect2003/11/1412OracleInventoryInventoryComponents-ItemTypInventoryComponents-ItemTypeNumberschemaEngineeringaspectInventoryaspectPurchasingaspect採購面Lead-time前置時間OrderPolicy:Reorderpoint、EOQ

再訂購點(diǎn)、經(jīng)濟(jì)訂購量Supplier供應(yīng)商2003/11/1413OracleInventoryInventoryComponents-ItemTypInventoryOverviewInventoryintroductionInventorycomponents庫存要素Item物料Inventory倉庫Inventorytheory2003/11/1414OracleInventoryInventoryOverviewInventoryinInventoryComponents-SubinventoryTypes分類按料件分原物料倉半成品倉成品倉按稅制分保稅倉非保稅倉其他報廢倉、客供品倉等2003/11/1415OracleInventoryInventoryComponents-SubinveInventoryOverviewInventoryintroductionInventorycomponentsInventorytheory庫存理論ABCanalysisABC分析Reorderpoint再訂購點(diǎn)EconomicOrderQty,EOQ經(jīng)濟(jì)訂購量Physicalinventory實(shí)體盤點(diǎn)2003/11/1416OracleInventoryInventoryOverviewInventoryinABCAnalysisA類約有10~30%的存貨項目，價值約佔(zhàn)全部庫存價值的70~80%C類約有40~50%的存貨項目，價值約佔(zhàn)全部庫存價值的5~15%B類剩餘的存貨2003/11/1417OracleInventoryABCAnalysisA類2003/11/1417OracABCAnalysisA類處理原則嚴(yán)密管制根據(jù)歷史資料及預(yù)測訂購縮短前置時間、嚴(yán)密控制交期增加循環(huán)盤點(diǎn)次數(shù)、提高庫存精確度放置於容易入出庫位置C類處理原則可採較不嚴(yán)密管制定量訂購方式定期盤點(diǎn)2003/11/1418OracleInventoryABCAnalysisA類處理原則2003/11/1418InventoryOverviewInventoryintroductionInventorycomponentsInventorytheory庫存理論ABCanalysisABC分析Reorderpoint再訂購點(diǎn)EconomicOrderQty,EOQ經(jīng)濟(jì)訂購量Physicalinventory實(shí)體盤點(diǎn)2003/11/1419OracleInventoryInventoryOverviewInventoryinReorderPoint再訂購點(diǎn)QuantityTimeReorderPoint

再訂購點(diǎn)SafetyStock

安全庫存ReorderQuantity

再訂購數(shù)量LeadTime

前置時間2003/11/1420OracleInventoryReorderPoint再訂購點(diǎn)QuantityTimeInventoryOverviewInventoryintroductionInventorycomponentsInventorytheory庫存理論ABCanalysisABC分析Reorderpoint再訂購點(diǎn)EconomicOrderQty,EOQ經(jīng)濟(jì)訂購量Physicalinventory實(shí)體盤點(diǎn) 2003/11/1421OracleInventoryInventoryOverviewInventoryinEOQ經(jīng)濟(jì)訂購量2003/11/1422OracleInventoryEOQ經(jīng)濟(jì)訂購量2003/11/1422OracleInInventoryOverviewInventoryintroductionInventorycomponentsInventorytheory庫存理論ABCanalysisABC分析Reorderpoint再訂購點(diǎn)EconomicOrderQty,EOQ經(jīng)濟(jì)訂購量Physicalinventory實(shí)體盤點(diǎn) 2003/11/1423OracleInventoryInventoryOverviewInventoryinPhysicalInventory實(shí)體盤點(diǎn)制定盤點(diǎn)時程計畫凍結(jié)庫存列印盤點(diǎn)卡、盤點(diǎn)清冊實(shí)際盤點(diǎn)

輸入實(shí)際盤點(diǎn)數(shù)量盤點(diǎn)差異列印盤差盈虧調(diào)整庫存凍結(jié)解除盤點(diǎn)差異對策分析2003/11/1424OracleInventoryPhysicalInventory實(shí)體盤點(diǎn)制定盤點(diǎn)時程計OracleInventoryFlowProcess2003/11/1425OracleInventoryOracleInventoryFlowProcess2OracleERPOverview庫存Inventory出貨作業(yè)PickingShipping總帳系統(tǒng)GL客戶訂單

SO主生產(chǎn)排程MPS粗略產(chǎn)能規(guī)劃RCCP物料需求規(guī)劃MRP請購作業(yè)

PR採購作業(yè)

PO收料作業(yè)

Receiving生產(chǎn)方式DiscreteRepetitiveFlowProjectProcess生產(chǎn)發(fā)料Issue生產(chǎn)控制製程移轉(zhuǎn)MoveTransaction生產(chǎn)入庫CompletionTransaction產(chǎn)能需求規(guī)劃CRP應(yīng)付帳款立帳Invoice付款作業(yè)Payment票據(jù)管理成本管理CostManagement主需求排程MDS固定資產(chǎn)管理

Assets供應(yīng)鍊管理最佳化排程APS銷售預(yù)測FCST統(tǒng)一發(fā)票管理收款作業(yè)Receipts應(yīng)收帳款立帳Invoice2003/11/1426OracleInventoryOracleERPOverview庫存出貨作業(yè)總帳系統(tǒng)InventoryFlowProcessEnterpriseStructureItemsInventoryControlsTransactionABCAnalysisCycleCountingPhysicalInventoryInventoryPlanning2003/11/1427OracleInventoryInventoryFlowProcessEnterpriOracleInventoryFlowProcessInventoryEnterpriseStructure組織架構(gòu)Item物料InventoryControl庫存控制MiscellaneousTransaction雜項交易Accuracycontrol正確性控制Planning規(guī)劃2003/11/1428OracleInventoryOracleInventoryFlowProcessIInventoryEnterpriseStructureOrganizationA

組織AOrganizationB組織BSetofBooks2LocationBLocationASetofBooks1Subinventory

倉庫Subinventory倉庫Subinventory倉庫Subinventory倉庫Locator

儲位Locator

儲位Locator

儲位Locator

儲位Locator

儲位2003/11/1429OracleInventoryInventoryEnterpriseStructure2003/11/1430OracleInventory2003/11/1430OracleInventory2003/11/1431OracleInventory2003/11/1431OracleInventory2003/11/1432OracleInventory2003/11/1432OracleInventory2003/11/1433OracleInventory2003/11/1433OracleInventoryEnterpriseStructure組織架構(gòu).例OrganizationA

JessOrgLocationA

JessLocationSetofBooks1Subinventory

倉庫

Je-RM1Subinventory倉庫

Je-FG1Locator

儲位

R1.1.1..Locator

儲位Locator

儲位2003/11/1434OracleInventoryEnterpriseStructure組織架構(gòu).例OrgOracleInventoryFlowInventoryEnterpriseStructureItemInventoryControlMiscellaneousTransactionAccuracycontrolPlanning2003/11/1435OracleInventoryOracleInventoryFlowInventoryOracleInventoryFlowInventoryEnterpriseStructureItem物料UnitofMeasure,UOM衡量單位DefineItem定義物料InventoryControlMiscellaneousTransactionAccuracycontrolPlanning2003/11/1436OracleInventoryOracleInventoryFlowInventoryUnitofMeasure衡量單位DefineUOMclasses

定義UOM類別DefinemultiplenonbaseUOMsforeachclass

定義此類別中的其他UOMDefineIntraclassConversions

定義類別內(nèi)的轉(zhuǎn)換機(jī)制DefineinterclassConversions

定義類別間的轉(zhuǎn)換機(jī)制DefineonebaseUOMForeachUOMclass

定義此類別中的基本UOMDefineUOMConversion

定義UOM轉(zhuǎn)換機(jī)制DefinestandardConversions

定義標(biāo)準(zhǔn)的轉(zhuǎn)換機(jī)制2003/11/1437OracleInventoryUnitofMeasure衡量單位DefineUOM2003/11/1438OracleInventory2003/11/1438OracleInventoryUnitofMeasure衡量單位.例DefineUOMclasses

QuantityDefinemultiplenonbaseUOMsforeachclass

Dozen,GrossDefineIntraclassConversionsDefineinterclassConversions

1Each=1.5GramDefineonebaseUOMForeachUOMclass

EachDefineUOMConversionDefinestandardConversions

1Dozen=12Each針對特定item2003/11/1439OracleInventoryUnitofMeasure衡量單位.例DefineUOracleInventoryFlowInventoryEnterpriseStructureItem物料UnitofMeasure,UOM衡量單位DefineItem定義物料InventoryControlMiscellaneousTransactionAccuracycontrolPlanning2003/11/1440OracleInventoryOracleInventoryFlowInventoryDefineItemusingtemplateCreateItemTemplate建立物料範(fàn)本

CreateItemfrom

Template&modify從範(fàn)本建立物料並修改

Organization

Assignmentandmodify組織設(shè)定並修改

同種類型的品項可先建立template，以節(jié)省新建item的時間建好item後，可依需要配置給不同的組織使用。

2003/11/1441OracleInventoryDefineItemusingtemplateCrea

2003/11/1442OracleInventory2003/11/1442OracleInventory

2003/11/1443OracleInventory2003/11/1443OracleInventory

2003/11/1444OracleInventory2003/11/1444OracleInventoryOracleInventoryFlowInventoryEnterpriseStructureItemInventoryControl庫存控制Locatorcontrol儲位控制Revisioncontrol版本控制Lotcontrol批量控制Serialnumbercontrol序號控制MiscellaneousTransactionAccuracycontrolPlanning2003/11/1445OracleInventoryOracleInventoryFlowInventoryLocatorControl儲位控制Trackitemsbyrackandbinlocators.Assigndefaultshippinglocatorsforitems.Assigndefaultreceivinglocatorsforitems.Restrictitemstoparticularlocators.Uselocatorsinamaterialtransaction2003/11/1446OracleInventoryLocatorControl儲位控制TrackitemLocatorControl儲位控制SubinventorySubinventoryLocatorOrganizationItemwithlocatorcontrolinthissubinventoryItemwithoutlocatorcontrolinthissubinventory2003/11/1447OracleInventoryLocatorControl儲位控制SubinventoOracleInventoryFlowInventoryEnterpriseStructureItemInventoryControlLocatorcontrol儲位控制Revisioncontrol版本控制Lotcontrol批量控制Serialnumbercontrol序號控制MiscellaneousTransactionAccuracycontrolPlanning2003/11/1448OracleInventoryOracleInventoryFlowInventoryRevisionControl版本控制Trackitemsbyrevisioninformation.Enteramiscellaneousreceiptwithrevisioncontrol.Enteraengineeringchangeorderwithrevisionnumber.RevisionARevisionB2003/11/1449OracleInventoryRevisionControl版本控制TrackiteOracleInventoryFlowInventoryEnterpriseStructureItemInventoryControlLocatorcontrol儲位控制Revisioncontrol版本控制Lotcontrol批量控制Serialnumbercontrol序號控制MiscellaneousTransactionAccuracycontrolPlanning2003/11/1450OracleInventoryOracleInventoryFlowInventoryLotControl批量控制Trackspecificbatchesofitems.Regulatetheuseofperishableitems.Enablelotandshelflifecontrolofitems.Lot#0326982003/11/1451OracleInventoryLotControl批量控制TrackspecificOracleInventoryFlowInventoryEnterpriseStructureItemInventoryControlLocatorcontrol儲位控制Revisioncontrol版本控制Lotcontrol批量控制Serialnumbercontrol序號控制MiscellaneousTransactionAccuracycontrolPlanning2003/11/1452OracleInventoryOracleInventoryFlowInventorySerialNumberControl序號控制Trackindividualunitsofitemsthatyoustoreandtransactinyourorganization.Trackitemsthatyouwanttomaintainverytightcontrol.SN#01015492003/11/1453OracleInventorySerialNumberControl序號控制Trac2003/11/1454OracleInventory2003/11/1454OracleInventory2003/11/1455OracleInventory2003/11/1455OracleInventory2003/11/1456OracleInventory2003/11/1456OracleInventory2003/11/1457OracleInventory2003/11/1457OracleInventoryOracleInventoryFlowInventoryEnterpriseStructureItemInventoryControlMiscellaneousTransaction雜項交易AccuracycontrolPlanning2003/11/1458OracleInventoryOracleInventoryFlowInventory原料倉出貨倉成品倉工程倉InventoryOrganization1庫房調(diào)撥Misc.TransactionsInventoryOrganization2原料倉成品倉採購(供應(yīng)商)檢驗在製品(工單)收料收料入庫工單領(lǐng)料完工入庫雜項收發(fā)跨組織調(diào)撥客戶訂單出貨盤點(diǎn)計畫盤點(diǎn)調(diào)整成本變動成本更新RMA收貨2003/11/1459OracleInventory原料倉出貨倉成品倉工程倉InventoryOrganiza2003/11/1460OracleInventory2003/11/1460OracleInventory2003/11/1461OracleInventory2003/11/1461OracleInventoryOracleInventoryFlowInventoryEnterpriseStructureItemInventoryControlMiscellaneousTransactionAccuracycontrol正確性控制Overview概觀Physicalinventory實(shí)體盤點(diǎn)ABCanalysisABC分析Cyclecounting循環(huán)盤點(diǎn)Planning2003/11/1462OracleInventoryOracleInventoryFlowInventoryOverview概觀Whyneedaccuracycontrol?ReasonsEffectiveplanningMinimizinginventoryinvestmentMethodsPhysicalinventory實(shí)體盤點(diǎn)ABCanalysisABC分析Cyclecounting循環(huán)盤點(diǎn)2003/11/1463OracleInventoryOverview概觀WhyneedaccuracycOracleInventoryFlowInventoryEnterpriseStructureItemInventoryControlMiscellaneousTransactionAccuracycontrol正確性控制Overview概觀Physicalinventory實(shí)體盤點(diǎn)ABCanalysisABC分析Cyclecounting循環(huán)盤點(diǎn)Planning2003/11/1464OracleInventoryOracleInventoryFlowInventoryOraclePhysicalInventoryDefinephysicalinventorySnapshotofon-handquantitiesGeneratetagsCountItemsEntercountsApprovecountsRunadjustmentprogram定義盤點(diǎn)

快照系統(tǒng)數(shù)量產(chǎn)生盤點(diǎn)卡

實(shí)際盤點(diǎn)數(shù)量輸入盤點(diǎn)數(shù)量確認(rèn)盤點(diǎn)數(shù)量盤點(diǎn)差異入帳2003/11/1465OracleInventoryOraclePhysicalInventoryDefiDefinephysicalinventory

Snapshotofon-handquantitiesGeneratetags

CountItemsEntercounts

Approvecounts

Runadjustmentprogram

PhysicalInv.v.sOraclePhysicalInv.制定盤點(diǎn)時程計畫凍結(jié)庫存列印盤點(diǎn)清冊、盤點(diǎn)卡實(shí)際盤點(diǎn)

輸入實(shí)際盤點(diǎn)數(shù)量盤點(diǎn)差異列印盤差盈虧調(diào)整庫存凍結(jié)解除盤點(diǎn)差異對策分析2003/11/1466OracleInventoryDefinephysicalinventorySnapDefinePhysicalInventory&Snapshot

2003/11/1467OracleInventoryDefinePhysicalInventory&SnGenerateTags

2003/11/1468OracleInventoryGenerateTags2003/11/1468OracEnterCounts

2003/11/1469OracleInventoryEnterCounts2003/11/1469OraclApproveCounts

2003/11/1470OracleInventoryApproveCounts2003/11/1470OraRunAdjustmentProgram

2003/11/1471OracleInventoryRunAdjustmentProgram2003/11OracleInventoryFlowInventoryEnterpriseStructureItemInventoryControlMiscellaneousTransactionAccuracycontrolOverview概觀Physicalinventory實(shí)體盤點(diǎn)ABCanalysisABC分析Cyclecounting循環(huán)盤點(diǎn)Planning2003/11/1472OracleInventoryOracleInventoryFlowInventoryABCAnalysisDefineABCcompilationDefineABCclassesDefineABCgroupAssignItemstoABCclassesUpdateclassassignments2003/11/1473OracleInventoryABCAnalysisDefineABCcompilaOracleInventoryFlowInventoryEnterpriseStructureItemInventoryControlMiscellaneousTransactionAccuracycontrolOverview概觀Physicalinventory實(shí)體盤點(diǎn)ABCanalysisABC分析Cyclecounting循環(huán)盤點(diǎn)Planning2003/11/1474OracleInventoryOracleInventoryFlowInventoryCycleCountHigh-ValueItemtoCountLow-ValueItemtoCountHigh-ValueItemtoCountLow-ValueItemtoCountHigh-ValueItemtoCountLow-ValueItemtoCountDay1ofCycleCountDay2ofCycleCountDay3ofCycleCountComputerPrinterComputerMouseComputerPrinter2003/11/1475OracleInventoryCycleCountHigh-ValueItemtoOracleInventoryFlowInventoryEnterpriseStructureItemInventoryControlMiscellaneousTransactionAccuracycontrolPlanning規(guī)劃Reorderpoint、EOQ再訂購點(diǎn)、經(jīng)濟(jì)訂購量2003/11/1476OracleInventoryOracleInventoryFlowInventoryReorderPoint再訂購點(diǎn)QuantityTimeReorderPointSafetyStockLeadTimeReorderQuantity2003/11/1477OracleInventoryReorderPoint再訂購點(diǎn)QuantityTimeEOQ經(jīng)濟(jì)訂購量2003/11/1478OracleInventoryEOQ經(jīng)濟(jì)訂購量2003/11/1478OracleInReorderPointStepsEnteritem-planningattributes.Forecastitemdemand.Definesafetystocks.Runreorder-pointreport.2003/11/1479OracleInventoryReorderPointStepsEnteritem-問題討論2003/11/1480OracleInventory問題討論2003/11/1480OracleInventoOracleInventory講師：莫明鳳2003/11/142003/11/1481OracleInventoryOracleInventory講師：莫明鳳2003/11/BeforeInventory

在庫存系統(tǒng)之前ERP到底有什麼樣的流程2003/11/1482OracleInventoryBeforeInventory

在庫存系統(tǒng)之前ERP到底OutlineInventoryOverview庫存概觀Inventoryintroduction庫存簡介Inventorycomponents庫存要素Inventorytheory庫存理論OracleInventoryFlowProcess庫存流程InventoryEnterpriseStructure企業(yè)結(jié)構(gòu)Item物料InventoryControl庫存控制MiscellaneousTransaction雜項交易Accuracycontrol正確性控制Planning規(guī)劃2003/11/1483OracleInventoryOutlineInventoryOverview庫存概InventoryOverview2003/11/1484OracleInventoryInventoryOverview2003/11/144OInventoryOverview庫存概觀Inventoryintroduction庫存簡介Inventorycomponents庫存要素Inventorytheory庫存理論2003/11/1485OracleInventoryInventoryOverview庫存概觀InventoInventoryIntroduction庫存簡介主要任務(wù)適時掌握正確的存貨狀況效益提高帳務(wù)處理的作業(yè)效率與正確性掌握正確即時的庫存資訊掌握存貨異動狀況及料件呆滯情形提高盤點(diǎn)作業(yè)的效率2003/11/1486OracleInventoryInventoryIntroduction庫存簡介主要任InventoryOverview庫存概觀Inventoryintroduction庫存簡介Inventorycomponents庫存要素Item物料Inventory倉庫Inventorytheory庫存理論2003/11/1487OracleInventoryInventoryOverview庫存概觀InventoInventoryComponents–ItemType分類Numberschema編碼原則Engineeringaspect工程面Inventoryaspect庫存面Purchasingaspect採購面2003/11/1488OracleInventoryInventoryComponents–ItemTypInventoryComponents-ItemType分類Rawmaterial原物料WIP(workinprocess)在製品Semi-finishedgoods半成品Finishedgoods(enditem)成品MRO(Maintenance,RepairandOperationSupplies)間接物料NumberschemaEngineeringaspectInventoryaspectPurchasingaspect2003/11/1489OracleInventoryInventoryComponents-ItemTypInventoryComponents-ItemTypeNumberschema編碼原則PartnumberorItemnumber品號、料號原則：簡單性、單一性、易記性、組織性、充足性EngineeringaspectInventoryaspectPurchasingaspect2003/11/1490OracleInventoryInventoryComponents-ItemTypInventoryComponents-ItemTypeNumberschemaEngineeringaspect工程面Revision版本EC工程變更Drawing圖面InventoryaspectPurchasingaspect2003/11/1491OracleInventoryInventoryComponents-ItemTypInventoryComponents-ItemTypeNumberschemaEngineeringaspectInventoryaspect

庫存面Locator儲位Safetystock安全庫存On-handquantity在手量Purchasingaspect2003/11/1492OracleInventoryInventoryComponents-ItemTypInventoryComponents-ItemTypeNumberschemaEngineeringaspectInventoryaspectPurchasingaspect採購面Lead-time前置時間OrderPolicy:Reorderpoint、EOQ

再訂購點(diǎn)、經(jīng)濟(jì)訂購量Supplier供應(yīng)商2003/11/1493OracleInventoryInventoryComponents-ItemTypInventoryOverviewInventoryintroductionInventorycomponents庫存要素Item物料Inventory倉庫Inventorytheory2003/11/1494OracleInventoryInventoryOverviewInventoryinInventoryComponents-SubinventoryTypes分類按料件分原物料倉半成品倉成品倉按稅制分保稅倉非保稅倉其他報廢倉、客供品倉等2003/11/1495OracleInventoryInventoryComponents-SubinveInventoryOverviewInventoryintroductionInventorycomponentsInventorytheory庫存理論ABCanalysisABC分析Reorderpoint再訂購點(diǎn)EconomicOrderQty,EOQ經(jīng)濟(jì)訂購量Physicalinventory實(shí)體盤點(diǎn)2003/11/1496OracleInventoryInventoryOverviewInventoryinABCAnalysisA類約有10~30%的存貨項目，價值約佔(zhàn)全部庫存價值的70~80%C類約有40~50%的存貨項目，價值約佔(zhàn)全部庫存價值的5~15%B類剩餘的存貨2003/11/1497OracleInventoryABCAnalysisA類2003/11/1417OracABCAnalysisA類處理原則嚴(yán)密管制根據(jù)歷史資料及預(yù)測訂購縮短前置時間、嚴(yán)密控制交期增加循環(huán)盤點(diǎn)次數(shù)、提高庫存精確度放置於容易入出庫位置C類處理原則可採較不嚴(yán)密管制定量訂購方式定期盤點(diǎn)2003/11/1498OracleInventoryABCAnalysisA類處理原則2003/11/1418InventoryOverviewInventoryintroductionInventorycomponentsInventorytheory庫存理論ABCanalysisABC分析Reorderpoint再訂購點(diǎn)EconomicOrderQty,EOQ經(jīng)濟(jì)訂購量Physicalinventory實(shí)體盤點(diǎn)2003/11/1499OracleInventoryInventoryOverviewInventoryinReorderPoint再訂購點(diǎn)QuantityTimeReorderPoint

再訂購點(diǎn)SafetyStock

安全庫存ReorderQuantity

再訂購數(shù)量LeadTime

前置時間2003/11/14100OracleInventoryReorderPoint再訂購點(diǎn)QuantityTimeInventoryOverviewInventoryintroductionInventorycomponentsInventorytheory庫存理論ABCanalysisABC分析Reorderpoint再訂購點(diǎn)EconomicOrderQty,EOQ經(jīng)濟(jì)訂購量Physicalinventory實(shí)體盤點(diǎn) 2003/11/14101OracleInventoryInventoryOverviewInventoryinEOQ經(jīng)濟(jì)訂購量2003/11/14102OracleInventoryEOQ經(jīng)濟(jì)訂購量2003/11/1422OracleInInventoryOverviewInventoryintroductionInventorycomponentsInventorytheory庫存理論ABCanalysisABC分析Reorderpoint再訂購點(diǎn)EconomicOrderQty,EOQ經(jīng)濟(jì)訂購量Physicalinventory實(shí)體盤點(diǎn) 2003/11/14103OracleInventoryInventoryOverviewInventoryinPhysicalInventory實(shí)體盤點(diǎn)制定盤點(diǎn)時程計畫凍結(jié)庫存列印盤點(diǎn)卡、盤點(diǎn)清冊實(shí)際盤點(diǎn)

輸入實(shí)際盤點(diǎn)數(shù)量盤點(diǎn)差異列印盤差盈虧調(diào)整庫存凍結(jié)解除盤點(diǎn)差異對策分析2003/11/14104OracleInventoryPhysicalInventory實(shí)體盤點(diǎn)制定盤點(diǎn)時程計OracleInventoryFlowProcess2003/11/14105OracleInventoryOracleInventoryFlowProcess2OracleERPOverview庫存Inventory出貨作業(yè)PickingShipping總帳系統(tǒng)GL客戶訂單

SO主生產(chǎn)排程MPS粗略產(chǎn)能規(guī)劃RCCP物料需求規(guī)劃MRP請購作業(yè)

PR採購作業(yè)

PO收料作業(yè)

Receiving生產(chǎn)方式DiscreteRepetitiveFlowProjectProcess生產(chǎn)發(fā)料Issue生產(chǎn)控制製程移轉(zhuǎn)MoveTransaction生產(chǎn)入庫CompletionTransaction產(chǎn)能需求規(guī)劃CRP應(yīng)付帳款立帳Invoice付款作業(yè)Payment票據(jù)管理成本管理CostManagement主需求排程MDS固定資產(chǎn)管理

Assets供應(yīng)鍊管理最佳化排程APS銷售預(yù)測FCST統(tǒng)一發(fā)票管理收款作業(yè)Receipts應(yīng)收帳款立帳Invoice2003/11/14106OracleInventoryOracleERPOverview庫存出貨作業(yè)總帳系統(tǒng)InventoryFlowProcessEnterpriseStructureItemsInventoryControlsTransactionABCAnalysisCycleCountingPhysicalInventoryInventoryPlanning2003/11/14107OracleInventoryInventoryFlowProcessEnterpriOracleInventoryFlowProcessInventoryEnterpriseStructure組織架構(gòu)Item物料InventoryControl庫存控制MiscellaneousTransaction雜項交易Accuracycontrol正確性控制Planning規(guī)劃2003/11/14108OracleInventoryOracleInventoryFlowProcessIInventoryEnterpriseStructureOrganizationA

組織AOrganizationB組織BSetofBooks2LocationBLocationASetofBooks1Subinventory

倉庫Subinventory倉庫Subinventory倉庫Subinventory倉庫Locator

儲位Locator

儲位Locator

儲位Locator

儲位Locator

儲位2003/11/14109OracleInventoryInventoryEnterpriseStructure2003/11/14110OracleInventory2003/11/1430OracleInventory2003/11/14111OracleInventory2003/11/1431OracleInventory2003/11/14112OracleInventory2003/11/1432OracleInventory2003/11/14113OracleInventory2003/11/1433OracleInventoryEnterpriseStructure組織架構(gòu).例OrganizationA

JessOrgLocationA

JessLocationSetofBooks1Subinventory

倉庫

Je-RM1Subinventory倉庫

Je-FG1Locator

儲位

R1.1.1..Locator

儲位Locator

儲位2003/11/14114OracleInventoryEnterpriseStructure組織架構(gòu).例OrgOracleInventoryFlowInventoryEnterpriseStructureItemInventoryControlMiscellaneousTransactionAccuracycontrolPlanning2003/11/14115OracleInventoryOracleInventoryFlowInventoryOracleInventoryFlowInventoryEnterpriseStructureItem物料UnitofMeasure,UOM衡量單位DefineItem定義物料InventoryControlMiscellaneousTransactionAccuracycontrolPlanning2003/11/14116OracleInventoryOracleInventoryFlowInventoryUnitofMeasure衡量單位DefineUOMclasses

定義UOM類別DefinemultiplenonbaseUOMsforeachclass

定義此類別中的其他UOMDefineIntraclassConversions

定義類別內(nèi)的轉(zhuǎn)換機(jī)制DefineinterclassConversions

定義類別間的轉(zhuǎn)換機(jī)制DefineonebaseUOMForeachUOMclass

定義此類別中的基本UOMDefineUOMConversion

定義UOM轉(zhuǎn)換機(jī)制DefinestandardConversions

定義標(biāo)準(zhǔn)的轉(zhuǎn)換機(jī)制2003/11/14117OracleInventoryUnitofMeasure衡量單位DefineUOM2003/11/14118OracleInventory2003/11/1438OracleInventoryUnitofMeasure衡量單位.例DefineUOMclasses

QuantityDefinemultiplenonbaseUOMsforeachclass

Dozen,GrossDefineIntraclassConversionsDefineinterclassConversions

1Each=1.5GramDefineonebaseUOMForeachUOMclass

EachDefineUOMConversionDefinestandardConversions

1Dozen=12Each針對特定item2003/11/14119OracleInventoryUnitofMeasure衡量單位.例DefineUOracleInventoryFlowInventoryEnterpriseStructureItem物料UnitofMeasure,UOM衡量單位DefineItem定義物料InventoryControlMiscellaneousTransactionAccuracycontrolPlanning2003/11/14120OracleInventoryOracleInventoryFlowInventoryDefineItemusingtemplateCreateItemTemplate建立物料範(fàn)本

CreateItemfrom

Template&modify從範(fàn)本建立物料並修改

Organization

Assignmentandmodify組織設(shè)定並修改

同種類型的品項可先建立template，以節(jié)省新建item的時間建好item後，可依需要配置給不同的組織使用。

2003/11/14121OracleInventoryDefineItemusingtemplateCrea

2003/11/14122OracleInventory2003/11/1442OracleInventory

2003/11/14123OracleInventory2003/11/1443OracleInventory

2003/11/14124OracleInventory2003/11/1444OracleInventoryOracleInventoryFlowInventoryEnterpriseStructureItemInventoryControl庫存控制Locatorcontrol儲位控制Revisioncontrol版本控制Lotcontrol批量控制Serialnumbercontrol序號控制MiscellaneousTransactionAccuracycontrolPlanning2003/11/14125OracleInventoryOracleInventoryFlowInventoryLocatorControl儲位控制Trackitemsbyrackandbinlocators.Assigndefaultshippinglocatorsforitems.Assigndefaultreceivinglocatorsforitems.Restrictitemstoparticularlocators.Uselocatorsinamaterialtransaction2003/11/14126OracleInventoryLocatorControl儲位控制TrackitemLocatorControl儲位控制SubinventorySubinventoryLocatorOrganizationItemwithlocatorcontrolinthissubinventoryItemwithoutlocatorcontrolinthissubinventory2003/11/14127OracleInventoryLocatorControl儲位控制SubinventoOracleInventoryFlowInventoryEnterpriseStructureItemInventoryControlLocatorcontrol儲位控制Revisioncontrol版本控制Lotcontrol批量控制Serialnumbercontrol序號控制MiscellaneousTransactionAccuracycontrolPlanning2003/11/14128OracleInventoryOracleInventoryFlowInventoryRevisionControl版本控制Trackitemsbyrevisioninformation.Enteramiscellaneousreceiptwithrevisioncontrol.Enteraengineeringchangeorderwithrevisionnumber.RevisionARevisionB2003/11/14129OracleInventoryRevisionControl版本控制TrackiteOracleInventoryFlowInventoryEnterpriseStructureItemInventoryControlLocatorcontrol儲位控制Revisioncontrol版本控制Lotcontrol批量控制Serialnumbercontrol序號控制MiscellaneousTransactionAccuracycontrolPlanning2003/11/14130OracleInventoryOracleInventoryFlowInventoryLotControl批量控制Trackspecificbatchesofitems.Regulatetheuseofperishableitems.Enablelotandshelflifecontrolofitems.Lot#0326982003/11/14131OracleInventoryLotControl批量控制TrackspecificOracleInventoryFlowInventoryEnterpriseStructureItemInventoryControlLocatorcontrol儲位控制Revisioncontrol版本控制Lotcontrol批量控制Serialnumbercontrol序號控制MiscellaneousTransactionAccuracycontrolPlanning2003/11/14132OracleInventoryOracleInventoryFlowInventorySerialNumberControl序號控制Trackindividualunitsofitemsthatyoustoreandtransactinyourorganization.Trackitemsthatyouwanttomaintainverytightcontrol.SN#01015492003/11/14133OracleInventorySerialNumberControl序號控制Trac2003/11/14134OracleInventory2003/11/1454OracleInventory2003/11/14135OracleInventory2003/11/1455OracleInventory2003/11/14136OracleInventory2003/11/1456OracleInventory2003/11/14137OracleInventory2003/11/1457OracleInventoryOracleInventoryFlowInventoryEnterpriseStructureItemInventoryControlMiscellaneousTransaction雜項交易AccuracycontrolPlanning2003/11/14138OracleInventoryOracleInventoryFlowInventory原料倉出貨倉成品倉工程倉InventoryOrganization1庫房調(diào)撥Misc.TransactionsInventoryOrganization2原料倉成品倉採購(供應(yīng)商)檢驗在製品(工單)收料收料入庫工單領(lǐng)料完工入庫雜項收發(fā)跨組織調(diào)撥客戶訂單出貨盤點(diǎn)計畫盤點(diǎn)調(diào)整成本變動成本更新RMA收貨2003/11/14139OracleInventory原料倉出貨倉成品倉工程倉InventoryOrganiza2003/11/14140OracleInventory2003/11/1460OracleInventory2003/11/14141OracleInventory2003/11/1461OracleInventoryOracleInventoryFlowInventoryEnterpriseStructureItemInventoryControlMiscellaneousTransactionAccuracycontrol正確性控制Overview概觀Physicalinventory實(shí)體盤點(diǎn)ABCanalysisABC分析Cyclecounting循環(huán)盤點(diǎn)Planning2003/11/14142OracleInventoryOracleInventoryFlowInventoryOverview概觀Whyneedaccuracycontrol?ReasonsEffectiveplanningMinimizinginventoryinvestmentMethodsPhysicalinventory實(shí)體盤點(diǎn)ABCanalysisABC分析Cyclecounting循環(huán)盤點(diǎn)2003/11/14143OracleInventoryOverview概觀WhyneedaccuracycOracleInventoryFlowInventoryEnterpriseStructure