{"id":352,"date":"2018-11-19T12:18:07","date_gmt":"2018-11-19T12:18:07","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/?p=352"},"modified":"2022-03-28T11:29:07","modified_gmt":"2022-03-28T11:29:07","slug":"dimension-counts-in-sage-intacct","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2018\/11\/19\/dimension-counts-in-sage-intacct\/","title":{"rendered":"Get dimension Counts in Sage Intacct"},"content":{"rendered":"

In Sage Intacct you can easily maintain a count of any dimension members say customer, vendor, product or employee. These counts are completely automated (as you update dimension say add\/delete customer), useful for reporting or any other computation.<\/p>\n

Imagine you have to track different type of customers you are dealing with.  Here you wish to track number of active customers belonging to each category and then used them as a base for reporting so that you can get better insight of your business.<\/p>\n

In this blog we will understand how to setup the count on dimension members and automate the dimension count posting (count update).<\/p>\n

In below example we are setting up the count for different type of customers \u2013 Commercial, Residential and Corporate so that we can track number of active customers under each type.<\/p>\n

The first step is to create a statistical account.  Each dimension count is posted into separate statistical account.<\/p>\n

\"Statistical<\/a>

Statistical accounts<\/p><\/div>\n

Here we created separate statistical account for different type of customers – Commercial, Residential and Corporate.<\/p>\n

In next step we will create dimension group.  Since we are referring customer dimension we will create customer groups.<\/p>\n

\"Customer<\/a>

Customer groups<\/p><\/div>\n

Here we will apply appropriate filters so that only qualifying members are attached to this group.<\/p>\n

\"Customer<\/a>

Customer groups view<\/p><\/div>\n

Finally will create dimension count rules with which system will update statistical account counts.  Also we will choose the statistical journal. Dimension count transactions will be posted using this statistical journal.<\/p>\n

\"Dimension<\/a>

Dimension count rule<\/p><\/div>\n

Please note; after setting up the dimension count only newly updated entries are posted.  You will have to enter a manual journal entry (statistical journal entry) to update the appropriate beginning balance.<\/p>\n

Now to verify the result; add new customers and remember to assign customer type. You will notice that the count has been updated by the system.<\/p>\n

\"Dimension<\/a>

Dimension count report<\/p><\/div>\n\n","protected":false},"excerpt":{"rendered":"

In Sage Intacct you can easily maintain a count of any dimension members say customer, vendor, product or employee. These counts are completely automated (as you update dimension say add\/delete customer), useful for reporting or any other computation. Imagine you have to track different type of customers you are dealing with.  Here you wish to\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,94,95,34,22,96,23,24,97,44,26,71,45],"class_list":["post-352","post","type-post","status-publish","format-standard","hentry","category-sage-intacct","tag-dimension","tag-dimension-count","tag-sage","tag-sage-intacct","tag-sage-intacct-configuration","tag-sage-intacct-customer","tag-sage-intacct-customization","tag-sage-intacct-development","tag-sage-intacct-dimension","tag-sage-intacct-implementation","tag-sage-intacct-offshore-development","tag-sage-intacct-programming","tag-sage-intacct-services"],"yoast_head":"\nGet dimension Counts in Sage Intacct<\/title>\n<meta name=\"description\" content=\"Check how to setup the count on dimension members and automate the dimension count posting in Sage Intacct.\" \/>\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\/2018\/11\/19\/dimension-counts-in-sage-intacct\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Get dimension Counts in Sage Intacct\" \/>\n<meta property=\"og:description\" content=\"Check how to setup the count on dimension members and automate the dimension count posting in Sage Intacct.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2018\/11\/19\/dimension-counts-in-sage-intacct\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage Intacct \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-19T12:18:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-28T11:29:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/wp-content\/uploads\/2018\/11\/1_statisticalaccounts-1.jpg\" \/>\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=\"2 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\/2018\/11\/19\/dimension-counts-in-sage-intacct\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2018\/11\/19\/dimension-counts-in-sage-intacct\/\",\"name\":\"Get dimension Counts in Sage Intacct\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2018\/11\/19\/dimension-counts-in-sage-intacct\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2018\/11\/19\/dimension-counts-in-sage-intacct\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/wp-content\/uploads\/2018\/11\/1_statisticalaccounts-1.jpg\",\"datePublished\":\"2018-11-19T12:18:07+00:00\",\"dateModified\":\"2022-03-28T11:29:07+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#\/schema\/person\/e108e7d0e2204e7a4b30748b516741c8\"},\"description\":\"Check how to setup the count on dimension members and automate the dimension count posting in Sage Intacct.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2018\/11\/19\/dimension-counts-in-sage-intacct\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2018\/11\/19\/dimension-counts-in-sage-intacct\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2018\/11\/19\/dimension-counts-in-sage-intacct\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/wp-content\/uploads\/2018\/11\/1_statisticalaccounts-1.jpg\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/wp-content\/uploads\/2018\/11\/1_statisticalaccounts-1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2018\/11\/19\/dimension-counts-in-sage-intacct\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Get dimension Counts in Sage Intacct\"}]},{\"@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":"Get dimension Counts in Sage Intacct","description":"Check how to setup the count on dimension members and automate the dimension count posting in Sage Intacct.","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\/2018\/11\/19\/dimension-counts-in-sage-intacct\/","og_locale":"en_US","og_type":"article","og_title":"Get dimension Counts in Sage Intacct","og_description":"Check how to setup the count on dimension members and automate the dimension count posting in Sage Intacct.","og_url":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2018\/11\/19\/dimension-counts-in-sage-intacct\/","og_site_name":"Sage Intacct \u2013 Tips, Tricks and Components","article_published_time":"2018-11-19T12:18:07+00:00","article_modified_time":"2022-03-28T11:29:07+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/wp-content\/uploads\/2018\/11\/1_statisticalaccounts-1.jpg","type":"","width":"","height":""}],"author":"Greytrix","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Greytrix","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2018\/11\/19\/dimension-counts-in-sage-intacct\/","url":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2018\/11\/19\/dimension-counts-in-sage-intacct\/","name":"Get dimension Counts in Sage Intacct","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2018\/11\/19\/dimension-counts-in-sage-intacct\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2018\/11\/19\/dimension-counts-in-sage-intacct\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/wp-content\/uploads\/2018\/11\/1_statisticalaccounts-1.jpg","datePublished":"2018-11-19T12:18:07+00:00","dateModified":"2022-03-28T11:29:07+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#\/schema\/person\/e108e7d0e2204e7a4b30748b516741c8"},"description":"Check how to setup the count on dimension members and automate the dimension count posting in Sage Intacct.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2018\/11\/19\/dimension-counts-in-sage-intacct\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageintacct\/2018\/11\/19\/dimension-counts-in-sage-intacct\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2018\/11\/19\/dimension-counts-in-sage-intacct\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/wp-content\/uploads\/2018\/11\/1_statisticalaccounts-1.jpg","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/wp-content\/uploads\/2018\/11\/1_statisticalaccounts-1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2018\/11\/19\/dimension-counts-in-sage-intacct\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/"},{"@type":"ListItem","position":2,"name":"Get dimension Counts in Sage Intacct"}]},{"@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\/352","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=352"}],"version-history":[{"count":2,"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/posts\/352\/revisions"}],"predecessor-version":[{"id":5005,"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/posts\/352\/revisions\/5005"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/media?parent=352"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/categories?post=352"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/tags?post=352"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}