Introduction

Thursday, October 6, 2022

Logicim XLGL is a Microsoft Excel add-in that connects to your Sage 50 company data and lets you use your worksheet to create, edit and view reports. 

Connectivity

With XLGL, you can connect to any number of Sage 50 companies individually or at the same time. Switching from one company to another is quick and simple, so does keeping your report up to date, which can be done at the click of a button. 

Formatting

Making cosmetic changes to the report is also very easy. Change the size and font of text, colour, or make any other changes. 

Reports included with XLGL are meant to be easy to customize. Once you are happy with your changes, simply save the file just like any other Excel file. You can re-open this file later on and still have it update with your Sage 50 company data. 

Custom Reports

On top of included reports, XLGL provides a number of tools to create new reports. Creating a table for example is only a few clicks away. Adding fields is as easy as dragging them to the worksheet. If needed, a powerful query editor can be used to finely customize your data request and include parameters that can be linked to the worksheet. 

XLGL worksheet functions are another powerful tool that can be used to avoid complex queries. They can reference all sorts of arguments from the worksheet to provide just the result you need. They are very flexible and will merge well with your worksheet creation process. Functions can be used in Excel formulas to accomplish all sorts of results. 

Other Tools

The XLGL ribbon contains a number of other tools to help you work with your report, including drilldown, hiding zeros and layout out a report for print. 

 

Was this article helpful?

 
Thank you for your feedback

Contact Can't find what you're looking for?

You can Contact us so we can address your question.