{"id":123,"date":"2009-04-20T11:50:00","date_gmt":"2009-04-20T11:50:00","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagemas\/?p=123"},"modified":"2018-10-30T09:09:18","modified_gmt":"2018-10-30T09:09:18","slug":"drill-down-facility-in-the-invoice-bi-explorer","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/04\/20\/drill-down-facility-in-the-invoice-bi-explorer\/","title":{"rendered":"Drill-Down facility in the Invoice BI Explorer"},"content":{"rendered":"<p>In standard MAS 500 functionality, the Business Insights Explorer for Invoice displays the records of the Invoice transactions i.e. Invoice Header and the corresponding Invoice Detail records. Please refer the below screenshot.<\/p>\n<p><a href=\"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/SexhxitDWZI\/AAAAAAAAATo\/HFw2Apoa1Ho\/s1600-h\/aging+before.JPG\"><img decoding=\"async\" id=\"BLOGGER_PHOTO_ID_5326739963029707154\" style=\"display: block; margin: 0px auto 10px; text-align: center; cursor: hand; width: 400px; height: 288px;\" src=\"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/SexhxitDWZI\/AAAAAAAAATo\/HFw2Apoa1Ho\/s400\/aging+before.JPG\" alt=\"\" border=\"0\" \/><\/a>If user wants to view the invoices on the basis of Aging Category then first user has to open the Customer BI explorer to view the aging category and then open the Invoice BI explorer to view the corresponding invoices for the customer. This is a cumbersome process.<\/p>\n<p>We at Greytrix have consolidated both this tasks for the convenience of the user. We have created a drill down component to view the Invoices based on the Aging Category in the Invoice BI Explorer itself. This component thus minimizes the duration required for the entire process.<\/p>\n<p>Please refer the below screenshot.<\/p>\n<p><a href=\"http:\/\/2.bp.blogspot.com\/_A6_b0zkYeSY\/Sexhx5v01LI\/AAAAAAAAATw\/44XGIiU4cVg\/s1600-h\/aging+after.JPG\"><img decoding=\"async\" id=\"BLOGGER_PHOTO_ID_5326739969215354034\" style=\"display: block; margin: 0px auto 10px; text-align: center; cursor: hand; width: 400px; height: 288px;\" src=\"http:\/\/2.bp.blogspot.com\/_A6_b0zkYeSY\/Sexhx5v01LI\/AAAAAAAAATw\/44XGIiU4cVg\/s400\/aging+after.JPG\" alt=\"\" border=\"0\" \/><\/a>For more information about this component feel free to contact us at\u00a0<a href=\"mailto:sage@greytrix.com\">sage@greytrix.com<\/a>.<\/p>\n<p><span style=\"font-size: Medium;\"><strong>About Us<\/strong><\/span><br \/>\n<a href=\"http:\/\/www.greytrix.com\/\">Greytrix<\/a> is a one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.<\/p>\n<p>Greytrix\u00a0has some unique solutions of\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/sage-crm\/gumu-sage-100-erp-integration\">Sage 100 integration with Sage CRM<\/a>,\u00a0and <a href=\"https:\/\/www.greytrix.com\/product\/sage-100-erp\/gumu-100-salesforce-integration\">Salesforce.com<\/a> along with <a href=\"https:\/\/www.greytrix.com\/product\/sage-100-erp\/sage-50-us-sage-100-migration\">Sage 100 Migration from Sage 50 US<\/a>, <a href=\"https:\/\/www.greytrix.com\/product\/intacct-apps-and-products\/gumu-sage-intacct-sage-100-migration\">Sage Intacct<\/a>, <a href=\"https:\/\/www.greytrix.com\/product\/sage-100-erp\/quickbooks-sage-100-migration\">QuickBooks<\/a>, Sage Business Vision and Sage Business Works. We also offer best-in-class\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/erp-development\/sage-100-erp\">Sage 100 customization and development services\u00a0<\/a>to Sage business partners, end users, and Sage PSG worldwide.<\/p>\n<p>For more details on Sage 100 Services, please contact us at\u00a0<a href=\"mailto:sage@greytrix.com\">sage@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In standard MAS 500 functionality, the Business Insights Explorer for Invoice displays the records of the Invoice transactions i.e. Invoice Header and the corresponding Invoice Detail records. Please refer the below screenshot. If user wants to view the invoices on the basis of Aging Category then first user has to open the Customer BI explorer\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/04\/20\/drill-down-facility-in-the-invoice-bi-explorer\/\">Read More &raquo;<\/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":[21],"tags":[],"class_list":["post-123","post","type-post","status-publish","format-standard","hentry","category-business-insights"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Drill-Down facility in the Invoice BI Explorer - GUMU\u2122 Integrations \u2013 Tips, Tricks and Components<\/title>\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\/sagemas\/2009\/04\/20\/drill-down-facility-in-the-invoice-bi-explorer\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Drill-Down facility in the Invoice BI Explorer - GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"In standard MAS 500 functionality, the Business Insights Explorer for Invoice displays the records of the Invoice transactions i.e. Invoice Header and the corresponding Invoice Detail records. Please refer the below screenshot. If user wants to view the invoices on the basis of Aging Category then first user has to open the Customer BI explorer\u2026 Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/04\/20\/drill-down-facility-in-the-invoice-bi-explorer\/\" \/>\n<meta property=\"og:site_name\" content=\"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2009-04-20T11:50:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-10-30T09:09:18+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/SexhxitDWZI\/AAAAAAAAATo\/HFw2Apoa1Ho\/s400\/aging+before.JPG\" \/>\n<meta name=\"author\" content=\"greysagemas\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagemas\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/04\/20\/drill-down-facility-in-the-invoice-bi-explorer\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/04\/20\/drill-down-facility-in-the-invoice-bi-explorer\/\",\"name\":\"Drill-Down facility in the Invoice BI Explorer - GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/04\/20\/drill-down-facility-in-the-invoice-bi-explorer\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/04\/20\/drill-down-facility-in-the-invoice-bi-explorer\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/SexhxitDWZI\/AAAAAAAAATo\/HFw2Apoa1Ho\/s400\/aging+before.JPG\",\"datePublished\":\"2009-04-20T11:50:00+00:00\",\"dateModified\":\"2018-10-30T09:09:18+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/04\/20\/drill-down-facility-in-the-invoice-bi-explorer\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/04\/20\/drill-down-facility-in-the-invoice-bi-explorer\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/04\/20\/drill-down-facility-in-the-invoice-bi-explorer\/#primaryimage\",\"url\":\"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/SexhxitDWZI\/AAAAAAAAATo\/HFw2Apoa1Ho\/s400\/aging+before.JPG\",\"contentUrl\":\"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/SexhxitDWZI\/AAAAAAAAATo\/HFw2Apoa1Ho\/s400\/aging+before.JPG\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/04\/20\/drill-down-facility-in-the-invoice-bi-explorer\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Drill-Down facility in the Invoice BI Explorer\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/\",\"name\":\"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\",\"description\":\"Welcome to the GUMU\u2122 blog, your one-stop source to gain all the insights on seamless integration solutions for ERP and CRM systems. Developed by Greytrix, GUMU\u2122 is a powerful integration platform that bridges the gap between your business applications. Whether you\u2019re looking to integrate a CRM (Salesforce, Dynamics 365 CRM, and Sage CRM) or an ERP (Sage ERP, Acumatica) with each other or any other third-party application, GUMU\u2122 is a robust and reliable integrator tailored to your unique needs. Join us as we explore the abilities of GUMU\u2122 and learn how it transforms your integration experience. \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/?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\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728\",\"name\":\"greysagemas\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/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\":\"greysagemas\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/author\/greysagemas\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Drill-Down facility in the Invoice BI Explorer - GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","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\/sagemas\/2009\/04\/20\/drill-down-facility-in-the-invoice-bi-explorer\/","og_locale":"en_US","og_type":"article","og_title":"Drill-Down facility in the Invoice BI Explorer - GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","og_description":"In standard MAS 500 functionality, the Business Insights Explorer for Invoice displays the records of the Invoice transactions i.e. Invoice Header and the corresponding Invoice Detail records. Please refer the below screenshot. If user wants to view the invoices on the basis of Aging Category then first user has to open the Customer BI explorer\u2026 Read More &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/04\/20\/drill-down-facility-in-the-invoice-bi-explorer\/","og_site_name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","article_published_time":"2009-04-20T11:50:00+00:00","article_modified_time":"2018-10-30T09:09:18+00:00","og_image":[{"url":"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/SexhxitDWZI\/AAAAAAAAATo\/HFw2Apoa1Ho\/s400\/aging+before.JPG","type":"","width":"","height":""}],"author":"greysagemas","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagemas","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/04\/20\/drill-down-facility-in-the-invoice-bi-explorer\/","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/04\/20\/drill-down-facility-in-the-invoice-bi-explorer\/","name":"Drill-Down facility in the Invoice BI Explorer - GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/04\/20\/drill-down-facility-in-the-invoice-bi-explorer\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/04\/20\/drill-down-facility-in-the-invoice-bi-explorer\/#primaryimage"},"thumbnailUrl":"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/SexhxitDWZI\/AAAAAAAAATo\/HFw2Apoa1Ho\/s400\/aging+before.JPG","datePublished":"2009-04-20T11:50:00+00:00","dateModified":"2018-10-30T09:09:18+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/04\/20\/drill-down-facility-in-the-invoice-bi-explorer\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/04\/20\/drill-down-facility-in-the-invoice-bi-explorer\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/04\/20\/drill-down-facility-in-the-invoice-bi-explorer\/#primaryimage","url":"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/SexhxitDWZI\/AAAAAAAAATo\/HFw2Apoa1Ho\/s400\/aging+before.JPG","contentUrl":"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/SexhxitDWZI\/AAAAAAAAATo\/HFw2Apoa1Ho\/s400\/aging+before.JPG"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/04\/20\/drill-down-facility-in-the-invoice-bi-explorer\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagemas\/"},{"@type":"ListItem","position":2,"name":"Drill-Down facility in the Invoice BI Explorer"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/","name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","description":"Welcome to the GUMU\u2122 blog, your one-stop source to gain all the insights on seamless integration solutions for ERP and CRM systems. Developed by Greytrix, GUMU\u2122 is a powerful integration platform that bridges the gap between your business applications. Whether you\u2019re looking to integrate a CRM (Salesforce, Dynamics 365 CRM, and Sage CRM) or an ERP (Sage ERP, Acumatica) with each other or any other third-party application, GUMU\u2122 is a robust and reliable integrator tailored to your unique needs. Join us as we explore the abilities of GUMU\u2122 and learn how it transforms your integration experience. ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagemas\/?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\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728","name":"greysagemas","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/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":"greysagemas"},"url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/author\/greysagemas\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/123","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/comments?post=123"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/123\/revisions"}],"predecessor-version":[{"id":3147,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/123\/revisions\/3147"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/media?parent=123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/categories?post=123"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/tags?post=123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}