Historical Aged Trail Balance report runs slow - Google Groups

You say you are running a Historical Aged Trial Balance, and later ... set up in Great Plains when this user prints the report? (Even if it's Groupsmicrosoft.public.greatplainsConversationsAboutHistoricalAgedTrailBalancereportrunsslow259viewsSkiptofirstunreadmessageGSunread,Dec8,2005,9:32:44AM12/8/05ReplytoauthorSignintoreplytoauthorForwardSignintoforwardDeleteLinkReportmessageasabuseSignintoreportmessageasabuseShoworiginalmessageEitheremailaddressesareanonymousforthisgrouporyouneedtheviewmemberemailaddressespermissiontoviewtheoriginalmessagetoI'mtheDBAatmycompany,andI'vebeenaskedtoresearchwhyaHistoricalAgedTrailBalancereporttakesover1.5hourstorun,printingtothescreen.I'mnotfamiliarwithGreatPlainsatall,andIwasnotinvolvedintheinstallationofourcurrentversion,butIthinkweuse7.5.Thisreportrunsprettyfastwhenrestrictionsareusedtofilterdowntooneortwocustomersforashorttimeframe,butourcontrollerlikestorunthereportfromFirstto11/30/2005,andIbelievewehaveatleastthreefullyearsofcustomer/invoicedatainthisdb.Isitreasonabletoexpectareportthathits/processesthatmuchdatatorunforthatlong?Thanks!GaryRobertCunread,Dec8,2005,4:56:42PM12/8/05ReplytoauthorSignintoreplytoauthorForwardSignintoforwardDeleteLinkReportmessageasabuseSignintoreportmessageasabuseShoworiginalmessageEitheremailaddressesareanonymousforthisgrouporyouneedtheviewmemberemailaddressespermissiontoviewtheoriginalmessagetoHelloG.S.YousayyouarerunningaHistoricalAgedTrialBalance,andlatermentioncustomers.IthereforetakeitthatyouarunningaReceivablesHATB.Thelengthtakenwhenunrestrictedlikeyoumention,itisconceiveableforthereporttotakethatlong.Thereasonbeingthatforeachinvoicethepreprocessingcheckswhetherthisgivendocumentwasappliedwithinthegivendaterangeandthatthegivenapplydocumentwasalsoenteredwithinthegivendaterange.Ifitsucceedsbothteststhedocumentwouldnotbedisplayed,butdoestakeupprocessingtime.Itislikelythatmostdocumentsshouldhavebeenpaidoff,andthereforewouldnotdisplay,butarestillundergoingthosechecks.Thereforeyouaremakingitworkexcessivelyforlittlegain.Ifyouarenotconcernedaboutwhetheradocumentwaspaidoffbyancashreceiptrecievedorappliedoutsidethedaterange,usethe'Agedtrialbalance'reportinstead.Victoria[MVP]unread,Dec8,2005,7:23:36PM12/8/05ReplytoauthorSignintoreplytoauthorForwardSignintoforwardDeleteYoudonothavepermissiontodeletemessagesinthisgroupLinkReportmessageasabuseSignintoreportmessageasabuseShoworiginalmessageEitheremailaddressesareanonymousforthisgrouporyouneedtheviewmemberemailaddressespermissiontoviewtheoriginalmessagetoGary,AsRobertsays,it'spossiblethatitwouldtakethislong,buttheremaybesomethingsyoucoulddotospeeditup.Howmanypagesareonthereportwhenitfinallyprints?(Thisshouldgiveusabetterideaofwhetheritshouldreallytake1.5hrs).HaveyoutriedprintingthereportdirectlyontheSQLserver?Doesitstilltakethesameamountoftime?Itwouldhelptoknowtheexactversionandservicepackyou'reon.AlsowhatprinterissetupinGreatPlainswhenthisuserprintsthereport?(Evenifit'sbeingprintedtothescreen,thereportwillusetheprinterdriverfortheprintercurrentlysetupinGP.)--VictoriaYudinGPMVP"GS"wroteinmessagenews:%23a1zMd5%[email protected]...[email protected],Dec8,2005,10:14:03PM12/8/05ReplytoauthorSignintoreplytoauthorForwardSignintoforwardDeleteLinkReportmessageasabuseSignintoreportmessageasabuseShoworiginalmessageEitheremailaddressesareanonymousforthisgrouporyouneedtheviewmemberemailaddressespermissiontoviewtheoriginalmessagetoThanksforthereplies.I'llrunthisinfobyourcontrollerandITmanagertoseeiftheAgedTrialBalancewouldworkforthem.Theunrestrictedhistoricalagedtrialbalancereporthas149pages.Thisparticularclientpchasnoprintersdefined,butthecontroller'spchasafew(oneortwoinkjetsandoneortwolasers).By"printingthereportdirectlyonthesqlserver,"doyoumeanrunningthemainstoredprocinqueryanalyzer?Ihavenotdonethis,althoughIdidviewtheestimatedexecutionplaninQA,withwhatiassumedtobethenecessaryparameters(enddate)andsomefudgingtogettheoptimizertorecognizeafewnecessarytemptablesusedbythestoredproc...theexecutionplanlistedtablescansontheConstantstable,butnothingelseseemedobviousfromaqueryperformancestandpoint...thisseemstobeanissuewiththesheeramountofdatathat'sbeingprocessed.VersionInformation:GreatPlains-7.50g3Dexterity-7.50m003SmartList-7.50.3Database-SQLServer(2000)System-WindowsXPODBCDriverManager-03.52.0000ODBCDriver-03.85.1117SessionInformation:Size-9617mbThanksagain!GaryVictoria[MVP]unread,Dec9,2005,3:22:13AM12/9/05ReplytoauthorSignintoreplytoauthorForwardSignintoforwardDeleteYoudonothavepermissiontodeletemessagesinthisgroupLinkReportmessageasabuseSignintoreportmessageasabuseShoworiginalmessageEitheremailaddressesareanonymousforthisgrouporyouneedtheviewmemberemailaddressespermissiontoviewtheoriginalmessagetoGary,149pagesisafairlylargereport.ButIstilldon'tthinkitshouldnecessarilytakethatlong.Ithinkyou'reexactlyrightinthatit'stheamountofthedata.WhatIhaveseeninthepastisthatwhenGPtriestosendalotofdatatoareportitissometimessloweddownsignificantlyby2variables:thenetworkconnectiontotheSQLServerandtheprinter(thiscouldbetheprinteritself,theprinterdriver,theprintserver,etc.,andcouldalsodependonthenetwork).That'swhyIwasaskingaboutwhatkindofprinterandtryingtorunthisdirectlyontheserver.(AndwhatImeantbythatisdoingthesamethingthattheuserisdoingintheGPinterface,butdirectlyontheSQLserveriftheGPapplicationisinstalledthere.)OneofourcustomerswhentheyfirststartedusingGP(version7.5)usedtocrashinthemiddleofalmosteverycheckrun.Ittookusawhiletofigureoutthatitwasbecausetheircheckrunswereusually200+checksandtheirprintercouldn'thandleit.Theyupgradedtoanew,morepowerfulprinterandeverythinghasbeenfinesincethen.Hopethishelpsyou.--VictoriaYudinGPMVP"GS"wroteinmessagenews:[email protected]...ZachMorganunread,Dec9,2005,3:48:03AM12/9/05ReplytoauthorSignintoreplytoauthorForwardSignintoforwardDeleteLinkReportmessageasabuseSignintoreportmessageasabuseShoworiginalmessageEitheremailaddressesareanonymousforthisgrouporyouneedtheviewmemberemailaddressespermissiontoviewtheoriginalmessagetoIntheAR/SOPmoduleyoucangotoRoutines/Agingandputinanagingdate(lastdayofmonth).Thenusesmartlistsundercustomersandcreateyourownaging.UsethecolumnsAgeingPeriodAmount1..2..3...4etc.Thisofcoursewillnotprovidetransactiondetail,butwillgiveaquickagingthatshouldtietotheGLandcanbeexportedandsavedinsoftcopy.LisaKoehntop[MSFT]unread,Dec15,2005,12:48:56AM12/15/05ReplytoauthorSignintoreplytoauthorForwardSignintoforwardDeleteLinkReportmessageasabuseSignintoreportmessageasabuseShoworiginalmessageEitheremailaddressesareanonymousforthisgrouporyouneedtheviewmemberemailaddressespermissiontoviewtheoriginalmessagetoHiGary,Itlookslikeyouhavebeengettinggreathelphere!OnethingIamwonderingisifitwouldbepossibleforthecontrollertoenteradateintheFirstvalueinsteadofleavingitasFirst.Thiswoulddecreasetheamountofrecordsthesystemwouldhavetosortthrough.Yousaidyouhavethreeyearsofdata.Iftherearen'tanyoutstandinginvoicesforprioryears,couldthereportbeprintedfrom7/1/2005to11/30/2005forexample?Doesthatincreasetheprocessingofthereportforyou?Also,IrecommendyoureviewthelistofsupportedprintersforGreatPlains7.5.Itisbesttoprintthisreportwithasupportedprintersetasthedefaultprinter.AsVictoriasaid,thisprinterdriverisusedtoprintthereporttothescreen.HereisthePrinterCompatibilityList:https://mbs.microsoft.com/customersource/support/documentation/SystemRequirements/compatibility_GP7.5_printers.htm.Thankyou,LisaMicrosoftOnlineSupportEngineerGetSecure!-www.microsoft.com/security=================================================Whenrespondingtoposts,please"ReplytoGroup"viayournewsreadersothatothersmaylearnandbenefitfromyourissue.=================================================Thispostingisprovided"ASIS"withnowarranties,andconfersnorights.--------------------Thread-Topic:HistoricalAgedTrailBalancereportrunsslowthread-index:AcX8ME0GKOe0vEJuSxOjiQngH8fsrQ==X-WBNR-Posting-Host:12.179.188.5From:"=?Utf-8?B?WmFjaCBNb3JnYW4=?="References:Subject:Re:HistoricalAgedTrailBalancereportrunsslowDate:Thu,8Dec200511:48:03-0800Lines:85Message-ID:MIME-Version:1.0Content-Type:text/plain; charset="Utf-8"Content-Transfer-Encoding:7bitX-Newsreader:MicrosoftCDOforWindows2000Content-Class:urn:content-classes:messageImportance:normalPriority:normalX-MimeOLE:ProducedByMicrosoftMimeOLEV6.00.3790.0Newsgroups:microsoft.public.greatplainsNNTP-Posting-Host:TK2MSFTNGXA03.phx.gbl10.40.2.250Path:TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gblXref:TK2MSFTNGXA02.phx.gblmicrosoft.public.greatplains:20641X-Tomcat-NG:microsoft.public.greatplainsGSunread,Dec15,2005,12:52:15PM12/15/05ReplytoauthorSignintoreplytoauthorForwardSignintoforwardDeleteLinkReportmessageasabuseSignintoreportmessageasabuseShoworiginalmessageEitheremailaddressesareanonymousforthisgrouporyouneedtheviewmemberemailaddressespermissiontoviewtheoriginalmessagetoThankyouallforyoursuggestionsandhelp.Thereportisbacktorunningin~30minutessincewereindexedthedatabase,sothat'sapositivestep.Iwillalsocheckhisprinteragainstthelisttoseeifthatcouldbepartoftheproblem.Interestingly,speakingofprinterdrivers,theothernightthecontrollershowedmehowhisreport(notsurewhichone)wasrenderingonhisclientscreenatarateof~1pageevery3minutes.Itwasbizarrewatchingthepagecounterstayon13for3minutes,thenwatchitchangeto14allofasudden.......Thisseemslikeitcouldbeaprinterissue.Thanksagain!GaryGSunread,Dec17,2005,2:09:55AM12/17/05ReplytoauthorSignintoreplytoauthorForwardSignintoforwardDeleteLinkReportmessageasabuseSignintoreportmessageasabuseShoworiginalmessageEitheremailaddressesareanonymousforthisgrouporyouneedtheviewmemberemailaddressespermissiontoviewtheoriginalmessagetoWell,nowI'mnotsosurethattheprinterhasanythingtodowithourparticularproblem.EachmemberinourA/Rstaffusesoneoffourprinters.TheonlyonethatisonthecompatibilitylististheHPLaserjet1200.IrantheHATBreport(nodaterangeorotherrestrictions)fromthisworkstation,andittook50minutestocomplete(atleastthat'showlongthemainstoredproctooktorun).Backtothedrawingboard...GaryVictoria[MVP]unread,Dec17,2005,2:38:20AM12/17/05ReplytoauthorSignintoreplytoauthorForwardSignintoforwardDeleteYoudonothavepermissiontodeletemessagesinthisgroupLinkReportmessageasabuseSignintoreportmessageasabuseShoworiginalmessageEitheremailaddressesareanonymousforthisgrouporyouneedtheviewmemberemailaddressespermissiontoviewtheoriginalmessagetoGary,It'snotsomuchifit'sonthelistornot,Ihaveuseddozensofprintersnotonthesupportedlistsuccessfully.Whatismuchmoreimportantishowmuchmemorytheprinterhas,whatprinterdriveryou'reusing,etc.IamnotsureIwouldexpectaLaserjet1200tohavegoodperformanceforthissizeofareport.--VictoriaYudinGPMVP"GS"wroteinmessagenews:[email protected]...Dukesterunread,Dec22,2005,12:48:02PM12/22/05ReplytoauthorSignintoreplytoauthorForwardSignintoforwardDeleteLinkReportmessageasabuseSignintoreportmessageasabuseShoworiginalmessageEitheremailaddressesareanonymousforthisgrouporyouneedtheviewmemberemailaddressespermissiontoviewtheoriginalmessagetoFewquestionswhichthegrouphaven'taskyou:1)HowdotheusersaccessGP?2)HowmanyGPserversdoyouhave?Ifmorethanone,areallonthesameOS?3)HaveyoutriedprintingtoFile?Doesitrunonsameamountoftimecomparedtoprintingtoaprinter?--http://ddelprado.blogspot.comReplyallReplytoauthorForward0newmessages