# GP 10+SQL 2005+Intercompany+2008 = Opportunity for Improvement

- URL: https://dynamicaccounting.net/gp-10sql-2005intercompany2008-opportunity-for-improvement/
- Date: 2008-01-04
- Topics: General Ledger & Financials, Install, Upgrade & Admin, SQL & Data
- Dynamics GP versions mentioned: GP 10
- Type: link to an external article
- Source: http://www.acemicrotech.com/

From my friend [Tom Karpowich](http://www.acemicrotech.com/):

*There is a bug in GP 10 when using SQL 2005 & Intercompany. Basically, Intercompany does not work in the calendar year 2008 without the fix. The Dynamics support team has suggested that a hot fix will be released in the near future.*

The error is: DB error 8114 when posting intercompany trx  
  
Tom and the MS team spent a leisurely (not) 5 hours working their way through this so you don’t have to. If this helps you, you owe Tom a drink at Convergence. I’m sorry, that’s just the way the world works.

The [SQL Fix](https://app.box.com/shared/06act4fksc) is a bit big to post here so [I’ll add it as a link](https://app.box.com/shared/06act4fksc) and put a link in the downloads on the right.

As always, apply any code you find here at your own risk. This is not an official MS fix, you’ll have to wait for a hot fix for that.