Movement Type and GL Account Determination - ERP Great

Different materials will use different accounts during movement. This is defined by the Valuation Class the material is assigned to. Also, movement definition ...   MovementTypeandGLAccount Determination Anyreporttoshowwhichaccountwithwhatmovement type?Aswehavetoomanymovementtypewithdifferentaccount,wewant todownloaditfromsystemandcheck. By:Roger  IntransactionOMWB(itrequiretoinputmaterialno.), gotothesimulationmode,theninmenuSimulation-->GotoReport.There, youcangivetheplants,valuationclassesandmovementtypesandexecute thereport.Thenyoucandownloadittoexcelandanalyze.  or Intheinitialscreeninputtheplant,materialnumber andmovementtypeandthengotosimulation-->report.Itwilltakeyou tosimulationofautomaticaccountassignments:InventoryManagementwhich isindependentofmaterialsandthereyoucangetthedesiredreport. Accountno.withmovementtype  Differentmaterialswillusedifferentaccountsduring movement.ThisisdefinedbytheValuationClassthematerialisassigned to. Also,movementdefinitionalsodifferswiththetypeofmovement, i.e.,aconsumptiononaproductionorderhasadifferentmovementthan aconsumptiononasalesorder.Thesemovementsarethereforelinkedto Transaction/EventKeys,whicharetheaccountingreflectionofthemovement. CalltransactionOMWN,AccountGroupingforMovementTypes. ThistablewillprovideyouwiththeTransaction/EventKeysforthemovement. Withineamovement  type,thesewilldifferbasedonthemovement,consumption type,etc.ThetablesbehindthisareT156XandT156W. WiththisTransactionKeyinformation,readthetable T030(OBYC)usingtheValClassandtheChartofAccountstogettheGL Accounts. HowtofindouthowG/Laccountisdeterminedwith respecttomovementtypeforvariousmaterialtypes? G/La/cisdecidednotonlybyMovementtype,butalso materialmaster/plant/typeoftransaction(transactionkey). Movement typeinOMJJiscontainstransactionkey/Accountmodifierwhichisthe linkforGLa/c. Inmaterialmasterwemaintainvaluationclass.  HencewhenwedoletussayGRforPurchaseorder(101),theG/Laccount isdecidedasbelow: Letussaymovementtype101 Accountmodifier=space CheckinOBYC Asyouareawareforanytransactiontherewillbe+ve and-VentryinGLa/c Whicha/chastobe-veandwhichhastobe+isdecided bypostingkeydependingontransaction. HenceWhenwedoGR...Stock a/cwillbe+,GR/IRwillbe-Veandanypricedifference(ifpricecontrol is-S)willbepostedtopricedifferenceaccount. InventorypostingisdonethroughBSX PricedifferencewillgotoPRD GR/IRwillgotoWRX InOBYC,checkthetransactionBSX,foragivenChart ofA/c,foragivenvaluationmodifier(itisnothingbutplantgrouping) andvaluationclass,youcanseetheG/Laccount.Thisdataisavailable intableT030 Youcanseethepostingkeyfordebitandcr.Thatmeans whenwedo101,thenStockwillbecreditedandthatpostingkeyisused, ifyoudoreverseGR-102,thensamestocka/cwillgetdebitedwiththat postingkey ForthetransactionPRD,youwillgetadditiontothe above,onemorecolumnGeneralmodifier,thisisnothingbuttheaccount modifierinOMJJforthatmovementtype,i.e.Sametransactioni.e.GR, ifidefineadifferentaccountmodifier,IcanchangetheG/Laccount sothatnewmovementtypePRD(variance)canbecollectedatdifferent G/Laccount. LikethatWRX,inwhichitismaintainedatclientlevel noa/cmodifier,novaluationclassetc...thatmeansGR/IRaccountdetermination willnotdependonmovementtype/material/plantetc. Related Inventory PostingToPriceDifferencesAccount Process OfImportedMaterialWithExcise Difference forStockTransferandTransferPosting Creating TheStockTransferOrder Differences BetweenRestrictedvsBlockedStock GethelpforyourSAPMMproblems SAPMMForums -DoyouhaveaSAPMMQuestion? SAPMMBooks SAPMaterial ManagementCertification,InterviewandConfigurationReferenceBooks SAPMaterialManagementTips SAPMMConfiguration TipsandMaterialsManagementDiscussionForum Bestregards, SAPBasis,ABAPProgrammingandOtherIMGStuff http://www.erpgreat.com OtherLogisticsModules SAPLE SAPSD SAPPP SAPQM SAPPM SAPPS AllthesitecontentsareCopyright©www.erpgreat.com andthecontentauthors.Allrightsreserved. Allproductnamesaretrademarksoftheirrespective companies. Thesitewww.erpgreat.comisinnowayaffiliatedwith SAPAG. Everyeffortismadetoensurethecontentintegrity.  Informationusedonthissiteisatyourownrisk.  Thecontentonthissitemaynotbereproduced orredistributedwithouttheexpresswrittenpermissionof www.erpgreat.comorthecontentauthors.