Bulk Copy Process (BCP) to Export Microsoft Dynamics GP Data into New Database

How to use the Bulk Copy Process (BCP) to export data and to import data by using Microsoft Dynamics GP.
  1. Make a backup of your company database.
  2. Copy and paste the following CreateBulkCopyOut.sql script into Microsoft SQL Query Analyzer.
/* Script to create bcp commands to export data for all tables. */
SET QUOTED_IDENTIFIER OFF
select 'bcp "TWO..' + name + '" out ' + name + '.out -e ' + name + '.err -c -b 1000 -U sa -P password -t "|" -S SERVERNAME -r "#EOR#\n"' from sysobjects where type = 'U' order by name

In the script, replace the following placeholders with the correct information:
    • Replace TWO with the name of your company database.
    • Replace password with your sa password.
    • Replace SERVERNAME with the name of your instance of Microsoft SQL Server.
Note To open Query Analyzer, click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.

Note If you are using Microsoft SQL Server 2000 Desktop Engine (also known as MSDE 2000), run the statement in Microsoft Support Administrator Console. To open Support Administrator Console, click Start, point to Programs, point to Microsoft Support Administrator Console, and then click Support Administrator Console. Support Administrator Console requires a separate installation. You can install the program by using the Great Plains installation CD number 2.
  1. Run the script against the database and then save the results to a batch file. To do this, follow these steps:
    • If you are using Query Analyzer, click in the results pane, and then click Save As on the File menu. Create a folder named BCPData, name this file Copyout.bat, and then click Save.
    • If you are using Support Administrator Console, click File, and then click Export. Create a folder and name it BCPData. Name the file Copyout.bat. Then click Save.
  2. Copy and paste the following CreateBulkCopyIn.sql script into Query Analyzer.
/* Script to create bcp commands to import data for all tables. */
SET QUOTED_IDENTIFIER OFF      
select 'bcp "TWO..' + name + '" in ' + name + '.out -e ' + name + '.err       -c -b 1000 -U sa -P password -t "|" -S SERVERNAME -r "#EOR#\n"' from sysobjects where type = 'U' order by name

In the script, replace the following placeholders with the correct information:
    • Replace TWO with the name of your company database.
    • Replace password with your sa password.
    • Replace SERVERNAME with the name of your instance of SQL Server.

Note To open Query Analyzer, click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.

Note If you are using SQL Server 2000 Desktop Engine, run the statement in Support Administrator Console. To open Support Administrator Console, click Start, point to Programs, point to Microsoft Support Administrator Console, and then click Support Administrator Console. Support Administrator Console requires a separate installation. You can install the program by using the Great Plains installation CD number 2.
  1. Run the script against the database and then save the results to a batch file.
    • If you are using Query Analyzer, click in the results pane, and then click Save As on the File menu. Create a folder and name it BCPData. Name the file Copyin.bat, and then click Save.
    • If you are using Support Administrator Console, click File and then click Export. Create a folder and name it BCPData. Name the file Copyin.bat. Then click Save.
  2. Perform a bcp command to move the data out of the company database. To do this, use the appropriate method.
      • Open the BCPData folder.
      • Double-click the Copyout.bat file.

        Note The batch file starts the BCP process to copy the data from the database to a text file.
  1. Delete the company from within Great Plains. To do this, log into Great Plains as the sa user. Click Tools, point to Setup, point to System and then click Company. Click the lookup glass to display all the companies listed. Select the company and then click Delete.

    Note For versions of Microsoft Great Plains that are earlier than Microsoft Great Plains 8.0, delete the company. To delete the company, do the following: On the Setup menu, click System, and then click Company to delete the company.
  2. Remove the database.
    • If you are using Microsoft SQL Server, open Enterprise Manager, expand the server name, expand Database, right-click the company database that you deleted in step 7, and then select Delete.
DROP DATABASE TWO
  1. Re-create the company database and procedures. To do this, start Great Plains Utilities, log on as the sa user, and then click Create new company in the Additional Tasks dialog box.

    Note Use the same company name as the one that you deleted in step 7.
  2. After the company is created, the tables must be truncated.
If you are using Microsoft SQL Server, run the following Truncate_Table_Company.sql script in Query Analyzer.

o    /* Script to remove all data from all user tables in the company database */
o    SET QUOTED_IDENTIFIER OFF
o    if exists (select * from sysobjects where name = 'RM_NationalAccounts_MSTR_FKC')
o    ALTER TABLE dbo.RM00105
o    DROP CONSTRAINT RM_NationalAccounts_MSTR_FKC
o    Go
o    declare @tablename char(255)
o    DECLARE t_cursor CURSOR for
o       select "truncate table " + name
o       from sysobjects where type = 'U'
o       set NOCOUNT on
o       open t_cursor
o       FETCH NEXT FROM t_cursor INTO @tablename
o       while (@@fetch_status <> -1)
o       begin
o       if (@@fetch_status <> -2)
o       begin
o       exec (@tablename)
o       end    
o       FETCH NEXT FROM t_cursor into @tablename
o       end
o    DEALLOCATE t_cursor
o    GO
o    ALTER TABLE dbo.RM00105 ADD
o       CONSTRAINT RM_NationalAccounts_MSTR_FKC FOREIGN KEY
o       (
o       CPRCSTNM
o       ) REFERENCES dbo.RM00101 (
o       CUSTNMBR
o       )
o    GO

  1. Move the data back into the company database. To do this, open the BCPData folder, and then double-click the Copyin.bat batch file. Running this batch file starts the process of moving the data back into the company database. When the data is moved back into the database, all indexes are created and verified for each table.

    Note When the process is completed, the BCPData folder will contain .err files. If any one of these .err files is larger than 0 KB, the data was not imported for the company database successfully.

Additional steps

If you are using the BCP process to change your Microsoft SQL Server Sort Order, you must bulk copy data out of the DYNAMICS database and all Company databases.

Note Changing the Microsoft SQL Server Sort Order for the DYNAMICS database and for the Company database is not supported by Microsoft. This is only supported if MBS Professional Services makes the change for you.
To do this, follow steps 1 through 11. In step 10, you must also truncate the DYNAMICS database. To do this, use one of the following methods:
If you are using Microsoft SQL Server, run the following Truncate_Tables_Dynamics.sql script in Query Analyzer.
·         /* ** **
·         Truncate_Tables_Dynamics.sql
·         function: Will remove all data from all user tables in the DYNAMICS database
·          ** */
·          
·         SET QUOTED_IDENTIFIER OFF
·          
·         if exists (select * from sysobjects where name = 'orgEntity_SETP')
·         ALTER TABLE dbo.ORG40100
·         DROP CONSTRAINT orgEntity_SETP
·         GO
·         if exists (select * from sysobjects where name = 'orgRelation_MSTR')
·         ALTER TABLE dbo.ORG00100
·         DROP CONSTRAINT orgRelation_MSTR
·         Go
·         declare @tablename char(255)
·          
·         DECLARE t_cursor CURSOR for
·         select "truncate table " + name
·         from sysobjects where type = 'U'
·          
·         set NOCOUNT on
·         open t_cursor
·         FETCH NEXT FROM t_cursor INTO @tablename
·         while (@@fetch_status <> -1)
·         begin
·         if (@@fetch_status <> -2)
·         begin
·         exec (@tablename)
·         end
·          
·         FETCH NEXT FROM t_cursor into @tablename
·         end
·          
·         DEALLOCATE t_cursor
·         GO
·         ALTER TABLE dbo.ORG40100 ADD
·         CONSTRAINT orgEntity_SETP FOREIGN KEY
·         (
·         ENTYLVL
·         ) REFERENCES dbo.ORG40000 (
·         ENTYLVL
·         )
·         GO
·         ALTER TABLE dbo.ORG00100 ADD
·         CONSTRAINT orgRelation_MSTR FOREIGN KEY
·         ( ENTITYID ) REFERENCES dbo.ORG40100 ( ENTITYID )
·         GO

VBA6 for Windows 7

Copy following text and save as "VBA6_4_Win7.REG" file and import in Windows 7 registry.


Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\TypeLib\{000204EF-0000-0000-C000-000000000046}\6.0\9\win32]
@="C:\\Program Files\\Common Files\\microsoft shared\\VBA\\VBA6\\VBE6.dll"

What is eConnect?

Dynamics eConnect is a collection of tools, components, and interfaces that allow applications to programmatically interact with Microsoft Dynamics GP. The key eConnect components and interfaces include:

  • A .NET managed code assembly
  • A Microsoft BizTalk® Application Integration Component (AIC)
  • Microsoft Message Queuing (MSMQ) services

These eConnect interfaces allow external applications like web storefronts, web services, point-of-sale systems, or legacy applications to integrate with Microsoft Dynamics GP. The external applications can perform actions like creating, updating, retrieving, and deleting back office documents and transactions. While eConnect supplies a large number of documents, not every Microsoft Dynamics GP feature is available through eConnect.

Hint: Throughout the documentation, the terms back office and front office are used. The term back office refers to the financial management system, in this case, Microsoft Dynamics GP. The term front office refers to customer relationship management systems, data warehouses, web sites, or other applications that communicate with the back office.

eConnect allows you to leverage the existing transaction-based business logic of Microsoft Dynamics GP. This allows you to focus your time and energy on creating or enhancing custom applications for the front office.

Using keyboard shortcuts in Microsoft Dynamics GP

This article explains how to use the keyboard shortcuts in Microsoft Dynamics GP.
To access a menu using keyboard shortcut keys, press ALT and the underlined letter of the menu that you want to access. For example, press ALT, A to display the Transactions menu and press ALT, F to display the File menu. To select a command from a menu by using the keyboard, press ALT and the underlined letter of the menu that you want to access, then select the underlined letter in the command name. For example, to open the Transaction Entry window, press ALT, A, F, G.
What if two menu commands share the same keyboard shortcut?
If two commands in a menu share a common keyboard shortcut, you can switch between the commands by continuing to press the underlined letter for those commands. For example, if you display the Transactions menu and select Financial, there are four commands that share the same keyboard shortcut (Batches, Bank Deposits, Bank Transactions, and Bank Transfers). To select the Bank Deposits command, press ALT, A, F, B, B. Each time you press B, the next command that has B underlined in its name is selected.

What if a button in an opened window shares the same keyboard shortcut as a menu on the menu bar?

When a button in an open window shares the same keyboard shortcut as a menu on the menu bar, the commands available on that menu will be displayed when you use the keyboard shortcut. But if you type the keyboard shortcut and then press the underlined letter again, the button in the open window will be selected. For example, the Accounts button in the Customer Maintenance window shares the same keyboard shortcut as the Transactions menu on the menu bar. If the Customer Maintenance window is open and you press ALT, A, the commands that are on the Transactions menu will be displayed. But if the Customer Maintenance window is open and you press ALT, A, A, the Accounts button will be selected and the Customer Account Maintenance window will be displayed.

WebMasters Block These IP Addresses

These Spam Referrers have been very diligent to show us their websites so I will show you their IP’s.  But first let me show you a few ways of blocking IP’s.  Block with null routes once you reboot the routes will be gone so this is only a temp fix route add IP-ADDRESS gw 127.0.0.1 lo.  You can also use reject target route add -host IP-ADDRESS reject.  But you might want to do something more permanent like using IPTABLES

iptables -A INPUT -s IP-ADDRESS -j DROP

To keep my server light I did not include IPTABLES in the kernel so I wrote a script to make my life easier
count=0
for i in `cat spamlist.txt`
do
count=`expr $count + 1`
echo “Line $count is being displayed”
route add $i gw 127.0.0.1
echo $i
echo counting
done
echo “End of file”
echo done
Just add the IP Addresses below to a file called spamlist.txt give the script execute permission
chmod +x scriptfilename.sh
and BAM!

So without further or due I give you a great list of spammers you asked for it spammers.

173.234.152.188
173.234.52.34
69.163.147.151
109.111.184.1
213.163.97.20
184.82.38.7
221.132.73.146
173.234.13.162
98.165.84.55
173.203.243.138
173.234.182.162
173.208.95.16
221.249.73.61
38.99.89.252
82.117.226.27
173.208.124.63
173.208.70.99
72.44.50.58
126.15.1.32
72.188.60.3
173.234.12.178
118.69.192.62
173.234.47.192
173.234.46.171
113.139.182.178
204.124.183.196
64.120.31.210
173.234.153.152
173.234.183.240
79.2.190.199
173.208.67.232
202.198.164.114
95.244.108.249
174.34.171.6
67.160.221.57
24.121.181.7
173.234.93.110
173.234.92.138
187.48.56.221
173.203.78.165
193.198.185.3
62.215.5.66
173.208.14.114
173.234.92.166
222.124.19.34
173.208.51.26
195.221.21.235
200.216.186.42
109.169.63.25
173.208.71.168
212.20.230.84
64.182.124.219
92.247.12.242
210.101.131.231
65.202.152.252
78.169.34.83
12.96.205.18
180.241.250.39
192.251.226.205
200.165.90.210
189.16.123.100
174.142.104.57
173.234.151.15
173.234.48.57
173.234.54.48
222.127.148.210
189.84.61.130
173.224.209.100
195.46.235.18
208.115.221.178
211.43.152.55
211.43.152.54
211.43.152.57
211.43.152.49
201.77.182.103
67.202.108.170
110.137.76.170
189.75.119.10
60.251.54.208
61.19.127.212
189.85.22.242
74.82.176.137
89.28.64.114
173.234.12.166
173.234.30.87
190.12.2.174
173.208.100.192
38.96.193.74
66.232.112.91
217.10.246.2
196.29.161.84
201.76.211.246
189.85.22.242
61.19.127.212
60.251.54.208
189.75.119.10
110.137.76.170
67.202.108.170
201.77.182.103
189.6.168.62
173.208.124.9
118.97.67.134
187.48.52.241
69.71.222.186
173.208.50.43
189.126.63.85
219.93.178.162
189.17.16.130
163.180.20.183
173.203.112.170
95.66.4.1
173.234.167.188
190.145.77.34
72.32.182.210
163.180.20.183
67.159.178.199
81.9.97.45
220.225.219.165
173.234.54.190
189.6.168.62
186.42.121.2
118.96.146.90
173.208.124.9
118.97.64.88
222.165.130.214
174.34.169.210
122.181.17.54
222.165.130.214
118.97.64.88
81.18.116.66
111.68.103.62
89.148.238.87
78.189.147.58
200.94.71.73
173.203.108.236
61.219.80.80
200.94.71.73
71.230.128.156
211.23.82.90
189.114.58.245
173.234.19.236
24.111.190.251
203.99.193.132
202.43.180.146
187.111.9.134
189.83.234.9
61.162.174.209
190.202.124.18
190.8.111.59
210.246.92.3
89.27.55.28
94.237.74.250
88.112.50.149
77.109.196.243
149.6.118.94
50.16.63.173
200.117.239.246
188.36.197.28
84.0.224.99
222.124.178.98
189.63.138.110
222.124.8.13
173.234.166.207
190.109.169.176
220.227.247.178
119.110.97.28
85.12.68.98
189.85.60.18
118.98.232.50
119.110.97.28
187.1.11.218
18.181.2.157
189.77.29.29
27.131.172.9
209.203.19.2
187.111.1.194
78.140.206.22
203.172.212.2
79.98.31.241
202.28.66.115
62.10.53.132

Desktop Shortcut Keys To Ever Use

These days are very interested to use shortcut keys & some newbies asked me to list it, but now I’m back to college, so i listed out the top 21 & we will blog the whole shortcut keys list later. Now let us see the top 21 desktop shortcut keys.

1. Windows key + E = Explorer
2. Windows key + Break = System properties
3. Windows key + F = Search
4. Windows key + D = Hide/Display all windows
5. ALT + Tab = Switch between windows
6. ALT, Space, X = Maximize window
7. CTRL + Shift + Esc = Task Manager
8. CTRL + C = Copy
9. CTRL + X = Cut
10. CTRL + V = Paste
11. CTRL + Z = Undo an action
12. CTRL + Y = Redo an action
13. CTRL + A =Select all items in a document or window
14. F1 = Display Help
15. F2 = Rename the selected item
16. F3 = Search for a file or folder
17. F4 = Display the Address bar list in Windows Explorer
18. F5 = Refresh the active window
19. F6 = Cycle through screen elements in a window or on the desktop
20. F10 = Activate the menu bar in the active program

FIN630 - Investment Analysis & Portfolio Management , GDB


Holding Period Return = Income + [ End of Period Value – Initial Value]
                                                            Initial Value

Holding period return of Stock A                              = 6.034%
Holding period return of Stock B                              = 6.00 %
Annual Return for both stocks:
            Stock A                                                       = 5.034%
            Stock B                                                       = 5.00 %
Stock With Greater Return                                       = Stock A

Fin 630 , Investment Analysis and Portfolio Management


REQUIREMENT 1:
ABC COMPANY
STATEMENT SHOWING RETURN ON ASSETS CALCULATION (All Figures in Thousand of Rupees)

                 Net Income / Total Assets X 100

                                    =   500 / 8,000 X 100
Return on Assets       =   6.25 % 

ABC COMPANY
STATEMENT SHOWING RETURN ON EQUITY CALCULATION (All Figures in Thousand of Rupees)

                 Net Income / Shareholder’s Equity X 100
                                    = Net Income / (Share Capital + Retained Earnings) X 100
                                    =   500 / (1,000 + 90) X 100
Return on Equity      =   45.87%






ABC COMPANY
STATEMENT SHOWING EARNING PER SHARE CALCULATION

                (Net Income – Dividend on Preferred Stock)/ Outstanding Shares
                                    =   500,000 / (100,000)
Earnings per Share   =   Rs. 5 / Share

REQUIREMENT 2:

ABC COMPANY
STATEMENT SHOWING VALUE OF BOND A CALCULATION

               C* [1- {1/ (1+i) n}] / (i) + M / (1+i)n
                                    =   75* [1- {1/ (1+0.05) 40}] / (0.05) + 1,000 / (1+0.05)40
                                    = 75* [1- {1/ (7.0399) }] / (0.05) + 1,000 / (7.0399)
                                    = 75* [1- {0.1420 }] / (0.05) + 142.046
                                    = 75* [ 0.8579 ] / (0.05) + 142.046
                                    = 75* 17.159 + 142.046
                                    = 1,286.93 + 142.046
Value of Bond A        = Rs. 1,428.977




REQUIREMENT 3:

ABC COMPANY
STATEMENT SHOWING VALUE OF BOND B CALCULATION

               C* [1- {1/ (1+i) n}] / (i) + M / (1+i)n
                                    =   27.5* [1- {1/ (1+0.04) 40}] / (0.04) + 1,000 / (1+0.04)40
                                    = 27.5* [1- {1/ (4.8010) }] / (0.04) + 1,000 / (4.8010)
                                    = 27.5* [1- {0.2083 }] / (0.04) + 208.29
                                    = 27.5* [ 0.7917 ] / (0.04) + 208.29
                                    = 27.5* 19.7928 + 208.29
                                    = 544.30 + 208.29
Value of Bond B        = Rs. 752.59


                                     



Synchronize Time Throughout Your Entire Windows Network

Synchronizing time on your Windows domain requires following the Active Directory domain hierarchy to find a reliable time source for your entire domain.  In a Windows Server 2003 Active Directory forest, the server that holds the primary domain controller (PDC) emulator role acts as the default time source for your entire network.

Each workstation and server in this network will try to locate a time source for synchronization. Using an internal algorithm designed to reduce network traffic, systems will make up to six attempts to find a time source. Here's a look at the order of these attempts:
  • Parent domain controller (on-site)
  • Local domain controller (on-site)
  • Local PDC emulator (on-site)
  • Parent domain controller (off-site)
  • Local domain controller (off-site)
  • Local PDC emulator (off-site)
To ensure that your servers are finding the proper time, you must configure your PDC emulator to receive the time from a valid and accurate time source. To configure this role, follow these steps:
  1. Log on to the domain controller.
  2. Enter the following at the command line:
W32tm /config /manualpeerlist:<timeserver> /syncfromflags:manual
<timeserver>is a space-delimited list of DNS and/or IP addresses. When specifying multiple timeservers, enclose the list in quotation marks.
  1. Update the Windows Time Service configuration. At the command line, you can either enter W32tm /config /update, or you can enter the following:
Net stop w32time
Net start w32time

If a system isn't a member of a domain, you must manually configure it to synchronize with a specified time source. Follow these steps:
  1. Go to Start | Control Panel, and double-click Date And Time.
  2. On the Internet Time tab, select a time server from the drop-down list, or enter the DNS name of your network's internal time source.
  3. Click Update Now, click Apply, and click OK.
Note: It's important to make sure that any access control lists on your network allow UDP port 123 to and from systems to the selected time source.

Birth Day

December 23rd ~ January 1st = Red
January 2nd ~ January 11th = Orange
January 12th ~ January 24th = Yellow
January 25th ~ February 3rd = Pink
February 4th ~ February 8th = Blue
February 9th ~ February 18th = Green
February 19th ~ February 28th = Brown
March 1st ~ March 10th = Aqua
March 11th ~ March 20th = Lime
March 21st = Black
March 22nd ~ March 31st = Purple
April 1st ~ April 10th = Navy
April 11th ~ April 20th = Silver
April 21st ~ April 30th = White
May 1st ~ May 14th = Blue
May 15th ~ May 24th = Gold
May 25th ~ June 3rd= Cream
June 4th ~ June 13th = Grey
June 14th ~ June 23rd = Maroon
June 24th = Grey
June 25th ~ July 4th = Red
July 5th ~ July 14th = Orange
July 15th ~ July 25th = Yellow
July 26th ~ August 4th = Pink
August 5th ~ August 13th = Blue
August 14th ~ August 23rd = Green
August 24th ~ September 2nd = Brown
September 3rd ~ September 12th = Aqua
September 13th ~ September 22nd = Lime
September 23rd = Olive
September 24th ~October 3rd = Purple
October 4th ~ October 13th = Navy
October 14th ~ October 23rd = Silver
October 24th ~November 11th = White
November 12th ~ November 21st = Gold
November 22nd ~ December 1st = Cream
December 2nd ~ December 11th = Grey
December 12th~ December 21st = Maroon
December 22nd = Teal  


RED
 

Cute And Lovable Type, You Are Picky But Always In Love... And Liked To Be Loved. Fresh And Cheerful, But Can Be 'Moody' At Times. Capable With People Nice, Soft, And That Can Love You For The Way You Are. Likes People That Are Easy To Talk To, And Can Make You Feel. Comfortable.

Orange
 

You Are Responsible For Your Own Actions, And You Know How To Treat People. You Always Have Goals To Reach And You Really Work Hard To Get There, You Are Competitive. Your Friends Are Really Important To You And You Appreciate What You Have, You Sometimes Over React That's Because You Are Sensitive. Comfortable.
 
Yellow
 

You Are Sweet And Innocent. Trusted By Many People, And Have A Strong Leadership Towards Relationships. You Make Good Decision And Make The Right Choice At The Right Time. And Always Dreaming Of Romantic Relationship.
 
Blue
 

You May Have Low Self-Esteem, And Can Be Very Picky. You Are Artistic And Like To Fall In Love, But You Let Your Love Pass By, By Loving With Your Mind, Not Your Heart. Relationship.
 
Pink
 

You Are Always Trying Your Best In Everything, And Like To Help And Care For Other People. But You Are Not Easily Satisfied. You Have Negative Thoughts, And You Look For Romantic Love Like In A Fairytale. Relationship.
 
Green
 

You Get Along Well With New People. You Are Not Really A Shy Person, But Sometimes You Can Hurt People's Feelings By Your Words... You Like To Be Loved And Noticed By Your Lover, But Mostly You Are Single, Waiting For The Right Person.
 
Brown
 

You Are Active And Sportive. It's Hard For Other People To Become Close With You, But You Fall In Love Easily. But Once You Find Out You Can't Get Something, You Give Up And Let Go Easily As Well.
 
Aqua
 

Your Feelings Change Suddenly And Easily. You Are Always Lonely, And Like Traveling. You Are Truthful, But Listen And Believe Other People Too Easily. It's Hard To Find Love For You, And Get Lost In Love Easily, Sometimes Get Hurt By Love.
 
Lime
 

You Are Calm, But Easily Stressed Out. You Get Jealous Easily, And Complain Over Little Things. You Can't Get Stuck Into One Thing, But You Have A Capable Personality For Everyone To Trust You And Like You.
 
Black
 

You Are Challenging, And Have The 'Guts'. But You Don't Like Changes In Your Life. And Once You Make A Decision, You Keep It That Way For A Long Time. Your Love Life Is Also Challenging, And Different.
 
Purple
 

 
You Are Mysterious, Never Selfish And Get Interested In Things Easily. Your Day Can Be Sad Or Happy Depending On Your Mood. You Are Popular Between Friends But You Can Act Stupid At Times, And Forget Things Easliy.You Go For A Person That's Trustworthy.
 
Navy
 

You Are Attractive, And Love Your Life. You Have A Strong Feeling Towards Everything. And Very Easily Distracted. Once You Get Angry At Someone, Its Hard For You To Forgive Them.
 
Olive
 

You Are Warm And Light Hearted. You Seem To Flow Well With Friends And Family. You Don't Like Violence And Know What's Right. You Are Kind And Cheerful But Don't Envy Other People.
 
Silver
 

 
You Are Imaginative And Fun, You Love Trying New Things. You Like To Challenge Yourself And You Learn Things Easily, You're Easy To Talk To And Give Good Advice. When Comes To Friendship, You Find It Hard To Trust Someone, But Once You Find The Right Friend, You Trust Them Forever.
 WHITE
 

 
You Are Shiny Person, Cute And Intelligent Person. You Like To Make Friendship With Your Higher Persons, Which Can Sometimes Cause Trouble.
Your Strength Is Your Love Towards Friends. You Always Looks To Love Somebody And U Be Loved By Somebody. Your Intelligence May Lead To Success In Your Life

Gold
 

You Know What's Right And What's Wrong. You Are Cheerful And Out Going. It's Hard For You To Find The One You Want, But Once You Find The Right Person, You Won't Be Able To Fall In Love Again For A Long Time.
 
Cream
 

Competitive And Sportive. Don't Like Losing And Always Cheerful! You Are Trustworthy, And Very Out Going. You Choose Love Carefully, And Don't Fall In Love Easily. But Once You Find The Right One, You Don't Let Go Or A Long Time.
 
Grey
 

Ur Are Attractive, And Active. You Never Hide Your Feelings, And Express Everything That's Inside. But Can Be Selfish At Times. You Want To Be Noticed, And Don't Like To Be Treated Unequally. You Can Brighten Up People's Day. You Know What To Say At The Right Time, And You Have A Good Sense Of Humor.
 
Maroon
 

 
You Are Intelligent, And Know What's Right. You Like To Make Things Go Your Way, Which Can Sometimes Cause Trouble For Not Thinking About Other People's Feelings. But You Be Patient When It Comes To Love.. Once You Get A Hold Of The Right Person, It's Hard For You To Find A Better Love.

Up-gradation from Microsoft Dynamics GP 10 to Microsoft Dynamics GP2010 / GP 11

First upgrade Microsoft Dynamics GP 10 to Version 10.00.1400 (Hotfix KB 975174 & KB 977783) and then Install Microsoft Dynamics GP2010/GP11 with SP1.  After this run GP2010 Utilities, it will be updated without any error.