Dynamics Community Forum Thread Details

Smart List Report

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?

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.

Quick Links

Leaderboard