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
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;
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,113 Super User 2024 Season 2
Martin Dráb 229,918 Most Valuable Professional
nmaenpaa 101,156