Try Microsoft Edge
A fast and secure browser that's designed for Windows 10
I have been asked to produce a detailed Check Register. This Check register is required to show the Check Number, the check amount, and the specific payable invoices that were paid.
Can this be done via smartlist? What fields should I use?
Alternatively, if I can get a smartlist which shows what the "voucher payment number" or "check number" is for a specific invoice, that will make my life alot easier. Is there a field in smartlist I can use for this?
Thank you for your assistance.
PS...it has to be reported in excel....therefore the option under "Reports" is not feasible.
You need to visit Victoria Yudin's web site. She has a list of views that addresses many issues like you described. https://victoriayudin.com/
You would need to create a custom SmartList for this. And Leslie is right - I have code for this on my blog: https://victoriayudin.com/2009/10/22/sql-view-for-payables-payment-apply-detail-in-dynamics-gp/.
Thank you Leslie and Victoria. My issue is that I am a user and not a programmer so I thought this could be done with the fields available. I see the code but I am unsure where to begin to put this data to generate the necessary smartlist in excel.
To my knowledge this is not possible out-of-the-box. If you need this report, you could ask your GP Partner to help you use the code on my blog to set up a custom report or SmartList for you.