Worksheet functions (Canadian edition)

  These instructions are only for Sage 50 Canadian edition

In this article, you will explore what Logicim XLGL worksheet functions are and how they can simplify your reporting efforts.

What are Logicim XLGL worksheet functions?

Logicim XLGL worksheet functions are a set of functions that can be used in Excel to fetch and summarize data directly from your Sage 50 company file. These functions work similarly to formulas and worksheet functions you may already be familiar with, such as "SUM" or "VLOOKUP."

How do Logicim XLGL worksheet functions work?

Logicim XLGL functions retrieve specific data from your Sage 50 company file and display it in your Excel worksheet. For example, the "XCompany" function can request the company name from the Sage 50 data, and the "XGL" function can report the balance of an account or a group of accounts at a given date.

These functions can be used in the same way as other Excel functions. You can enter them directly into a cell or use the function argument window to specify the required arguments and get more help on the function.

Examples of Logicim XLGL worksheet functions

Look at some examples of how you can utilize the Logicim XLGL worksheet functions:

• The "XCompany" function can be utilized to populate the company name in a cell.
• The "XGLDesc" function can be utilized to get the account description given its number.
• The "XGL" function can be utilized to get the current balance of an account.

By changing the values in the cells referenced by these functions, such as the account number or the date, the functions will automatically update and recalculate the results.

Logicim XLGL worksheet functions are a powerful tool for fetching and summarizing data from your Sage 50 company file directly into your Excel worksheets. By using these functions, you can simplify your reporting efforts and ensure that your data is always up to date.