General Ledger Integration Setup
As you set up your General Ledger, use these specific settings if you are using the Sage X3 G/L or Sage 100 links.
Step 1 - Account Segments
Setup > Payroll > General Ledger > Options > Segments tab
- Set the first segment number/name to the "Core" account. The others will be equivalent to AX1 (Division), AX2 (Region), AX3 (Project), and so on.
- Set Account Segment to "1"
- Set Segment Delimiter to "-"
Step 2 - Segment Codes
Setup > Payroll > General Ledger > Segment Codes
- Segments are equivalent to "dimensions"
- You must set up one code with all zeroes
Step 3 - Account Structures
Setup > Payroll > General Ledger > Account Structures
- There must be two structure codes:
- One using just the "Core" account
- One using the "Core" plus all other segments in the order specified on the Segments tab in Step 1
Step 4 - Accounts
Setup > Payroll > General Ledger > Accounts
- Account numbers can be imported but must follow the account structures. That is, account numbers that use dimensions must include zeroes for dimensions not used for any specific core account number.
- For example, "Core" account = 2599. This core account can use dimensions (segments) AX1 and AX3. In this case, the account number must be 2599-AX1-000-AX3
- Also, the core account number plus the core account with all zeroes for each dimension, can be imported. Then you can use the Create Accounts window to create all combinations of the account number with the dimensions that are available.