Dynamics GP 9.0 Smartlist

25 pts.
Tags:
Microsoft Dynamics GP
Does anyone know how to create a Smartlist that would list all invoices that have been applied to a specific payment document?

Answer Wiki

Thanks. We'll let you know when a new response is added.

In order to do this you’ll need to use the SmartListBuilder product, available from MS. If you are already using SLB, you can create a SQL table to hold certain information related to payments and certain invoice info fields, say over the last 90 days. I’ve done that and also created another table to hold all the GL distribution info for the invoices in the first table. Then with SLB you can create a custom SmartList that uses one or both of these tables. You would think a View would be the way to go, but SLB seems to have problems reading data from a SQL view. Once you’ve got the data you want in the tables/SmartList, create a SQL Agent job to refresh the data – early every morning or periodically during the day, based on the GP Users needs.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following