Departments - General Ledger Department(s)
Description
Many Logicim XLGL worksheet function have an Departments parameter.
This parameter can be used to specify which department(s) are to be used in the calculation.
This article describes the different ways you can use this parameter.
Sage 50 US Edition
The department correspond 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 use Account Number instead.)
- Comma-separated list of Account Number 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 use 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