SageForum for UK versions of Sage 50- Help and support.

Help and support for Sage50 users, covering all subjects including report writing, installation problems, accounting issues, data errors, integrating with other desktop systems and web services..
https://forum.makingithappen.co.uk/

Odbc query not returning all results

https://forum.makingithappen.co.uk/viewtopic.php?t=2384

Page 1 of 1

Odbc query not returning all results

Posted: 13 Nov 2013, 20:53
by Topcat
Hi I am trying to run a query from excel and for some reason the audit history is only pulling data from 2009 to exactly 31/8/2012.....it's so weird because the nominal account balance query is up to date and the audit journal includes 2013 transactions, I would use the audit journal but it excludes deleted transactions and I need everything.

Please help...thanks

Re: Odbc query not returning all results

Posted: 14 Nov 2013, 13:05
by brucedenney
You need to user the AUDIT_HEADER/AUDIT_SPLIT tables to get data from the audit trail.
All times are UTC
Page 1 of 1

Powered by phpBB® Forum Software © phpBB Limited