Detail Historical Aged Trial Balance problem

When I run the Detail Historical Aged Trial Balance for Receivables it shows items that have been in History for years. I ran the historical and regular ... SBX-Heading Helpfulresources SBX-AskQuestions CommunityForums Askaquestion SBX-RBEPersonalizedColumnEqualContentCard Personalizeyourexperience! PersonalizedCommunityishere! Quicklycustomizeyourcommunitytofindthecontentyouseek. PersonalizeCommunityNow Name FEATUREDCONTENT ChooseyourpathIncreaseyourproficiencywiththeDynamics365applicationsthatyoualreadyuseandlearnmoreabouttheappsthatinterestyou.Upyourgamewithalearningpathtailoredtotoday'sDynamics365mastermindsanddesignedtoprepareyouforindustry-recognizedMicrosoftcertifications. VisitMicrosoftLearn Name PRODUCTUPDATES 2022ReleaseWave2CheckoutthelatestupdatesandnewfeaturesofDynamics365releasedfromOctober2022throughMarch2023 ReleaseOverviewGuidesandVideos ReleasePlan Preview2022ReleaseWave2 Name FASTTRACK TheFastTrackprogramisdesignedtohelpyouaccelerateyourDynamics365deploymentwithconfidence.  FastTrackCommunity| FastTrackProgram  |  FinanceandOperationsTechTalks  |  CustomerEngagementTechTalks  |  UpcomingTechTalks |AllTechTalks Share Twitter LinkedIn Facebook Email Print RSS MicrosoftDynamicsGPForum Daisy_P askedaquestionon10Feb20159:50AM MyBadges DetailHistoricalAgedTrialBalanceproblem Verified WhenIruntheDetailHistoricalAgedTrialBalanceforReceivablesitshowsitemsthathavebeeninHistoryforyears. Iranthehistoricalandregularagedtrialbalancewithadateoftodayandthereareseveralitemsonthehistoricalthatarenotontheregular. Anyideashowtoremovethemfromthehistoricalreportsoitwillbeaccurate? Thanksforyourhelp! historical MicrosoftDynamicsGP10.0 Other Receivables trialbalance Reply Replies(9) AllResponses OnlyAnswers TimW respondedon10Feb201510:05AM MyBadges DetailHistoricalAgedTrialBalanceproblem Verified TherearesomenumberofrogueapplyrecordsormissingrecordsinetherRM20201orRM30201(orboth) whichcausethisissueandI'veseenitanumberoftimes.  IfyouqueryRM20201andRM30201whereAPTODCNM=youwillseethatthetotalsofthe actualapplyrecords(as opposedtothecurrenttrxamountinRM20101 RM30101whichwouldsayzero)wontaddtothedocumenttotal. WhenGPdoestheHATBittakesthedocumentamountthensubtractsofftheappliedamountsitfindswithinthedateyouspecifysoitcandoan'AsWas'report.  I'veevenseenthedocumentamountgonegativeinthereportwhentherewere'extra'applyrecords. I'vedecided thattheApply/Un-Apply/RemovePaidTransactionsprocessesarenotdoneinatransactionstatesoyouareatthemercyoftheprocesscompletingcorrectly.  I'veseen thisissue comeuplikethismanytimesovertheyears.    I'vealwayshadtofixthisfromSQLbothinsertingmissingrecords(that'spurepain) anddeletingextraones, I'veneverhadchecklinksfixthisissuebutothersheremighthaveadifferentexperience. Best Tim    Reply MarlenaStark respondedon10Feb20157:28PM LinkedIn Blog Website DetailHistoricalAgedTrialBalanceproblem Unanswered Startbyverifyingthatbothreportsareexcludingthesamevaluesinreportoptionswindow.IwouldexcludeFullyPaidDocuments,ZeroBalance,Noactivity.Also,makesurethatbothreportshavethesameselectionasHistoricalTrialbalancecanbebyDocumentDatewhileARTrialBalancewithOptionsisbyGLPostingDateandnootherrestrictionsareselected.Reprintreports.Checkthetotals.Ifthereisadifferencebetweenthetwo,thenyoumayhavemissingapplyrecordsormayhavedamagedrecordsinyourhistoricalapplytables. TheATBpullsfromtheopentable.TheHATBpullsfromtheOpenandHistorytables. Reply Daisy_P respondedon12Feb20151:02PM MyBadges DetailHistoricalAgedTrialBalanceproblem Unanswered Wewilltrythat. Thanks! Reply Daisy_P respondedon12Feb20151:03PM MyBadges DetailHistoricalAgedTrialBalanceproblem Unanswered Bothreportsaresetupexactlythesame.  Reply SandipJadhav respondedon12Feb20151:10PM MyBadges DetailHistoricalAgedTrialBalanceproblem Unanswered HiDaisy, DidyoutrytoremovepaidtransactionremovalfromTools-->Routines-->Sales-->PaidTransactionRemoval. PleasedothisR&DonyourtestenviornmentandbeforerunningPaidTransactionRemovalonProductionkeepgoodbackup. ItwillmoveallyourfullypaidtransactionsintoHistoricaltables. ThanksSandip Reply Daisy_P respondedon17Feb201511:04AM MyBadges DetailHistoricalAgedTrialBalanceproblem Unanswered Ididpaidtransactionremovalanditdidn'tmakeadifference. Theitemsarealreadylistedashistory,theydonotshowopen. Yettheyshowonthetrialbalancereporteventhoughtheyhavebeeninhistoryforyears.  Reply BillCampbell respondedon25Feb20153:08PM LinkedIn MyBadges DetailHistoricalAgedTrialBalanceproblem Unanswered Tim,doyouknowifthesamewouldapplytoMulticurrencytransactions? WehaveacasefromaclientwithZEROintheFunctionalCurrency,butshowingamountsintheReportingcurrency. Thanksforthefeedback Reply TimW respondedon26Feb20151:10PM MyBadges DetailHistoricalAgedTrialBalanceproblem Unanswered HiBill. NotsomuchasdetailedaboveforthatbutprobablythereareissueswiththeMC020102tablewhichholdsthecurrencyvaluesforMCtransactions. Ifyouqueryitagainstthedocumentsinquestionyouwillprobablyseethoserecordsmisrepresentedthere. Reply ateel7 respondedon21Apr20178:28AM DetailHistoricalAgedTrialBalanceproblem Unanswered Bump.Anyanswertothis?Havingsameissue. Reply TimW respondedon10Feb201510:05AM MyBadges DetailHistoricalAgedTrialBalanceproblem Verified TherearesomenumberofrogueapplyrecordsormissingrecordsinetherRM20201orRM30201(orboth) whichcausethisissueandI'veseenitanumberoftimes.  IfyouqueryRM20201andRM30201whereAPTODCNM=youwillseethatthetotalsofthe actualapplyrecords(as opposedtothecurrenttrxamountinRM20101 RM30101whichwouldsayzero)wontaddtothedocumenttotal. WhenGPdoestheHATBittakesthedocumentamountthensubtractsofftheappliedamountsitfindswithinthedateyouspecifysoitcandoan'AsWas'report.  I'veevenseenthedocumentamountgonegativeinthereportwhentherewere'extra'applyrecords. I'vedecided thattheApply/Un-Apply/RemovePaidTransactionsprocessesarenotdoneinatransactionstatesoyouareatthemercyoftheprocesscompletingcorrectly.  I'veseen thisissue comeuplikethismanytimesovertheyears.    I'vealwayshadtofixthisfromSQLbothinsertingmissingrecords(that'spurepain) anddeletingextraones, I'veneverhadchecklinksfixthisissuebutothersheremighthaveadifferentexperience. Best Tim    Reply UHF-Footer