Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Smart List Report

Posted on by 255

Hi

Is there any way we can get a smart list report for the purchase day book?  I need to obtain all invoices posted within the financial year and the GL codes they were posted too.

Hope you can help?

*This post is locked for comments

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Smart List Report

    PDB report shows all the purchasing entries made for vendors summarized per day along with the General Ledger reference (Journal Entry No). Some companies include returns as well.

    In Dynamics GP, under Purchasing >  "Payable Transactions" Smart List shows  "all" the entries made per vendor, including the following document types;

    • Invoice
    • Finance Charge
    • Misc Charge
    • Return
    • Credit Memo

    Although, the data set provided by this smart list is detailed per transaction, rather being summarized per vendor per day.

    This means, you might have 10 invoices for a specific vendor in one day under this smart list. On the contrary, PDB report shows the total of these invoices in one record.

    Therefore, I recommend creating a custom SQL script to perform the required "group by" and "sort" options on your payable transactions. Further, the report can be published to GP through smart list builder, or other various options.

    One more important issue to be considered, Journal Entry is transaction unique, which means that each of the payable transactions has an associated journal entry; It can't be included in a summarized data set (per vendor, per day)

    Your feedback is highly appreciated to dig for further details if required.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans