Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / SSRS GL Trial Balance ...
Microsoft Dynamics GP (Archived)

SSRS GL Trial Balance Summary Missing Accounts Without Activity

(0) ShareShare
ReportReport
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

  • Community Member Profile Picture
    Community Member on at
    RE: SSRS GL Trial Balance Summary Missing Accounts Without Activity

    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.

  • Suggested answer
    Romryan Profile Picture
    Romryan on at
    RE: SSRS GL Trial Balance Summary Missing Accounts Without Activity

    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.

  • Community Member Profile Picture
    Community Member on at
    RE: SSRS GL Trial Balance Summary Missing Accounts Without Activity

    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.

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 6 on at
    RE: SSRS GL Trial Balance Summary Missing Accounts Without Activity

    Hi Joe,

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,401 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans