Worksheet Functions (US Edition)

 These instructions are only for Sage 50 US Edition

In this article, we will provide an overview of XLGL functions and how they can simplify your reporting efforts.

What are XLGL Worksheet Functions?

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 in a similar way to formulas and worksheet functions you may already be familiar with, such as "SUM" or "VLOOKUP".

Examples of XLGL Functions

Let's look at some real examples of how XLGL functions can be used:

• The "XCompany" function can be used to request the name of the company from the Sage 50 data.
• The "XUSFinancial" function can be used to report the balance of an account or a group of accounts at a given date.

These functions can fetch data from specific columns or cells in your worksheet and update automatically when the data changes.

Using XLGL Functions

To use XLGL functions, you can follow these steps:

1. Enter the function name in a cell, followed by any required arguments.
2. Open the function argument window to see what arguments the function uses and get more help on the function.
3. Preview the result in the function argument window and click "OK" to confirm.

XLGL functions also have default behavior, such as returning a default value when no argument is provided.

XLGL Worksheet Functions are a powerful tool for fetching and summarizing data from your Sage 50 company file directly in Excel. By using these functions, you can simplify your reporting efforts and create outstanding reports. We hope this knowledge base article has provided you with a good understanding of XLGL functions and how to use them effectively.