Finance | Project Operations, Human Resources, ...

Trial Balance displays Inactive Accounts even though the checkbox is unmarked

(0) Share

Report

Posted on by ZGP

Trial Balance reports are still displaying accounts that have been marked as inactive on their card. The "Include Inactive Accounts" checkbox is unmarked in the Trial Balance Report Options screen and, yet, the accounts appear. Any solutions?

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (8)

Answers (0)

Lisa at AonC.com 937 Super User 2025 Season 2 on at

Like (0)

Report

Is it possibly a modified version of the report?

Was this reply helpful? Yes No
Nicole Hellerud 1,712 on at

Like (0)

Report

Hi ZGP-

Thank you for your post.

I'd first check whether or not the General Ledger Trial Balance report is modified or not. If yes, I'd recommend testing the core GP report.

You could also try rebuilding the reports.dic file Re-create the Reports.dic file - Dynamics GP | Microsoft Docs

Are you running the GP GL TB or is this being generated via SSRS? If SSRS, does the same issue occur in GP?

What version/build of Microsoft Dynamics GP is being used?

I appreicate your feedback when available.

Nicole Sutton
Support Engineer
Microsoft Dynamics

Was this reply helpful? Yes No
ZGP 5 on at

Like (0)

Report

Hello and thanks for the reply! It is not a modified report and if I use the core GP report, the same issue arises when I have the same parameters set. I am running the GP trial balance, not via SSRS. Version is Dynamics 2018. For the options set on the report, I currently have it set to Include: Posting Accounts, Unit Accounts, and Zero Balance/No Trx. The accounts I have marked inactive that are still showing on the report have zero balance and no transactions for the year. Is it possible the interaction of telling it to include Zero Balance/No Trx is overriding the option to exclude inactive accounts? Basically, I'd prefer the report to exclude all accounts marked inactive, but also still display ACTIVE zero balance accounts. Hope that makes sense. Thanks again.

Was this reply helpful? Yes No
Suggested answer

Cheryl Waswick on at

Like (0)

Report

If the GL account has a balance in that year, then it will still print on the TB report with the words 'Inactive Account' next to it. This is by design, as a safe-guard so financials are not skewed for that year.

Was this reply helpful? Yes No
ZGP 5 on at

Like (0)

Report

Thanks for the response, Cheryl. I have several accounts printing on the TB that have not had balances in the year and show "Inactive Account" next to them.

Was this reply helpful? Yes No
Cheryl Waswick on at

Like (0)

Report

The system is seeing a reason that it can't exclude it, since it is listing it and putting 'inactive account' next to it to alert the user. Check to see if the account is a 'balance sheet' type account and also check GL inquiry to see if it has a beginning balance that is rolling forward.

Was this reply helpful? Yes No
ZGP 5 on at

Like (0)

Report

Agree it must be finding a setting somewhere that isn't allow TB to exclude it. It's marked as Balance Sheet and Cash with no balance rolling forward year to year. I tried unchecking "Allow Account Entry" on the GL card, but it did not change anything on the TB report. It's such a small nuisance, but it has me stumped.

Was this reply helpful? Yes No
Cheryl Waswick on at

Like (0)

Report

If you are printing a current year TB report, then I would find the account index for it in the GL00100 table, and then search the GL20000 and GL10110 tables for that account index. If you find this account index existing on a record in either of these open year tables, then that would be why.

Was this reply helpful? Yes No