Tuesday, December 29, 2009

Year End Tip

Can you apply the YE update if you still have 2009 payroll to process?

Answer: you can apply the YE update anytime, regardless of whether or not you still have 2009 payroll(s) to process. The YE update does not include tax table updates for 2010. Those are part of the 2010 US Payroll Tax Update.

The 2009 YE update does include all previous YE updates, hotfixes, and service packs.

Thursday, November 19, 2009

Tips for Importing Data into Fixed Asset Mgmt (applies to v8, v9, v10)

  • The import source file should be saved in a tab-delimited file or in a comma-delimited file. If you use Microsoft Office Excel to create a tab-delimited file, save the file as Text (Tab delimited) (*.txt).
  • The Fixed Assets feature sorts the asset ID by the first character on the left. For example, if you use a numbering scheme, and if the assets are numbered 1 through 1,000, the following data is returned when you search for an asset:

1, 10, 100, 2, 20, 200 and so on

To force the program to sort numerically, each number must have leading zeros. See example:

00001, 00002, 00003

The Asset ID field is an alphanumeric field. Type the asset IDs in all uppercase characters when you import the Asset Book information.

  • Do not use the Table Import feature. This feature is not supported.
  • To save imported account numbers to the asset records, click Require Accounts in the Fixed Assets Company Setup dialog box. This option lets you import data from the Payables/Purchase Order dialog box. Also, this option lets you export data to the General Ledger dialog box. If you do not click Require Accounts, the account numbers will not be completely saved to the asset.
  • When you import Asset Book information, do not click Auto Add Book in the Fixed Assets Company Setup dialog box. If you do click Auto Add Book, you may receive the following error message:

You have changed a depreciation sensitive field.

If you receive this error message, the macro stops, and you must restart the import process.

You cannot import new Asset General records or new Asset Book records over existing records. For example, if you try to import records, and the import fails, some assets may have been created in Fixed Assets. To import new Asset General records or new Asset Book records, use one of the following methods:

- If you cannot import data because the asset already exists, you can clear this asset from the system.

- If you cannot import data because the asset already exists, you must restore the data from a backup. Or, you can remove the assets one at a time by using the Asset Delete utility. To use this utility, follow these steps:

1. Use one of the following substeps as appropriate for your installation:

- In Microsoft Dynamic GP 10.0, point to Tools on the Microsoft Dynamics GP menu, and then point to Utilities.

- In Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions -Great Plains 8.0, click Utilities on the Tools menu.

2. Click Fixed Assets, and then click Delete.
3. Select the first asset to delete, and then click Delete.

  • Do not use the following items during the import process:

- A screen saver

- Antivirus software

- A mouse

If you use any of these items, the macro stops, and you must restart the import process.

  • Do not use a slash (/) or a hyphen (-) in the date fields. The import may fail if you use these characters.

To format the date correctly when you use an Excel spreadsheet, you must set up a custom format for the cells. To do this, use the following custom formats:

- January through September: 0#####

- October through December: ######

  • You cannot import retired assets. You can bring retired assets into the system as fully depreciated. But there is no field and no option that you can use to flag the assets as retired. You must perform the retirement process while the asset is in the system.
  • Use Notepad to open a comma-delimited source file. When you use Excel to open the source file, Excel deletes any leading zeros that are in the asset IDs.
  • Use different macros for each import.
  • In the Asset Import/Export dialog box, click Run macro after creation, and then process the import. Or, you can manually run the macro. To do this, use one of the following substeps as appropriate for your installation:

- In Microsoft Dynamics GP 10.0, point to Tools on the Microsoft Dynamics GP menu, point to Macro, and then click Play.

- In Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions - Great Plains 8.0, click Tools, click Macro, and then click Play.

  • If you receive errors when you try to import data, examine the field in which the import process stopped. You may have to change this field in the imported file.
  • You can also use Integration Manager in Microsoft Dynamics GP to import asset information.
  • Setup information cannot be imported by using this import process. This import process is only for asset cards.
  • If General Ledger is already updated for asset balances before the asset additions are run in Fixed Asset Management, make sure that you run the FA to GL Posting routine for these additions, and then delete the FATRX batch that is automatically created. Follow this step so that accounts in General Ledger are not overstated if the FATRX batch for asset addition is posted in error.

Monday, October 26, 2009

Payroll Tax Update Released

Microsoft has released the Round 9 U.S. Payroll Tax Update. This includes the changes to California State Taxes which are effective November 1, 2009, as well as all other changes that have been made this year to date. Please note that if you do not have any employees who reside in California you do not need to install this update at this time, unless any of the following situations apply to you:

  • You have employees in Louisiana or Missouri and you have not previously installed the Round 6 update
  • If you haven’t installed the Round 4 tax update and require the changes it includes. The program code portion of the Round 4 tax update contained HR and Payroll COBRA changes required by the American Recovery and Reinvestment Act of 2009, HR Form I-9 changes, and bug fixes. Note: This installation does require an additional code update. Please contact Collins Support, support@collinscomputing.com, for more information and help installing this.

The changes in Round 9 and all previous tax releases for 2009 are described in the following document, US09OctTaxR9. It also includes instructions for installing the changes. See page 5 for Dynamics GP version 9 installation or page 8 for version 10 instructions.

If you have any questions please email or call our Support Department at support@collinscomputing.com or (888) 391-6690.

Wednesday, October 14, 2009

IMPORTANT NOTICE REGARDING A PAYROLL TAX UPDATE!

The State of California is implementing a change to the state income tax withholding table effective as of November 1, 2009. Microsoft will include these changes in the next tax update, Round 9, due out the end of October.

We will keep you informed once Microsoft gives us a firm release date but as today, the projected release date is 10/23/09.

If you will need Collins assistance to download and install the update, please contact Analisa Fatigati at afatigati@collinscomputing.com as soon as possible in order to get a install date scheduled.

Wednesday, September 16, 2009

Microsoft Support for GP v8.0 Ends Soon

Microsoft Support for GP v8.0 ends on October 13th, 2009. If your system or any systems you look after is running on v8.0 or earlier, now is the time to get them upgraded to v9.0 or even better v10.0. More info



Contact the consulting team at Collins Computing! Microsoft Dynamics GP 10 has delivered over 120 enhancements and we have upgraded many of our customers - Dynamics GP 10 is very stable. Microsoft released a Feature Pack and Service Pack 3. Want to upgrade your system and/or have any questions? Contact your account manager or email us at upgrade@collinscomputing.com.

Monday, August 31, 2009

Microsoft Dynamics GP Extender Notice of Change

Announcing added features and functionality as well as a pricing increase for Microsoft Dynamics GP Extender (EEX) on the Microsoft Dynamics GP price list. On September 1, 2009, the pricing for Extender will increase to $2,450 (was $1,750) for BRL Business Essentials, BRL Advanced Management, MBL Standard and MBL Professional.

Extender is an easy-to-use tool that allows you to add data fields, notes, macros, lookups and much more, without writing a single line of code. Develop workflow and enrich your reporting power for Microsoft Dynamics GP with this empowering tool. This tool will be enhanced and improved along with Microsoft Dynamics GP Service Pack 4 due out in mid August 2009.

CLICK HERE to view Extender's new features.

Have any questions about Extender or would like a quote? Please contact your Collins consultant.

Monday, August 3, 2009

Automated Solutions

We are all aware of certain tasks in Dynamics GP that require knowledge of SQL Query Language and access to the SQL Query Tools, but unfortunately not all users have this knowledge or access.

Well what you may not be aware of it the fact that Microsoft has created automated solutions to address some of these issues. These solutions can be found in the support section of CustomerSource. You need to make sure you have a current enhancement plan so you can access CustomerSource. (This is a good reason to keep your enhancement plan current.)

Solutions include:
-Bank Rec Reconcile Error
-Deposit Edited by Another User
-Rebuild Account Index
-GL Out of Balance SQL
-Trial Balance out of Balance
-Year End Close Checklist
-Copy Human Resources Setup
-Payables Duplicates
-Clear Payroll Activity
-Purchase Order being Edited by Another User Error
-RM Reconcile Can't Be Completed
-Receivables Duplicates
-SOP Document Edited by Another User
-Duplicates in SOP
-Cannot Post Batch
-Copy Company Setup
-Delete Company in Dynamics GP
-Unable to Log in to Dynamics GP

and more....

Most of these tools do require the SA login, but they do not require SQL Query Tools. These are possibly good options if you have one of these issues.

Of course always make sure you have a current backup of your database prior to using any of these tools and if you need assist you can contact Collins Computing.

Friday, July 31, 2009

Getting Started with SmartList Builder

Have you ever wished you could create a new SmartList? I am sure we all have had ideas about additional SmartLists that we would like to have. Well that is why Microsoft came out with SmartList Builder, but the problem is that is can be very tough to get started.

  • What table do you use?
  • How do you link the tables?
  • What fields should I show?
  • Do I need totals or summaries?

Well now Microsoft has create over 100 templates to get you started. They can be downloaded from CustomerSource or you can contact your Collins Computing team.

The following is a list of templates that are available:

· Activity Tracking
· Tax Detail Transactions
· Account Summary
· Account Transactions
· Accounts
· Bank Transactions
· Multidimensional Analysis
· Exchange Rates
· Cash Receipts
· Commissions
· Customer Addresses
· Customer Items
· Customer Period Summary
· Customer/Vendor
· Customers
· Receivables Transactions
· Prospects
· Sales Line Items
· Sales Transactions
· Invoicing Lines
· Payables Distributions
· Payables Transactions
· Vendor Addresses
· Vendors
· Purchase Line Items
· Purchase Orders
· Receivings Line Items
· Receivings Transactions
· Inventory Purchase Receipts
· Inventory Transactions
· Item Quantities
· Items
· Landed Cost Group ID
· Landed Cost ID
· Stock Count
· Vendor Items
· Assembly Orders
· Bill of Materials
· Bill of Materials Components
· Employee Summary
· Employees
· Payroll Historical Trx
· Payroll Transactions
· Applicant
· Applicant Education
· Applicant Skills
· Employee Benefits
· Employee Education
· Injuries
· Post-Dated Pay Rates
· Contract Lines
· Contracts
· Equipment
· Field Service Calls
· History Contract Lines
· History Contracts
· History Field Service Calls
· History RMA Lines
· History RMAs
· History RTV Lines
· History RTVs
· RMA Lines
· RMAs
· RTV Lines
· RTVs
· Work Orders
· Manufacturing Bill of Materials
· Manufacturing Item Details
· Manufacturing Orders
· Manufacturing Potential Shortages
· Manufacturing Receipt Master
· Manufacturing Routing Line
· Manufacturing Serial Trace
· Manufacturing SO/MO Link
· Manufacturing Work in Process
· Picklists
· Recorded Outsourcing Shipments
· Sales Documents Not Linked to Manufacturing
· Suggested Outsourcing Purchase Orders
· Suggested Outsourcing Shipments
· PA Billing Cycle
· PA Billing Historical Transactions
· PA Billing Open Transactions
· PA Billing Work Transactions
· PA Contracts
· PA Cost Categories
· PA Employee Expense Historical Transactions
· PA Employee Expense Transactions
· PA Equipment
· PA Equipment Log Historical Transactions
· PA Equipment Log Transactions
· PA IV Transfer Historical Transactions
· PA IV Transfer Transactions
· PA Miscellaneous
· PA Miscellaneous Log Historical Transactions
· PA Miscellaneous Log Transactions
· PA Projects
· PA Timesheet Historical Transactions
· PA Timesheet Transactions
· Fixed Assets
· Fixed Assets Books
· Fixed Assets Purchase

Why do you see zero dollar payments on the check remittance???

Have you ever seen payments from the Select Checks and Edit Checks window that have an amount of zero? This happens because the Automatically Apply Existing Unapplied check boxes for Payments, Credit Memos and Returns are automatically marked when you open the Select Checks window.

These options will apply remaining unapplied Payments, Credit Memos, and/or Returns to open invoices for the vendor before creating the check for payment.

This is the reason why you see the REMITxxxxxx document numbers that does not come from EFT payments. The system was able to fully pay the remaining amount for the invoice or vendor by using the total unapplied amount of the Payments, Credit Memos, and/or Returns for the vendor. By default, the system will show you what has been applied to the invoice even if there were no checks created.

You cannot print a check for a non- EFT zero dollar payment.

When you print a batch of checks, remittance forms will be printed for any payments in the batch that have an amount of zero.

On the first remittance for a payment that has an amount of zero, the Check Number field is set to REMIT00000000000001. This number automatically increments for each successive remittance.

Remittances are not posted to Bank Reconciliation for the following reasons:

· Remittances for payments that have a amount of zero use distinctive check numbers. These check numbers have a prefix that differs from the prefix of check numbers for other remittances.

· Remittances for payments that have an amount of zero do not use check stubs.

Note: Unmarking the “Print Previously Applied Documents on Remittance” in the Payables Management Setup window will not prevent the zero dollar REMIT documents from being created.

Thursday, June 11, 2009

Support Debugging Tool

Are you responsible for support Dynamics GP? Do you wish you could run SQL Scripts from inside of GP? Do you wish you could better log error messages or system issues? Well if that is the case you need to make sure you download and install the Support Debugging Tool.


The Support Debugging Tool is a Dexterity built application which contains a collection of utilities and tools to make the task of supporting, developing and debugging Microsoft Dynamics GP easier and faster.

Examples of use
The Support Debugging Tool can be used for many purposes. Some examples of these are listed below:

  • It can help you identify the specific series of events which lead up to an issue or bug in the code occurring.

  • It can be used to quickly and simply turn on all logging and profiling capabilities without restarting the application. This can be useful when looking at performance problems.

  • It can be used to find details about dictionary resources.

  • It can be used to identify resources (forms, reports and tables) causing security access issues.

  • It can be used to enable and disable third party products or change the order of the products in the launch file.

  • It can be used to export data from and import to any table.

  • It can be used to run SQL or Dexterity scripts without needing Dexterity or SQL Administration Tools installed.

  • It can be used to capture and email or save screenshots of all open windows and a system status report.

  • It can be used to send email to the system administrator, even on systems without a locally installed Outlook client.

  • It can assist in resolving issues with reports using Report Writer (RW) user defined functions.

What can it do for me?



The tool currently contains the following Standard Mode features (that do not require system administrator or database owner (dbo) privileges):




  • Manual Logging Mode
    Turn on SQL logging, Dexterity script logging, and Dexterity script profiling with a single mouse click without needing to edit the dex.ini file or exit the application. Start logging just before an error or performance problem and stop logging immediately afterwards.

  • Individual Logging Mode
    Control SQL logging, Dexterity script logging, and Dexterity script profiling individually.

  • Dex.ini Settings
    Provides an user interface to a number of Debugging Tool, application and debugging related dex.ini file settings.

  • Resource Information
    Identifies display names, technical names, physical names and resource IDs for dictionary resources (forms, windows, reports, tables and fields) from any one known value. Great for entering obscure SQL column names (physical names) and getting the field's technical name.

  • Security Profiler
    Monitors all application level security requests. This is a great tool for identifying the cause of privilege errors caused by hidden windows.

  • Configuration Export/Import
    Allows Support Debugging Tool settings to be exported and imported using XML files. You can create settings on your system and send them to the customer to use.

The tool currently contains the following Advanced Mode features (that do require system administrator or database owner (dbo) privileges. Dexterity and SQL skills are also necessary):

  • Automatic Debugger Mode
    This is the mode where you can create a Dexterity trigger to execute off almost any event. It can then run a sanScript script (which can include SQL queries) to check for some sort of error condition. While this mode is active, the system will be logging all Dexterity and SQL activity and so when the error condition occurs the complete logs of the events leading up to the condition have been captured.

  • Dictionary Control
    This window allows the application dictionaries in the system to be control without manually editing the Dynamics.set launch file. You can disable triggers and use of alternate windows and these changes can be remembered for next login. Great for "removing" 3rd party add-ons when testing. You can also re-order products in the Dynamics.set launch file to resolve potential clashes between 3rd party add-ons.

  • XML Table Export
    You can select any number of tables from any product in the system and export them as a single XML file. This can be used to backup demo or test data, or can be used to obtain specific data from the customer without sending a backup of the entire database.

  • XML Table Import
    You can import back any table(s) previously exported using the XML Table Export tool.

  • Runtime Execute
    This is a Dexterity sanScript editor which can be used to execute any script in the context of any dictionary. It includes a number of helper functions to make working across dictionaries easier. Sometimes fixing data is much easier in a procedural language environment rather than a SQL query.

  • SQL Execute
    This is a mini SQL Query Analyzer which can be used to execute almost any Transact-SQL script. It includes the ability to automatically translate Dexterity technical names for tables and fields into their physical name equivalents used by SQL. No need to install the SQL Administration tools just to run a quick query.

  • Configuration Maintenance
    This option just allows the settings in the tool to be cleared if they are no longer needed.

NOTE: While in Standard Mode, the Automatic Debugger Mode can be active, it just cannot have any settings changed.



The tool is free and available for download from CustomerSource. You can also contact support or your assigned consultant at Collins Computing and we can assist you with installing this very useful tool.

Thursday, April 23, 2009

Allocating Inventory

Recently I have run across customers that have several sales orders in Dynamics GP that will not be fulfilled and shipped for a few weeks or months. They are having problems with their inventory because the sales orders already have inventory allocated to the order eventhough the inventory is still on the shelf.



I have recommended that they look at creating a new Order Type. The new order type would not automatically allocate inventory items as they are entered on the order. Once the order is ready to ship you could then go into the Order and allocate and fulfill the items or you can allocate and fulfill when you transfer the Order to an Invoice.



I find many people forget about this setting in Sales Order Processing.


Tools - Setup - Sales - Sales Order Processing - Orders

Wednesday, April 22, 2009

Account Rollups

  • Do you need to know the total of all of your salary accounts?
  • Do you need a quick look at all of your travel accounts against budget?
  • Would you like to get a quick look at your net income without running a report?

Account Rollups might be your answer!!!!

  • Account Rollups let you consolidate information from various accounts and then be able to drill down into the account details.
  • Useful for things like departmental totals with drilldowns.
  • Accounts do not have to be consecutive.
  • Rollups can include Actual, Budget and Calculated information
How to inquire on multiple accounts

Inquiry – Financial – Account Rollup
Step 1 – Enter an Option ID (if you enter a new name you will be prompted to create the new Option)
Step 2 – Select
· Account Segment to sort by,
· Select Number of Columns in inquiry
Step 3 – Setup Columns
· Enter Header Name (for example: Actual, Budget, Historical)
· Select Type
· Enter Selection for data
Step 4 – Select Accounts
· By Segment
· From Range – To Range

Step 5 – Save Option
Step 6 - Redisplay

Monday, April 20, 2009

Upcoming Webinars at Collins Computing

Are you looking to learn more about Dynamics GP? Well Collins Computing is offering our customers the opportunity for some free training and information.

All webinars are at 10:00am Pacific Time and require preregistration. Collins Computing customers should contact their account manager or Analisa at 949-457-0500 to register.

04/22/09 Report Writer
05/28/09 Collections Management
06/24/09 Forecaster Overview
07/23/09 eBanking
08/27/09 Security Tips and Tricks
09/24/09 Intercompany
10/28/09 Rockton Software enhancements
11/19/09 Analytical Accounting
12/16/09 Analysis Cubes
01/27/09 Excel Report Builder

Wednesday, March 11, 2009

Financial Planning and Reporting Roadmap

Well I just attended the Financial Planning and Reporting roadmap here at Convergence. They were talking about Management Reporter which will by the Dynamics CPM (Corporate Performance Management) solution. The problem is we will not get Management Reporter until 2010 with GP 11. When we do get Management Reporter it will only replace FRx 6.7. We will still need to use Forecaster or Enterprise Reporter for budgeting.

The plan is for Management Reporter 3.0 to offer budgeting but that will not be until 2012 and advanced budgeting and consolidation will not come until 2014.

So it looks like we still need keep moving forward with Forecaster for the next few years.

Tuesday, March 10, 2009

Convergence Day 1

Convergence is under way. The day started with a keynote presentation by Kirill Tatarinov. He had many product demos and all of our customers that attended really seemed to like it.

From there we went to General Sessions. Most of us were in the Dynamics GP sessions. There were a lot of demos. They showed Extender, Action Panes, Web Services, Vendor Portal and 3 views into GP11. It was great to see the Microsoft Word forms for GP11.

Announcements from GP General Session include:
Service Pack 4 for GP 10 will ship in July 2009
GP 11 is targeted for May 2010.

Extender is changing and will allow you to create base forms but the price goes up on August 1, 2009. New CRM adapter in Q3 2009.

They also talked about Management Reporter replacing FRx in Version 11. It will be an option not a requirement. They also showed a lot of metrics and graphs. It was all shown in Sharepoint.

Overall a very good morning. Stay tuned for more

Tuesday, February 24, 2009

BUSINESS INTELLIGENCE FOR EVERYONE

Excel Report Integration is available with Dynamics GP 10.0. Its part of the GP 10.0 core functionality so there is no additional charge for Excel Report Integration. However, if you deploy the Excel reports by using MS SharePoint Server 2007, there is an additional charge to do this. What is Excel Report Integration: By default Excel reports are created based on existing SmartList Favorites. These reports use an Office data connection (ODC) to update data at any time. Essentially what you have are Excel reports connected to your SLQ database that can be saved and subsequently opened up again and refreshed at any point in time. This is very different and much better than what we're used to with SmartList where you have to continually export the repot to Excel to get the latest results. Cool! The reports, of course, are available within Great Plains where they can be accessed from the reports list. They can also be generated to a network share or to SharePoint with appropriate security. The dual deployment capability is good example of the Microsoft initiative of providing business intelligence for everyone throughout the organization whether they are GP users or not.

The actual report deployment is a two step process accomplished in the reporting tools setup window. Here a network share has been specified for both the data connections and the reports library so that non-GP users can access the reports.


Users can view the Excel reports and data connections only if they have admin credentials on SQL server and have access to the network share. So security needs to be addressed at the share folder and at the database level. If the reports are deployed to SharePoint, then SharePoint group or individual user security also needs to be setup.
Here are a couple of other things about Excel reports:
You can change an existing Excel report and save the report by using the same name or by using a new name
Say you don't want to use the standard report but you want to create a new Excel report (maybe a pivot chart/table report). You can use the data connection that is provided to create your unique Excel report.
If you want additional information on Excel Report Integration, please see the TechKnowlege article 949524

Tuesday, February 3, 2009

Don't Forget about Microsoft Convergence 2009

The Power of Possibilities
March 10-13, 2009 New Orleans, LA

This is the annual Microsoft Dynamics conference. It is attended by Microsoft Team Member, Microsoft Partner and Customers.

But why should Dynamics GP Users attend Convergence???

· 65 Dynamics GP specific sessions
· 11 Business Intelligence sessions
· 20 Server sessions
· Don’t forget the Keynotes, General Sessions, Interactive Discussions, and Hands-On Labs
· Of course the Sponsors and Exhibitors

Session will include information on Business Portal, Workflow, Sharepoint, Excel Reports, Extending your solution, Security, Electronic Banking, Advanced Tips & Tricks, Troubleshooting, and many more.

In addition there will be a sneak peak at Dynamics GP 11.0. What are they planning???? I cannot wait to find out.

DATE AND VENUE
March 10-13, 2009

Morial Convention Center
900 Convention Center Blvd.
New Orleans, LA 70130
http://www.mccno.com

PRICING
Regular Price = $1495
Group Discount is $100 off 3rd and more

Don't miss out - REGISTER TODAY!!!

Monday, February 2, 2009

Don't forget about CustomerSource

Over the years I have answered many support calls that the client could have answered themselves with just a simple search in CustomerSource. Of course I have no problem answering support calls and helping clients, but I know everyone is watching their budget and looking for places to cut. Unfortunately they sometimes cut out support when they do not realize they have access to CustomerSource and they can use the self support.

Of course using CustomerSource requires that you have an active service plan. If you have an active plan you will get access to all of the following areas:
  • News and Events
  • My Account
  • Support
  • Downloads and updates
  • Technical content
  • Product information
  • Service plan information
  • Training and certification
  • Microsoft Dynamics newsgroups
  • Solution Finder

In my opinion the top two areas are Support and Training. In the Support section you have access to technical resources including Automated Solutions, Hot Topics and Microsoft KnowledgeBase. The KnowledgeBase is the same database used by the technical support team at Microsoft. Training give you access to searchable lists of classroom training, unlimited access to several e-learning classes and downloadable training material.


These are just a few highlights of CustomerSource. I could write several pages on the value of CustomerSource, but seeing is believing. You need to login and take a look. To access CustomerSource simply go to www.microsoft.com/dynamics/customersource.mspx. On this page you can login if you currently have access or you can take a tour of the features. CustomerSource login is controlled by using Microsoft Live login. Also either your company administrator, partner or Microsoft support will need to activate your account and send you an invitation.


Remember CustomerSource requires an active service plan, so if your plan has lapsed you need to contact your partner to renew prior to using CustomerSource.

Thursday, January 29, 2009

Extending Dynamics GP

Have you ever wished you had a place to enter additional information in Dynamics GP? This might be additional information on Vendors, Customers or even Inventory Item. For example you might want to track credit information for a customer. You have information for Credit Rating, D & B Number, Credit Reference, Credit Contact and Email. While we are all familar with entering information in other fields that we are not using, like Comment 1 and 2 or Tax Registration. It is always easier to had fields created specifically for the information we are tracking.
With Extender you can simply create a new "sub" window that is attached to any window in Dynamics GP or any other Dexterity based application.

Field types are:

  • Checkbox
  • Currency
  • Date
  • List
  • Lookup
  • Number
  • Percentage
  • Phone Number
  • Quantity
  • Short String
  • Time
  • Linked Lookup
  • EMail Address
  • File
  • Folder
  • Long String
  • Calculated
This information can be added to Reports and Smartlist. You can also create an inquiry to see the information on other windows in Dynamics GP.

A couple things to know about Extender

Extender is an Ala Carte Module, so even if you are on BRL you will still need to buy the Extender Module.

Extender was added to the Dynamics GP Suite on Version 8.0. Prior to that the module was sold by eOne. eOne also offers an Enterprise version of Extender that allows you to create your own main windows and include scripting. To learn more about the Enterprise Version of Extender you should check out
eOne Solutions.

For additional information on Extender and adding fields to reports you can review TechKnowledge articles 937244, 898983, and 935385.

Wednesday, January 28, 2009

Welcome to our new BLOG!!!

We hope to provide important tips and tricks on Dynamics GP along with current information about Dynamics GP and other related products.

Please subscribe or check back often for the latest information.