Departments parameter

Departments - General ledger department(s)

Description

Many  Logicim XLGL  worksheet functions have a Departments parameter.

This parameter can be utilized to specify which department(s) are to be utilized in the calculation.

This article describes the different ways you can utilize this parameter.

 Sage 50 US edition

The department corresponds to the ending part of a GL Account. It can be a single segment, multiple segment or only part of a segment. You can specify the deparment(s) using the following methods:

• The ending part of an account number, or the complete account number Ex: 40100 or 100 (any account ending with 100)
• Account name Ex: Account Receivable (It is recommended to avoid this and utilize the account number instead.)
• Comma-separated list of account numbers Ex: 40100, 40200, 40400
• A range of accounts using a colon Ex: 40100:40400
• Wildcards using '?' Ex: 40??? (wildcards can be used in comma-seperated list and range as well)
• Combination of the previous methods Ex: 40100, 40400:40800, 42???

It is also possible to create an exclude list by using ' ' (backslash) then another set of account to remove from the original list. For example, to get all account between 40000 and 45000, except 41000 and 42000: 40000-45000 41000, 42000

Note that all the account number rules are applied to the end of the account number.

 Sage 50 Canadian edition

You can specify the department(s) using the following methods:

• Department number Ex: 0001
• Department name Ex: Sales (It is recommended to avoid this and utilize account number instead.)
• Comma-separated list of department number Ex: 0001, 0002, 0004
• A range of department using a dash Ex: 0001-0004
• Combination of the previous two methods Ex: 0001, 0003-0004, 0006