Sage 50 Canada

Is there a tool out there to extract sage 50 data. We need a file of every transaction for the last 3 years that contains customer, invoice #, items, totals, tax and Very importantly the Message field. Any ideas? Thanks Doug

In the Sage 50 database, there are header files for sales orders and purchase orders. I’m not sure how they work, but with transactions they seem to get duplicated with a new ID. how do you tell if a sales order has been deleted? Is there a field that…