Historical Aged Trial Balance for the Account Receivable

Hi! We would like to have one Smartlist that include an Historical Aged Trial Balance for the Account Receivable. In the Smartlist, we need ...    Skiptomaincontent(PressEnter). Signin Skipauxiliarynavigation(PressEnter). DynamicsCRMPowerPlatformAllUserGroups Skipmainnavigation(PressEnter). Togglenavigation SearchOptions MembershipJointheUserGroupMembershipBenefitsPricingParticipateLocalGroupsDiscussionForumWebinarArchiveResourcesCommunityStoriesBlogsPartnerCompanyDirectoryConferencesConferencesOverviewCommunitySummitAboutOurStoryContact OpenForum CommunityHome Discussion 61K Library 1.8K Blogs 381 Backtodiscussions Expandall| Collapseall sortbymostrecent sortbythread HistoricalAgedTrialBalancefortheAccountReceivable SimonNormandJan21,201411:48AMHi!WewouldliketohaveoneSmartlistthatincludeanHistoricalAgedTrialBala...BeatBucherJan21,201403:07PMHiSimon,HavealookatVictoriaYudin'swebsite...shehasafewinterestingSQLscriptsthaty...VictoriaYudinJan22,201404:41AMHiSimon,IfyoutrulywantaHistoricalAgedTrialBalance,thisisnotpossibleinSmartListb...BillMarshallJan23,201402:26PMIjustfinishedwritingacustomizationforalong-timecustomerthat'smovingoffofGPtoSAPa...MatthewPelloJan22,201401:19PMSimon,Smartlistsdon'thavetheabilitytoenteranasofdatewhichiskeytoahistoricaltri...LisaIrelandJan22,201410:27AMHaveyoucheckedouttheHistoricalAgedTrialBalanceintheSSRSreportsthatcomewithGP?---... 1.  HistoricalAgedTrialBalancefortheAccountReceivable 0 Like SimonNormand PostedJan21,201411:48AM Reply ReplyPrivately OptionsDropdown Hi!WewouldliketohaveoneSmartlistthatincludean HistoricalAgedTrialBalancefortheAccountReceivable.IntheSmartlist,weneedtheinformationinUSD(transactioncurrency)andCAD(reportingcurrency)intheSmartlist.Infact,itisthesameinformationthatisincludedintheHistoricalAgedTrialBalancefortheAccountReceivable.TheobjectiveofthisistoallowustoimportinExceltheinformationsoweanswerourauditorsrequesttohaveanagedtrialbalanceinExcelasofDec31,2013.AsecondSmartlistwouldberequiredinasimilarformatfortheAccountsPayableThanks,-------------------------------------------SimonNormandProgrammerRopackInc.MontrealQC------------------------------------------- 2.  RE:HistoricalAgedTrialBalancefortheAccountReceivable 0 Like GPUGALLSTAR BeatBucher PostedJan21,201403:07PM Reply ReplyPrivately OptionsDropdown HiSimon,Have alookatVictoriaYudin'swebsite...shehasafewinterestingSQLscriptsthatyoucouldusedirectlyinanExcelreportwithMS-Queryandbasedonthesamples,youshouldbeabletoworksomethingout...orusetheSQLcodetocreatesomenewSmartListswithSLBinGP.http://victoriayudin.com/gp-reports/receivables-sql-views/http://victoriayudin.com/gp-reports/payables-sql-views/-------------------------------------------BeatBucherBusinessAnalyst,GPAdministratorForensicTechnologyWAIInc.CoteSt-LucQC/Canada514-489-4267------------------------------------------- OriginalMessage OriginalMessage:Sent:01-21-201403:05PMFrom:SimonNormandSubject:HistoricalAgedTrialBalancefortheAccountReceivableHi!WewouldliketohaveoneSmartlistthatincludean HistoricalAgedTrialBalancefortheAccountReceivable.IntheSmartlist,weneedtheinformationinUSD(transactioncurrency)andCAD(reportingcurrency)intheSmartlist.Infact,itisthesameinformationthatisincludedintheHistoricalAgedTrialBalancefortheAccountReceivable.TheobjectiveofthisistoallowustoimportinExceltheinformationsoweanswerourauditorsrequesttohaveanagedtrialbalanceinExcelasofDec31,2013.AsecondSmartlistwouldberequiredinasimilarformatfortheAccountsPayableThanks,-------------------------------------------SimonNormandProgrammerRopackInc.MontrealQC------------------------------------------- 3.  RE:HistoricalAgedTrialBalancefortheAccountReceivable 0 Like   VictoriaYudin PostedJan22,201404:41AM Reply ReplyPrivately OptionsDropdown HiSimon,IfyoutrulywantaHistoricalAgedTrialBalance,thisisnotpossibleinSmartListbecauseSmartListwillnotacceptaparameterandyouneedatleastoneparameterforahistoricaltrailbalance(the"asofdate").Ifyou'relookingforacurrentagedtrialbalance,youcandothatinaSmartList,sinceitwilljustbetakingallthecurrentdataandwouldnotrequirethedateparameter.AndBeat'sright,Idohavesomestartingpointsforyouonmyblog(thanksBeat!).-------------------------------------------VictoriaYudinMicrosoftMVP2005-2013FlexibleSolutionshttp://www.GPReportsViewer.comhttp://victoriayudin.com------------------------------------------- 4.  RE:HistoricalAgedTrialBalancefortheAccountReceivable 0 Like BillMarshall PostedJan23,201402:26PM Reply ReplyPrivately OptionsDropdown Ijustfinishedwritingacustomizationforalong-timecustomerthat'smovingoffofGPtoSAPandwroteanexportprogramthatusestheHATBprocessinPMandRMtogenerateaSmartListforthemtothenexporttoExcel. ThecurrentformatoftheSmartListisprobablynotwhatyouwouldwantforaHATBSmartList,butwithadayortwoofwork,IcouldprobablymakeitmoresuitableforatypicalGPcustomer.Italldependsonwhatyou'dwanttoappearina SmartList. KeepinmindthattherearethreebasicsectionstotheHATB:Customer;Transaction;ApplyToDocuments. ThewaySmartListsworks,thatwouldindicatethreeseparatelists,oneforeach.-------------------------------------------BillMarshallPresidentmc2SoftwareStamfordCT2039751647------------------------------------------- OriginalMessage OriginalMessage:Sent:01-23-201402:17PMFrom:VictoriaYudinSubject:HistoricalAgedTrialBalancefortheAccountReceivableHiSimon,IfyoutrulywantaHistoricalAgedTrialBalance,thisisnotpossibleinSmartListbecauseSmartListwillnotacceptaparameterandyouneedatleastoneparameterforahistoricaltrailbalance(the"asofdate").Ifyou'relookingforacurrentagedtrialbalance,youcandothatinaSmartList,sinceitwilljustbetakingallthecurrentdataandwouldnotrequirethedateparameter.AndBeat'sright,Idohavesomestartingpointsforyouonmyblog(thanksBeat!).-------------------------------------------VictoriaYudinMicrosoftMVP2005-2013FlexibleSolutionshttp://www.GPReportsViewer.comhttp://victoriayudin.com------------------------------------------- 5.  RE:HistoricalAgedTrialBalancefortheAccountReceivable 0 Like MatthewPello PostedJan22,201401:19PM Reply ReplyPrivately OptionsDropdown Simon,Smartlistsdon'thavetheabilitytoenteranasofdatewhichiskeytoahistoricaltrialbalance. IwouldassumeyouarethinkingofasmartlistwhichwouldgeneratetheHATBbasedonthepriormonthenddate(ormaybetheprioryearenddate). SincetheHATBinvolvesrecalculatingbalancesasofahistoricaldate,thereisalotofSQLactivitytogeneratethereports. Invoicescanbeinbothopenandhistoryfiles. Todeterminebalancesonaspecificdate,theopenandhistoryapplyfilesneedtoalsobeprocessed. SoGPstoredprocedureswillcreateseveraltemporarytables,pullinalltherelevanttransactionsandthenfinallygeneratethereport.ThereisaDetailedHATBavailablethroughreportingservices. Thatcouldbemodifiedtomakean"nice"Excelexportifthatistheprimarygoal. That report callsastoredproceduressrmHATBSRSWrapperwhichinturncallsthestoredprocedurermHistoricalAgedTrialBalance. Ihaven'ttriedhookingupaSmartlisttoastoredprocedure,soIdon'tknowifthatcouldbedone. I'msurefilteringwouldbeinefficientsincethatcouldonlybedonebySmartlistafterthefullHATBhasbeengenerated.IfIwasgoingtocreateaSmartlist,IwouldcreateanightlyjobwhichrunstheabovestoredprocedureandpushesthedataintoaSQLtable. ThenbuildtheSmartlisttorunagainstthattable.SImilarstoredproceduresandreportsareavailableforPayables.-------------------------------------------MatthewPelloDirofISAmeriQuestCherryHillNJ856-382-4721------------------------------------------- OriginalMessage OriginalMessage:Sent:01-22-201411:28AMFrom:BeatBucherSubject:HistoricalAgedTrialBalancefortheAccountReceivableHiSimon,Have alookatVictoriaYudin'swebsite...shehasafewinterestingSQLscriptsthatyoucouldusedirectlyinanExcelreportwithMS-Queryandbasedonthesamples,youshouldbeabletoworksomethingout...orusetheSQLcodetocreatesomenewSmartListswithSLBinGP.http://victoriayudin.com/gp-reports/receivables-sql-views/http://victoriayudin.com/gp-reports/payables-sql-views/-------------------------------------------BeatBucherBusinessAnalyst,GPAdministratorForensicTechnologyWAIInc.CoteSt-LucQC/Canada514-489-4267-------------------------------------------OriginalMessage:Sent:01-21-201403:05PMFrom:SimonNormandSubject:HistoricalAgedTrialBalancefortheAccountReceivableHi!WewouldliketohaveoneSmartlistthatincludean HistoricalAgedTrialBalancefortheAccountReceivable.IntheSmartlist,weneedtheinformationinUSD(transactioncurrency)andCAD(reportingcurrency)intheSmartlist.Infact,itisthesameinformationthatisincludedintheHistoricalAgedTrialBalancefortheAccountReceivable.TheobjectiveofthisistoallowustoimportinExceltheinformationsoweanswerourauditorsrequesttohaveanagedtrialbalanceinExcelasofDec31,2013.AsecondSmartlistwouldberequiredinasimilarformatfortheAccountsPayableThanks,-------------------------------------------SimonNormandProgrammerRopackInc.MontrealQC------------------------------------------- 6.  RE:HistoricalAgedTrialBalancefortheAccountReceivable 0 Like LisaIreland PostedJan22,201410:27AM Reply ReplyPrivately OptionsDropdown HaveyoucheckedouttheHistoricalAgedTrialBalanceintheSSRSreportsthatcomewithGP? -------------------------------------------LisaIrelandAcCountingOnComputersIncorporated------------------------------------------- OriginalMessage OriginalMessage:Sent:01-22-201410:25AMFrom:SimonNormandSubject:HistoricalAgedTrialBalancefortheAccountReceivableHi!WewouldliketohaveoneSmartlistthatincludean HistoricalAgedTrialBalancefortheAccountReceivable.IntheSmartlist,weneedtheinformationinUSD(transactioncurrency)andCAD(reportingcurrency)intheSmartlist.Infact,itisthesameinformationthatisincludedintheHistoricalAgedTrialBalancefortheAccountReceivable.TheobjectiveofthisistoallowustoimportinExceltheinformationsoweanswerourauditorsrequesttohaveanagedtrialbalanceinExcelasofDec31,2013.AsecondSmartlistwouldberequiredinasimilarformatfortheAccountsPayableThanks,-------------------------------------------SimonNormandProgrammerRopackInc.MontrealQC------------------------------------------- × NewBestAnswer Thisthreadalreadyhasabestanswer.Wouldyouliketomarkthismessageasthenewbestanswer? No Ifyou'vefoundthisthreaduseful,divedeeperintoUserGroupcommunitycontentbyrole overlayandnegativeCSS cssforhidingmenuitems Canvas1 Layer1 CreatedwithSketch.CreatedwithSketch.CreatedwithSketch.CreatedwithSketch.CreatedwithSketch.CreatedwithSketch.CreatedwithSketch. Canvas1 Layer1 Group_291 Graphic_292 Group_289 Graphic_290 Group_287 Graphic_288 Group_285 Graphic_286 Group_283 Graphic_284 Group_281 Graphic_282 Group_279 Line_280 Group_277 Line_278 Group_275 Line_276 Canvas1 Layer1 Canvas_1 Canvas_1:Layer1 Graphic_175 Graphic_195 Graphic_177 Graphic_180 Graphic_200 Graphic_204 Graphic_203 Graphic_207 Graphic_206 Graphic_209 Graphic_212 Graphic_217 Line_222 Graphic_201 Graphic_210 Graphic_213 Graphic_178 Graphic_181 Graphic_216 Canvas1 Layer1 Canvas1 Layer1 ? Canvas1 Layer1 Canvas_1 Canvas_1:Layer1 Graphic_430 Line_432 Line_456 Line_457 Line_459 Line_460 Graphic_358 CreatedwithSketch.CreatedwithSketch. new_window CreatedwithSketch. Graphic_358 btnclasses addjoinbutton lastoftypehome Receiveemailnotificationsforthe2021GPTechConference. × Close ContactFAQPrivacyPolicyCodeofConduct MembershipJointheUserGroupMembershipBenefitsPricingParticipateLocalGroupsWebinarArchiveResourcesCommunityStoriesBlogsPartnerCompanyDirectoryConferencesConferencesOverviewCommunitySummitAboutOurStoryContact Copyright©2022DynamicCommunities,Inc.Allrightsreserved. PoweredbyHigherLogic