Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Smartlist Totals do no...
Microsoft Dynamics GP (Archived)

Smartlist Totals do not match

(0) ShareShare
ReportReport
Posted on by Rosemary 2

Hi,

I ran a Smartlist Report from 'Customer' to get my totals, this was just prior to the monthend close. All batches in SOP and Rec were posted. I ran a detail TB before I did the Aging, when I checked the totals, the TB and the Smartlist the aging bucket 181 and over did not match.

I normally run this report and the  totals would match that of the TB.

The difference has been identified but not sure where to look or how to start to find the documents which make up this value.

*This post is locked for comments

  • Rich Mikolainis Profile Picture
    Rich Mikolainis 705 on at
    RE: Smartlist Totals do not match

    Last Year Totals on Smartlist are not date driven, they are driven by the year end closing dates. So if you closed the year on 2/1/13 , your last years totals will show totals for 13 months.

    Idiotic? Yes. They should change the column heading, its not a "yearly" total.

  • Tim W Profile Picture
    Tim W 2,925 on at
    Re: Smartlist Totals do not match

    The trial balance, assuming you are running the detail does not depend on the aging process.  When you run the detail report it it is as if you have just aged AR.  I would advise you to run the aging before you run the Smartlist.  I would either:

    Run TB -> Age -> Run Smartlist   or

    Age -> Run TB -> Run Smartlist

    You need to age before you run the Smartlist otherwise the buckets will be off from the TB calcualtions depending on when you last aged.

  • Rosemary Profile Picture
    Rosemary 2 on at
    Re: Smartlist Totals do not match

    The SmartList was done before the TB.

    This TB was also done before the aging. It is something the Receivables person likes to check before the aging. 

  • Tim W Profile Picture
    Tim W 2,925 on at
    Re: Smartlist Totals do not match

    Did you run the aging (up to current date) before you ran the smartlist (you would want to)?  Typically that would be the source of the issue you describe.

    The Detailed TB will calculate the buckets on the fly regardless of the last time you aged where as the Smartlist will be dependent on you running the aging.  Other issues that come to mind might be you excluding credit balances in the TB or some date setting if you are printing HTB.

    Tim

     

     

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans