Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

"Amount Paid LYR" Showing $0.00 for All Vendors

(0) ShareShare
ReportReport
Posted on by

Hello:

In just one company in GP, SmartList is showing $0.00 for Amount Paid LYR for all vendors.

It is true that Payables Year-End Closing was not conducted, until 01/11/2018.  But, I would have thought that this field would have dollar amounts for at least some of the vendors, instead of showing $0.00 for all vendors.

Year-end close was not conducted twice. 

This issue is not occurring in other companies.

Why would this be case?

John

*This post is locked for comments

  • Community Member Profile Picture
    on at
    RE: "Amount Paid LYR" Showing $0.00 for All Vendors

    Hi John!  You mention you ran payables summary recalc scripts to fix your issue.  I am wondering where you found the scripts, or if there is a utility in GP that runs them?  

    Thanks!

    Wendy

  • Community Member Profile Picture
    on at
    RE: "Amount Paid LYR" Showing $0.00 for All Vendors

    Hi There, Leslie:

    Thank you, for your quick response!

    You're probably right.  That being said, I found the means to allow for those summary SmartList columns to display accurate data, instead of $0.00.

    I ran the payables (and receivables) summary recalc scripts.  That solved the problem.

    John

  • Verified answer
    L Vail Profile Picture
    65,271 on at
    RE: "Amount Paid LYR" Showing $0.00 for All Vendors

    Hi,

    I know you said the year-end close was not conducted twice, but boy it sure sounds like it might have been. It's easy to hit that button twice when you do the close. You can always go to your transaction detail and build a report or view that will show you the numbers. You could hook that view to SmartList so that you could more easily access it. They would be better numbers too.

    Leslie

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Featured topics

Product updates

Dynamics 365 release plans