Smartlist for Trial Balance

(0) Share

Report

Posted on by Jo-Ann M

295

Is there a simple way to run a single smartlist that would incorporate the Balance sheet accounts ytd balance per row? The default report has an amount for each period.

*This post is locked for comments

All responses (6)

Answers (0)

Suggested answer

Victoria Yudin 22,768 on at

Like (0)

Report

RE: Smartlist for Trial Balance

Jo-Ann,

You might find this helpful if you're using FRx: victoriayudin.com/.../dynamics-gp-trial-balance-in-excel-using-frx
Frank Hamelly | MVP... 46,527 Super User 2025 Season 1 on at

Like (0)

Report

RE: Smartlist for Trial Balance

Yeah, there's no easy way to get a TB out of SmartList. Use the Report Wizard in FRx. That should have you going in no time. Let us know if you need further guidance.
Jo-Ann M 295 on at

Like (0)

Report

RE: Smartlist for Trial Balance

Thanks Frank. I was trying to take the "easy" way out by using Smartlist. FRX was my next option. I don't use it too often so it's always somwhat challenging.
Frank Hamelly | MVP... 46,527 Super User 2025 Season 1 on at

Like (0)

Report

RE: Smartlist for Trial Balance

Jo-ann, could you use FRx or Management Reporter to meet your requirements? Either reporting tool is very capable of creating a GL Trial Balance.
Jo-Ann M 295 on at

Like (0)

Report

RE: Smartlist for Trial Balance

Thanks however Smartlist Builder is not an option and i'm too low in the organization food chain to have direct access to SQL :(

I'm familiar with all of the other reports.
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Smartlist for Trial Balance

You could print YTD GL Trial Balance as shown in the reference below;

GPtip42day - Non-consecutive accounts Trial Balance

As for having a YTD trial balance, you could script out the "GL Trial Balance", along with having Smart List Builder in order have your script in Dynamics GP SmartList. Here is another reference for consideration, it needs a bit of enhancement to have YTD GL Trial Balance;

SQL Query for GL Trial Balance – GP 2010

Hope this helps,