Sage 2012 v18 exporting to Excel

Posted by RAYC PM | on Wed, 07/12/2011 - 14:12  3095  5 comments | report

For many years I have exported all P&L entries for a financial year to excel to prepare my P&L in Excel. All has worked well via ODBC until the most recent version of Sage (2012 v18) where it now returns two entries for each transaction thus doubling all entries in my P&L. Anyone got a fix for this?

Comments

Unusual..?

Optegra | Thu, 08/12/2011 - 00:44 | Permalink

Hi - Which data table are you connecting to using ODBC? or are you using Excel integrated reporting?

Does sound unusual because our management reporting pack does not experience any problems with Sage v2012.

 

Jeremy

Optegra Financial

 

ODBC

johndon68 | Wed, 07/12/2011 - 14:26 | Permalink

There have been some issues with the ODBC driver for v2012 and it was definately broken by Update 3.  If you go to www.sage.co.uk/updates there is a hotfix for the ODBC driver so I'd definately download and install that.

John

Tables being used in report

RAYC | Wed, 07/12/2011 - 18:44 | Permalink

Tables being used in report are Audit_Journal, Cat_Title, Category and Nominal _Ledger.

*

Optegra | Thu, 08/12/2011 - 00:43 | Permalink

*

Cause

RAYC | Thu, 08/12/2011 - 21:46 | Permalink

The penny finally dropped on my problem, I have two charts fo accounts. Once I point at a single one the problem is fixed.

Thanks you for your assistance.

Regards

Raymond

Add comment
Log in or register to post comments
More posts from this group

Pages