Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[James Wheeler]

We are a new of accounts receivable in Microsoft Dynamics GP.  
How can we get a historical aged trial balance in an excel format without out zero balance accounts??

——————————
James Wheeler
Controller
The Pond Guy
Armada MI
——————————

[Thomas Garcia]

Hi James.

You can us the built-in SQL Reporting Services Report (sample attached).  I personally like to build a customized view to make it cleaner, but this should work.

Hope it helps!

——————————
Thomas Garcia
ICON Business Consulting, LLC | Cooper City FL
ICON, SRL | Santiago, Dominican Republic
954-804-2140
——————————
——————————————-

[Blair Christensen]

?You can also enable Excel reporting and have the report generate a refreshable Excel workbook.  The SSRS one is nice if you have someone who can tinker with it to meet your needs.

——————————
Blair Christensen
Database Administrator
Oppenheimer Companies, Inc.
Boise ID
——————————
——————————————-