I have 5 distinct copmanies in QuickBooks; I want to merge the audit trails from each database into one table, and store it seperate from the databases (auditor's request).  Is there an audit trail object?

Rick

You can extract all the transactions for the day by running the TxnDetailByAccount stored procedure report:

sp_report TxnDetailByAccount show Text, Blank, TxnType, Date, RefNumber,
Name, Memo, ClearedStatus, SplitAccount, Debit, Credit, RunningBalance
parameters DateMacro = 'Today'

at the end of the day, or use the:

parameters DateMacro = 'Yesterday'

option for yesterday's transactions.

You can also look at our Transaction table, which is good approximate of a GLTran file:

SELECT * FROM Transaction where TxnDate >= {d '2007-12-01'} and TxnDate <= {d '2007-12-31'}

Hello - I want to select for customers with transactions edited since a last rundatetime paramter, and then add or update the related transactions to an external database.  Does the most recent version of QODBC give query access to the table(s) used in the Audit Trail report?  In particular, I would like to select for all transactions where the column labeled Entered/Last Modified, which I think corresponds to the the underlying column ModifiedTime, is greater than the last rundatetime for my update process.

I am currently running version 7.1 of the QODBC driver (read-write version).  The table list doesn't seem to include anything that looks like an Audit Trail object or the ModifiedTime column.   Do the more recent versions allow access to this table or this data?  Thank you for your help.

The Transaction table has a TimeModified column you can use or you can use the ModifiedTime column in the report like this:

sp_report TxnDetailByAccount show ModifiedTime, Text, Blank, TxnType, Date, RefNumber,
Name, Memo, ClearedStatus, SplitAccount, Debit, Credit, RunningBalance
parameters DateMacro = 'Today'

See also: How do I run a CustomTxnDetail Report?