Is Office Accounting Professional 2009 Compatible with Office 2010

[Boolean1]

If I un-install Office 2007, and install Office 2010 64-bit, will I still be
able to export invoices and reports from Office Accouting to Word / Excel?

(I using a Windows 7, 64-bit operating system.)

Thanks,

 

[icreateofx]

There have been documented incompatibilities between Office 2010 and Office
Accounting. It has not been officially deemed incompatible by Microsoft,
though I would not rely on such an installation for critical business data.

I STILL use Office 2007 with BCM and Office Accounting Pro 2009, and will
continue doing so for the fore-seeable future. I simply cannot find ANY
product on the market to match the functionality and simplicity of use that
this combination offers for the cost. Nearest would be SAP Business One on
functionality and ease of use but NOT cost.

 

[rodwhiteley]

I had an issue with the templates when using Office 2010 and Windows 7. My
suspicion is that the filepath has changed with the slightly different
conventions in windows 7 (Documents Libraries versus My Documents) which
means I have to export all receipts to Word to print. Things seem to work
better with Office 2007 than 2010, so I uninstalled 2010 and went back to
2007 for the computer using Office Accounting.
Hope this helps,
Rod

 

[rodwhiteley]

There are some issues it seems with XML, and there is discussion of this on
the Office Accounting (UK) forum. Since it's dumped now by the MS forum,
here's a link to Google's cache:
http://groups.google.com/group/microsoft.public.uk.moa/browse_thread/thread/6cb9961f97188120#
Hope this helps,
Rod

 

[WillFa]

The one issue that we encountered is that since MS lost the i4i patent
lawsuit regarding Custom XML, your templates will not work if they've been
modified and saved in Word 2007/2010 format. Re-save your templates in Word
97-2003 format (*.doc) for them to work.

If they're saved in *.docx, *.doct, or *.docm format; Word will strip out
all the little pink tags in the document and you'll be left with the
[Placeholder Text] and not actual database values.

 

[Paul]

Not a complete answer but from what I have read you might want to install
Office 2010 in 32 bit mode to allow for compatibility with the various
plug-ins that integrate everything into office; there may be some problems
running 32bit plug-ins with 64bit Office software.

 

[Peter]

Yes seems to have a problem using Access 2010 64bit with any Access 32-bit;
no solution seen at present with .mde
Peter

 

[Answer]

The answer

If you upgrade to Office 2010, you will lose the XML functionality, which allows you to export to word. Microsoft was in a lawsuit, which deemed the XML tags Office Accounting was using, to be proprietary. So before Office 2010 was actually shipped, the XML capabilities were stripped out.

If you do upgrade to Office 2010, do not open your custom templates and then save them. The XML will be stripped and no data will come across. You will want to uninstall Office 2010 as well as deleting the OFFICE14 folder in the registry. (Office Accounting looks for this reg key and attmepts to export to the newest version of Word). By deleting that key, Office Accoutning will again export to Office 2003/2007... whatever the newer installed version is.

Here is the exact location of the registry key that needs to be deleted (after uninstalling Office 2010):

1) Click "Start" and then click "Run".
2) Type in regedit and then click "OK".
3) Navigate here:

Computer
HKEY_LOCAL_MACHINE
SOFTWARE
Microsoft
Office

4) Delete the "14.0" folder.
NOTE Microsoft skipped the number 13... just an interesting fact.
5) At this point, I would restart to refresh the registry, then run a repair on your previous version of Office. (from add-remove programs or by inserting the 2007/2003 CD)
6) Export from Office Accounting as normal.

 

[AndrewR]

There is a way round this that doesn't involve reinstalling Word 2010 or editing the registry - well, it worked for me. The trick seems to be to get Word to access the XML schema provided by Accounting 2009. Summary as follows:

1. Ideally find an unedited Accounting 2009 template file that retains the schema links (see later). It doesn't matter which template it is, but it saves effort later finding the XML schema file
2. Save it as a new template in Word 97-2003 format
3. Put Word 2010 into 'developer' mode (File > Options > Customise Ribbon to display it on the Ribbon)
4. Select 'Structure' (on the XML tab) and select 'Design Mode' (Controls tab)
5. An XML Structure pane should have opened on the RHS of the Word window. If not (esp if you've not managed to find an unaltered template file per step 1), you will need to select 'Schema' (XML tab) and hunt through your system for the Accounting 2009 XML schema. I didn't have to do this, so can't help much more
6. Assuming you've got a valid schema open, untick the box at the bottom of the XML Structure pan entitled "List only child elements of current element". This should then bring up a list of all the placeholders from Accounting 2009, which you can then insert into your document as you like
7. Edit the template, inserting fields as required, and save in 97-2003 format in the Accounting template folder.

HTH

Andrew