Detail Trial Balance report not working when restricting to one account.

(0) Share

Report

Posted on by Community Member

We updated this clients CoA using PSTL. We are not sure if this was happening before the change, but now when we run a Detail Trial Balance report, and restrict to one account (any account), the report is blank. If I rerun the report with a range, the report prints correctly, and the initial account displays activity.

Any thoughts would be appreciated.

Pete

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

Did you run checkink against financial and run the trial balance.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for your reply. Yes we did run checklinks, but are still having the same issue. I just checked to see if this occurs in multiple companies, which it does, but it only seems to affect companies that we converted accounts using the PSTL Account modifier.

Was this reply helpful? Yes No
babubaskaran@outloo... 12 on at

Like (0)

Report

Is the summary trial balance works on single account

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

It does not work on the summary trial balance for one account either, but does for multiple accounts.

Was this reply helpful? Yes No
Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

Hi,

Have you run the checklink against the Series-System & Company, it might worth trying the same.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello Babu,

Thanks for your replies. I thought we might be dealing with a corrupt reports dictionary, but after you had asked about the Account Summary TB, I realized this was not report specific. I rebuilt the GL00105 table, and now the Trial Balance Detail and Summary are working when restricting to one account.

Thanks again,

Pete

Was this reply helpful? Yes No
babubaskaran@outloo... 12 on at

Like (0)

Report

That's good to know Pete and thanks for the update.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

This is an odd one. I have one client that comes up empty when trying to print the detail trial balance for a particular account. It happened with 2010 and 2013. I never resolved the issue because it wasn't worth the investment for the research (for the client). I know that doesn't help except to let you know there is another soul in the world with an odd TB problem. You bring up an idea though. I never have tried using PSTL to transfer to a new account and then transfer back. I'll have to try that this year :).

Kind regards,

Leslie

Was this reply helpful? Yes No
Rennecia Barran on at

Like (0)

Report

Thanks, this worked for me.

Was this reply helpful? Yes No