23rd May 2016

Sage 200 Tips – Analysis Codes

As your business continues to expand it can become difficult to manage the various types of Orders, Ledger Accounts, and Stock Items in a way that produces meaningful reports and analysis. Sage 200 provides you with the ability to categorise areas of your business with Analysis Codes, and it’s quite simple to do! Perhaps within your business each Customer Account has its own Sales Representative and you need to review how each of your Sales Reps are performing. I’m going to create an Analysis Code, ‘Sales Rep’ and apply this to a handful of Sales Ledger accounts so they can be ‘separated from […]
10th May 2016

Sage 200 Tips – Exporting lists to Excel

Most Accountants like working with Microsoft Excel, this will come as no surprise to you I’m sure! Refining and presenting your financial data in a workbook can produce some fantastic results and this fact is not lost on Sage. Over time Sage 200 has evolved to become an incredibly feature-rich and user-friendly system. The integration with MS Excel is an area that Sage has continued to invest time into developing and improving with each version release. There are various features that have become important to users such as the ability to export any of the reports into a Workbook, and of course the powerful Business Intelligence […]