Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

"Amount Paid LYR" Showing $0.00 for All Vendors

Posted on by Microsoft Employee

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
    Community Member Microsoft Employee 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
    Community Member Microsoft Employee 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
    L Vail 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans