Setup Ledger allocation rule | My Financial Dynamics AX

This article describes how to setup and use ledger allocation rules in Dynamics AX 2012. This functionality can be used to allocate a global ... FollowMyFinancialDynamicsAXonWordPress.com Subscribebyemail Clicktofollowthisblogandbenotifiedbyemailofnewpublications. EmailAddress: Folllow RSS RSS-Posts RSS-Comments + ThisarticledescribeshowtosetupanduseledgerallocationrulesinDynamicsAX2012.Thisfunctionalitycanbeusedtoallocateaglobalamountinseveralcombinationsofaccount/financialdimensions.Thekeyoftherepartitioncanbefixedorlinkedtoanotheraccount.Inanallocationrule,thereareseveralcomponents: thesource:selecttheaccount/dimensionyouwanttoallocate.Thetotaloftheamountfromallthejournalswillbethebaseoftheallocation. thedestination:selectallthecombinationsofaccount/dimensionsthatwillreceiveanamount. therule:selectthewayofcalculationoftheallocation.Itcanbefixed(enterdirectlyapercentage)orvariable(withalinkedtoanotheraccountforexample). Theallocationrule,canbesetupwithseveralmethods: OptionA:Basisallocationmethod OptionB:Fixedpercentagemethod OptionC:Fixedweight OptionD:Distributethesourcedocumentamountequally. ToillustratethisDynamicsAXfunctionality,Iwilluseanexample:theaccountantwanttoallocatetheamountoftheinsuranceofthebudget“004”into3differentbudgets.Theamountoftheinsurancetoallocateisintheaccount616000-004. OptionA:theallocationruleisbasedontheamountofthepropertyrental(account613200)foreachbudget. OptionB:theallocationruleisbasedonafixepercentage:10%forbudget001,35%forbudget002and55%forbudget003. Prerequisites Beforeusingallocationrule,youneedtocreateanewJournalnamewiththejournaltype“Allocation” Access: GL>Setup>Journals>Journalsnames Createanewjournal Selectthejournaltype“Allocation” Selectavoucherseries. OptionA:Basisallocationmethod Youneedtouseabasiswhenyouwanttoallocateanamountinseveralcombinationofmainaccountsanddimensionsbasedonanothermainaccount/dimensionamount.Inthecaseofabasismethod,youneedtosetupa“Ledgerallocationbasis”. Withtheexample,Ihaveanamountofinsurancechargefromabudget(account61600withbudget004)thatIwanttoallocatein3othersbudgets.Theallocationisbasedontheamountofthepropertyrental(account613200)foreachbudget: Insurancechargetoallocate:account616000–004=$12000 Destinationofmyallocation:616000–001/616000–002/616000–003 Baseoftherepartition:Amountoftheaccount613200foreachbudget(001,002and003). Amountintheaccounting: 613200–001=10000 613200–002=15000 613200–003=25000 Step1:Createledgerallocationbasis Access:GL>Setup>Posting>Ledgerallocationbasis Createonebasisruleforeachcombinationofaccount/dimension.Intheexampleweneedtocreate3rules. Enteradescription ClickonBasis Createafirstlineandselect“Mainaccount”in“Fieldsetting”, In“Sourcecriteria”,selectthemainaccount.Intheexample,thevalue613200, Createasecondlineandselect“FinancialDimension”in “Fieldsetting”, Infinancialdimensionfiled,selectthedimensionyouneed.Intheexample,itis“budget”, In“Sourcecriteria”,selectthemainaccount.Forthefirstrule,itis“001”. Createtwootherruleswiththe2otherbudgetvalues. Clickonactiveofeachledgerallocationbasis. Step2:Createledgerallocationrules Access: GL>Setup>Posting>Ledgerallocationrules Createanewledgerallocationrule Enteradescription Gotothe“General”tab, Selecttheallocationmethod“Basis”, Selectajournalname. GototheOffsettab, Selecttheoffsetaccount.Intheexample,Iwanttocreditthesameaccountusedinthesource(61600-004)tohaveazerobalanceaftertheallocation. Clickon“Source” Selectthemainaccount.Intheexample,thevalueisthemainaccount616000. Youcancreateanotherlinetoaddafinancialdimension.Intheexample,IaddasecondlinewiththedimensionBudget. Clickon“Destination” CreateafirstlinewiththefirstBasisrule.SelecttheBasisrule,theledgeraccount andfinancialdimension ofthedestination(616000-001) Createasecondlinewiththesecondbasisruleandtheledgeraccountandfinancialdimensionofthedestination(616000-002). Createathirdlinewiththethirdbasisruleandtheledgeraccountandfinancialdimensionofthedestination(616000-003). Gobacktothefirstformandactivetherule. Step3:Executeallocationrule Intheexample,wewanttohavethisresults: Access: GL>Periodic>Processallocationrequest Selecttheallocationrule, Selectthestartdatetoretreiveamountfortheallocation, Inproposaloption,select“Proposalonly”tobeabletocheckthejournalor“Postanly”todirectlypostthejournal. Access:GL>Journals>Allocation OpenthenewallocationjournalcreatedbyDynamicsAX. PostthejournalifallisOK. Intheexample,Ihavetheamountoftheaccount616000-004isallocateintothe3otherbudgetsaccordingtotheamountoftheaccount613200foreachbudget. OptionB: Fixedpercentagemethod Withtheexample,Ihaveanamountofinsurancechargefromabudget(account61600withbudget004)thatIwanttoallocatein3othersbudgets.Theallocationisbasedonfixedpercentage: Insurancechargetoallocate:account616000–004=$12000 Destinationofmyallocation:616000–001/616000–002/616000–003 Baseoftherepartition:10%forbudget001,35%forbudget002and55%forbudget003 Step1:Createledgerallocationrule Access: GL>Setup>Posting>Ledgerallocationrules Createanewledgerallocationrule Enteradescription Whentheruleiscreated,don’tforgettoclickon“Active”tobeabletouseit. Gotothetab“General” Selecttheallocationmethod“Fixedpercentage” Selectajournalname. Gotothetab“Offset” Inthisexample,Iwanttoreversingtheinitialaccount/dimension,soIselectSource.Butyoucanspecifedanotheraccount. Clickon“Source” Createanewlineandselectthemainaccount.intheexamplethevalueis616000. Createasecondlineandselectthefinancialdimension“Budget”withthevalue004forthisexample. Clickon“Destination” Createafirstlineforthefirstdestination:account616000-001withthefixedpercentage10% Createasecondlinefortheseconddimension002:account616000-002with  fixedpercentage35% Createathirdlineforthethethirddimension003: account616000-003with  fixedpercentage55% Checkthatthetotalpercentageisequalto100. Step2:Executeallocationrule Access: GL>Periodic>Processallocationrequest Selecttheallocationrule, Selectthestartdatetoretreiveamountforthebasisoftheallocation, Inproposaloption,select“Proposalonly”tobeabletocheckthejournalor“Postanly”todirectlypostthejournal. Access: GL>Journals>Allocation Openthenewallocationjournal. PostthejournalifallisOK. Intheexample,Ihavetheamountoftheaccount616000-004isallocateintothe3otherbudgetsaccordingtothepercentageoftherule. Sharethis:ClicktoshareonLinkedIn(Opensinnewwindow)ClicktoshareonTwitter(Opensinnewwindow)ClicktoshareonFacebook(Opensinnewwindow)Likethis:LikeLoading... Related ThisentrywaspostedinGLfunctionality,GLSetupandtaggedAllocationrules,Generaljournal.Bookmarkthepermalink. 4thoughtson“SetupLedgerallocation rule” Pingback:Generaljournalswithtemplate|MyFinancialDynamicsAX Great!Thanks! Reply Hi, Ineedtoputinthesourcemorethanoneaccountforexample: accountA accountB costcenter99 Icreateafixedpercentagerule Iwouldcreateonedestinationforallaccountincludedinthesourcewiththesame%distribution butIneedtoputthedestinationaccountinthesamesourceaccount accountA–costcenterA20% accountA–costcenterB80% accountB–costcenterA20% accountB–costcenterB80% inallsinglerule. Thereisthepossibilitytobookasdestinationaccountthesourceaccount?? Anyparameter,maybe? thanks Reply HowtoprocessledgerallocationfromVendorInvoiceJournal/PaymentJournalfromAP>Journals>Invoices>InvoicejournalandAP>Journals>Payments>Paymentjournal. —Ram|+91-9003151150|skype:svrcrown Reply LeaveaReplyCancelreply Enteryourcommenthere... Fillinyourdetailsbeloworclickanicontologin: Email(required)(Addressnevermadepublic) Name(required) Website YouarecommentingusingyourWordPress.comaccount. ( Log Out /  Change ) YouarecommentingusingyourTwitteraccount. ( Log Out /  Change ) YouarecommentingusingyourFacebookaccount. ( Log Out /  Change ) Cancel Connectingto%s Notifymeofnewcommentsviaemail.Notifymeofnewpostsviaemail. Δ Postnavigation ←Setupperiodicjournal SetupAccrualschemes→ Search Search Recentposts Howtobrowsetablein D365 ActivateDocumenthandlingfunctionforposted journals AddanAttachment Accrualsschemedescription setup Positionsmassupdate Createanauto-report Purchaserequisitionworkflow:ApprovalbytheProject Manager DynamicsExcelAdd-In Createaprocessinggroupforpositionswiththe DIEF Importdatawiththe DIEF TagsAccount Accountingerror Accountingschema Accrualscheme Allocationrules Assetacquisition Bankaccount BOE Budget Budgetcontrol CashFlow Closing Customerinvoice CustomerPayment D365 Dateintervals Depositslip Depreciation DIEF document FAjournals FixedAssets Generaljournal Import Paymentjournal Paymentjournals Periodicjournal Position PR Prepayment Purchaseorder report SalesTax Settlement Statements Table taskrecorder Template tips Vendorinvoice Vendorpayment;Settlement Voucher Vouchertemplate Workflow Privacy&Cookies:Thissiteusescookies.Bycontinuingtousethiswebsite,youagreetotheiruse. Tofindoutmore,includinghowtocontrolcookies,seehere: CookiePolicy Follow Following MyFinancialDynamicsAX Join259otherfollowers Signmeup AlreadyhaveaWordPress.comaccount?Loginnow. MyFinancialDynamicsAX Customize Follow Following Signup Login Copyshortlink Reportthiscontent ViewpostinReader Managesubscriptions Collapsethisbar   LoadingComments...   WriteaComment... Email(Required) Name(Required) Website %dbloggerslikethis: