Data Dictionary For Sage Accounts?

I've taken the liberty of cross-posting this item from the IT Zone discussion group to see if any of our new members here can help:

Posted by NigelJustinDay on Sun, 15/11/2009 - 19:06"I am trying to devise a report that will show all my purchases and include the department and project ref field. I have tried looking at the fields available under the Supplier reports option and I can't find these 2 fields. Can someone please point me in the right direction or do I need to extract this information via a SQL query?"

I assume this is Sage 50 ? In which case it's not possible to do a SQL query as currently Sage 50 is not written in SQL. What you can do, if you have the new report designer (2007 onwards) you have a Join functionality on the menu which allows you to add extra tables. Just be careful in how you join the tables as it can give strange results.

I've had a long-standing problem of having recorded project information in Sage, but with limited reporting functionality, being unable to print off any meaningful report to compare our excel-based Production Tracking with the final recorded data in Sage.

Thanks to this information on joining tables in the new report designer, I will now be able to provide our Producers with customised line by line project costs reports and will be the most popular girl in the studio (without the need for chocolate bribery) :o)