The Chart of Accounts - Dynamics 365 Business Central

In the Business Central solution, the chart of accounts is the core of all ... you is my totaling account and I have an example here on an account here, ... Businesscentral/Finance/TheregistrationmodelandsetupFinanceFilters:AllWHYOVERVIEWBASICSCOMMONDETAILSCONFIGAllBEGINTADVTheRegistrationModelandSetup1HowtosetuptheCompanyInformationINTCONFIG2HowtosetupthebasicfieldsintheGeneralLedgerSetupINTCONFIG3TheChartofAccountsBEGBASICS4SettingupDimensionsINTCONFIG5SettingupIntrastatINTCONFIG6SettingupDeferralsINTCONFIG7SettingupExchangeRateServicesADVCONFIG8SettingupReminderTermsADVCONFIG9SettingupElectronicinvoicingwithOIOUBL(EAN)ADVCONFIG10HowtosetupanduseNumberSeriesADVCONFIG11SettingupBankINTCONFIG12WalkthroughoffieldsontheCurrencyCardINTCONFIG13AddingaCompanyIdentifiertoyourCompanyINTCONFIGThePostingGroups1TheConceptandOverallFlowofPostingGroupsandPostingSetupINTOVERVIEW2TheBusinessPostingGroupsdetermineswhoapostingisconcerningINTOVERVIEW3TheProductPostingGroupsdetermineswhatapostingisconcerningINTOVERVIEW4TheVATBusiness&VATProductPostingGroupINTOVERVIEW5InventoryPostingGroupsdeterminesgroupingofItemsinInventoryAccountsINTOVERVIEW6ThePostingGroupsusedonCustomersINTCONFIGOVERVIEW7ThePostingGroupsusedonVendorsINTCONFIGOVERVIEW8ThePostingGroupsusedonItemsINTCONFIGOVERVIEW9ThePostingGroupsusedonResourcesINTCONFIGOVERVIEW10ThePostingGroupsusedonItemChargesINTCONFIGOVERVIEW11ThePostingGroupsusedonFixedAssetsINTCONFIGOVERVIEW12ThePostingGroupsuseddirectlyonG/LAccountsINTCONFIGOVERVIEWThePostingSetup1TheGeneralPostingSetupdeterminespostingofRevenueandCostsintheIncomeStatementINTCONFIGOVERVIEW2TheInventoryPostingSetupdeterminestheInventoryAccountsandVarianceAccountsINTCONFIGOVERVIEW3TheVATPostingSetupdeterminestheVATPostingintheBalanceAccountsINTCONFIGOVERVIEW4TheCustomerPostingGroupsdeterminestheReceivablesAccountINTOVERVIEW5TheVendorPostingGroupsdeterminesthePayablesAccountINTOVERVIEW6TheBankAccountPostingGroupsisusedforpayables,receivables,interestandchargesINTOVERVIEW7TheFixedAssetPostingGroupsdeterminesBalanceaccountsusedforFixedAssetsINTOVERVIEW8WalkthroughoffieldsintheBankAccountPostingGroupsADVDETAILS9WalkthroughoffieldsintheCustomerPostingGroupsADVDETAILS10WalkthroughoffieldsintheInventoryPostingSetupADVCOMMON11WalkthroughoffieldsintheVATPostingSetupINTCOMMON12WalkthroughoffieldsintheVendorPostingGroupsADVDETAILS13WalkthroughoffieldsrelevantforSalesintheGeneralPostingSetupINTCOMMON14WalkthroughoffieldsrelevantforPurchaseintheGeneralPostingSetupINTCOMMON15WalkthroughoffieldsrelevantforInventoryintheGeneralPostingSetupINTCOMMONVendorsAccounting1InvoicingwiththePurchaseJournalBEGBASICS2InvoicingwiththePurchaseInvoiceBEGBASICS3InvoicingfromaPurchaseOrderBEGBASICS4PurchaseCreditMemosBEGBASICS5PayoutandapplicationBEGBASICS6AddingDimensionstoVendorsflowingtoPurchasePostingsINTCOMMON7FrequentlyusedfieldsontheVendorrelevantfortheFinanceDepartmentINTDETAILS8AdvancedfieldsontheVendorsrelevantfortheFinanceDepartmentADVDETAILS9PostingapplicationofVendorsfromVendorledgerEntriesINTCOMMONCustomersAccounting1FrequentlyusedfieldsandCalculatedfieldsontheCustomerrelevantfortheFinanceDepartmentINTBASICS2FrequentlyusedActionbuttonsontheCustomerCardrelevantfortheFinanceDepartmentINTCOMMON3AddingDimensionstoCustomersflowingtoSalesPostingsINTCOMMON4InvoicingwiththeSalesJournalBEGBASICS5InvoicingwiththeSalesInvoiceBEGBASICS6InvoicingfromaSalesOrderBEGBASICS7SalesCreditMemosBEGBASICS8CreatingRemindersManuallyforasingleCustomerINTBASICS9CreatingRemindersautomaticallyINTCOMMON10CreatingReminderwithInterestsBEGCOMMON11ReminderHeaderLevelandUpdatingReminderTextsINTCOMMON12HowtoprintaProFormaInvoiceBEGCOMMON13ElectronicinvoicingwithOIOUBL(EAN)ADVCOMMON14DepositandapplicationINTBASICS15CancelingIssuedRemindersINTDETAILSRegistrationsandJournals1HowtoworkwithjournalsinDynamics365BEGCOMMONMicrosoft2CreateDeferralsfromSalesandPurchasesINTCOMMON3IntroductiontopostingwithDimensionsBEGBASICS4AddingDimensionstoMultiplelinesBEGBASICSClosingMonth,Activities1ExchangeRateUpdateADVDETAILS2ExchangeRateAdjustmenttoupdatetheG/LADVDETAILS3ReportingIntrastatINTDETAILS4ThebasicsetupoftheVATStatementINTCONFIG5HowtoSettleVATintheERPsystemINTCOMMON6VATViesReportingADVCOMMON7DeferralSummariesADVCOMMONClosingMonth,Reconciliation1HowtoReconciletheCustomerEntriesADVDETAILS2HowtoReconciletheVendorEntriesADVDETAILS3HowtoReconciletheBankEntriesADVDETAILS4HowtoReconciletheVATEntriesADVDETAILS5HowtoReconciletheInventoryADVDETAILS6HowtoReconciletheWorkinProgress(WIP)ADVDETAILSClosingofYear1HowtocreatenewAccountingPeriodsINTCOMMONBackTheChartofAccountsTheRegistrationModelandSetupVideo3/13Auto-forwardDoyouwanttoenableauto-forwardandautomaticallyloadthenextvideowhenthecurrentvideoends?Enableauto-forwardSkipCloseFeedbackHelpfulNothelpfulNeedsupdateTechnicalerrorShareFacebookTwitterLinkedInCopyLinkAbeginnervideoisforpeoplewithlittleornoexperiencewithBusinessCentral.Itisexplainedthoroughlyandiseasytounderstand.BeginnerWatchthe"basic"videostotakethetourofthemainprocessesofBusinessCentral.Thisisthebasic,need-to-usefunctionality.TheBasicsPlaylists ManageLogintocreateaplaylistorseeyourexistingplaylists.LoginUsernameorEmailAddress*Password*RemembermeDon'thaveanaccount?SignupNow»Lostyourpassword?OpenPlaylistPresenter:SuneLohse,ChiefStrategyOfficer»MoreaboutSuneSuneonLinkedInHowtosetupyourchartofaccountsinBusinessCentralIntheBusinessCentralsolution,thechartofaccountsisthecoreofallfinancialprocesses,thisiswherewecontrolallofourfinancialprocesses.ThisiswhathappensinthevideoInthisvideo,Iwilldemonstratehowitissetup,andhowweworkwithit.First,Iwillentermychartofaccountstoseethelistofalltheaccounts,thatwehavesetuphere,andlet’sgothroughwhatitdoesinhere.Tobeginwith,Ilookattheoverviewofalltheaccountshere.Icanseeonmychartofaccountslistthattheaccounttypecanbedifferent.IfIeditthelist,Icandiveintotheaccounttypeandseethatanaccountcanbeforpostings,whichmeansIcandopostingsonit.Itcanbeaheadingforgroupingdata,atotal,orabegin/endtotal.Let’slookathowthisworks.IfIfilterontheaccountnumber,andI’lljustseeallmyaccountsstartingwithnumberone.So,Icangetalimitedoverviewhere.Now,IcanseeIhaveforinstancemysalesofretailwhichisatypebegin-total,itmeansIcannotpostonthisaccount,anditgoesalsoallthewaytomytotalofretailswhichisanend-total.So,automatically,thelastlineherewillbecalculatedasthesumofthenetchangeandbalanceandIcanseeitherestartingfromthebegin-totaltilltheend-total.ButIcanalsoseemyrevenueasabegin-totalstartinguphereandit’smysalesofretailisembeddedinthisoneandmytotalrevenuegoesdowntohere.So,it’sgroupingbybeginandends,sothetotalrevenuewouldbeasumofallthepostingaccountswhereasthepartlybeginandend-totalwouldbesectionsofthat.Myincomestatementaccountinthebeginningisaheading,meaningthisisjustforgroupingpurposesandthelasttypeofaccountIwanttoshowyouismytotalingaccountandIhaveanexamplehereonanaccounthere,mygrossprofitaccountandifIjustremovemyfilteragainhere,wecanseewhatit’sapartofandIcanseethegrossprofitaccounthereasjustatotal,andmanuallyI’veenteredtheaccounttotaling,meaningit’sstartsfromaccount11,000andendsinthelastaccounthereandit’sonlyincludedinthepostingaccountsinthatcalculation.Thenetchangecolumnisdisplayingthepostinginaspecificfilterintervalandmybalanceisdisplayingthetotal.So,nowthosetwoarethesamebecauseIhaven’taddedadatefiltertomychartofaccounts.So,ifIaddadatefilterhere,filtertotalsbydateandIwouldlikemaybetoseeeverythingfrom2018,andIcanaddafilterforthatandnowmynetchangecolumnwilldisplayeverythingthathappenedin2018withinthisfilterandmybalancewilldisplaythetotal.Likewise,Icouldfilteronmanyotherdifferentflowfieldsanditwilldisplayonthenetchangecolumnwhat’sinthefilterandthebalancewilldisplaythetotal.So,whenIdivedownintomyaccountandIcanseemynetchangewhenitopenshere.It’sonlysomeentrieswhereasifIdrilldowninmybalanceaccount,itwilldisplayeverythingonthataccount.So,thisishowthedatesareworking.Nowlet’strytoenteranaccountcharttoseehowthatlooks.Andwecouldtakeforinstancethe11301,myrevenueofretail.Thereissomesetuponthisaccountchart.So,IcaneditmyaccountchartandIwilljustrunthroughsomeofthefieldsinhereSoIhavemyaccountnumberwhich,ofcourse,reliestotheplacementintheaccount.IhaveadescriptionandIcandetermineherewhetherit’sanincomestatementorabalancesheetaccountandithastofitintomyhierarchyinthechartofaccountsandthenIhavemyaccountcategoryandmyaccountsubcategorywhichareusedforreportingpurposes.So,onceIselectanaccountcategory,Icanselectbetweendifferentsubcategoriesthatissetup.So,theseareforreporting.Ontherighthandside,IhavemyreconciliationaccountwhichisjustacheckmarkIcanselectordeselectandthisbasicallymeansifIwanttolookintotheaccounttotalsfromdifferentjournals.So,forinstance,ifIlookintomypaymentjournal,andI’vecheatedalittlehere,let’slookintoapaymentjournalandI’veaddedsomelineshere,maybeI’mabouttoreceivesomepaymentsfromtwocustomersandI’vemadeapaymentforavendorandifIscrolltotheright,IcanseetheamountsandIcanseethebalanceaccount.AndifIwanttoknowwhatishappeninginmybankwhenIactuallypostthisjournalbecausethosetwodifferentaccountsaresetupasreconciliationaccounts,IcanclickbankandreconcileandIcanalsodothatfromanormalG/Ljournal.AndinhereIcanseealltheaccountsthathasacheckmarkinreconciliation.So,hereIcanseemynetchangeinthisspecificjournalononeaccountandtheotheraccountandittotalsupfromthisjournalandIcanseemybalanceafterpostingthisaccount.So,whenIpostthis,thiswillbethebalanceonmytwobankaccounts.Let’sgobacktotheaccountchart.Nexttothereconciliationaccount,IhavemydirectpostingcheckmarkandthisdeterminesbasicallyifI’mallowedtododirectpostingsonthisaccountinjournalsforinstanceorifIcanonlydoindirectpostings,meaningapostingcomingfromdocuments.Onthepostingtabintheaccountchart,IcansetupdifferentselectionsandIdon’thavetofillitout,itcouldbeblankifIwanttobutitcanhelpmedodefaultpostingswhenIenterjournallinesmanuallyinmyG/Ljournals,purchasejournalsorsalesjournals.So,normallythisinformationwouldcomefromcustomersandvendorsanditemsorresources,butitcouldalsocomedirectlyfrommyG/Laccount.So,hereIcansetupmygeneralpostingtype,Icansetupmygeneralpostinggroup,mygeneralproductpostinggroupandVATforthosegroups.So,mygeneralbusinesspostinggroupisnormallyappliedtowhoI’mbuyingfromorsellingtoandoftenalsowhereitcomesfrom,soit’sbothamatteroflocationandamatterofwhoI’msellingfromandbuyingfrom,whereastheproductpostinggroupappliestowhatI’msellingorbuying,meaningitemsorresources,whereastheotheriscustomersandvendors.So,thisdeterminestheaccountthatI’mgoingtouseinthedifferentmixofbusinesspostingandproductposting.Andthisisallsetupinthegeneralpostingsetup,soI’lljustshowyouquicklyhowitlooksbutnotgothroughthatinthisvideo.So,ifIhavemygeneralpostingsetup.YoucanseethefirsttwocolumnsisamixtureofmygeneralbusinesspostinggroupandgeneralproductpostinggroupanddependingonwhatmixtureIuse,onpurchasedocuments,salesdocumentsordirectlyinthejournal,itdetermineswhichaccounttopostto.Inmygeneralpostingsetups,theaccountsaregrouped,soIhavemysalesaccountfirst,alltherelevantpurchaseaccountsasnextandmyinventoryaccountsintheend.So,ifwemakeasalesjournallinetoaspecificvendor,alltheseaccountswilldeterminewherethedifferentamountsgoesinto.So,thepostingsetupisexplainedinanothervideo,andit’sofcourseverycomplextomaintain.LikewiseontheVATpostingsetup.LastfieldIwanttoshowyouontheG/LaccountcardisthedefaultdeferraltemplateandIhaven’tsetupanyinherebuthereyoucansetupadeferralcodesayingyouwanttodeferralthisinthreemonthsortwelvemonthsorwhatever,andifyoupostinajournalonanaccountthathasadeferraltemplatecode,onelineintheaccountwouldbesplitintothedifferentperiodsofthisdeferralaccordingtothistemplatethatyousetuphere.Let’stakeanaccountandlookattheentriesandIwilltakeanaccount,whichIknowhasmanyentriesonit,justtoshowyou.So,I’lltakeoneofmyinventoryaccounts,myrawmaterialaccount.IfIgointothisaccountchartlikethis,IhavedifferentnavigationpossibilitiesthatIwanttoshowyou.Frommyaccountfunctionhere,IcangointomyledgerentriesandIcanseealltheentriesonthisspecificaccount,Icouldalsohaveopenedthisfielddirectlyfrommychartofaccounts.So,hereIhavealltheentries,theamounts,andalltheinformationandthereisadefaultfilterhereonmyG/LaccountbecauseI’mcomingfromthataccount.IcouldalsofilteronotherstuffandIcouldremovethefiltersontheG/Laccount.So,let’ssayIwanttoseethedocumentnumber133onlyintheendhere,IcouldplacemyselfonthelinehereandfiltertothisvalueormanuallyenterthisfilteronthisvalueandthisisallpostingsonthisdocumentnumberonthisspecificaccountandifIremovemyaccountfilterhere,Icanseeallthepostingsonthisdocumentnumber,whichisquitealotofcourse.Fromeachofthoseentries,IcouldgointomyprocessandIcannavigatetoseealltheentries,allthepostingdoneonthisspecificdocumentnumber.So,hereIcanseethattherelatedentriesisforinstanceaproductionorder.ThiswayIcanseewherethispostingcomesfromonitsproductionorderlistandIcanseetheproductionorderandgofurtherintothatone.IcanseeIhave54G/Lentriesandthatwastheonewesawonthebackground,ofcourseIcanseeallmyitemledgerentriescomingfromthisspecificposting,Icanseethere’salotofconsumptionandthereisoneoutput,sothisistheitemimpactthatcamefromthisposting.Icanseevalueentrieswhichisbothdirectcostandindirectcost,it’sanoutputandconsumptionanditrelatestomyitemledgerandmycapacityledgerentries,andthelastIseehereismycapacityledgerentries,that’smadefrommyproduction.So,thiswayIcannavigatethroughthedocumentnumber,soeverytimeIpostsomethinginBusinessCentral,thedocumentnumberisbindingitalltogether.AndthelastthingIwanttoshowyouisthatIcanopenthisinExcel.SoIcanexporttheviewthatI’mlookingatintoExceljustbyclickinghereandthisrelatestothefilterthatI’veappliedinthisview,meaningmydocumentnumberandnotmyaccountnumber.So,hereIcanseeallmyentriesopenedinExcelandIcanusethatforallkindsofreportingpurposes.PreviousvideoHowtosetupthebasicfieldsintheGeneralLedgerSetupnextvideoSettingupDimensions326808424-7k6KucksjCo-ENG19021103Weusecookiesonourwebsitefortechnical,analyticalandmarketingpurposes.Byclicking“Accept”,youconsenttotheuseofallcookies.HoweveryoumayvisitCookieSettingstoprovideacontrolledconsent.CookiesettingsACCEPTManageconsentClosePrivacyOverviewThiswebsiteusescookiestoimproveyourexperiencewhileyounavigatethroughthewebsite.Outofthesecookies,thecookiesthatarecategorizedasnecessaryarestoredonyourbrowserastheyareessentialfortheworkingofbasicfunctionalitiesofthewebsite.Wealsousethird-partycookiesthathelpusanalyzeandunderstandhowyouusethiswebsite.Thesecookieswillbestoredinyourbrowseronlywithyourconsent.Youalsohavetheoptiontoopt-outofthesecookies.Butoptingoutofsomeofthesecookiesmayhaveaneffectonyourbrowsingexperience.NecessaryNecessaryAlwaysEnabledNecessarycookiesareabsolutelyessentialforthewebsitetofunctionproperly.Thiscategoryonlyincludescookiesthatensuresbasicfunctionalitiesandsecurityfeaturesofthewebsite.Thesecookiesdonotstoreanypersonalinformation.NonNecessarynon-necessaryAnycookiesthatmaynotbeparticularlynecessaryforthewebsitetofunctionandisusedspecificallytocollectuserpersonaldataviaanalytics,ads,otherembeddedcontentsaretermedasnon-necessarycookies.Save&Accept