Unified Business Solutions

Posts Tagged ‘Dynamics GP’

Microsoft Announces Dynamics GP 2010 R2

Tuesday, November 30th, 2010

Q: How do you make Dynamics GP 2010 even better?

A: By putting “R2” after it.

Coming in spring 2011, Microsoft will be releasing Dynamics GP 2010 R2!

Microsoft Announces Dynamics GP 2010 R2

Post to Twitter

New Partner Training for Microsoft SharePoint and Microsoft Dynamics GP 2010!

Wednesday, November 10th, 2010

SharePoint offers Dynamics GP customers a lot of fantastic functionality, and Microsoft plans to increase integration with each future Dynamics GP release.  However, Microsoft knows there are a lot of partners and customers who are afraid to embrace this technology.  So, Microsoft gathered the best SharePoint minds in the world together to work on a course.  The course is scheduled to be available on November 29, 2010.  Stay tuned.

New Partner Training for Microsoft SharePoint and Microsoft Dynamics GP 2010!

Post to Twitter

Dynamics GP Online Services

Monday, October 18th, 2010

Beginning November 1st, Microsoft Dynamics GP customers will have two online services available for both Dynamics GP 10 and 2010.

Payment Services will allow customers to accept credit and debit card payments.  It integrates with receivables Management and Sales Order Processing.  Finally!

Commerce Services will enable customers to publish new sales catalogs on demand and extend sales reach across multiple online channels.

Dynamics GP Online Services Coming Soon

Post to Twitter

Service Pack 1 Released for Dynamics GP 2010

Wednesday, September 29th, 2010

Afraid to upgrade to Dynamics GP 2010?  Worried about bugs?  Cast aside your fears because Service Pack 1 is now out!

Dynamics GP 2010 Service Pack 1

 

Service Pack 5 for Dynamics 10 was also recently released.

Dynamics GP 10 Service Pack 5

Post to Twitter

Cash Basis adjustments using Dynamics GP 2010 Reporting Ledgers

Friday, September 10th, 2010

*NEW* in Microsoft Dynamics GP 2010 is a feature called ‘Reporting Ledgers’ that provides three separate General ledgers in each company database:

· Base – What you use today

· Local, and

· IFRS – International Financial Reporting Standards, “Coming soon to a Country near you!”

Organizations that maintain their books and records on an Accrual base but pay taxes on a Cash Basis often make quarterly adjustments to create a Cash Basis report.  This is typically performed using separate accounts and/or a GP company database.  The results are combined in FRx to create Cash Basis reports.

Consider using the ‘Local’ Reporting Ledger in Dynamics GP 2010 for Cash Basis adjusting entries.  The new Management Reporter application (replaced FRx) supports Reporting Ledgers allowing for the consolidation of all three ledgers to produce the required financial statements, in this situation, a Cash Basis Financial Statement.

Also see Transfer Pricing and other adjustments using Dynamics GP 2010 Reporting Ledgers .

Post to Twitter

Transfer Pricing and other adjustments using Dynamics GP 2010 Reporting Ledgers

Friday, September 10th, 2010

*NEW* in Microsoft Dynamics GP 2010 is a feature called ‘Reporting Ledgers’ that provides three separate General ledgers in each company database:

· Base – What you use today

· Local – Per the available literature this is for “Non-GAAP” entries, whatever that means

· IFRS – International Financial Reporting Standards, “Coming soon to a Country near you!”

Before GP 2010, separate account numbers and/or separate GP company databases were used to record non-management reporting entries such as Transfer Pricing, Tax, and Prior Year adjustments.  The idea is to keep these entries from effecting the financial reports used by Management.

In GP2010 you now have three ledgers to post GJ entries, Base, Local, and IFRS!  So what’s the big deal about Reporting Ledgers in GP 2010?  How might you use this feature?

Let’s say you don’t have a need for a “Local” ledger because you follow GAAP (as opposed to GUAP, Generally Unaccepted Accounting Principles) and “IFRS”, while great bedtime reading for us CPAs, is not relevant to your organization, yet!  FYI – there are hundreds of blogs on “IFRS” that say nothing about the type of entries that would require a separate ledger (can’t wait to see these entries).  You can utilize these additional ledgers for all entries that need to be separated from Management’s Financial Statements.

If you use separate account numbers or a separate GP company to record transactions without changing Management’s Financial Statements (the ones you use to run your company), you might be a Reporting Ledger user!

· Tax Adjustments

· Transfer Pricing

· Prior year adjustments maintained separate from Management Reporting

Management Reporter (replaced FRx) allows you to separate each ledger in a Column or Row format for separate financial reporting.  This is the same as using separate companies in an FRx report to combine two ledgers, only now you don’t need the separate GP company.  Note:  Management Reporter is scheduled to support Multicurrency in a Service Pack later this year.

Before you get too carried away and imagine using intercompany transactions to a separate ledgers across companies, Intercompany Transactions do not support Reporting Ledgers. As soon as you select the Intercompany checkbox in the GL transaction window, the Reporting Ledger dropdown grays out and defaults to the Base ledger. Still, a net one step forward!

Also see, Cash Basis adjustments using Dynamics GP 2010 Reporting Ledgers

Post to Twitter

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.

Post to Twitter

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.

Post to Twitter

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

Post to Twitter

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

Post to Twitter