Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Darin Vialpando]

Does anyone have the code for the view of the Historical Aged Trial Balance?

——————————
Darin Vialpando
Business Applications Manager
Kroenke Sports & Entertainment
Denver CO
——————————

[Rod O’Connor]

Hi ,

Which HITB are you looking for?  AR, AP, or IV?

Thanks,
Rod?

——————————
Rod O’Connor
President
Briware Solutions Inc.
Oakville ON
——————————
——————————————-

[Kristen Hosman]

the AR?

——————————
Kristen Hosman
Dynamics ERP Consultant
Briware Solutions Inc.
Pine CO
——————————
——————————————-

[Jo deRuiter]

?Hi!

If you are talking about the out-of-the-box GP report OR the out-of-the-box SSRS for GP report then that one is built on a series of Stored Procedures.  You should be able to find it if you have access to SQL under the Programmability for the database.

I think the main call is dbo.pmHistoricalAgedTrialBalance

——————————
Regards,

Jo deRuiter
“That GP Red Head”
Senior Financial Systems Consultant
Heartland Business Systems, LLC
Little Chute WI
920-687-4797 (Work)
770-906-4504 (Cell)
——————————
——————————————-

[Windi Epperson]

Hey ,
Not sure what the end goal is but I thought this was interesting so I’d throw it in:  https://qfactorconsulting.wordpress.com/2012/02/17/doing-the-impossible/

As Jo said, you can also export the SRS report easily to Excel.
Thanks
Windi
?

——————————
Windi Epperson
President/GP Senior Consultant
Advanced Integrators, Inc.
Norman OK
405-946-1774 Ext 102
——————————
——————————————-

[Kristen Hosman]

is looking for an Excel friendly historical trial balance?

——————————
Kristen Hosman
Dynamics ERP Consultant
Briware Solutions Inc.
Pine CO
——————————
——————————————-

[Steve Erbach]

I wrote two blogs on creating a refex from the RM HATB.

Regards,

——————————
“Sparkly” Steve Erbach – Business Analyst
GLC Minerals, LLC – Green Bay, WI
Co-Chair, GPUG WI (Green Bay) Chapter
GP 2016 R2 (16.00.0579) / MR 2012 CU16
Blog: https://www.gpug.com/blogs/steve-erbach
Twitter: twitter.com/serbach
——————————
Welcome to Dynamics!
You do not have permission.
Call Steve.
(hat tip: Lou Spevack)
——————————
——————————————-

[Steve Gray]

Historical Aged Trial Balance script

Dyndeveloper		remove preview
Historical Aged Trial Balance script exec seermHATBSRSWrapper @I_dAgingDate=’2014-07-16 00:00:00′, @I_cStartCustomerNumber=N’a’,@I_cEndCustomerNumber=N’b’, @I_cStartCustomerName=N”,@I_cEndCustomerName=N” … View this on Dyndeveloper >

Historical Aged Trial Balance script

Dyndeveloper		remove preview
Historical Aged Trial Balance script IF exists (select * from INFORMATION_SCHEMA.ROUTINES where ROUTINE_NAME = ‘dd_RMHistoricalAgingSummary’) begin DROP proc dd_RMHistoricalAgingSummary end GO CREATE proc dd_RMHistoricalAgingSummary – View this on Dyndeveloper >

http://dynDeveloper.com/Article/CFFD

I’ve done a bunch of blogging on this…

——————————
Steve Gray
Vice President of Development
941-747-3669
DynDeveloper.com
Training GP Developers at DynDeveloper.com
Bradenton FL
——————————
——————————————-

[Mark Polino]

There is an option to just buy an Excel friendly option and not have to deal with fun (bugs) in certain Excel versions.

http://mpolino.com/gp/historical-excel-reporting/

——————————
Mark Polino
Director of Client Services
Fastpath
Altamonte Springs FL
——————————
——————————————-