Dynamics GP to Business Central – How to Control your General Ledger Code and Dimension Combinations using Allowed Values Filter
When migrating from Dynamics GP to Business Central, General Ledger segments become dimensions that are available to any account by default. The post explains how to control which dimension values can be used with specific GL accounts using the Allowed Values Filter feature to replicate Dynamics GP's segment-code restrictions.
"The solution to this issue is the Allowed Values Filter to limit the Dimension Values allowed on your General Ledger Account Card."
Key points
- Dynamics GP combines GL codes with segment codes, while Business Central separates GL accounts from dimensions
- Business Central’s consolidated chart of accounts is more efficient than creating separate GL codes for each cost centre combination
- Allowed Values Filter on the GL Account card restricts which dimension values can be posted to that account
- This feature requires Code Mandatory posting to work effectively
Quotes
- “The solution to this issue is the Allowed Values Filter to limit the Dimension Values allowed on your General Ledger Account Card.” (Provides the direct answer to achieving Dynamics GP-like control in Business Central)
AL objects mentioned
As named in the post. A name that matches one object page by exact type and name links to it; the others stay as named.
- other “General Ledger Account Card”
Context
- Features: Allowed Values Filter, Dimension restrictions, GL account dimensions, Code Mandatory posting, Chart of accounts consolidation
Source: The Dynamics Explorer, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.