SSRS GL Trial Balance Summary Missing Accounts Without Activity

(0) Share

Report

Posted on by Community Member

Have been all around this and can't find an answer. In SSRS GL Trial Balance Summary report, we have accounts that have not had any activity this year but do have a beginning balance. They even have a transaction on a future date, but not yet (4/30/15). Our years run 4/1 - 3/31, so in GP 2016 is 4/1/2015 to 3/31/2016. If I run the report for 4/1/15-4/24/15, two accounts are missing. If I rerun but choose to "Include Zero Balance", they show up, but this causes a lot of other accounts to show up that our accounting department does not want on the report. If I run it and include the date of the future transaction, they show up.

Found another post that referenced a similar issue and a stored procedure to fix it, but that did not work for me so I put the procedure back to the original.

GP 2013 R2 version 12.00.1826. SSRS on SQL Server 2014 12.0.2000.8.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Sort by

babubaskaran@outloo... 12 on at

Like (0)

Report
Copy link

Link copied!

Hi Joe,

Have you tried to reconcile the GL and re-run the trial balance.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Reconcile does not make a difference.

Today we are having additional issues with the GP Trial Balance Summary and the SSRS Trial Balance summary not matching even though all dates and settings are the same.

Was this reply helpful? Yes No
Suggested answer

Romryan on at

Like (0)

Report
Copy link

Link copied!

Can you see the transaction if you use Enquiry>>Financial>>Detail

or are you able to trace a specific date transaction from smartlist.

if you are able in above both occasions,then you may be required to review your SRSS GL summary report.

RomRyan.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Original problem still persist. If an account does not have any transactions other than beginning balance for this fiscal year, it does not show on the report.

New problem is that beginning balances for some accounts are $0.00 when running for a specific time range (last week 4/25/2015-5/1/2015). All transactions are the same on the detailed report, just SSRS has $0.00 for beginning balance while GP has the correct amount.

Was this reply helpful? Yes No