0

I'm accessing sage 50 via the v16 ODBC driver, and I'm struggling to find the expenses data.

i.e. I'm shown an export which shows things like water bills, phone bills, salary etc, all going out from the company / main bank account

However I dont see this data in the audit_journal table, which from my limited knowledge is where I did expect to find it.

Codek
  • 5,114
  • 3
  • 24
  • 38

1 Answers1

0

You need to use AUDIT_HEADER or AUDIT_SPLIT tables e.g. SELECT * FROM AUDIT_SPLIT

If you only want expenses then you should probably add a where clause for TYPE ="BP" OR TYPE="PI"

Audit Header is the group transaction header and audit split is the nominal code analysis.

Adam

Adam McCrory
  • 391
  • 3
  • 7
  • Thanks. What is the audit_journal table then? I have now found the data, just making sure I'm using the right thing! – Codek Dec 07 '12 at 14:29
  • Ignore the Audit journal table - its just a subset of the audit trail and only displays the journal entries e.g. JD and JC transactions – Adam McCrory Mar 18 '13 at 15:04