Oracle数据仓库解决方案介绍

整理文档很辛苦,赏杯茶钱您下走!

免费阅读已结束,点击下载阅读编辑剩下 ...

阅读已结束,您可以下载文档离线阅读编辑

资源描述

第1页共45页MaterialsManagement(MM)CaseStudy实验报告P183,MM6:CreateNewVendor创建供应商Logistics►MaterialsManagement►Purchasing►MasterData►Vendor►Central►CreateTransCode/交易码:XK01采购的预备动作是集中创建供应商,以便后续的采购和财务结算。下图为记录供应商的公司代码、采购组织、财务组的动作,这些是组织数据。第2页共45页创建供应商地址创建税务号码创建统权科目第3页共45页创建支付条件,设定检查双重发票创建会计职员,负责后续发信函催款第4页共45页创建订单货币及付款条件最终生成供应商的代码0000125009第5页共45页P185,MM7:CreateMaterialMasterforTradingGoods创建物料Logistics►MaterialsManagement►MaterialMaster►Material►Create(Special)►TradingGoodsTransCode/交易码:MMH1创建物料物料主文件有自己的数据结构,包括基础数据、销售组织数据、采购数据等。第6页共45页在物料主文件中的组织数据层设定工厂为迈阿密工厂,销售地在美国东部,分销方式是批发。接下来需要完善数据结构中的各个数据项。第7页共45页第8页共45页第9页共45页第10页共45页第11页共45页最终创建物料主文件。P188,MM8:ExtendMaterialMasterforTradingGoods扩展物料第12页共45页Logistics►MaterialsManagement►MaterialMaster►Material►Create(Special)►TradingGoodsTransCode/交易码:MMH1本案例中增加了工厂SanDiego。第13页共45页P189,MM9:DisplayStock/RequirementsListLogistics►MaterialsManagement►InventoryManagement►Environment►Stock►Stock/RequirementsListTransCode/交易码:MD04截图中可用数量为零,表明虽然建立了库存,但是库存尚未使用。第14页共45页P190,MM10:CreatePurchaseRequisition①创建采购请求Logistics►MaterialsManagement►Purchasing►PurchaseRequisition►CreateTransCode/交易码:ME51N生成采购请求号码第15页共45页P192,MM11:DisplayStock/RequirementsListLogistics►MaterialsManagement►InventoryManagement►Environment►Stock►Stock/RequirementsListTransCode/交易码:MD04P193,MM12:CreateRequestForQuotation②创建报价请求RFQLogistics►MaterialsManagement►Purchasing►RFQ/Quotation第16页共45页►RequestforQuotation►CreateTransCode/交易码:ME41对供应商Mid-WestSupply生成报价请求。第17页共45页对供应商DallasBikeBasics生成报价请求。第18页共45页对供应商SpyGear生成报价请求。第19页共45页P196,MM13:MaintainQuotationsfromVendors③维护报价Logistics►MaterialsManagement►Purchasing►RFQ/Quotation►Quotation►MaintainTransCode/交易码:ME47第20页共45页供应商Mid-WestSupply报价32第21页共45页供应商DallasBikeBasics报价36.5第22页共45页供应商SpyGear报价35第23页共45页P198,MM14:EvaluateQuotationsonPrice选择供应商Logistics►MaterialsManagement►Purchasing►RFQ/Quotation►Quotation►PriceComparison第24页共45页TransCode/交易码:ME49以报价的均值做参考,选取最终有效价格。P199,MM15:RejectQuotationsLogistics►MaterialsManagement►Purchasing►RFQ/Quotation►Quotation►PriceComparisonTransCode/交易码:ME47第25页共45页拒绝36.5的报价拒绝35的报价P201,MM16:CreatePurchaseOrderReferencinganRFQ④创建采购订单POLogistics►MaterialsManagement►Purchasing►PurchaseOrder►Create►Vendor/SupplyingPlantKnownTransCode/交易码:ME21N找到采购请求第26页共45页第27页共45页选择了供应商Mid-WestSupply,并分两批进行采购。第28页共45页生成订单并打印出来。第29页共45页生成采购订单,订单号为4500000006.P205,MM17:DisplayPurchaseOrder⑤跟踪订单Logistics►MaterialsManagement►Purchasing►Purchase第30页共45页Order►DisplayTransCode/交易码:ME23NP206,MM18:CreateGoodsReceiptforPurchaseOrder⑥采购入库GRLogistics►MaterialsManagement►InventoryManagement►GoodsMovement►GoodsReceipt►ForPurchaseOrder►GRforPurchaseOrder(MIGO)TransCode/交易码:MIGO_GR首先入库100份物料。第31页共45页P207,MM19:VerifyPhysicalReceiptofGoodsLogistics►MaterialsManagement►InventoryManagement►Environment►Stock►StockOverviewTransCode/交易码:MMBE第32页共45页P208,MM20:CreateInvoiceReceiptfromVendor⑦发票验证/三单匹配Logistics►MaterialsManagement►LogisticsInvoiceVerification►DocumentEntry►EnterInvoiceTransCode/交易码:MIRO第33页共45页P210,MM21:DisplayPurchaseOrderHistoryLogistics►MaterialsManagement►Purchasing►PurchaseOrder►Display第34页共45页TransCode/交易码:ME23N显示GR第35页共45页发票界面第36页共45页P211,MM22:CreateGoodsReceiptforPurchaseOrderLogistics►MaterialsManagement►InventoryManagement►第37页共45页GoodsMovement►GoodsReceipt►ForPurchaseOrder►GRforPurchaseOrder(MIGO)TransCode/交易码:MIGO_GRP212,MM23:CreateInvoiceReceiptfromVendorLogistics►MaterialsManagement►LogisticsInvoiceVerification►DocumentEntry►EnterInvoice第38页共45页TransCode/交易码:MIRO第39页共45页P213,MM24:PostPaymentstoVendor⑧结算应付帐款Accounting►FinancialAccounting►AccountsPayable►DocumentEntry►OutgoingPayment►PostTransCode/交易码:F-53第40页共45页P215,MM25:DisplayVendorLineItemsAccounting►FinancialAccounting►AccountsPayable►第41页共45页Account►DisplayBalancesTransCode/交易码:FK10NP216,MM26:DisplayPurchaseOrderHistoryLogistics►MaterialsManagement►Purchasing►PurchaseOrder►Display第42页共45页TransCode/交易码:ME23NP217,MM27:Display/ReviewG/LAccountBalancesandIndividualLineItemsAccounting►FinancialAccounting►GeneralLedger►Account►DisplayBalances(New)第43页共45页TransCode/交易码:FAGLB03第44页共45页第45页共45页

1 / 51
下载文档,编辑使用

©2015-2020 m.777doc.com 三七文档.

备案号:鲁ICP备2024069028号-1 客服联系 QQ:2149211541

×
保存成功