{"id":2531,"date":"2024-02-06T09:34:00","date_gmt":"2024-02-06T09:34:00","guid":{"rendered":"https:\/\/cssi.com\/gp\/?p=2531"},"modified":"2024-01-26T21:34:53","modified_gmt":"2024-01-26T21:34:53","slug":"how-to-do-account-rollups-in-gp","status":"publish","type":"post","link":"https:\/\/cssi.com\/gp\/2024\/02\/06\/how-to-do-account-rollups-in-gp\/","title":{"rendered":"How to do Account Rollups in GP"},"content":{"rendered":"\n

GP Tip: Dynamics GP – Account Rollups<\/h2>\n\n\n\n

The GP Account Rollup Inquiry screen allows you to summarize information from GL several accounts and display this information in several ways such as Current and Previous years, Actuals vs. Budgets with variances.\u00a0 Use this as a quick way to view a sum of a group of related accounts.<\/p>\n\n\n\n

1. Go to Financial > Inquiry > Account Rollup
2. Enter an Option ID
3. Press the Tab key
4. Select Yes to add this option
5. In the Sort By drop-down list, select the G\/L account segment you want to use to sort the information that will be displayed.\u00a0
6. Select the number of columns of information you want to display
7. For each column of information, enter the column heading you want to use, and the Type of information you want to display.\u00a0 If you selected Budget type, click on the lookup icon to the right of Selection to select your Budget ID.\u00a0 If you selected Calculated type, click on the blue arrow to the right of Selection to open the Account Rollup Inquiry Calculated Column window.\u00a0<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

8. Enter restrictions to define the account segment ranges you want to use in this inquiry.\u00a0 You can set up multiple ranges for a single segment.
9. Click on Save
10. Go back to the Option ID you created and click on Redisplay.\u00a0 You can choose to display either Net Change amounts or Period Balances.
11. Click to select an amount then drill-down on one of the blue underlined column headers to see the account breakdown.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Need GP Help?<\/h2>\n\n\n\n

Need more help with GP? Please contact CSSI for expert GP support.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

GP Tip: Dynamics GP – Account Rollups The GP Account Rollup Inquiry screen allows you to summarize information from GL several accounts and display this information in several ways such as Current and Previous years, Actuals vs. Budgets with variances.\u00a0 Use this as a quick way to view a sum.<\/p>\n","protected":false},"author":4,"featured_media":2535,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","footnotes":""},"categories":[8],"tags":[38,229,144],"class_list":["post-2531","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-dynamics-gp","tag-gp-tips","tag-microsoft-dynamics"],"acf":[],"yoast_head":"\nHow to do Account Rollups in GP - Dynamics GP Support in PA - CSSI Technologies LLC<\/title>\n<meta name=\"description\" content=\"The GP Account Rollup Inquiry screen allows you to summarize information from GL accounts and display this information in several ways.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cssi.com\/gp\/2024\/02\/06\/how-to-do-account-rollups-in-gp\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to do Account Rollups in GP - Dynamics GP Support in PA - CSSI Technologies LLC\" \/>\n<meta property=\"og:description\" content=\"The GP Account Rollup Inquiry screen allows you to summarize information from GL accounts and display this information in several ways.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cssi.com\/gp\/2024\/02\/06\/how-to-do-account-rollups-in-gp\/\" \/>\n<meta property=\"og:site_name\" content=\"Dynamics GP Support in PA - CSSI Technologies LLC\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-06T09:34:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cssi.com\/gp\/wp-content\/uploads\/sites\/2\/2024\/01\/GP-Tip-Account-roll-ups.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1500\" \/>\n\t<meta property=\"og:image:height\" content=\"1000\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"jtosolt\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@jtosolt@cssi.com\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"jtosolt\" \/>\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\":\"Article\",\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2024\\\/02\\\/06\\\/how-to-do-account-rollups-in-gp\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2024\\\/02\\\/06\\\/how-to-do-account-rollups-in-gp\\\/\"},\"author\":{\"name\":\"jtosolt\",\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/#\\\/schema\\\/person\\\/2af2cbcbd389a279188e6b4608ddb4db\"},\"headline\":\"How to do Account Rollups in GP\",\"datePublished\":\"2024-02-06T09:34:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2024\\\/02\\\/06\\\/how-to-do-account-rollups-in-gp\\\/\"},\"wordCount\":271,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2024\\\/02\\\/06\\\/how-to-do-account-rollups-in-gp\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cssi.com\\\/gp\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/01\\\/GP-Tip-Account-roll-ups.jpg\",\"keywords\":[\"dynamics gp\",\"gp tips\",\"microsoft dynamics\"],\"articleSection\":[\"blog\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/cssi.com\\\/gp\\\/2024\\\/02\\\/06\\\/how-to-do-account-rollups-in-gp\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2024\\\/02\\\/06\\\/how-to-do-account-rollups-in-gp\\\/\",\"url\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2024\\\/02\\\/06\\\/how-to-do-account-rollups-in-gp\\\/\",\"name\":\"How to do Account Rollups in GP - Dynamics GP Support in PA - CSSI Technologies LLC\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2024\\\/02\\\/06\\\/how-to-do-account-rollups-in-gp\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2024\\\/02\\\/06\\\/how-to-do-account-rollups-in-gp\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cssi.com\\\/gp\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/01\\\/GP-Tip-Account-roll-ups.jpg\",\"datePublished\":\"2024-02-06T09:34:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/#\\\/schema\\\/person\\\/2af2cbcbd389a279188e6b4608ddb4db\"},\"description\":\"The GP Account Rollup Inquiry screen allows you to summarize information from GL accounts and display this information in several ways.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2024\\\/02\\\/06\\\/how-to-do-account-rollups-in-gp\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/cssi.com\\\/gp\\\/2024\\\/02\\\/06\\\/how-to-do-account-rollups-in-gp\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2024\\\/02\\\/06\\\/how-to-do-account-rollups-in-gp\\\/#primaryimage\",\"url\":\"https:\\\/\\\/cssi.com\\\/gp\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/01\\\/GP-Tip-Account-roll-ups.jpg\",\"contentUrl\":\"https:\\\/\\\/cssi.com\\\/gp\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/01\\\/GP-Tip-Account-roll-ups.jpg\",\"width\":1500,\"height\":1000,\"caption\":\"GP Tip Account roll-ups\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2024\\\/02\\\/06\\\/how-to-do-account-rollups-in-gp\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/cssi.com\\\/gp\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to do Account Rollups in GP\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/#website\",\"url\":\"https:\\\/\\\/cssi.com\\\/gp\\\/\",\"name\":\"Dynamics GP Support in PA - CSSI Technologies LLC\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/cssi.com\\\/gp\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/#\\\/schema\\\/person\\\/2af2cbcbd389a279188e6b4608ddb4db\",\"name\":\"jtosolt\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6322382d65cc71df3e9c204b08e5722e704d53b70cbd527b85c7cb3a758a3d3d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6322382d65cc71df3e9c204b08e5722e704d53b70cbd527b85c7cb3a758a3d3d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6322382d65cc71df3e9c204b08e5722e704d53b70cbd527b85c7cb3a758a3d3d?s=96&d=mm&r=g\",\"caption\":\"jtosolt\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/jtosolt@cssi.com\"],\"url\":\"https:\\\/\\\/cssi.com\\\/gp\\\/author\\\/jtosolt\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to do Account Rollups in GP - Dynamics GP Support in PA - CSSI Technologies LLC","description":"The GP Account Rollup Inquiry screen allows you to summarize information from GL accounts and display this information in several ways.","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:\/\/cssi.com\/gp\/2024\/02\/06\/how-to-do-account-rollups-in-gp\/","og_locale":"en_US","og_type":"article","og_title":"How to do Account Rollups in GP - Dynamics GP Support in PA - CSSI Technologies LLC","og_description":"The GP Account Rollup Inquiry screen allows you to summarize information from GL accounts and display this information in several ways.","og_url":"https:\/\/cssi.com\/gp\/2024\/02\/06\/how-to-do-account-rollups-in-gp\/","og_site_name":"Dynamics GP Support in PA - CSSI Technologies LLC","article_published_time":"2024-02-06T09:34:00+00:00","og_image":[{"width":1500,"height":1000,"url":"https:\/\/cssi.com\/gp\/wp-content\/uploads\/sites\/2\/2024\/01\/GP-Tip-Account-roll-ups.jpg","type":"image\/jpeg"}],"author":"jtosolt","twitter_card":"summary_large_image","twitter_creator":"@jtosolt@cssi.com","twitter_misc":{"Written by":"jtosolt","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cssi.com\/gp\/2024\/02\/06\/how-to-do-account-rollups-in-gp\/#article","isPartOf":{"@id":"https:\/\/cssi.com\/gp\/2024\/02\/06\/how-to-do-account-rollups-in-gp\/"},"author":{"name":"jtosolt","@id":"https:\/\/cssi.com\/gp\/#\/schema\/person\/2af2cbcbd389a279188e6b4608ddb4db"},"headline":"How to do Account Rollups in GP","datePublished":"2024-02-06T09:34:00+00:00","mainEntityOfPage":{"@id":"https:\/\/cssi.com\/gp\/2024\/02\/06\/how-to-do-account-rollups-in-gp\/"},"wordCount":271,"commentCount":0,"image":{"@id":"https:\/\/cssi.com\/gp\/2024\/02\/06\/how-to-do-account-rollups-in-gp\/#primaryimage"},"thumbnailUrl":"https:\/\/cssi.com\/gp\/wp-content\/uploads\/sites\/2\/2024\/01\/GP-Tip-Account-roll-ups.jpg","keywords":["dynamics gp","gp tips","microsoft dynamics"],"articleSection":["blog"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/cssi.com\/gp\/2024\/02\/06\/how-to-do-account-rollups-in-gp\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/cssi.com\/gp\/2024\/02\/06\/how-to-do-account-rollups-in-gp\/","url":"https:\/\/cssi.com\/gp\/2024\/02\/06\/how-to-do-account-rollups-in-gp\/","name":"How to do Account Rollups in GP - Dynamics GP Support in PA - CSSI Technologies LLC","isPartOf":{"@id":"https:\/\/cssi.com\/gp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/cssi.com\/gp\/2024\/02\/06\/how-to-do-account-rollups-in-gp\/#primaryimage"},"image":{"@id":"https:\/\/cssi.com\/gp\/2024\/02\/06\/how-to-do-account-rollups-in-gp\/#primaryimage"},"thumbnailUrl":"https:\/\/cssi.com\/gp\/wp-content\/uploads\/sites\/2\/2024\/01\/GP-Tip-Account-roll-ups.jpg","datePublished":"2024-02-06T09:34:00+00:00","author":{"@id":"https:\/\/cssi.com\/gp\/#\/schema\/person\/2af2cbcbd389a279188e6b4608ddb4db"},"description":"The GP Account Rollup Inquiry screen allows you to summarize information from GL accounts and display this information in several ways.","breadcrumb":{"@id":"https:\/\/cssi.com\/gp\/2024\/02\/06\/how-to-do-account-rollups-in-gp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cssi.com\/gp\/2024\/02\/06\/how-to-do-account-rollups-in-gp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cssi.com\/gp\/2024\/02\/06\/how-to-do-account-rollups-in-gp\/#primaryimage","url":"https:\/\/cssi.com\/gp\/wp-content\/uploads\/sites\/2\/2024\/01\/GP-Tip-Account-roll-ups.jpg","contentUrl":"https:\/\/cssi.com\/gp\/wp-content\/uploads\/sites\/2\/2024\/01\/GP-Tip-Account-roll-ups.jpg","width":1500,"height":1000,"caption":"GP Tip Account roll-ups"},{"@type":"BreadcrumbList","@id":"https:\/\/cssi.com\/gp\/2024\/02\/06\/how-to-do-account-rollups-in-gp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cssi.com\/gp\/"},{"@type":"ListItem","position":2,"name":"How to do Account Rollups in GP"}]},{"@type":"WebSite","@id":"https:\/\/cssi.com\/gp\/#website","url":"https:\/\/cssi.com\/gp\/","name":"Dynamics GP Support in PA - CSSI Technologies LLC","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cssi.com\/gp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/cssi.com\/gp\/#\/schema\/person\/2af2cbcbd389a279188e6b4608ddb4db","name":"jtosolt","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/6322382d65cc71df3e9c204b08e5722e704d53b70cbd527b85c7cb3a758a3d3d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/6322382d65cc71df3e9c204b08e5722e704d53b70cbd527b85c7cb3a758a3d3d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6322382d65cc71df3e9c204b08e5722e704d53b70cbd527b85c7cb3a758a3d3d?s=96&d=mm&r=g","caption":"jtosolt"},"sameAs":["https:\/\/x.com\/jtosolt@cssi.com"],"url":"https:\/\/cssi.com\/gp\/author\/jtosolt\/"}]}},"_links":{"self":[{"href":"https:\/\/cssi.com\/gp\/wp-json\/wp\/v2\/posts\/2531","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cssi.com\/gp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cssi.com\/gp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cssi.com\/gp\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/cssi.com\/gp\/wp-json\/wp\/v2\/comments?post=2531"}],"version-history":[{"count":0,"href":"https:\/\/cssi.com\/gp\/wp-json\/wp\/v2\/posts\/2531\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cssi.com\/gp\/wp-json\/wp\/v2\/media\/2535"}],"wp:attachment":[{"href":"https:\/\/cssi.com\/gp\/wp-json\/wp\/v2\/media?parent=2531"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cssi.com\/gp\/wp-json\/wp\/v2\/categories?post=2531"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cssi.com\/gp\/wp-json\/wp\/v2\/tags?post=2531"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}