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

112

Disclaimer:Thisdocumentinanyform,softwareorprintedmatter,containsproprietaryinformationthatistheexclusivepropertyofOracle.YouraccesstoanduseofthisconfidentialmaterialissubjecttothetermsandconditionsofyourOracleSoftwareLicenseandServiceAgreementorotherapplicablecontractwithOracle,withwhichyouagreetocomply.Thisdocumentandinformationcontainedhereinmaynotbedisclosed,copied,reproducedordistributedtoanyoneoutsideOraclewithoutOracle’spriorwrittenconsent.ThisdocumentisnotpartofyourlicenseagreementnorcanitbeincorporatedintoanycontractualagreementwithOracleoritssubsidiariesoraffiliates.

Thisdocumentisforinformationalpurposesonlyandisintendedsolelytoassistyouinplanningfortheimplementationandupgradeoftheproductfeaturesdescribed.Thisisnotacommitmenttodeliveranymaterial,code,orfunctionality,andshouldnotberelieduponinmakingpurchasingdecisions.Thedevelopment,release,andtimingofanyfeaturesorfunctionalityarealwaysatOracle’ssolediscretion.Thisdocumentisnotconsideredpartoftheapplicableprogramdocumentation.

Duetothenatureoftheproductarchitecture,itmaynotbepossibletosafelyincludeallfeaturesdescribedinthisdocumentwithoutriskingsignificantdestabilizationofthecode.Purpose:ThisdocumentprovidesanoverviewoffeaturesandenhancementsincludedinOracleE-BusinessSuiteRelease12.1.ItisintendedsolelytohelpyouassessthebusinessbenefitsofupgradingyourexistingOracleProductstoRelease12.1,orimplementingcompletelynewOracledevelopedproducts,andplanningyourI.T.Projects.2Disclaimer:Purpose:OracleE-BusinessSuite

Release12.1-ImplementandUse

OracleLandedCostManagement

Presenters:

MuralidharreddyVenkatasesha–ProductManager,Logistics

MarioNobre–ProductManager,LandedCostManagement

AshishPathak–ProductManager,CostManagement

VeereshaJavli–ApplicationsArchitect,CostManagementOracleE-BusinessSuiteReleas4AgendaOracleLandedCostManagementOverviewKeyFeaturesEstimatedLandedCostActualLandedCostFinancialVisibilityDemonstrationImplementationConsiderationsAdditionalResourcesQ&A4AgendaOracleLandedCostMana5<InsertPictureHere>OracleLandedCostManagementOverview5<InsertPictureHere>OracleL6OracleLandedCostManagement

IntroductionOracleLandedCostManagementisanewproductreleasedonE-BusinessSuiteRelease12.1.LandedCostManagementcapturesextendedsupplychaincosts(freight,insurance,duties,taxes,etc.)andattributesthembacktotheproductswhichincurredthem.CostsareestimatedduringreceiptActualcostscalculatedwheninvoicesarrivetoidentifyvariancesEstimatesandanyvariancesautomaticallyupdateinventoryvaluationandaccountingLandedCostManagementreplacescustomizedsolutionstraditionallyprovidedbysystemintegratorsandconsultingengagements.6OracleLandedCostManagement7LCMSimpleExample

InboundShipmentKansasCityUSPortVesselCarrierHKPortShipment

toHKCustomer$100$140ChinaManufacturingBuyerAnadditional40%isaddedontothepurchasepriceoftheitemPO:123ItemACostItemATotalLandedCostIssuePO:123$3Duties$2BrokerFees$5DomesticFreight$2Intnl.Freight$3Intnl.Freight$20Intnl.Freight$5Intnl.Freight7LCMSimpleExample

InboundSh8OracleLandedCostManagementProductMap&InformationFlowPurchasingAdvancedPricingReceivingCostingPayablesEBTaxPOInformation

VATCalculationDutyCharges,Freight,InsuranceEstimatedLandedCostInvoicesEstimatedLandedCostLandedCostManagementChargeMgt.LCCalculatorProductCostDashboardActualVariancesReceipts8OracleLandedCostManagement9<InsertPictureHere>KeyFeatures9<InsertPictureHere>KeyFeat10KeyFeaturesEstimatedLandedCost

CostcalculationbasedonthepredefinedestimatesatthetimeofreceivinggoodsActualLandedcost

LandedcostcalculationafterreceivingtheactualinvoicesinAPFinancialVisibility

Userscanflexiblytrackextendedsupplychainchargesasexpensesorcarrythemforwardasliabilitiesbasedontheirbusinessneeds10KeyFeaturesEstimatedLanded11OracleLandedCostManagement

LCMasaServiceUserActionsAutomatedActionsReceiveGoodsinreceivingReceivingClerkAccrueReceiptsUpdateItemCostCostingCaptureEstimatedChargesfromQPCalculateEstimatedLandedCostLCMIntegratewithCostingRCVIntegratedwith

LCMPayablesClerkEnterInvoicesAccrualReversal/AccountingValidateInvoicesPayablesReviewActual

CalculationProcessLCMClerkLCMCalculateActualLandedCostCost&AccrualAdjustmentCostingInvoicedetailsShipGoodsSupplier/

CarrierCreatePOBuyer11OracleLandedCostManagemen12CaptureEstimatedchargesfromQPCalculateEstimatedLandedCostLCMComplianceClerkEnterLCM

ShipmentsOracleLandedCostManagement

LCMasPre-ReceivingUserActionsAutomatedActionsPayablesClerkEnterInvoicesAccrualReversal/AccountingValidateInvoicesPayablesReviewActual

CalculationProcessLCMClerkLCMCalculateActualLandedCostCost&AccrualAdjustmentCostingInvoicedetailsShipGoodsSupplier/

CarrierCreatePOBuyerReceivingClerkReceiveGoodsinReceivingReceiveGoodsbyLCMshipmentRCVAccrueReceiptsUpdateItemCostCostingInterfaceLCInformationtoreceivingasLCMshipments12CaptureEstimatedchargesfr13<InsertPictureHere>LandedCostCalculationExample–AverageCosting13<InsertPictureHere>Landed14AccrueChargesatReceipt

EventAccountAverageCostingLandedCosting

(LCMEnabledOrganization)DebitCreditDebitCreditReceiptReceivingInspectiona/c$1,000$1,200LandedcostAbsorptiona/cN/AN/A$200APAccruala/c$100$1,000DeliveryReceivingInspectiona/c$1,000$1,200OrganizationMaterialValuationa/c$1,000$1,200AccountingEntriesatReceiving:Invoice 100each@$12ActualLandedCost=$14.00PurchaseOrder100each@$10Receipt100each@$10EstimatedFreight=$100EstimatedInsurance=$100EstimatedLandedCost=$12.0014AccrueChargesatReceipt

Ev15ClearLiabilitiesatInvoicingEventAccountAverageCostingLandedCosting

(LCMEnabledOrganization)DebitCreditDebitCreditItemInvoiceAPAccruala/c$1,000$1,000APLiabilitya/c$1,200$1,200IPV(LCM:InvoicePriceVariance)$200$200AccountingEntriesatInvoicing:Invoice 100each@$12ActualLandedCost=$14.00PurchaseOrder100each@$10Receipt100each@$10EstimatedFreight=$100EstimatedInsurance=$100EstimatedLandedCost=$12.0015ClearLiabilitiesatInvoici16AdjustCostatActualLCCalculationEventAccountAverageCostingLandedCosting

(LCMEnabledOrganization)DebitCreditDebitCreditLandedCostAdjustment:ReceiptReceivingInspectiona/cN/A$200Landedcostabsorptiona/c$200LandedCostAdjustment:DeliveryReceivingInspectiona/cN/A$200Landedcostabsorptiona/c$200AverageCostUpdateLandedcostabsorptiona/cN/A$200OrganizationMaterialValuationa/c$200LandedCostvariancea/c-AccountingEntriesatLandedCostAdjustment:LCCostAdjustmentLCVariance=$200UnitLCVariance=$2.00

On-handBalance=100eachLCVar.AllocatedtoInventory=$200LCVariance=$0Invoice 100each@$12=$1200Freight/Ins=$200(estimate)ActualLandedCost=$14.00 16AdjustCostatActualLCCal17ClearChargeLiabilitiesatInvoicingEventAccountAverageCostingLandedCosting

(LCMEnabledOrganization)DebitCreditDebitCreditFreight+InsuranceInvoiceChargea/c(defaultchargea/cincaseofLCM)$260$260

($155+$105)APLiabilitya/c$260$260

($155+$105)AccountingEntriesatInvoicing:Invoice 100each@$12ActualLandedCost=$14.00PurchaseOrder100each@$10Receipt100each@$10EstimatedFreight=$100EstimatedInsurance=$100EstimatedLandedCost=$12.0017ClearChargeLiabilitiesat18AdjustCostatActualLCCalculationEventAccountAverageCostingLandedCosting

(LCMEnabledOrganization)DebitCreditDebitCreditLandedCostAdjustment:ReceiptReceivingInspectiona/cN/A$60Landedcostabsorptiona/c$60LandedCostAdjustment:DeliveryReceivingInspectiona/cN/A$60Landedcostabsorptiona/c$60AverageCostUpdateLandedcostabsorptiona/cN/A$60OrganizationMaterialValuationa/c$60LandedCostvariancea/c-AccountingEntriesatLandedCostAdjustment:LCCostAdjustmentLCVariance=$60UnitLCVariance=$0.6

On-handBalance=100eachLCVar.AllocatedtoInv=$60LCVariance=$0Invoice 100each@$12=$1,200Freight/Ins=$260ActualLandedCost=$14.60 18AdjustCostatActualLCCal19AccountingReconciliationEventAccountAverageCostingLandedCosting

(LCMEnabledOrganization)DebitCreditDebitCreditReceiptLandedcostabsorptiona/c$200ItemInvoiceIPV(LCM:InvoicePriceVariance)$200Freight+InsuranceInvoiceChargea/c(defaultchargea/cincaseofLCM)$260LandedcostAdjustment:ReceiptLandedcostabsorptiona/c$260LandedcostAdjustment:DeliveryLandedcostabsorptiona/c$260AveragecostUpdateLandedcostabsorptiona/c$260Total:$720$720ReviewingAccountingEntriesfortheLCMAccounts:19AccountingReconciliationEve20ReconciliationatPeriodEndUsetheGLAccountAnalysisSummaryReportforreconciliationofthechargeportionofthelandedcostUsetheAP-POReconciliationreportfortheitemportionofthelandedcost20ReconciliationatPeriodEnd21<InsertPictureHere>Demonstration21<InsertPictureHere>Demonst22<InsertPictureHere>ImplementationConsiderations22<InsertPictureHere>Impleme23ImplementationConsiderations

ImplementationTips&BestPractices

UseQualifierstopreciselydefineestimatedchargesinOracleAdvancedPricingCreateconcurrentsetsforactualcostingconcurrentprogramsandschedulethemathigherfrequencytoachievenearrealtimeactualcostupdatesDefineLCMaccountsasaccrualaccountsforaccuratemeasurementofliability23ImplementationConsideration24ImplementationConsiderations

TroubleshootingTips

EstimatedChargesarenotdefaultedProperly:CheckOracleAdvancedPricingprofilesetupLCMShipmentsnotcreatedproperly:CheckLCMProfilesassuggestedinthesetupPOsarenotappearinginLCM:Checkifapprovalstatus