Unified Business Solutions

Posts Tagged ‘Dynamics GP’

Dynamics GP wrong Invoice Date prevention

Friday, June 25th, 2010

When entering an Invoice Date there is no system warning that you are using the wrong date, usually typing in the wrong year.  Once the Invoice is posted you cannot change the invoice date (well, easily).  Here is a great idea, have a validation on the Invoice Date similar to the Posting Date.  Oh, and do not charge me for this!

Good news for Dynamics GP 2010 users!  There is a new Professional Services Tools Library called “Doc Date Verify”, I like the sound of that.

Doc Date Verify (FREE)

Available only on Microsoft Dynamics GP 2010

Using Doc Date Verify
When Doc Date Verify is activated, and a document date is entered, a check will be
performed to determine whether the document date is in a valid fiscal period or if
the fiscal period is closed.
• If the date does not fall within a valid fiscal period, a message will be displayed
and the user will not be allowed to continue until the date is in a valid period.
• If the Document Date falls within a period that is closed, a message will be
displayed that will allow the user to correct the date or continue on leaving the
date.
This functionality is available in the following windows:
• Payables Transaction Entry
• Receivables Transaction Entry
• Invoice Entry
• Payables Manual Payment Entry
• Sales Transaction Entry
• Inventory Transaction Entry
• Cash Receipts Entry
• Purchase Order Entry
• Receiving’s Transaction Entry
• Purchasing Invoice Entry
To activate this tool, simply mark the second check box next to Doc Date Verify in
the Professional Services Tools Library window.

It’s Official – GP 2010 Available May 1

Tuesday, April 20th, 2010

Today Microsoft officially introduced Dynamics GP 2010, the latest update to the popular Dynamics GP (formerly Great Plains) ERP system.  The official press release can be viewed here.

Dynamics GP 2010 will be the focus of this weekend’s Microsoft Convergence, the annual conference for Microsoft Dynamics customers and partners.  The upgrade will be available beginning May 1, 2010.

Of the many enhancements, further integration with SharePoint and Office are key improvements.

More information can be found at the official US launch site.

Six new Professional Services Tools for Microsoft Dynamics GP 2010 “11” FREE!

Thursday, April 15th, 2010

SALES SERIES TOOLS

SOP PO Number Check (FREE)*

Verify Customer PO Numbers for duplicates as data is entered into the field on both the SOP Entry window and the SOP Customer Detail Entry window.

PURCHASING TOOLS

POP Cost Defaulter (FREE)*

Use this tool to default in the Standard Cost or the Current Cost within the Purchase Order Entry window instead of the vendor specific Last Invoice Cost.

Default Add Item POP/SOP (FREE)*

Automatically mark the Add Item option to be marked in Sales Transaction Entry, Purchase Order Entry, POP Receiving’s Entry and Purchasing Invoice Entry.

Doc Date Verify (FREE)*

Verify document dates fall in a valid fiscal period when entered in Payables Transaction Entry or Receivables Transaction Entry. If the date does not fall within a valid fiscal period, a message will be issued and the user will not be allowed to continue until the date is in a valid period. This customization will also do a validation if the period is closed.

Decimal Place Tool (FREE)*

Adjust the Check Amount in Words to two decimals, for both Payables Management and Payroll checks. This tool is useful when the currencies in Microsoft Dynamics GP have been changed to more than two decimals, which can alter the amount when a check prints. Note: Report Writer must be used to modify the check report and adjust the currency fields.

SYSTEM TOOLS

Update User Date (FREE)*

Automatically update the User Date at midnight.. The application will run in the background as long as Microsoft Dynamics GP is open. This tool can be useful when the solution is left open on a machine overnight running integrations or other processes.

*Available only on Microsoft Dynamics GP “11”

Other Free Professional Services Tools Library for Microsoft Dynamics GP

SALES SERIES TOOLS

Territory Modifier (FREE)

Change territory IDs in the system. The

(more…)

Consolidation Accounting in Dynamics GP and FRx

Thursday, March 25th, 2010

When it comes to Consolidation Accounting in Dynamics GP and FRx, it tends to fall in the “more than one to skin a cat” category. While the results are the same, the path to get there varies from simple Excel files to high end consolidation software. The question is what to use to get the desired results. The answer for Dynamics GP and FRx is, “that depends”. It depends on many factors:

  • How do you manage separate accounting systems?
  • What to do with different COA (Chart-of-Accounts) logic and segments?
  • Do you have the option of starting from Scratch on your COA?
  • Is redesigning an existing Chart-of-Accounts an option?
  • Do you have the option of migrating existing companies to Dynamics GP?
  • Can you use Excel for consolidation reporting?
  • Are your consolidation processes SOX compliance?
  • Do you consolidate by organization structures, lines-of-business, or departments?
  • Do you have Statutory reporting requirements by country?
  • Are your functional currencies different from your reporting currencies?
  • Do you provide budget to actual analysis at the consolidation level?
  • How do you document and manage eliminations?

No matter the size of the organization, at the end of each accounting period the results of all companies need to be consolidated. The purpose of our “Consolidation Design in Microsoft Dynamics GP” White Paper is to provide design concepts for performing Consolidation Accounting using Microsoft Dynamics GP and FRx.

Microsoft Dynamics GP and FRx can be successfully designed to manage the consolidation process!

Request a free copy of “Consolidation Design in Microsoft Dynamics GP” at http://www.unifiedbiz.com/solutions/consolidations/ .

Select Payable Checks using Dates

Tuesday, January 26th, 2010

Computer Checks – Select Payables Checks

Select Due Date and Discount Date Cut-offs Overview

The Due Date Cutoff and Discount Date Cutoff are used to determine what invoices to include in the check run.

If Due Date is selected in the Due Date Cutoff field, all the vouchers for the selected vendors that are due on or before the date specified are included in the batch. To not use a cut-off date, select None. If None is selected, all the vouchers within the vendor and document range selected are included.

If a due date cut-off is selected, the Discount Date Cutoff field becomes available. If Discount Date is selected as the discount cut-off date, all vouchers for the selected vendors with a discount date on or before the date specified are included in the batch. If All is selected, all vouchers with discounts available are included in the batch.

The Apply Date and Non-Qualifying Discounts

Apply Date – of the invoices selected using the Due and Discount Date Cutoff, the Apply Date determines what discounts to apply.  All invoices selected that have valid discounts on this date will be paid at the discount amount.

Take Non-Qualifying Discounts – this selection override the Apply Date and takes all discounts on the invoices selected. 

Sample – Select Payables Checks Using Various Dates and Options

The following sample invoice was used to demonstrate the resulting check amount using various date selections in the Select Payable Check window.

Sample Invoice
Invoice Amount $1,000.00
Terms 2% 10 Net 30
Discount Available $20.00
Invoice Date Jan 1
Terms Discount Date Jan 11
Due Date Jan 31
Results using different date combinations:

Due Date Cutoff

Discount Date Cutoff

Take Non-Qualifying Discounts

Apply Date

Results Check Amount

None None No Jan 11      $980.00
None None No Jan 10      $980.00
None None No Jan 12    $1,000.00
Jan 11 None No Jan 12          $0.00
Jan 11 None No Jan 11          $0.00
Jan 31 None No Jan 11      $980.00
Jan 31 None No Jan 12    $1,000.00
Jan 11 Jan 11 No Jan 11      $980.00
Jan 11 Jan 11 No Jan 12    $1,000.00
Jan 11 Jan 12 No Jan 11      $980.00
Jan 11 Jan 12 No Jan 12   $1,000.00

Use Take Non-Qualifying Discounts on all scenarios above will override the discount amount used as follows:

None None Yes Jan 12      $980.00
Jan 31 None Yes Jan 12      $980.00
Jan 11 Jan 11 Yes Jan 12      $980.00
Jan 11 Jan 12 Yes Jan 12      $980.00

Child Care Payments and other recurring garnishments in Dynamics GP

Tuesday, January 5th, 2010

Setup Dynamics GP to maintain your Account Payable Child Care Payments and other garnishments in a recurring batch with the appropriate frequency.  The Check’s remittance advice will list Employee Name, Case #, and Amount.

First, in the Payables Management Setup Window, select Allow Duplicate Invoices Per Vendor: Recurring Transactions Only, Tools>>Setup>>Purchasing>>Payables.

Create a recurring batch for all garnishments with the appropriate frequency, weekly, monthly, etc..

In the Payables Transaction Entry window, enter an invoice transaction for each garnishment using the Employee Name in the Description field and the Case # in the Document Number field.  Save each transaction to the recurring Batch ID for garnishments.

When you print checks, the remittance will have the Employee Name, Case # and Amount for each garnishment.  You may need to modify your check form to align the fields to print properly on the remittance.

The batch will maintain all payments and you can add or remove employees as needed.

Allowing Duplicate Invoices Per Vendor for recurring transactions keeps the Case # from changing for each payment posting.

Month End Closing using Routines on Microsoft Dynamics GP

Friday, December 18th, 2009

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.

clip_image002

Processing NSF Checks in Microsoft Dynamics GP (Great Plains)

Thursday, December 17th, 2009

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

clip_image002

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.

 

clip_image002[8]

Year-End Closing Procedures for Dynamics GP

Friday, November 20th, 2009

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!

How do I print a Vendor Check as a Prepayment in Dynamics GP?

Tuesday, October 20th, 2009

Situation: You have a vendor that requires a down payment on a purchase and you need to print a system check before you receive an invoice.

Solution: Use the Select Payables Checks process!

Create a Batch in the Select Payables Checks window. Select the Edit Check button to enter the Edit Payables Checks window. Select the Vendor ID and the enter the amount of the check in the Amount: Unapplied field. Save this to the batch. Select Print Checks and process the batch.

This process results in recording the Check to the Vendor as an unapplied payment and to the outstanding check list in Bank Reconciliation. Later, when the invoice is received, use the Apply Payables Documents window to apply the check to the invoice. If you prefer to let the system apply the check, select to Automatically Apply Existing Unapplied: Payments as part of your Select Payables Checks process. The payment will be applied to an open invoice and reduce the amount paid to the vendor.

This process may seem a bit cumbersome but it is actually very easy and quick to cut a single check to a Vendor with no invoice. The benefits of having this check recorded in the system are well worth the few extra steps.