Smartlist Builder Historical Aged Trial Balance (AR, AP, Inventory)

(0) Share

Report

Posted on by JBS ERP

1,175

We are wondering if anyone know how to build the Historical Aged Trial Balance report with Smartlist Builder. If we work with the current data, smartlist builder will work fine. However, we are not sure how we specify the date in the past to generate the Historical Aged Trial Balance with Smartlist Builder. We currently use the GP report for those historical aged trial balance, and export to csv file. However, we have to work on to organize the excel a lot to look better. We hope using the smartlist builder might help, but we need advise how we can specify the as of date which we can do with the GP report.

Thank you in advance.

Jbserp

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Frank Hamelly | MVP... 46,627 Moderator on at

Like (0)

Report
Copy link

Link copied!

What version GP you on? GP2010 and 2013 have canned SSRS reports for these. If on an older version, it would still be easier to develop in SSRS than SmartList Builder.

Was this reply helpful? Yes No
Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
Copy link

Link copied!

I have previously developed the Historical Inventory Trial Balance per period to be deployed for Smart List Builder. Find the SQL View on Dynamics GP Essentials, on the following link;

Historical Inventory Trial Balance - per Period

Hope this helps,

Was this reply helpful? Yes No
JBS ERP 1,175 on at

Like (0)

Report
Copy link

Link copied!

We use GP 2010. We will look into the SSRS report. Can we generate Historical Inventory Trial Balance with SSRS report?

Was this reply helpful? Yes No
JBS ERP 1,175 on at

Like (0)

Report
Copy link

Link copied!

Hi Mahmound, thank you for the link. We'll try the script.

Was this reply helpful? Yes No
rlmcvicar 380 on at

Like (0)

Report
Copy link

Link copied!

Did you ever find a AP (payables) example? if so can you share. I appreciate Mahmoud's reply however it was for AR I believe.

Was this reply helpful? Yes No