Data Dictionary For Sage Accounts

Hi Nigel,

We just set up a Sage 50 Accounts discussion group and I have posted your query over there as well to see if anyone can help. If I hear anything back, I'll let you know.

I'm not familiar enough with the reporting and database structure in Sage 50 to help you, I'm afraid, but I know some people who might, including David Carter, who's done a lot of work with management reporting in Sage with Excel. If you do decide to delve into the MS Query route, here are some tutorial articles that might help:

● Getting better reports out of your accounts package
● Improve your reporting skills with self-teach tutorials
● Improve your sales reports using MS Access
● Use MS Query to analyse Sage sales data

I'll get in touch with David and see if he's got more immediate advice about the two fields you're hunting for.

__________________________
John Stokdyk, Technology editor

Supplier reports will only give you Net purchases.

If you want to analyse purchases by department or by nominal analysis you need to use the audit_journal table.  

From memory the last time I did this, the 2 x Project Ref fields aren't held in Audit_journal.  Instead they've put them in entirely separate tables - hopeless.   David Carter