Unified Business Solutions

Blogs

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.

Office on the web for Free!

Wednesday, June 9th, 2010

If you already have a Windows Live account, also referred to as hotmail or passport, when you log into your account you will find the new Office menu.

Windows Live Menu

These are free, online versions of Word, Excel, PowerPoint, and OneNote that you can access from the web browser.  Yes, they are watered down, but they are compatible with their desktop versions and are surprisingly functional.  The PowerPoint Web App is one to really look at.

You don’t have a Windows Live account?  No worries, they’re free.  Just go to http://live.com and sign up for one.

Documents that you create are saved online in your SkyDrive, which is your virtual hard disk on the internet. 

Here’s a look at Word:

Word Web Appand Excel:

Excel Web App

So go to http://live.com now and start living in the “cloud”, you don’t want to be left out of the next internet revolution, do you?

Office 2010: Product Guides

Wednesday, April 28th, 2010

The retail release of Office 2010 is right around the corner!  Learn all about new features and improvements in the downloadable official product guides from Microsoft.

Office 2010: Product Guides

SQL Server 2008 R2 is released

Thursday, April 22nd, 2010

SQL Server continues to get updated, the latest release 2008 R2 has significant updates to performance, business intelligence, and data availability as a service.  PC World has a quick rundown on the release and more info is available at Microsoft.

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…)

Office 2010 to launch on May 12

Monday, April 5th, 2010

ZDnet is reporting that Office 2010 will be released at an event in New York on May 12th, you can watch it at Microsoft here.  Initially it will only be immediately available for businesses with licensing agreements.  It should reach retail and the masses sometime in June.

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/ .

Microsoft Office 2010 Technology Guarantee

Friday, March 5th, 2010

Office 2010 is almost here!  But what if you need Office and can’t wait until June.  Fear not, Microsoft has you covered.  Purchase and activate a qualifying Office 2007 product between March 5, 2010, and September 30, 2010, and you can download Office 2010 at no additional cost.

Microsoft Office 2010 Technology Guarantee

Return transaction document types that are available in Purchase Order Processing in Microsoft Dynamics GP

Monday, February 22nd, 2010

Under what conditions should I use a specific return transaction document type?  Here is summary of when to use a particular document type. For examples of each type go to CustomerSource and search for the Microsoft Knowledge Base Article ID 936280. I found it very useful, however, like some Knowledge base articles, it took some time to find it.

Return transaction document types

The following return transaction document types are available in Purchase Order Processing.

Return

A Return transaction document type is used if the following conditions are true:

• A shipment transaction has been posted for the purchase order.

• An invoice transaction has not been entered for the purchase order.

• The item in the purchase order has not yet been removed from inventory.

"Return w/Credit"

A "Return w/Credit" transaction document type is used if the following conditions are true:

• A shipment transaction has been posted for the purchase order.

• An invoice transaction has been posted for the purchase order.

• The item in the purchase order has not yet been removed from inventory.

Inventory

An Inventory transaction document type is used if the following conditions are true:

• A shipment transaction has been posted for the purchase order.

• An invoice transaction has not been entered for the purchase order.

• The item in the purchase order has been removed from inventory.
Note An Inventory transaction can also be used for items in drop-ship purchase orders that were returned by the customer. You can do this if the invoice transaction has not been matched to the purchase order.

"Inventory w/Credit"

An "Inventory w/Credit" transaction document type is used if the following conditions are true:

• A shipment transaction has been posted for the purchase order.

• An invoice transaction has been posted for the purchase order.

• The item in the purchase order has been removed from inventory.
Note An "Inventory w/Credit" transaction can also be used for items on drop-ship purchase orders that were returned by the customer after the invoice transaction has been posted.