Tutorial: use MSQuery to create an analysis-ready SALES file in Sage. By David Carter
Continuing his series on live-linking Excel to Sage data, David Carter shows you how to use MS Query to pull in data from the invoice data tables. If you use Sage for sales invoicing, this will give you the data you need to report on sales and margins by product and customer
Up to now we’ve concentrated on getting data out of Sage to produce accounting reports. For this, most of the data is held in the audit_journal table.
However, if you want to report on product sales, the data is held in the invoice and invoice_item tables.