Microsoft Dynamics GP Tip: Cheat Sheet for Accounts Payable ...

In this tip you will learn what you need to know about aged trial balance, aged trial balance with options, aged historical trial balance, ... SkiptocontentMicrosoftDynamicsGPTip:CheatSheetforAccountsPayableMonthEndProcessesinMicrosoftDynamicsGPPreviousNextMicrosoftDynamicsGPTip:CheatSheetforAccountsPayableMonthEndProcessesinMicrosoftDynamicsGPInthistipyouwilllearnwhatyouneedtoknowaboutagedtrialbalance,agedtrialbalancewithoptions,agedhistoricaltrialbalance,reconciletoGLforAP,andprintingamonth-endcheckregister.AccountsPayableMonthEndProcessChecklistAgedTrialBalancePurchasingReports>>AgedTrialBalances(Thisisthereportyourauditorswillwantwherenothingisexcluded)Normallyonlyusedforauditors.AgedTrialBalancewithOptionsPurchasing>>Reports>>AgedTrialBalancewithOptionsAgedHistoricalTrialBalancewithOptionsPurchasing>>Reports>>AgedHistoricalTrialBalancewithOptionsReconciletoGLFinancials>>Routines>>ReconciletoGLCheckRegisterPrintoutofallChecksformonthPurchasing>>Reports>>CheckInformation>>ChecksbyVendorbyMon1.   AgedTrialBalancePurchasing>>Reports>.AgedTrialBalanceWhenyouprintthisreportyouhavenooptions,itisgoingtogobytheGLdateandwillincludeallvendorsthatyouhaveinyoursystemwhethertheyareazerobalanceorhavehadanyactivityornot.Thisisnormallyonlyusedforyourauditorforyear-end.2. AgedTrialBalancewithOptionsGotoPurchasing>>Reports>>AgedTrialBalancewithOptionsThengotoNewPutinanamefortheoptionYouwanttoPrint/Ageasoftheendofthemonth(forreconcilingtoyourGLbalanceforA/P)Exclude:ZeroBalanceNoActivityUnpostedAppliedcreditDocuments(thesearenotposted,won’tbepartofyourGL)MulticurrencyInfoIfyouleavetherangeblankwillbringupallvendorsandcanbeprinted.3.    HistoricalAgedHistoricalTrialBalancePurchasing>>Reports>>HistoricalAgedTrialBalanceThisreportcanbeprintedatanytimeandgiveyouexactlywereA/Pstoodattheendofthemonthbeforechecksorcreditswerebeingappliedandissuedinthesystem.YoudonothavetorememberonthefirstofthemonthtoruninandprinttheAgedTrialBalancewithOptionstoreconcile. Ifyouforgetanditisthe3rdor4thofthemonthyoucanprintthisreportanditwillshowyouexactlywhereyoustoodattheendofthemonth.Thisreportcanbeprintedinsummaryordetailbychangedthecheckboxinredabove.Youcanprintthisreportforonevendororall. Byusingtherangeandinsertingintotherestrictions.ThisisliketheAgedTrialBalancewithOptionsforexcludingdetail.4.    ReconciletoGLforA/PFinancial: Routines>>ReconciletoGLNextReconciliationNumbercomesupautomaticallyPutinthedatetoreconcile(endofthemonth)PutinaDateRangeforthereconciliation(Begofmonthtoendofmonth)MakesuretomarkModule:PayablesManagementInaccountsenterinyourA/PaccountEnterintheOutputfile(thiswillsavetheexcelfilethatisproducedforyou)ProcessReport:ReportwillshowalltheGLdetailontherightandthepayablestransactionontheleftaswellasthebeginningbalancesintheGLandA/PThisisdoingallthematchingforyouandwillshowyoupotentialareaswhereyourA/PtoGLaccountisoff.5.   PrintingaMonthEndCheckRegisterReports>>Purchasing>>CheckInformation>>VendorCheckRegisterNametheOptionUsetheDropdownRangetoenteryourdaterange.Youcanexcludeorincludevoids.PrintRegister:WillshoweverycheckVendorID,VendorNamedate,andtheamount.IfyouareinterestedinDynamicsGPtrainingorsupportcontact860-485-0910x4orsales@calszone.comGetmoreDynamicsGPTipsandTrickswww.calszone.com/tipsBySusanM.Conrod,SeniorImplementationConsultant,CALBusinessSolutions,www.calszone.comBySusanM.Conrod,SeniorImplementationConsultant,CALBusinessSolutions|2022-03-22T16:07:57-04:00July9th,2016|AccountsPayableTips,DynamicsGPTips,ERPTips&TricksBlog,MicrosoftDynamicsGP|CommentsOffonMicrosoftDynamicsGPTip:CheatSheetforAccountsPayableMonthEndProcessesinMicrosoftDynamicsGPShareThisStory,ChooseYourPlatform!FacebookTwitterRedditLinkedInTumblrPinterestVkEmailRelatedPostsVideo:HowTransitioningtoAcumaticaCanTransformYourBusiness–AcumaticaReportingToolbox–Lunch&LearnSeries2Video:HowTransitioningtoAcumaticaCanTransformYourBusiness–AcumaticaReportingToolbox–Lunch&LearnSeries2Video:HowTransitioningtoAcumaticaCanTransformYourBusiness–AcumaticaOverview–Lunch&LearnSeries1Video:HowTransitioningtoAcumaticaCanTransformYourBusiness–AcumaticaOverview–Lunch&LearnSeries1AcumaticaARM:ReportingwithoutHavingtoLearnAncientGreekAcumaticaARM:ReportingwithoutHavingtoLearnAncientGreek5ReasonsWeSwitchedfromMicrosoftDynamicsGPtoAcumatica5ReasonsWeSwitchedfromMicrosoftDynamicsGPtoAcumaticaCALBusinessSolutionsis#95onBobScott’sTop100VARsfor2022CALBusinessSolutionsis#95onBobScott’sTop100VARsfor2022Searchfor:SubscribetoBlogRSS:GetNewPostsbyEmailRecentPostsVideo:HowTransitioningtoAcumaticaCanTransformYourBusiness–AcumaticaReportingToolbox–Lunch&LearnSeries2Video:HowTransitioningtoAcumaticaCanTransformYourBusiness–AcumaticaOverview–Lunch&LearnSeries1AcumaticaARM:ReportingwithoutHavingtoLearnAncientGreekCategoriesAccountsPayableTipsAccountsReceivableTipsAcumaticaAcumaticaDemos/VideosAcumaticaEventsAcumaticaNewFeaturesAcumaticaSummitAcumaticaTipsAcumaticaUserGroupAddOnToolTipsCALClients/CaseStudiesCALConnectCALNewsCALZoneNewsletterCavalloCavalloDemos/VideosCavalloTipsCustomerSourceTipsDistributionIndustryDynamicsGPDemo/VideosDynamicsGPEventsDynamicsGPNewFeaturesDynamicsGPOnlineDynamicsGPPromotions/CostDynamicsGPTipsDynamicsGPUpgradeResourcesERPTips&TricksBlogGeneralLedgerTipsGPwithExcel/WordTipsGPUGInfographicsInventoryTipsMarketplace/ISVPartnersMgmtReporter/FRxTipsMicrosoftDynamicsGPNavigationTipsOrderProcessingTipsPayroll/HRTipsTipsProfessionalServicesTools/PSTLTipsSetUp/Security/AdminTipsSmartListTipsSSRSTipsVideoTipsWhyChooseAcumaticaWhyChooseCAL?WhyChooseDynamicsGPYear/MonthEndClosingTipsPageloadlinkGotoTop