[Elaine Salyer]

I am looking for a way to reprint invoices paid with a specific check in A/R. The only way I seem to be able to see this information is from a screenshot. Click on payment in Transaction by Customer, then click on Amount Remaining. It would be so much easier if I could run a Smartlist or we also have Smartview, I would love to get this information into Excel. We are on GP 18.3. Any help with this would be greatly appreciated.

——————————
Elaine Salyer
MAS, Inc.
Richfield OH
——————————

[Samantha Higdon]

Hi ,

has a script that you can put into a view for SmartList or possibly Smartview (less familiar with that admittedly) that shows all the AR apply information.

https://victoriayudin.com/2010/02/15/sql-view-with-ar-apply-detail/

It works beautifully in SmartList, Excel Refreshable Reports, SSRS, etc.  You’d be able to search or filter by customer, payment number, dates, etc. to help hunt down the information.

I’d give that a look.  If it doesn’t meet your needs, let us know.

Thanks,

Samantha??

——————————
Samantha Higdon ,CPA,CGMA
Consultant
Lagom, LLC
Carmel IN
——————————
——————————————-

[Elaine Salyer]

Thanks !

Now I just need to get someone to create the view. I don’t have access to Smartlist Builder.

I will let you know how it goes.?

——————————
Elaine Salyer
MAS, Inc.
Richfield OH
——————————
——————————————-

[Elaine Salyer]

This worked perfectly. Thanks so much!

——————————
Elaine Salyer
MAS, Inc.
Richfield OH
——————————
——————————————-

[Samantha Higdon]

Great!  I’m glad it worked out for you. 🙂

Thanks,

Samantha

——————————
Samantha Higdon ,CPA,CGMA
Consultant
Lagom, LLC
Carmel IN
——————————
——————————————-