SBX - Search With Button

SBX - Forum Post Title

Check Register - Detailed

Microsoft Dynamics GP Forum

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

Question Status

Suggested Answer

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
Leslie Vail responded on 19 May 2017 4:58 PM
Suggested Answer

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
My Badges

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
Victoria Yudin responded on 23 May 2017 5:28 AM
My Badges
Suggested Answer

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
Leslie Vail responded on 19 May 2017 4:58 PM
Suggested Answer

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 23 May 2017 5:28 AM
My Badges
Suggested Answer

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

SBX - Two Col Forum

SBX - Migrated JS