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

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

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.

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

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