Accounts - General Ledger Account(s)
Description
Many Logicim XLGL worksheet function have an Accounts parameter.
This parameter can be used to specify which account(s) are to be used in the calculation.
This article describes the different ways you can use this parameter.
Sage 50 US Edition
The account correspond to the beginning part of a GL Account. It can be a single segment, multiple segment or only part of a segment. You can specify the account(s) using the following methods:
- The beginning part of an Account Number, or the complete account number Ex: 40100 or 40 (any account starting with 40)
- 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
Sage 50 Canadian Edition
You can specify the account(s) using the following methods:
- Account Number Ex: 40100
- 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 dash Ex: 40100-40400
- Combination of the previous two methods Ex: 40100, 40400-40800, 41000