RKL eSolutions Blog Trends and Insights

How to Setup Restriction Codes in Sage X3

Sage X3 uses dimensional accounting which improves and simplifies reporting. There may be instances where a specific dimension should not be used for a specific account although the dimension type is allowed on the GL account. There may be other cases where dimensions should not be used in combination with another dimension. Restriction codes can be configured to prevent such cases.

Define a new Account Restriction and Dimension Restriction Code

  • Expand Development > Data and Parameters > Miscellaneous tables
    • Define a new Account Restriction and Code on Table 321 and Table 322.Sage X3 Define a new Account Restriction & CodeSage X3 Misc Tables

Setup the Account/Dimension and Dimension/Dimension Restrictions

  • Expand Common Data, G/L accounting tables, Analytical, Restriction Codes
      • Restrict a specific dimension from being used on a specific GL Account. In the sample below the SUPL-001 dimension will not be allowed to be used for GL account 41100. However other dimensions belonging to the CCT Dimension Type will be allowed.Sage X3 Account Dimension Restriction
      • Restriction dimension relationships within specific dimension types. For example, if Dimension type CCT has “MARK-001” dimension then Dimension Type SR cannot have the value “US” dimension.Sage X3 Restriction dimension relationships

    Now you know how to configure restriction codes in Sage X3.

Have Questions or Need Help?

Got QuestionsClick below to get in touch with us here at RKL eSolutions if you have questions about dimensional accounting in Sage X3 or need help with Sage X3.
Ask a Question

Tags: Sage X3
LeeAnn Segan

Written by LeeAnn Segan

LeeAnn Segan is an ERP Support Specialist with RKL eSolutions LLP. She supports Sage 500 ERP and Sage X3. LeeAnn specializes in the financial and distribution modules. Her background includes managing distribution and warehousing for ecommerce based companies. When not working, LeeAnn enjoys working out, volunteering with groups that support special needs, and spending time at the beach with family and friends.