Setup Ledger allocation rule | My Financial Dynamics AX
文章推薦指數: 80 %
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:
延伸文章資訊
- 1About allocation rules | Microsoft Docs
Beginning with cumulative update 7 for Microsoft Dynamics AX 2012 R2, you can use ledger allocati...
- 2BBCG.03.06.AX2012.2.PDF: Configuring Allocation Rules ...
BBCG.03.06.AX2012.2.PDF: Configuring Allocation Rules within Dynamics AX 2012 - Second Edition (D...
- 3Allocations | Dynamics 365FO/AX Finance & Controlling
In this webcast, I show you how you can use MS-Flow for allocating depreciation costs from the fi...
- 4Allocation Rules vs. Ledger Allocation Rules in AX 2012 - Part 2
Allocation Rules in AX 2012 ... Allocation rules are defined on the set up of individual Main acc...
- 5Create an allocation rule | Microsoft Docs
Starting with cumulative update 7 for Microsoft Dynamics AX 2012 R2, you can also use ledger allo...