Unified Business Solutions

Routines have been available in Dynamics since version 1.0 but is one of the most under utilized features of the system.  Most companies only utilize the receivables aging and remove paid transactions routines.

Routines were designed to a allow a company to have a set of procedures that are followed each month, period, quarter or year and document that they have been followed with the person’s login ID and date and time.

Routines can open a MS Dynamics GP Window, perform an external task (like open a specific file with Excel and run a macro) or run a MS Dynamics GP Macro.  With a MS Dynamics GP Macro you can perform almost any task within Dynamics.

You can get to Routines in MS Dynamics GP by going to MS Dynamics GP | Tools | Routines and then selecting the series that you wish and selecting “Checklists”.  Then press the “Add” button to add a routine.

Below is an example of a period end routine to close the month and produce the monthly reporting package with all the reconciliations and analyses.

Dynamics GP has a very sophisticated process for dealing with NSF (Not Sufficient Funds)

checks.  You select the Receivables Maintenance Posted Transaction screen by going to

Transactions | Sales | Receivables Maintenance Posted Transaction.  Enter the customer ID.

Then select the type of transaction, in this case “payment” and then select the payment

number that you want to mark as NSF.  Press the “NSF” button.  Auto Post NSF Debit Charge

screen will open and you can enter the NSF charge amount

Then click the OK button.  Dynamics GP voids the payment and adds a NSF fee.

See below where the payment is voided as indicated by the * next to Open on PMT line

and posts a debit memo for the $15.00 NSF fee to the customer account.

So in this example, the customer now owes a total of $114.75, $99.75 for the original

invoice and $15.00 for the NFS fee.

When it comes to Year-End Close the first thing many Dynamics GP users do is a search in Knowledge Base on CustomerSource for “Year End Close”.  They get 100’s of results like, “Error message when you try to post a transaction in General Ledger in Microsoft Dynamics GP after the year is closed: "Year-End Close is still in process and batches cannot be posted"”.  Good to know but not exactly what they were looking for.  That’s because Knowledge Base is focused on closing errors and issues, not the proper Year-End Closing processes and procedures.

Next, users open each functional area manual, great Holiday reading, and they find specific closing procedures but scattered throughout and not in order.  What do you close first and what does the close actually do to the data?

Save time and confusion, order your Year-End/Period-End Processing manual by Accolade Publications today from Unified Business Solutions, $45.00, Contact Us!  

Properly closing a year in Dynamics GP is necessary to maintain not only accurate financials but a number of important business metrics. The procedures provided by Microsoft effect the proper closing for the software but do not always provide a solid financial accounting close.

This manual provides complete closing procedures for Dynamics GP modules GL, AR, AP, SOP, POP, IV, and PR.  It also includes complete explanations of the processes being performed, the proper sequence in which to perform the closings, and when each module should be closed.

Year-End Closing Procedures for Dynamics GP 8, 9 and 10!

Working with Dynamics GP over the years, one of the often unexploited tip to use deals with dates. On ANY date field within Dynamics GP if you are entering a date within the current month, simply enter in the two digit date (as an example for 07/31/2009 simply enter 31). If you are dating entries for a different month, simply enter the two digit month and date (for August 9, simply enter 0809). The Dynamics GP will automatically complete the dates.

One client saved 90 minutes a day using this tip.