{"id":12606,"date":"2015-09-28T05:07:57","date_gmt":"2015-09-28T05:07:57","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=12606"},"modified":"2015-09-28T05:07:57","modified_gmt":"2015-09-28T05:07:57","slug":"inquiry-tool-in-sage-300-web-portal","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/28\/inquiry-tool-in-sage-300-web-portal\/","title":{"rendered":"Inquiry tool in Sage 300 web portal"},"content":{"rendered":"

Sage 300<\/em><\/strong><\/a> web<\/em><\/strong> Portal<\/em><\/strong> has a new advanced feature called the \u201cADHOC Query Tool\u201d <\/em><\/strong>where we had query templates for A\/R customers & Transactions, A\/P Vendors & Transactions, G\/L Accounts & Net changes, G\/L Account & Transactions, IC Transactions, O\/E Transactions & P\/O Transactions.<\/p>\n

Through specific filter criteria a user can add multiple filters according to User requirement.<\/p>\n

Portal Login -> Inquiry -> From Template -> A\/R Customer and Transaction -> Query Template -> Select Report<\/strong><\/p>\n

\"Untitled\"<\/a><\/strong><\/p>\n

New Stuff:\u00a0Migrate Price Lists from Sage BusinessWorks to Sage 300 ERP<\/a><\/strong><\/em><\/p>\n

If the user wants to save the query he can save it. Also he can give name to his query in \u201cQuery Name\u201d<\/em><\/strong> and in details tab the user can save the query in 2 categories<\/p>\n

1) Public Query (All authorized users can use this query.)
\n2) Private Query (Only the user who created the Query can use it.)<\/p>\n

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

\n

The user can open the saved report from saved query.<\/strong><\/p>\n

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

\n

The report thus generated can also be customized and as per the new advanced feature of Sage ERP 300 Web Portal<\/em><\/strong>, the user can see grand total of the generated report by selecting the \u201cShow Grand Totals Pane\u201d<\/em><\/strong> and can also export the report in Excel or PDF format.<\/p>\n

Also Read:<\/strong>
\n1.\u00a0AR Customers-OE Sales Inquiry<\/a>
\n2.\u00a0I\/C Current Transactions Inquiry Form<\/a>
\n3.\u00a0AR Customers-OE Order Inquiry<\/a>
\n4.\u00a0IC Items Location Details Quantity Inquiry in Sage 300 ERP<\/a>
\n5.\u00a0AR Customer Receipt Enquiry<\/a><\/p>\n

\n","protected":false},"excerpt":{"rendered":"

Sage 300 web Portal has a new advanced feature called the \u201cADHOC Query Tool\u201d where we had query templates for A\/R customers & Transactions, A\/P Vendors & Transactions, G\/L Accounts & Net changes, G\/L Account & Transactions, IC Transactions, O\/E Transactions & P\/O Transactions. Through specific filter criteria a user can add multiple filters according\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[20,239,2311,3045],"class_list":["post-12606","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-300-erp","tag-ar-customer-inquiry","tag-sage","tag-web-portal"],"yoast_head":"\nInquiry tool in Sage 300 web portal - Sage 300 ERP \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\/sageaccpacerp\/2015\/09\/28\/inquiry-tool-in-sage-300-web-portal\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Inquiry tool in Sage 300 web portal - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Sage 300 web Portal has a new advanced feature called the \u201cADHOC Query Tool\u201d where we had query templates for A\/R customers & Transactions, A\/P Vendors & Transactions, G\/L Accounts & Net changes, G\/L Account & Transactions, IC Transactions, O\/E Transactions & P\/O Transactions. Through specific filter criteria a user can add multiple filters according\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/28\/inquiry-tool-in-sage-300-web-portal\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2015-09-28T05:07:57+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/09\/Untitled.png\" \/>\n<meta name=\"author\" content=\"sage300\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"sage300\" \/>\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\/sageaccpacerp\/2015\/09\/28\/inquiry-tool-in-sage-300-web-portal\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/28\/inquiry-tool-in-sage-300-web-portal\/\",\"name\":\"Inquiry tool in Sage 300 web portal - Sage 300 ERP \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/28\/inquiry-tool-in-sage-300-web-portal\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/28\/inquiry-tool-in-sage-300-web-portal\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/09\/Untitled.png\",\"datePublished\":\"2015-09-28T05:07:57+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/28\/inquiry-tool-in-sage-300-web-portal\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/28\/inquiry-tool-in-sage-300-web-portal\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/28\/inquiry-tool-in-sage-300-web-portal\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/09\/Untitled.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/09\/Untitled.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/28\/inquiry-tool-in-sage-300-web-portal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Inquiry tool in Sage 300 web portal\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\",\"name\":\"Sage 300 ERP \u2013 Tips, Tricks and Components\",\"description\":\"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?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\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\",\"name\":\"sage300\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/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\":\"sage300\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Inquiry tool in Sage 300 web portal - Sage 300 ERP \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\/sageaccpacerp\/2015\/09\/28\/inquiry-tool-in-sage-300-web-portal\/","og_locale":"en_US","og_type":"article","og_title":"Inquiry tool in Sage 300 web portal - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"Sage 300 web Portal has a new advanced feature called the \u201cADHOC Query Tool\u201d where we had query templates for A\/R customers & Transactions, A\/P Vendors & Transactions, G\/L Accounts & Net changes, G\/L Account & Transactions, IC Transactions, O\/E Transactions & P\/O Transactions. Through specific filter criteria a user can add multiple filters according\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/28\/inquiry-tool-in-sage-300-web-portal\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2015-09-28T05:07:57+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/09\/Untitled.png","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/28\/inquiry-tool-in-sage-300-web-portal\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/28\/inquiry-tool-in-sage-300-web-portal\/","name":"Inquiry tool in Sage 300 web portal - Sage 300 ERP \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/28\/inquiry-tool-in-sage-300-web-portal\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/28\/inquiry-tool-in-sage-300-web-portal\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/09\/Untitled.png","datePublished":"2015-09-28T05:07:57+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/28\/inquiry-tool-in-sage-300-web-portal\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/28\/inquiry-tool-in-sage-300-web-portal\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/28\/inquiry-tool-in-sage-300-web-portal\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/09\/Untitled.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/09\/Untitled.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/28\/inquiry-tool-in-sage-300-web-portal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Inquiry tool in Sage 300 web portal"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/","name":"Sage 300 ERP \u2013 Tips, Tricks and Components","description":"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?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\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5","name":"sage300","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/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":"sage300"},"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/12606","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/comments?post=12606"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/12606\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=12606"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=12606"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=12606"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}