ORACLE LCM运费成本分摊利器解析课件.ppt

1,2,Disclaimer:This document in any form, software or printed matter, contains proprietary information that is the exclusive property of Oracle. Your access to and use of this confidential material is subject to the terms and conditions of your Oracle Software License and Service Agreement or other applicable contract with Oracle, with which you agree to comply. This document and information contained herein may not be disclosed, copied, reproduced ordistributed to anyone outside Oracle without Oracles prior written consent. This document is not part of your license agreement nor can it be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates. This document is for informational purposes only and is intended solely to assist you in planning for the implementation and upgrade of the product features described. This is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality are always at Oracles sole discretion. This document is not considered part of the applicable program documentation.Due to the nature of the product architecture, it may not be possible to safely include all features described in this document without risking significant destabilization of the code.,Purpose:This document provides an overview of features and enhancements included in Oracle E-Business Suite Release 12.1. It is intended solely to help you assess the business benefits of upgrading your existing Oracle Products to Release 12.1, or implementing completely new Oracle developed products, and planning your I.T. Projects.,Oracle E-Business Suite Release 12.1 - Implement and UseOracle Landed Cost Management Presenters: Muralidharreddy Venkatasesha Product Manager, LogisticsMario Nobre Product Manager, Landed Cost ManagementAshish Pathak Product Manager, Cost ManagementVeeresha Javli Applications Architect, Cost Management,4,Agenda,Oracle Landed Cost Management OverviewKey FeaturesEstimated Landed CostActual Landed CostFinancial VisibilityDemonstrationImplementation ConsiderationsAdditional ResourcesQ&A,5,Oracle Landed Cost Management Overview,6,Oracle Landed Cost ManagementIntroduction,Oracle Landed Cost Management is a new product released on E-Business Suite Release 12.1.Landed Cost Management captures extended supply chain costs (freight, insurance, duties, taxes, etc.) and attributes them back to the products which incurred them.Costs are estimated during receiptActual costs calculated when invoices arrive to identify variancesEstimates and any variances automatically update inventory valuation and accountingLanded Cost Management replaces customized solutions traditionally provided by system integrators and consulting engagements.,7,LCM Simple ExampleInbound Shipment,Kansas City,US Port,Vessel Carrier,HK Port,Shipment to HK,Customer,$100,$140,China Manufacturing,Buyer,An additional 40% is added on to the purchase price of the item,PO: 123Item A Cost,Item ATotal Landed Cost,Issue PO: 123,8,Oracle Landed Cost Management Product Map & Information Flow,Purchasing,Advanced Pricing,Receiving,Costing,Payables,EB Tax,PO Information,VAT CalculationDuty,Charges, Freight, Insurance,EstimatedLanded Cost,Invoices,EstimatedLanded Cost,Landed Cost Management,Charge Mgt.,Actual Variances,Receipts,9,Key Features,10,Key Features,Estimated Landed Cost Cost calculation based on the predefined estimates at the time of receiving goodsActual Landed cost Landed cost calculation after receiving the actual invoices in APFinancial Visibility Users can flexibly track extended supply chain charges as expenses or carry them forward as liabilities based on their business needs,11,Oracle Landed Cost ManagementLCM as a Service,User Actions,Automated Actions,Receive Goods in receiving,Receiving Clerk,Accrue Receipts,Update Item Cost,Costing,Capture Estimated Charges from QP,Calculate Estimated Landed Cost,LCM,Integrate with Costing,RCV,Integrated with LCM,12,Capture Estimated charges from QP,Calculate Estimated Landed Cost,LCM,Compliance Clerk,Enter LCMShipments,Oracle Landed Cost ManagementLCM as Pre-Receiving,User Actions,Automated Actions,Payables Clerk,Enter Invoices,Accrual Reversal / Accounting,Validate Invoices,Payables,Review ActualCalculation Process,LCM Clerk,LCM,Calculate Actual Landed Cost,Cost & Accrual Adjustment,Costing,Invoice details,Receiving Clerk,Receive Goods in Receiving,Receive Goods by LCM shipment,RCV,Accrue Receipts,Update Item Cost,Costing,Interface LC Information to receiving as LCM shipments,13,Landed Cost Calculation Example Average Costing,14,Accrue Charges at Receipt,Accounting Entries at Receiving :,Invoice 100 each $12Actual Landed Cost = $14.00,Purchase Order100 each $10,Receipt100 each $10Estimated Freight = $100Estimated Insurance = $100Estimated Landed Cost = $12.00,15,Clear Liabilities at Invoicing,Accounting Entries at Invoicing:,Invoice 100 each $12Actual Landed Cost = $14.00,Purchase Order100 each $10,Receipt100 each $10Estimated Freight = $100Estimated Insurance = $100Estimated Landed Cost = $12.00,16,Adjust Cost at Actual LC Calculation,Accounting Entries at Landed Cost Adjustment:,Invoice 100 each $12 = $1200Freight/Ins = $200 (estimate)Actual Landed Cost = $14.00,17,Clear Charge Liabilities at Invoicing,Accounting Entries at Invoicing:,Invoice 100 each $12Actual Landed Cost = $14.00,Purchase Order100 each $10,Receipt100 each $10Estimated Freight = $100Estimated Insurance = $100Estimated Landed Cost = $12.00,18,Adjust Cost at Actual LC Calculation,Accounting Entries at Landed Cost Adjustment:,Invoice 100 each $12 = $1,200Freight/Ins = $260Actual Landed Cost = $14.60,19,Accounting Reconciliation,Reviewing Accounting Entries for the LCM Accounts:,20,Reconciliation at Period End,Use the GL Account Analysis Summary Report for reconciliation of the charge portion of the landed costUse the AP-PO Reconciliation report for the item portion of the landed cost,21,Demonstration,22,Implementation Considerations,23,Implementation ConsiderationsImplementation Tips & Best Practices,Use Qualifiers to precisely define estimated charges in Oracle Advanced PricingCreate concurrent sets for actual costing concurrent programs and schedule them at higher frequency to achieve near real time actual cost updatesDefine LCM accounts as accrual accounts for accurate measurement of liability,24,Implementation ConsiderationsTroubleshooting Tips,Estimated Charges are not defaulted Properly: Check Oracle Advanced Pricing profile setup LCM Shipments not created properly: Check LCM Profiles as suggested in the setupPOs are not appearing in LCM: Check if approval status (Approved), matching option (Receiving), and destination (Inventory)Specific item is not appearing in LCM:Check if it is an inventory asset item,25,Additional Resources,26,Oracle Landed Cost ManagementMore Information,Functional Transfer of Ownership PresentationsEBS 12.1.1 Oracle Landed Cost Management OverviewEBS 12.1.1 Oracle Landed Cost Management SetupEBS 12.1.1 Oracle Landed Cost Management Pre-ReceivingOracle Landed Cost Management FAQOracle Landed Cost Management Process Guide (coming soon)Oracle Landed Cost management Accounting whitepaper (Coming soon),27,Additional Resources,For more release information on MetaLinkhttps:/ more information about Oracle Applicationshttp:/ more information about Educationhttp:/ more information about Supporthttp:/ MetaLink informationhttp:/ For Oracle Product documentation:http:/,28,A,Q,&,29,30,