{"id":3063,"date":"2021-02-26T12:47:58","date_gmt":"2021-02-26T12:47:58","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/?p=3063"},"modified":"2024-11-29T07:04:38","modified_gmt":"2024-11-29T07:04:38","slug":"effective-use-of-sage-intacct-dimension-relationships","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2021\/02\/26\/effective-use-of-sage-intacct-dimension-relationships\/","title":{"rendered":"Effective Use of Sage Intacct Dimension Relationships"},"content":{"rendered":"\n

To restrict users from entering improper location when posting to a specific GL account, i.e., basically allowing no entries unless they are to a certain location, we can write a Smart Rule with condition {!GLENTRY.ACCOUNTNO!} == ‘[account_no]’ && {!GLENTRY.LOCATION!} == ‘[location_id]’ and throwing an appropriate error.

For scenarios like the above one, we usually tend to create a smart rule or some validation page scripts to only allow certain department\/location IDs to be posted with a group of Account Numbers or any account that begins with a specific digit using some wildcards or so.<\/p>\n\n\n\n

But it would be tedious and time consuming if there are multiple Accounts and Dimensions to be checked or validated.
For instance, if the locations are 4 digit numbers (e.g. 1000, 2000, etc.) and there are location groups which are 2 digit numbers (e.g. 10, 20, 30, etc.) and we want to disallow any journal entries for account numbers above 3000 to be entered only into a specific location group but for account numbers below 3000 can be entered into any location\/location group. To achieve this it would not be feasible to write and apply Rules or Scripts.<\/p>\n\n\n\n

Instead of using Page Scripts or Smart Rules, we can productively use the built-in functionality of dimension relationships provided by Sage Intacct<\/a>. Dimension relationships can be used for Auto-populating, cascading, filtering and validating dimensions as discussed in our earlier blog<\/a>.
It will automatically limit the available items or auto-populate dimensions based on an earlier choice. <\/p>\n\n\n\n

Go to GL Account > Object Definition > Edit Properties and Attributes > Select the \u201cAuto-fill related objects\u201d flag and enable override auto-filled objects if needed.<\/p>\n\n\n

\"Edit<\/a><\/p>\n

Create a \u201cMany-to-One\u201d or \u201cMany-to-many\u201d relationship with Location dimension according to the requirement. If you want more than one location to be available for selection for a specific GL account then the relationship must be \u201cMany-to-many\u201d.
Edit\/Add a GL account and choose the Locations to be allowed for that account and save.<\/p>\n

\"Many-to-One<\/a><\/p>\n

Above is the screenshot showing \u201cMany-to-One\u201d relationship with Location dimension, So only location 20 is chosen for account \u201cComputer Expenses\u201d which will be auto-populated when posting entry into this account.
See below.<\/p>\n

\"GL-Entry<\/a><\/p>\n

Following are the screenshots showing \u201cMany-to-Many\u201d relationship with Location dimension, So when posting entry into this account, the location dimension selection will be narrowed down to limited locations (10, 20, 30) and user cannot select other locations for this account.<\/p>\n

\"One-to-One<\/a><\/p>\n

\"GL<\/a><\/p>\n

Another example can be like auto-populating the location\/department field on a sales invoice when the employee field is updated.<\/p>\n

Thus using Dimension Relationships would be more feasible and of ease to the users and also easy to setup for the company admin.<\/p>\n\n","protected":false},"excerpt":{"rendered":"

To restrict users from entering improper location when posting to a specific GL account, i.e., basically allowing no entries unless they are to a certain location, we can write a Smart Rule with condition {!GLENTRY.ACCOUNTNO!} == ‘[account_no]’ && {!GLENTRY.LOCATION!} == ‘[location_id]’ and throwing an appropriate error. For scenarios like the above one, we usually tend\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[93,125,124,339,334,126,355,128,34,208],"class_list":["post-3063","post","type-post","status-publish","format-standard","hentry","category-sage-intacct","tag-dimension","tag-dimension-relationship","tag-gl-accounts","tag-gl-transaction","tag-glentry","tag-many-to-many-relationship","tag-many-to-one-relationship","tag-related-dimensions","tag-sage-intacct","tag-smart-rules"],"yoast_head":"\nEffective Application of Sage Intacct Dimension Relationships<\/title>\n<meta name=\"description\" content=\"Find out how to use Sage Intacct Dimension Relationships effectively.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2021\/02\/26\/effective-use-of-sage-intacct-dimension-relationships\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Effective Application of Sage Intacct Dimension Relationships\" \/>\n<meta property=\"og:description\" content=\"Find out how to use Sage Intacct Dimension Relationships effectively.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2021\/02\/26\/effective-use-of-sage-intacct-dimension-relationships\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage Intacct \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2021-02-26T12:47:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-29T07:04:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/wp-content\/uploads\/2021\/02\/auto-fill.png\" \/>\n<meta name=\"author\" content=\"Greytrix\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Greytrix\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2021\/02\/26\/effective-use-of-sage-intacct-dimension-relationships\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2021\/02\/26\/effective-use-of-sage-intacct-dimension-relationships\/\",\"name\":\"Effective Application of Sage Intacct Dimension Relationships\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2021\/02\/26\/effective-use-of-sage-intacct-dimension-relationships\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2021\/02\/26\/effective-use-of-sage-intacct-dimension-relationships\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/wp-content\/uploads\/2021\/02\/auto-fill.png\",\"datePublished\":\"2021-02-26T12:47:58+00:00\",\"dateModified\":\"2024-11-29T07:04:38+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#\/schema\/person\/e108e7d0e2204e7a4b30748b516741c8\"},\"description\":\"Find out how to use Sage Intacct Dimension Relationships effectively.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2021\/02\/26\/effective-use-of-sage-intacct-dimension-relationships\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2021\/02\/26\/effective-use-of-sage-intacct-dimension-relationships\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2021\/02\/26\/effective-use-of-sage-intacct-dimension-relationships\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/wp-content\/uploads\/2021\/02\/auto-fill.png\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/wp-content\/uploads\/2021\/02\/auto-fill.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2021\/02\/26\/effective-use-of-sage-intacct-dimension-relationships\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Effective Use of Sage Intacct Dimension Relationships\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/\",\"name\":\"Sage Intacct \u2013 Tips, Tricks and Components\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#\/schema\/person\/e108e7d0e2204e7a4b30748b516741c8\",\"name\":\"Greytrix\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"Greytrix\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/author\/sageintacct\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Effective Application of Sage Intacct Dimension Relationships","description":"Find out how to use Sage Intacct Dimension Relationships effectively.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2021\/02\/26\/effective-use-of-sage-intacct-dimension-relationships\/","og_locale":"en_US","og_type":"article","og_title":"Effective Application of Sage Intacct Dimension Relationships","og_description":"Find out how to use Sage Intacct Dimension Relationships effectively.","og_url":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2021\/02\/26\/effective-use-of-sage-intacct-dimension-relationships\/","og_site_name":"Sage Intacct \u2013 Tips, Tricks and Components","article_published_time":"2021-02-26T12:47:58+00:00","article_modified_time":"2024-11-29T07:04:38+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/wp-content\/uploads\/2021\/02\/auto-fill.png","type":"","width":"","height":""}],"author":"Greytrix","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Greytrix","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2021\/02\/26\/effective-use-of-sage-intacct-dimension-relationships\/","url":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2021\/02\/26\/effective-use-of-sage-intacct-dimension-relationships\/","name":"Effective Application of Sage Intacct Dimension Relationships","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2021\/02\/26\/effective-use-of-sage-intacct-dimension-relationships\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2021\/02\/26\/effective-use-of-sage-intacct-dimension-relationships\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/wp-content\/uploads\/2021\/02\/auto-fill.png","datePublished":"2021-02-26T12:47:58+00:00","dateModified":"2024-11-29T07:04:38+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#\/schema\/person\/e108e7d0e2204e7a4b30748b516741c8"},"description":"Find out how to use Sage Intacct Dimension Relationships effectively.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2021\/02\/26\/effective-use-of-sage-intacct-dimension-relationships\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageintacct\/2021\/02\/26\/effective-use-of-sage-intacct-dimension-relationships\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2021\/02\/26\/effective-use-of-sage-intacct-dimension-relationships\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/wp-content\/uploads\/2021\/02\/auto-fill.png","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/wp-content\/uploads\/2021\/02\/auto-fill.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2021\/02\/26\/effective-use-of-sage-intacct-dimension-relationships\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/"},{"@type":"ListItem","position":2,"name":"Effective Use of Sage Intacct Dimension Relationships"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/","name":"Sage Intacct \u2013 Tips, Tricks and Components","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#\/schema\/person\/e108e7d0e2204e7a4b30748b516741c8","name":"Greytrix","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"Greytrix"},"url":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/author\/sageintacct\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/posts\/3063","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/comments?post=3063"}],"version-history":[{"count":3,"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/posts\/3063\/revisions"}],"predecessor-version":[{"id":7039,"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/posts\/3063\/revisions\/7039"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/media?parent=3063"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/categories?post=3063"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/tags?post=3063"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}