Setting Up the Chart of Accounts
Navigate to Finance > General Ledger > Chart of Accounts to define your GL account structure. The SL_ChartOfAccounts IDO manages account records in the chart table. SyteLine supports segmented account structures with configurable segment separators, typically using department, account, and sub-account segments.
Each account must be assigned an account type (Asset, Liability, Equity, Revenue, or Expense) which controls balance sheet versus income statement reporting.
- Define account segments and their lengths in Finance > General Ledger > GL Parameters before creating accounts
- Create accounts following your segment structure such as Department-Account-SubAccount (e.g., 100-4010-00)
- Assign account types to control financial statement placement and period-end closing behavior
- Set up account groups and categories for consolidated reporting across multiple account ranges
Configuring Posting Rules and Account Defaults
Posting rules define which GL accounts receive debits and credits for each transaction type. Navigate to Finance > General Ledger > Posting Rules to configure rules for inventory receipts, issues, work order completions, and sales transactions. The SL_PostingRules IDO stores rules in the acct_default table.
Each rule maps a transaction type to specific debit and credit accounts, optionally using account derivation logic based on product code, warehouse, or item attributes.
- Configure posting rules for all major transaction types: PO Receipt, Inventory Issue, WO Completion, Sales Shipment
- Set default accounts on the Account Defaults form under Finance > General Ledger > Account Defaults
- Use product code-level account overrides for items requiring different GL treatment than the site default
- Enable the Posting Preview option to review GL distributions before committing transactions
Managing GL Transaction Processing and Posting
SyteLine batches GL transactions in the gltrans table before posting to the general ledger. Navigate to Finance > General Ledger > Post Transactions to process pending entries. The GL posting process validates account numbers, checks period status, and creates journal entries in the journal table.
Configure automatic posting schedules or run manual posting during period-end processing to control when transactions hit the ledger.
- Run the Post Transactions utility to move pending entries from the staging table to the general ledger
- Review the GL Transaction Edit List report before posting to catch invalid accounts or unbalanced entries
- Configure automatic GL posting frequency in the GL Parameters form (real-time, daily, or on-demand)
- Set up the GL Exception Report to flag transactions that fail validation rules during posting
Try it here, free
SyteLine Implementation Cost Calculator
Estimate the full first-year cost of an Infor SyteLine implementation, including licensing, services, data migration, and internal effort.
Frequently asked questions
How many GL accounts does a typical SyteLine implementation need?
A mid-size manufacturer typically requires 200-500 GL accounts covering assets, liabilities, equity, revenue, and expense categories. Manufacturing-specific accounts for WIP, finished goods, raw materials, and variance accounts add 50-100 additional accounts. Plan for 15-25 accounts per department segment. Starting lean with 200 accounts and expanding is preferable to over-building the initial structure.
What happens if a GL posting rule is missing in SyteLine?
When SyteLine encounters a transaction without a matching posting rule, it uses the site-level default accounts configured in Account Defaults. If no default exists, the transaction fails with an 'Account not found' error and remains in the pending transactions table. Monitor the GL Exception Report daily to catch these failures. Typically 2-3% of transactions hit defaults during initial go-live.
Can SyteLine post to an external general ledger system?
Yes, SyteLine supports GL integration with external financial systems through the GL Interface Export. Navigate to Finance > General Ledger > GL Interface to configure export formats compatible with systems like SAP, Oracle Financials, or other ERP platforms. The export generates flat files or XML with configurable account mapping. Most integrations process 500-5,000 journal entries per nightly batch.
Need help configuring your SyteLine general ledger? Netray's financial consultants can design your chart of accounts and posting rules to ensure accurate manufacturing cost accounting.