Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Heidi Love]

?How do I run an outstanding check list in Great Plains?  Do I need to complete a bank reconciliation to do it?
thanks!
Heidi

——————————
Heidi Love
Industrial Metal Supply Co
Sun Valley CA
——————————

[Maureen Martin]

@Heidi Love

Heidi – has anyone in your organization used the Bank Reconciliations option before?

1)  If they have, follow the steps below (1a thru 1d).  If they have not, then jump to Step 2, at the bottom of this post.  Steps 1a thru 1d will allow you to see a list of checks that were outstanding on a previous reconciliation.  Here’s the path – it’s kind of buried in a place that isn’t where I would look for it intuitively:

1a)  Financial > Reports > Bank Posting Journals

1b)  Then from the pulldown window, select the Outstanding Transactions Report.

1c)    Then select a report that has previously been set up, (ours is called OS Checks).  If there are none, go to 1d).
If there is a report set up, then select it from the pulldown menu.  In the From/To fields, use the lookup icon to select a code from the list of Audit Trail Codes available — I would select the latest one, or a range of the latest ones, which will give you the last reconciliation done. (If your company uses Bank Rec for more than one bank account, you may have to sift through a few Reconciliations to get the account you need).

1d)  If there are no reports set up on the Outstanding Transactions Report, simply click the “new” button and on the window below, give it a name in the Option field (top of the window). 
You are limited as to the parameters the report calls for, so just give it a name and save it.  Then use the From/To fields to specify which reports you wish to view (example CMADJ00000752 on our system gives a recent reconciliation).

2)  If your company has not yet used Bank Reconciliation, or if you prefer SmartList as an easier option, you can set up a Smart List similar to the one we’ve set up. Under SmartList, navigate to:
SmartList > Financial > Bank Transactions.
 
We have set our SmartList up to include the fields we need. 
     Reconciled = No
     Checkbook ID – enter the name of your checkbook
     CM Trx Type – what type of field is this (check, deposit, withdrawal, etc)
     CM Trx Number – transaction number
     Date
     Paid To Rcvd From
     Amount 

You can use the date field to specify your cutoff date.  Above, “Date is less than 12/31/18” will give us all trxns Outstanding as of 12/31/18.

Let us know how it goes and pop back in with questions!

Maureen

?

——————————
Maureen Martin
Finance Manager
Home Repair Services
Grand Rapids MI
——————————
——————————————-

[Heidi Love]

?Thank you Maureen!  I will try it.

——————————
Heidi Love
Industrial Metal Supply Co
Sun Valley CA
——————————
——————————————-