Friday, February 19, 2010

GP 2010 on 64-bit Windows 7 with i3 Processor

I have more to report on my attempted installation of Dexterity 2010.

Thanks to Vaidy for the guidance, I did the following:
I ran "dw20sharedia64.msi" from the following path:
GP2010 Main Folder -> Tools -> Dex -> Watson -> dw20sharedia64.msi

I got this error:

I then ran “dw20sharedamd64.msi'” from that same folder and was greeted with nothing noteable. I didn't expect anything because this is not an AMD processor, but you never know.

I then ran the “dw20shared.msi” and received this message:

It looked promising, but then nothing else happened.

I then run the setup.exe file for Dex and got this again:

I restarted the machine between attempts.

The test machine's processor is an i3. The i3 was released January 8th, 2010. Since the first error message tells me the processor isn't supported, I am thinking the new processor may be the issue.

I do not have another machine to use for the beta - has anyone tried to install Dex 2010 on a similar hardware configuration to mine?

The machine is 64-bit, running Windows 7 Professional, with an i3 processor.

Until next post!


12 inches of Snow in Dallas!

How is this related to Dynamics GP? It isn’t, but it was a record setting day! The snow fell on Thursday, Feb 11, 2010. It is all melted now, but it was amazing.

The city shut down, schools closed, electricity went out, etc. I grew up in Michigan, if they had closed the schools because of cold weather and snow, I would still be in high school.

The pictures are from my neighborhood. We lost a lot of trees, that was a shame.

Until next post!


Tools Available from Professional Services

Lately there have been several posts to the various newsgroups regarding functionality that is not part of Dynamics GP ‘out-of-the-box’.

I received a list from GP Professional Services of tools available to partners for resale. Prices are subject to change, and the versions supported have been based on the popularity of the request. Some of the tools are my favorite price, free! The most expensive one is $1,500, most are $500 or $750.

I have struggled with so many of the issues that these tools have solved so I thought I would put the list out for all. I asked Microsoft first and they said it was OK to post it.

Name Description Versions Price
AutoDim Utility allows you to launch Great Plains and run one or more integrations or integration groups and have Great Plains exit upon completion of the integrations. This product also supports integrating into several different companies. 7.0, 7.5, 8.0, 9.0, 10.0 500
Customer PO Number Check
(this is a very nice tool, it prevents some orders from being duplicated)
This tool checks the Customer PO Number for duplicates as data is entered into the field on both the SOP Entry window and the SOP Customer Detail Entry window. 7.5, 8.0, 9.0, 10.0 500
Doc Date Verify When a document date is entered in Payables Transaction Entry or Receivables Transaction Entry, a check will be performed to determine if the document date is in a fiscal period. 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. 7, 8.0, 9.0,10.0 FREE
Grant All Access Script Grants all users access to all projects. Not version specific FREE
Master Record Macros Macros to populate the master records when Project Accounting has been implemented after Vendors, Customers, or Employees have been created.  Not version specific FREE
Payroll Local Tax Tool This utility allows specific local taxes for an employee to be sheltered for TSA style deductions while allowing other local taxes for the same employee to not be sheltered.  Each deduction in the system can specify which local taxes should be sheltered, and employees can also be specifically excluded from this process. 7.0, 7.5, 8.0, 9.0, 10.0 500
PO Returns
(this prevents you from paying for an item that has been returned)
When invoicing a receipt in POP, this customization will check the previous quantity invoiced and the quantity returned for the line item. The maximum quantity allowed to be invoiced is based the following formula: Quantity Shipped minus (Previous Quantity Invoiced plus Quantity Returned). This customization will not allow invoicing of more than this amount. 7.5, 8.0, 9.0, 10.0 FREE
POP Cost Defaulter
(a life saver if you don’t want your PO cost to float around)
This utility allows the user to default in the Standard Cost or the Current Cost within the Purchase Order Entry window instead of the vendor specific Last Invoice Cost. 7.0, 7.5, 8.0, 9.0, 10.0 FREE
RM Auto Apply Utility

This application will allow the user to Mass Apply posted RM Credit Documents to posted RM Debit Documents.  The user can select a range of Customer, Debit Document Dates, Credit Document Dates, and a Credit Document Type restriction if desired.

The credit documents will apply to the debit documents in the order specified in Receivables Management Setup window which is the same order that Dynamics Apply Sales Documents Auto Apply button uses.

7.0, 7.5, 8.0, 9.0, 10.0 750
Shipment Notification
(YES! No more delaying customer billing!)
Will allow drop ship sales orders to be transferred to invoice prior to invoicing the purchase order 7.x, 8.0, 9.0, 10.0 750
SOP Lot Number Overrides Use this tool if you use Lot Number processing and run into situations where you sell Lot Numbers before they are entered into the system through POP or BOM.  This utility will create a temporary Lot Number receipt during the Sales Transaction Entry process and manage the Lot Number quantity accurately. After the Lot Number is received through POP, BOM or IV, the temporary receipt is removed and the actual lot receipt is updated to reflect that a portion of it has already been sold. 7.0,7.5,8.0, 9.0, 10.0 1,500
SOP Partial Kit Transfers This utility supports partial transfers of Kit items from Orders to Invoices and will maintain the Previously Invoiced quantity for the overall kit item and all of its components. This utility does not currently support partial transfers to back-order documents. 7.0,7.5,8.0, 9.0, 10.0 1,500
SOP to POP Line Reordering
(the PO doc will now be in the same order as the SOP doc.)
This utility will reorder the line items of Purchase Orders generated by the SOP to POP transfer process to be in the same order as they originally were on the Sales Order document(s).  The preview report will still show an alphabetical list, but on the actual Purchase Order document the line items will maintain their correct sequence. This is critical for companies who rely on matching up PO printouts to Packing Lists or Picking Tickets in SOP. 7.0, 7.5, 8.0, 9.0, 10.0 500
Default AddItem for POP/SOP Application that defaults the Add Item option to be marked in Sales Transaction Entry, Purchase Order Entry, POP Receivings Entry and Purchasing Invoice Entry. 8.0, 9.0, 10.0 FREE

COM dll that can be called from IM or an outside application to post some types of Dynamics Batches.  Currently the application supports posting of:
Sales Order Processing Batches
GL Transaction Entry Batches
IV Transaction Entry Batches
RM Cash Receipts Batches

Because this application uses the Continuum API, the Great Plains client must be running and a user logged into a company for this application to work.  The posting process would then use that user & company to post the desired batch.

8.0, 9.0 500
Benefit Modifier Tool Allows users to change the Benefit Code 7.5,8.0,9.0 750
Deduction Modifier Tool Allows users to change Deduction Codes 7.0,7.5,8.0,9.0 750
Credit Limit Override for eOrder Allows the function of overriding credit limits for customers that have no credit or have reached their credit limit during the creation of an Order. This feature is not available on the base package of eOrder or eCommerce. 7.0, 7.5, 8.0 750
Customer specific Catalogs for eOrder Provides ability to setup multiple catalogs and assign different catalogs to different customers. 7.0, 7.5, 8.0 750
Email confirmation for eOrder Sends an email to the shopper after the order has been placed with the order details to the email address entered on the Internet Information page from the page off the Customer’s main address record for eOrder 7.0, 7.5, 8.0 750
Email used as login for eOrder Changes the login from Customer ID to the email address entered on the Internet Information page from the page off the Customer’s main address record. 7.0, 7.5 750
Extended Pricing eOrder / eCommerce Allows extended pricing for the eOrder and eCommerce module. 7.0, 7.5 1,500
Historical Order Inquiry for eOrder Provides the capability of viewing historical Order information within eOrder. 7.0, 7.5 750
Email Invoices Allows users to email invoices to Customers. No more hassles mailing invoices to customers, simply specify their email address and send the invoice electronically. 7.0, 7.5, 8.0, 9.0 750
Employee Business Card with Image The Employee Business Card with Image web part will display the image of the employee.  Employee Business Card with Image web part adds an image to the Employee Business Card web part found in the Business Portal at Company – Directory.  Business Portal administrators simply name their *.jpg file according to the Employee ID and copy the file to a specified directory. 8.0, 9.0 FREE
IV Post To GL Allows IV Transaction Batches to look at the checkbox in Setup>Posting>Posting to determine if the Post To GL checkbox should be marked or unmarked for IV batches. 6.0,7.0,7.5,8.0,9.0 FREE
Multi-Build Payroll Tool Allows multiple people to build /calculate / print / post payroll batches at the same time 8.0, 9.0 1,000
Pay Code Modifier Tool Allows users to change Pay Codes 7.0,7.5,8.0,9.0 750
Payables Management Checks (Decimal Place Tool) There is an option under Setup | System | Currency to change the decimal places. Once you move them up (example 2 to 4) it affects all modules checks and you are not able to back it down. This tool will print the checks out with two decimal places for Payables Management and Bank Reconciliation checks. 7.0,7.5,8.0,9.0 FREE
Payroll Checks (Decimal Place Tool) There is an option under Setup | System | Currency to change the decimal places. Once you move them up (example 2 to 4) it affects all modules checks and you are not able to back it down. This tool will print checks with two decimal places only for Payroll checks and Direct Deposit. 7.0,7.5,8.0,9.0 FREE
Payroll Customized 941 Report Prints the 941 by date range and  / or employee 7.0, 7.5, 8.0, 9.0 500
Payroll Detailed Activity Tracking Each time a change is made within HR and Payroll to an employee a script can be processed to see the activity. 7.5, 8.0, 9.0 750
Payroll Pay Code History Edit Allows users to change WC, FUTA and SUTA within the Pay Code History window 7.0, 7.5, 8.0, 9.0 500
PM Checks Default
(remember this feature?)
Default Print PM Checks to check and not alignment form 6.0,7.0,7.5,8.0,9.0 FREE
Print Check Default
(and its cousin in payroll)
For payroll only (not used with Direct Deposit)  to default into print the check within the Print Checks window instead of Printing the alignment first 7.0, 7.5 FREE
PM EFT User Defined Setup Utility Allows users that require slight variations to the EFT file to format in order for their banks to accept the files. 8.0, 9.0 FREE
POP Over Receipt Tolerance Utility that allows a receipt tolerance percentage for quantities.  A setup window allows the user to enter a tolerance percentage, that percentage is then used when a Purchase Order is received.  The highest quantity that can be received is the original quantity ordered plus the percentage amount.  For example, a Purchase Order is entered for a quantity of 10.  A tolerance percentage of 20% is entered.  The highest quantity allowed to be received would be 12. 7.0, 7.5, 8.0, 9.0 750
Security Troubleshooting Utility This utility assist in troubleshooting security issues which have occurred in Great Plains.  Utility lists each window/report resource ID then trace these references to the security table before the permissions to the resources ID is validated by Great Plains, aiding in which resource is causing a security issue in Great Plains.  Does not function with Small Business Manager. 7.0, 7.5, 8.0, 9.0 FREE
SOP Default Site per Line This customization changes the site that is defaulted on line items.  Instead of pulling the site from the Default Site on the SOP Entry window, if there is a default site assigned to the item in Cards>Inventory>Qtys/Sites, then that site will default for that line item  If there is no default site id for the item, then the customization will default the first site that is assigned to the item. 7.0, 7.5, 8.0, 9.0 FREE
SOP Returns Account Default This customization will default the sales order returns account when a return is created from SOP Entry under Extras>Create Return.  As the SALES distribution type is created for the return, the customization will check the Sales Order Returns account from the customer card.  If the account is not empty, then all SALES type accounts will default with the account number in the Sales Order Returns slot from the customer. 7.0, 7.5, 8.0, 9.0 FREE
SOP Sort Line Items This utility allows the user to define custom sorting options to display line items in Sales Order Processing.  For example, a sort could be defined by Item Number and then the currently selected SOP Document would display the line items in Item Number order instead of the standard by order entered.  This utility does not physically reorder the records in the underlying tables; it only displays them differently in the Sales Order Processing window.  This application also does not affect the way that sales documents print. (SQL database only) 7.0, 7.5, 8.0, 9.0 500
Update User Date Utility
(otherwise the user date will be off and so will all of the default batch dates)
This application automatically updates the User Date in Great Plains to the next date at midnight.  The application will run in the background as long as Great Plains is open.  This tool can be useful when Great Plains is left open on a machine overnight running integrations or other processes.  (date disabled with dex.ini switch) 7.0, 7.5, 8.0, 9.0 FREE

Tuesday, February 16, 2010

GP 2010

I installed the beta version of GP 2010 on my 64-bit Windows 7 pro machine running SQL 2008. It installed without a hitch. I installed the SDK with no problems. I could not get Dexterity installed. I received a simple error message:

So that was a little disappointing but I still plan on taking GP2010 through the upgrade cycle of one of my smaller clients and see what I can discover. The 'new' FRx is also part of my plan - conversion wizard and all. I'm doing all of this on a clean machine dedicated to the beta test of GP2010 and the Office Beta.

Good news! I hooked up the old c-tree ODBC driver and can easily read the .dat files now.

This should be a fun process, especially since I have a machine just for testing.

Until next post :)