Tutorial: Sage and MSQuery #6 - Add customer and supplier names. By David Carter
When you export data out of Sage, it includes account codes of customers and suppliers, but not their names. This may not matter for your own use, but any report for a manager has to include full names and descriptions. In his final tutorial of the series, David Carter adds customer and supplier names to the analysis-ready file.
1. Why does Sage omit customer and supplier names?
Right now in the MASTER database we have an ACCTNO field in column G which holds the account code, whether it’s from the Sales or Purchase Ledger or the Nominal Ledger.