Account Reference Syntax and Examples

Sage 300 ERP

previous page next page
Home > Financial Reporter > Designing Financial Statements > Retrieving G/L Account Information > Account Reference Syntax and Examples

Account Reference Syntax and Examples

Account number references can use the following symbols:

Account Reference Symbols
Symbol Description
Hyphen - An account segment separator defined on the G/L Options screen in General Ledger. (The hyphen is the default separator.)
Colon : Separates account numbers in a range.
Tilde ~ Separates segment codes in a segment range.

Note: All examples assume that segment 1 is the account segment and segment 2 is the department segment.

Standard Account References

Standard Account References
Format Description Examples
aaaaaaaa

or

aaaa-aaaa

A specific General Ledger account number composed of one or two segments.

Account numbers can be entered with or without the segment separator -. However, if you are specifying ranges of accounts, we suggest you include separators to remove ambiguity from your specifications.

 100-C

Account 100, department C.

aaaa-A:bbbb-B

A range of General Ledger accounts and departments.

When creating a search statement from the information you enter, Financial Reporter adds Zs to the last number in the range. In other words, it searches for account numbers between "aaaa-A " and "bbbb-BZZZZZZZZZZZZZZZ".
  • 100:200

    Accounts between 100 and 200 (from any department)

  • 100-A:200-F 

    Accounts with an account segment value between 100 and 200, and with a Department segment value between A and F (for any order other than ACCTID order).

    If the order is ACCTID, account 150-H will be included because it falls between 100-A and 200-F. However, for non-ACCTID order, Financial Reporter takes only those accounts that fall within both ranges ( the range of accounts and the range of departments), so that 100-A:200-F is the same as 100~200-A~F (shown below).

    If the order is ACCTID, the constraint is ACCTID => 100-A and ACCTID <= 200-F.

aaaa%%

or

aaaa:aaaa

A range of General Ledger account numbers. (The wildcard notation %% is a simpler way of specifying all accounts with the same segment.)

100%% or 100:100

All accounts that start with 100, regardless of account structure.

aaaa~bbbb-A

A range of General Ledger account numbers with a fixed second segment.

Financial Reporter retrieves information from each account within the range that includes the second segment code.
  • 100~200-F

    Accounts in department F with an account segment value between 100 and 200, and with a department segment code of F.

  • 100~200-A~F 

    Accounts with an account segment code between 100 and 200, and with a department segment code from A to F.

aaaa~bbbb

A range of General Ledger account segment codes.

Financial Reporter retrieves all accounts matching the account segment you specify, no matter how many segments are in the number, and no matter where the account segment is in the account structure.

This allows you to specify a range for one segment (rather than a range of complete account numbers), and is particularly useful when the account segment is not the first segment in the account number.

4000~8000

Accounts with an account segment code from 4000 to 8000, no matter how many segments are in the number, and no matter where the account segment is in the account structure. For example, results will include 10-4000, 20-5000, and 10-6000 if those accounts exist in General Ledger.

aaaa[ACCT], bbbb~cccc-A[MANU]

An individual account number and a range of account numbers. The square brackets indicate the account structure codes used by the account numbers.  

aaaa-%, bbbb~cccc-A~B, gggg-D

A set of ranges and individual accounts with each specification separated by a comma.  

Related Topics

previous page start next page