SAP庫存評估和減值準(zhǔn)備手冊

H:\精品資料\建筑精品網(wǎng)原稿ok（刪除公文）\建筑精品網(wǎng)5未上傳百度InventoryValuationInventoryValuationInaccordancewiththeAccountingStandard FORCNTABLEOFCONTENTS1. Introduction 32. InventoryValuationBusinessProcessDefinition(BPD) 43. InventoryValuationBusinessScenarioFlow(BSF) 44. PreliminaryworkbytheEndUser 54.1ResettheexistingvaluesinitialProcessExplanation(PE) 54.2 ResettheexistingvalueinitialTransactionalOperation(TO) 54.3 MASSResetofdevaluationindicator(TO) 84.4 Verificationofmaterialmaster 115. Step1:MarketpriceanalysisProcessExplanation(PE) 145.1 MarketpriceanalysisTransactionalOperation(TO) 145.2 Validatingthenewprices 215.2.1Checkingthecomparisonprice 225.2.2Checkingthelastgoodsreceiptprice 225.3Databaseupdate 245.4Verificationofmaterialmaster 256. Step2:Inventorycosting 266.1 InventoryCostingProcessExplanation(PE) 266.2 InventoryCostingTransactionalOperation(TO) 266.3 Verificationofmaterialmaster 337. Step3:LowestvaluedeterminationbasedonLoss-freevaluation 347.1 Lowestvaluedeterminationbasedonlossfreevaluation(PE) 347.2 Lowestvaluedeterminationlossfreevaluation(TO) 347.3 Verificationofmaterialmaster 398. Step4:Lowestvaluedeterminationbasedonmovementrate 408.1 Lowestvaluedeterminationbasedonmovementrate(PE) 408.1.1 Marketabilitydiscounts 418.2 Lowestvaluedeterminationbasedonmovementrate(TO) 428.2.1 Finished/UnfinishedgoodsrelatedtoTaxprice2 438.2.2 RawmaterialsandsuppliesrelatedtoCommercialprice2 619. Evaluation 779.1 Evaluation(PE) 779.2 MRN9–Analysisofdevaluation(TO) 7710. Step5:CalculateSlowmovingstockitems 8111. Appendix1:Functionalspecification 8211.1 Configuration 8211.2 EnhancementofMRN3 8211.3 User-ExitofMRN2 8211.4 ProgramofZAMM002report 83IntroductionAninventoryvaluationisaprocessofassigningafinanicalvaluetoon-handinventory,basedonseveraldifferentmethods.Originallythevalueoftheinventoryequalsthecostofthematerials.Howeverundercertaincircumstancestheinventoryvalueshavetobedevaluated.Theinventoryvaluationisanimportantpartofthecostofgoodssoldintheincomestatementaswellofthecompany’scurrentassetsinthebalancesheet.Thisdocumentationprovidesyouwithadetailedprocessdescription,astepbystepguidancethroughtheSAPprocessesaswellwithallnecessarybackgroundinformation.TogetaccesstothefunctionalityyoushouldselectthefollowingpathintheSAPEasyAccessMenu:LogisticsMaterialManagementValuationBalanceSheetValuationInventoryValuationBusinessProcessDefinition(BPD)TheInventoryvaluationprocesscontainsfivesubsequentstepswhichmustbeexecutedinchronologicalorder.Eachstepisbasedonthevaluescalculatedintheprevioussteps.Jumping,missingorhavingerrorsineachstepwillleadtoafalseresultinthefollowingstep.Thereforeallstepsneedtobeexecutedwithhighattention.InventoryValuationBusinessScenarioFlow(BSF)Step1Marketpriceanalysis(T-Code:MRN0)Comparebetweenthemovingaveragepriceandthelastgoodsreceiptprice.ThelowestwillbeupdatedintoCommercialPrice.UpdatesonlypurchasepartsCommercialprice2Step2Inventorycosting(T-Code:CK40N)TakeCommercialprice2plusthecurrentBOMandroutingsintoaccount.UpdateonlySemifinishedandfinishedgoods.Commercialprice3Step3Loss-freevaluation(T-Code:MRN3)ComparetheCommercialPrice3withthelastSDinvoice.ThelowestwillbeupdatedintoTaxprice2Taxprice2Step4Lowestvalueprinciplebasedonmovementrate(T-Code:MRN2,MRN9)LowestvalueprinciplebasedonmovementrateTaxprice3&DevaluationIndicatorStep5CalculateSlowmovingstockitems(T-Code:ZAMM002)Executeprogram:SlowmovingdevaluationreportPreliminaryworkbytheEndUser4.1ResettheexistingvaluesinitialProcessExplanation(PE)Atthebeginningoftheprocessitismandatorytoresetthedevaluationindicatorsaswellasthecommercialprice2+3andtaxprice2+3to0(zero).TheresettingofthosevaluescanbeonlydonebytheEndUserFI/Accountingdepartment.ResettheexistingvalueinitialTransactionalOperation(TO)TransactionMRN0–ResetoftaxpriceandcommercialpriceinmaterialmasterThecommercialprices2+3andtaxprices2+3arestillsavedinthematerialmasterfromtheformeryearwhentheinventoryvaluationwasprocessedWiththefollowingsteps,thesepricesaregoingtobedeletedTheEndUserhastorequestthisresettotheEndUserFI/AccountingTheresetprocedurewillthenbecarriedoutbytheEndUserFI/AccountingUsevariant:2290_MRN0andadjustthecompanycodeandplantKeyDate:.11.30RunitforallmaterialtypeEnteryourCompanyCodeandKeyDateNeverupdatethematerialpriceinthematerialmasterLeavethesettingsasshowninthescreenshotforresettingTaxprice2/3andCommercialprice2/3PressclickcheckboxforresettingTaxprice2/3andCommercialprice2/3tozerointhematerialmasterThedownloadoftheprintinglistisnotusefulforanalyzingthepricesthathavebeenreset(informationnotavailable)LeavethetransactionbythegreenarrowMASSResetofdevaluationindicator(TO)Whentheinventoryvaluationwasprocessedfromthepreviousyear,thedevaluationindicatorisstillsavedinthematerialmasterTransactionMASS,theDevaluationindicatorcanbedeletedwiththefollowingstepsTheEndUserhastorequestthisresetattheEndUserFIorAccountingResetprocedurehastobedonebySAP-FIorAccountingEndUserSelecttheObjectTypeandValuationnameselectdisplayallrecordsSelectthedevaluationindicatortorunthemassupdateMarkthecolumnforoverwritingthedevaluationindicatorwith0Whenalllineshavethedevaluationindicator0,thedatacanbesavedVerificationofmaterialmasterAftereachstepamaterialmasterverificationisrecommendedinordertocheckthevaluescalculatedinthepreviousstep.ThereforeanewSAPmaterialmasterquerywasdeveloped.Transaction:ZAMM001DownloadthematerialmasterforyourcompanycodeandplantCheckiftheCommercialPrice2+3andtheTaxPrice2+3arezeroCheckifdevaluationindicatoriszeroStep1:MarketpriceanalysisProcessExplanation(PE)ThefirststepoftheInventoryvaluationisthemarketpriceanalysis.Withthemarketpricesanalysisthelowestpriceforallraw,auxiliaryandoperatingmaterialcanbedetermined.Itcomparesthestandardpriceormovingaverageprice(dependingonthepricecontrol)tothelastgoodsreceiptpriceinagiventimeperiod.Basedonthelowestvaluecomparisonthelowerpriceofthestandardpriceormovingaveragepricevs.lastgoodsreceiptpriceisupdatedintocommercialprice2inthematerialmaster.MarketpriceanalysisTransactionalOperation(TO)TransactionMRN0–DeterminationoflowestpriceoftheRawmaterialandsuppliesProcessthepricecomparisontodeterminethelowestpriceforrawmaterialsandsuppliesUsevariant:2290_MRN0_1”FineRMMarketPrice”andsaveyourownvariantHint:youcanrunthistransactionforallkindofmaterials(materialtypeintotal),butonlypurchasedpartswillbecompared.Unfinishedandfinishedgoodswillbeupdated,becausenoreceiptpriceisavailableRecommendation:SplittheprogramrunintovariousgroupsofmaterialtypeduetohighnumberofmaterialsSystemstepsinbackground:SelectionofthelastGR/IRinvoiceofwithinthechosentimeintervalSelectionofthecurrentmaterialpricefromthematerialmasterascomparisonprice(原材料選定時(shí)間的最低的GR/IR價(jià)格v.s物料價(jià)格)Comparisonofbothpricesandupdatingthecommercialprice2fieldinthematerialmasterwiththelowestofbothprices(相對低的價(jià)格更新到”commercialprice2”)EnterthecompanycodeandEnterthekeydatewhichrepresentstheendofafiscalyearorapostingperiodIf2ormoreplantsareassignedtoacompanycode,andtheplantshaveasamematerialbutwithdifferentprice.Andifyouwanttoupdatethemarketpricebyplantpleasemakethesettingasfollows.afiscalperiodStep1:ReceiptpriceareallgoodsreceiptsandinvoiceswhicharetakenintoconsiderationintheselectedpostingperiodAnalyzedpricesonly1receiptpricewillbetakenintoconsideration(noaveragecalculationwithmorethan1price)StrategyB:Ifmorethan1receiptpriceisdetermined,thelastonewillbetakenintoconsiderationExchangerateA:istakenfromtheposteddocumentMeaningofpercentages:Thequantityinvoicedmustnotbe.……. ofthequantitydelivered.lessthan 100% invoicedquantitymustbethesameasdeliveredquantity75% atleast75%mustbeinvoiced0.01% nofreeofchargeinvoiceshallbeincludedmorethan120% invoicedquantitycanbeatmax.20%morethandeliveredquantity100% invoicedquantitycanbeatmax.thesameasthedeliveredquantityExample:100%-100% areonlythosematchingGR/IR’sthatarechosenforthemarketpricedetermination,wherethedeliveredandinvoicedquantityarethesame0.01%-100% aminimumofthedeliveredquantitymustbeinvoicedbutmaximumthesamequantityasdeliveredAttention: Onlyifthesecriteriaarefulfilled,thelowerpriceofthematchingGRandIRistakenasmarketpriceforthecomparisonCommentSAPF1-HelpStep2:LowestVal.Comparison:Theprogramcomparesthemarketpriceandthecomparisonprice(currentmaterialprice)andsetthelowestofbothLowestofValuationAreaPrices:Ifmorethan1plant(valuationarea)isassignedtoacompanycodeandtherearedifferentpricescalculated–thelowestonewillbesetforthecompanycodeCurrentMaterialprice:StandardpriceformaterialswithpricecontrolkeySMovingaveragepriceformaterialswithpricecontrolkeyVStep3:RemainthesettingsasshownaboveforupdatingCommercialprice2YoucanchangethesettingsfortheoutputlistifdifferentinformationarerequestedIfyouwanttocheckthepricesinadvance–Remainthe”DatabaseUpdate”openPressclickcheckboxforupdatingCommercialprice2inthematerialmasterThedownloadofthelistshowsyouthematerialdocument,whichleadsyoutotheinvoicewherethemarketpricewastakenfromHint:ifnoinvoicewasfoundinthechosenperiod–thecurrentpriceiscopiedintoCommercialprice2ValidatingthenewpricesAdetailedlistwithcompanycode,materialnumber,comparisonprice,newpricechangein%,date,sourceandreferencewillbegenerated.Thesevalueshavetobeverified.Onlyafterallmaterialswithanewpriceareverifiedandthenewpriceisconfirmedandupdaterunshouldbecarriedout.5.2.1CheckingthecomparisonpriceThecomparisonpricemustalwaysbethemovingaveragepriceofthematerial.Inthematerialmasterrecord(MM03)underthetapaccountingview1youcanfindthecurrentmaterialpriceofthepart.5.2.2CheckingthelastgoodsreceiptpriceThedetailedlistfromTransactionMRN0showsyouthepurchasedocumentnumberfromwhichSAPtookthenewprice.Youcanverifythispriceinthefollowingway:TransactionMB03Enterthepurchasingdocumentnumber&yearfromyourdownloadedexcelfile.TakethePOnumberfromthedisplayeddocumentTransactionME23NClickonpurchaseorderhistory5.3VerificationofmaterialmasterZAMM001DownloadthematerialmasterforyourplantintoExcelCheckifCommercialPrice2wasupdatedforallmaterialsAnalyzethosematerialsthathavestockbutnocommercialprice2Step2:InventorycostingInventoryCostingProcessExplanation(PE)Instep1oftheinventoryvaluationallpurchasedpartswereupdatedwithanewcommercialprice2basedonthelowestvaluecomparison.Thiscommercialprice1isnowthenewbasesforthecalculationoftheinventoryvaluationforsemi-finishedandfinishedgoods.TheinventorycostingwilltakethecurrentBOMs,routingsandactivityratesplusthecommercialprice2andcalculatethenewvalueforallownproductparts(Materialtype:ZHIB,ZPRD)ThiscalculatedpricewillthenbeupdatedintotheCommercialPrice3inthematerialmasterdataInventoryCostingTransactionalOperation(TO)Fortheinventorycostinghasaowncostingvariant,theCN:C007,KR:K004calculation.TheCostingrunafterthecostingistheupdateofthecommercialprice3Step1:Createacostingrun(CostingVariant:CN:C007,KR:K004)TransactionCK40NacostingrunisperformedwiththecostingvariantCN:C007,KR:K004RuntheinventorycostingwithcostingvariantCN:C007,KR:K004foryourcompanycodeThiscostingvariantCN:C007,KR:K004isbasedupontheCommercialprice2forrawmaterials,whichwassavedinStep1MRN0(seepreviouschapter)Allunfinished/finishedgoods(Materialtype:ZHIB,ZPRD)aregoingtobeupdatedinCommercialprice3Recommendation:Selectonlymaterialswithstock.YoucanusethematerialmasterqueryZAMM001Selectthedataforinventoryvaluation(30.11.20xx)ExecutethesinglestepsforyoucompanycodewithmaterialtypesZHIBandZPRDAnalyzetheerror/warningmessagesandeliminatethemifpossible–runthecostingrunagainifnecessaryorcreatesinglecostingpermaterial(TA:CK11N)Theprocessingstepsareplannedatthisstage.Clickontheparametersandselecttherelevantdata.Enterthematerialnumbersandtypeofmaterialandsavetheentries.CN:Input.FordetaileddescriptionrefertotheCostingRunDocumentation.Whenthecostingrunisfinalized,theupdateofCommercialprice3inthematerialmasterhastobestartedDeterminethesettingsinthe”Parameter”asshowninthefollowingscreenprintSavethesettingsandafterleavingthe”Parameter”,executetheCommercialprice3updateDownloadtheanalysisfromthecostingrunintoExcelbyT-Code:S_P99_41000111andsaveitfortransparencyandtraceabilitypurposesFinalofcostingrun Forcostingsinglematerials,youcanusetransactionCK11NandCK24withselectionCommercialprice3inTheprocedureisthesame(defineparametersandrun)fortherestofthesteps.VerificationofmaterialmasterTransactionZAMM0001YoucanfoundthatComl.Price3hadbeenupdatedbyprevioussteps.CNCompanyCode:2290,DownloadthematerialmasterforyourplantintoExcelCheckifCommercialprice3wasupdatedforallmaterialswithmaterialtypeZHIBandZPRD.AnalyzethosematerialsthathavestockbutnoCommercialprice3Step3:LowestvaluedeterminationbasedonLoss-freevaluationLowestvaluedeterminationbasedonlossfreevaluation(PE)Thethirdstepoftheinventoryvaluationcomparesthecommercialprice3withthelastsalespriceinagiventimeperiod.ThelastsalespriceistakenoutoftheSDinformationfromtheKE24lineitem.TheCN:C007,costcalculationvariantonlycalculatesthematerialuntilproductcost.Meansoutboundlogistics,productdivision,centralsurcharge,customercentreandotherdirectsalescostareexcluded.Therefore,tocomparethepricesweneedtoadjusttheKE24information.Lowestvaluedeterminationlossfreevaluation(TO)ProcessstartingwithtransactionMRN3theloss-freeevaluationtodeterminethelowestpriceforsaleablefinished(unfinished)goodsUsevariant:2290_MRN3Hint:youcanrunthistransactionalsofortradingpartswithoutboundinvoicesinthechosenperiodwhilechangingthecomparisonprice(Commercialprice2)*.YoushouldcheckforthoseValuationClassinyourCountry*.YoushouldmaintaincustomizetableZJ0000MMT0001”withvalue?YCL_IM__SMOD_NIWE0003_IMP”andrelatedCompanyCode Systemstepsinbackground:SelectionoftheCommercialprice3calculatedwiththeinventorycostingascomparisonpriceSelectionofthelastoutboundinvoicetodeterminethesalespriceminussalesandadministrationcostsComparisonofbothpricesandupdatingtheTaxprice2fieldinthematerialmasterwiththelowestofbothpricesEnteryourcompanycodeandtheappropriateplantEnterthekeydatewhichrepresentstheendofthefiscalperiodStep1Commercialprice3:comparisonpriceiscalculatedwithcostingvariantCN:C007,andsavedforfinished(ZPRD)andunfinishedgoods(ZHIB)Step2:Comparison:thesystemverifiesCommercialprice3andtheMarketpriceforupdatingthelowestofbothinTaxfield2(Step3)ifnoMarketpricehasbeenfound(nooutboundinvoice)–Commercialprice3istransferredintoTaxpriceStep3:RemainthesettingsasshownaboveforupdatingTaxprice2YoucanchangethesettingsfortheoutputlistifdifferentinformationarerequestedIfyouwanttocheckthepricesinadvance–leavethe”DatabaseUpdate”openPressclickcheckforupdatingTaxprice2inthematerialmasterAnappropriatelistcanbedownloadedwhichshowsthelowestpricebetween[salespriceminusadministrativeandsalesoverhead]andCommercialprice2fromtheinventorycostingafterfinishingtheprogramrunBecausethereisaprobleminthecurrentprogram‘slogic,thesalespriceisdisplayedas0.Theissuehasalreadyraisedandwillbefixedsoon.VerificationofmaterialmasterTransaction:ZAMM001DownloadthematerialmasterforyourplantintoExcelCheckifTaxprice2wasupdatedforallmaterialswithmaterialtypeoffinishedgoods(ZPRD)andunfinishedgoods(ZHIB)AnalyzethosematerialsthathavestockbutnoTaxprice2Step4:LowestvaluedeterminationbasedonmovementrateLowestvaluedeterminationbasedonmovementrate(PE)Theobsolescenceofinventoriescouldbecounteredbymarketabilitydiscounts.Withinthescopeofthegroupevaluation,generallythemarketabilitydiscountsareapplicable.However,thelegalassessmentrulesdoesnotpermittheformationofso-calledhiddenreserves.Thebenchmarkofmovementrateisthelengthofthestorageperiodandthelaststockmovement.AdditionalreferencestoBiRiLiG:InventoriesarevaluedinaccordancewithGroupPolicyaccordingtothelowestvalueprinciple.Thesettingsforthisformofevaluationmustbesetinthesystem.SAPperformsthecostingandassessmentinaccordancewiththeprescribedstandard.Inthereviewyoumayencounterirregularitiesandfaultydatawhichcouldbedifficultforthefurtherassessment.Basicallyinthisstepofevaluationitisabsolutelynecessarytodistinguishbetweenthecategoriesofraw,auxiliary,andsupplymaterialsontheonehandandfinished/unfinishedgoodsontheotherhand.The??determinedvaluesinthisevaluationstepwillbeeventuallyusedtoupdatethetax-basedprice2whichcorrespondsdirectlytotheactualvaluereflectedinthebalancesheet.Whendeterminingthelowestvaluebasedonmovementratethesystemexamineswhetherthepriceofamaterialshouldbedevaluedonthebasisofnon-movement.Themovementofamaterialischaracterizedbythepercentagewhichdescribeshowmanyunitshavebeenreceivedorsentoffinrelationtothematerialstock.Themovementratecanbedeterminedintwoways:?ThroughthematerialdocumentsInthiscasethemovementrateforinputsandoutputscanbeexamined.Ifyoutakeintoaccountinputsaswellasoutputsyougetamovementrateforbothreceivedanddispatchedgoods.Inthiscasethematerialisconsideredtobenon-movingifbothvalues??aresmallerthantherespectivepredeterminedpercentage.?ThematerialmasterrecordInthiscaseonlyoutputsareconsidered.Thisprocesstakesconsiderablylesstimethanthedeterminationthroughthematerialdocuments.InthenextchapterscommonpitfallsandsolutionsaredescribedinadditiontotheinstructionstocompletetheevaluationwithSAP.MarketabilitydiscountsThemarketabilitydiscountsforeachgroupareexplainedasfollows:Themovementrateofamaterialisbeingdeterminedthroughthereceiptsorrequirementsofthematerialandtheconsumptionofthematerialstock:Movement=thetotalamountofin-oroutputs/materialstock*100Themovementofamaterialischaracterizedbythepercentagewhichdescribeshowmanyunitshavebeenreceivedorrequiredinrelationtothematerialstock.Thispercentageiscomparedtoagiventhreshold:Ifthepercentageofthein-oroutputsarelessthanthethresholdvalueitisconsiderednon-moving.Ifitisbiggerthematerialisconsideredmoving.Thematerialstockusedtocalculatethemovementratecanbedefinedasthemeansoftheclosingstocksofpastaccountingperiods.Weightingfactorsmustbespecifiedformaterialstocksandmovements.Thiscanbedoneinthecustomizingorusingthestartscreen.Todeterminethemovementratethesystemdrawsonlyonmaterialmovementswhicharewithintheobservationperiod.Toincludenon-movementfromthemoredistantpastinthedevaluationaswell,theprocessproceedsviaadevaluationindicatorusingthefollowingrules:?Ifamaterialisclassifiedasnon-movinginthecurrentreportingperiod,thedevaluationindicatorisincreasedby1.?Ifamaterialisclassifiedasmovinginthecurrentreportingperiod,thedevaluationindicatorissettozero.Lowestvaluedeterminationbasedonmovementrate(TO)TransactionMRN2–DeterminationoflowestpricebasedonhistoricalmovementsStartingwithtransactionMRN2Processthedeterminationofthenon-marketablegoodstocalculatethelowestpricefortheinventoryvaluationUsevariants:2290_MRN2_1,2290_MRN2_2,2290_MRN2_32290_MRN2_1_RM,2290_MRN2_2_RM,2290_MRN2_3_RMMaterialTypeTHCN(xxxmeansCOCD)KRMovementRateCriteriaDevaluationKeySTEP1,STEP2,STEP3ZHIBZPRDMRN2_1,MRN2_2,MRN2_3,XXX_MRN2_1,XXX_MRN2_2,XXX_MRN2_3,KR_MRN2_1,KR_MRN2_2,KR_MRN2_3,keydate-24mkeydate-12mkeydate-6m321STEP1,STEP2,STEP3ZROHMRN2_1_RM,MRN2_2_RM,MRN2_3_RMXXX_MRN2_1_RMXXX_MRN2_2_RMXXX_MRN2_3_RMKR_MRN2_1_RMKR_MRN2_2_RMKR_MRN2_3_RMkeydate-24mkeydate-12mkeydate-6m321Hint:youneedtochangeimportantsettings(*.e.gCreationDate,KeyDate,Valuationclass)byyourselfbeforeyouruneachofthesevariantsoneaftertheother.Hint:ThetransactionMRN2shouldbeexecutedby3steps(Run1,Run2andRun3).Ifyourunthetransactionformorethan3times,thedevaluationindicatormaybeincreasedto4or5. Systemstepsinbackground:EntertheMovementratecriteriatodeterminethecorrectdevaluationindicator(*.Consideringthesystemperformance&specialmovementtypeforconsignment631/633,werecommendedthatyouchangeto”frommaterialmasterdata”,andyoucanrunas”backgroundjob”)asbelowChecktheSettingsfortheBasepriceandEntertheDevaluationpercentagesUpdateofTaxprice3fieldinthematerialmasterwiththelowestpriceEnterthecompanycodeEnterthekeydatewhichrepresentstheendofthefiscalperiodCreationdaterepresentsthedatebywhenamaterialmustbecreatedsothatitcanbedevaluated–asof:keydateminus6monthsFinished/UnfinishedgoodsrelatedtoTaxprice2ThesettingsoftheMRN2runforfinished(ZPRD)andunfinishedgoods(ZHIB)refertothemarketabilitycriteriaBU1oftheguidelineFordeterminationthedevaluationindicatorandcalculationofthelowestprice,3differentupdaterunshavetobeexecutedGroupsDescriptionDevaluationpercentageDevaluationindicator4Currentconsumption0%03Lastconsumptionwasmorethan6monthsago3350%12Lastconsumptionwasmorethan12monthsago6690%21Noconsumptionfor24months95100%3RUN1–Variant:2290_MRN2_1Step1(*.Consideringthesystemperformance&specialmovementtypeforconsignment631/633,werecommendedthatyouchangeto”frommaterialmasterdata”,andyoucanrunas”backgroundjob”)asbelowFrommaterialmasterdata:determinesthattheconsumptionisbasedondatainthematerialmasterrecord.Materialconsumptionandthecorrectionofmaterialissuescanbeselected.Frommaterialdocument:determinesthattheconsumptionisbasedonmovementtypethatmaintainedinthisfunction.Materialreceiptsandconsumptioncanbeselected.Periodunderreview:determinesthedatefromwhichthegoodsmovementsaretobeincludedkeydateminus24monthsForanalysesofthematerialmovementsyoucanusetransactionMB51andtheequivalentintheBW-system.Lower–Upperlimit:determinestheintervalforwhichthematerialstockshastobeincludedkeydateminus24monthsStep2:Taxprice2 :BasepricetakenforcalculationofapossiblemarketabilitydeductionValuationLevel:CompanyCodeLevel;Devaluationpercentages:forcalculatingthemarketabilitydeductionthereductionrateperdevaluationindicatorhastobemaintainedforthecompanycodeStep3:ForupdatingTaxprice3inthematerialmasterpressclickcheckboxRemainthesettingsasshownaboveforupdatingTaxprice3YoucanchangethesettingsfortheoutputlistifdifferentinformationarerequestedIfyouwanttocheckthepricesinadvance–Remainthe”DatabaseUpdate”openAdetailedlistcanbedownloadedaftertheruniscomplete.Pleasesavethislistforaauditpurpose.RUN2–Variant:2290_MRN2_2Step1:Periodunderreview:determinesthedatefromwhichthegoodsmovementsaretobeincludedkeydateminus12monthsLower–Upperlimit:determinestheintervalforwhichthematerialstocksaretobeincludedkeydateminus12monthsStep2:Taxprice2:Basepricetakenforca