Playing with checks Part 2–Did it clear?

So in my previous post we walked through setting up a report to print out all the checks issued to a particular vendor so we could locate a check number.  When we left off the next question we wanted to know was when the check cleared.  I found an easy way via SmartList to gather that information and I’ll show you how.

With Dynamics open lets open up our SmartList. Microsoft Dynamics GP > SmartList

image

 

When you have the SmartList open you will need to drill down to Financial > Bank Transactions.

image

The next thing we are going to do is add two columns to this SmartList object. The two columns we are going to add are the Audit Trail Code and Cleared Date.  The Audit Trail is what we can use if we need to narrow our search down a bit.

image

We now have our two additional columns added to our SmartList object.

image

To use the audit trail code we click on the search button and enter our information.

image

 

image

jcox@hexoma.com
2 Comments

Add a Comment

Your email address will not be published. Required fields are marked *