Check Register - Detailed

Question Status

Suggested Answer
DexterA asked a question on 19 May 2017 3:45 PM

Good Day,

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.

Dexter

Reply
DexterA responded on 19 May 2017 3:45 PM

PS...it has to be reported in excel....therefore the option under "Reports" is not feasible.

Reply
Suggested Answer
Leslie Vail responded on 19 May 2017 4:58 PM

Dexter,

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/

Kind regards,

Leslie

Reply
Victoria Yudin responded on 20 May 2017 9:46 AM

Hi Dexter,

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/

Reply
DexterA responded on 20 May 2017 9:10 PM

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.

Reply
Suggested Answer
Victoria Yudin responded on 23 May 2017 5:28 AM

Hi Dexter,

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.

Reply
Suggested Answer
Leslie Vail responded on 19 May 2017 4:58 PM

Dexter,

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/

Kind regards,

Leslie

Reply
Suggested Answer
Victoria Yudin responded on 23 May 2017 5:28 AM

Hi Dexter,

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.

Reply