Friday, May 30, 2008

GP 10 SP2 Released - Download Link

GP 10 Service Pack 2 has been released. Download it - here

Here are download links and Service Pack version for GP 6, GP 7.5, GP 8, GP 9, GP 10

The big thing that I have been waiting for with Service Pack 2 is the Windows 2008 compatibility. A quick look at the install document showed steps for carrying out Install on Windows 2008 with UAC Activated.

Friday, May 23, 2008

Dynamics PartnerSource 2.0

Disclaimer : This is a wish. Maybe somebody like Mark would notice, and maybe some Microsoft guy reading Mark's blog would notice that. And maybe someday we would have these features.

The world is already talking about Web 3.0. I wish Partnersource had a few Web 2.0 features. Who knows maybe Microsoft is already working on them.

1. More Community Participation Options :

Comments with Knowledge Base Articles. Many MSDN Articles now have comments with them - I don't see why we cant have this feature with KB Articles.

2. Usability and Joy of Use

Compare Partnersource with any of the Ruby on Rail's Apps - We are far behind. AJAX, Auto completion are things that can be added here - to name a few. Silverlight, maybe ? That would be wonderful! Can't the web team make a Partnersource BETA version their pet project ?

3. Cross Browser Compatibility

This is how the new home page looks in firefox ... Often I have to switch between Firefox and IE because certain pages just dont load up in Firefox. I don't really mind - but as a Dynamics GP Partner I wish ... for better standards.

Partnersource Homepage in IE

Partnersource Homepage in Firefox

Wednesday, May 14, 2008

FRx 6.7 Service Pack Versions and Downloads

As a few of you found the links and information about GP Service packs and Versions useful, here is the list for FRx 6.7

Download Link for All Service Packs


FRx 6.7 RTM (6.7.141)

FRx 6.7 Service Pack 1 Download (6.7.1013) - August 30, 2004

FRx 6.7 Service Pack 2 Download (6.7.2013) - November 1, 2004

FRx 6.7 Service Pack 3 Download (6.7.3073) - March 4, 2005

FRx 6.7 Service Pack 4 Download (6.7.4031) - June 16, 2005

FRx 6.7 Service Pack 5 Download (6.7.5014) - November 8, 2005

FRx 6.7 Service Pack 6 Download (6.7.6062) - February 2, 2006

FRx 6.7 Service Pack 7 Download (6.7.7032) - June 9, 2006

FRx 6.7 Service Pack 8 Download (6.7.8069) - October 19, 2006

FRx 6.7 Service Pack 9 Download (6.7.9111) - March 19, 2007 (VISTA Compatible)

FRx 6.7 Service Pack 10 Download (6.7.10343) - March 28, 2008 (Must apply SP9 before applying this service pack)

FRx 6.7 Service Pack 11 Download (6.7.11027) - March 28, 2008 (Must apply SP9 before applying this service pack) (with Limited Windows 7 Compatibility)

Hope it helps,


Tuesday, May 6, 2008

Microsoft FRx 6.7 Service Pack 10 has been released

I know this is like talking about the Sydney Olympics, now that you have all the news about Performance Point Server. However, this could be helpful if you have that FRx issue.

Note - You need to first install FRx 6.7  SP 9 and then install SP 10. :)

The download link and the list of issues fixed are available here -


"RPC Server is unavailable" when you run an Integration

If you get this error when running an integration -

1. Exit Integration Manager and GP 10

2. Start GP 10

3. Start IM 10

4. Run the Integration again.

Thought it might help somebody!

Monday, May 5, 2008

Dynamics GP Table Naming Logic

A million thanks to Mark Polino for putting up an amazing presentation on understanding Table Structure in GP. Please visit Mark's blog post which contains a link to the powerpoint. A must see for anybody who writes reports for GP.

Here are the gems from his powerpoint about table naming logic in-

1. ‘00000’ - Master tables contain all the permanent data about your business. Accounts, vendors, customers, items, and so on.

2. ‘10000’ - Work tables contain unposted batches of transactions entered using windows that can be opened using the Transactions button on the toolbar. Temporary transactions that can be changed or deleted until they are posted to an open table.

3. ‘20000’ - Open tables contain posted transactions for the current year, of which some may be unpaid. Information in open tables is moved to history tables when the transactions are paid.

4. ‘30000’ - History tables contain paid transactions, or transactions from a previous year.

5. ‘40000’ and up - Setup tables contain all the default settings and module options you’ve specified in the setup windows for each series.

In addition to that, I think the tables in 50000 series are the temp tables.

Based on this Logic - Review some of the Receivables Management(RM) Tables in GP

RM00101 RM Customer Mater RM00102 Customer Master Address File

RM10101 RM Distribution Work File RM10201 RM Cash Receipts Work File

RM20101 RM Open File RM20101 RM Open File Debit Copy

RM30101 RM History File RM30201 RM Apply History File

RM40101 RM Module Setup File RM40201 RM Period Setup

Now review the Payables Management(PM) Table

PM00100 PM Class Master File PM00200 PM Vendor Master File

PM10000 PM Transaction WORK File PM10100 PM Distribution WORK OPEN

PM20000 PM Transaction OPEN File PM20100 PM Apply To OPEN OPEN Temporary File

PM30200 PM Paid Transaction History File PM30300 PM Apply To History File

PM40100 PM Setup File PM40101 PM Period Setup File

and the General Ledger(GL) Tables

GL00100 Account Master GL00100 Distribution Account Master

GL10000 Transaction Work GL10001 Transaction Amounts Work

GL20000 Year-to-Date Transaction Open

GL30000 Account Transaction History

GL40000 General Ledger Setup GL40100 Quick Journal Setup

GL50010 General Ledger Period Header Temporary GL50011 General Ledger Period Temporary