{"id":28825,"date":"2020-09-30T11:10:46","date_gmt":"2020-09-30T11:10:46","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=28825"},"modified":"2024-05-06T07:06:14","modified_gmt":"2024-05-06T07:06:14","slug":"bank-master-export-utility","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/09\/30\/bank-master-export-utility\/","title":{"rendered":"Bank Master Export Utility"},"content":{"rendered":"\n<p>Bank Services module in our Sage 300 ERP centralizes payments and receipts for all Sage 300 accounting programs. It maintains bank information, tracks payments and receipts, reverses payments, returns NSF items, performs reconciliations with bank statements, and creates General Ledger batches for information from bank statements and miscellaneous monthly transactions. The master screen, Bank, stores all the important information related to the banks that the organization maintains.<\/p>\n\n\n\n<p>We have developed a utility that will enable the organization to check and get this data available on a single click. In this blog, we are going to introduce the Bank Master Export Utility where the user can use this utility to export the detailed data of Bank. The utility has below Filter criteria:<\/p>\n\n\n\n<p><strong>New Stuff:- <a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/09\/30\/ap-misc-payment-export-utility\/\" data-type=\"post\" data-id=\"28808\" target=\"_blank\" rel=\"noreferrer noopener\">AP Misc. Payment Export utility<\/a><\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>From and To Bank code<\/strong><\/li><\/ul>\n\n\n\n<p>The report data will be produced as an MS-Excel exported file based on the user-specified Range of Bank Codes.<\/p>\n\n\n\n<p>Please refer below screenshot of the user interfaces for the \u201c<strong>Bank Master Export Utility<\/strong>\u201d.<\/p>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/09\/Bank-Master-Export-Utility-User-Interface.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/09\/Bank-Master-Export-Utility-User-Interface.png\" alt=\"Bank Master Export Utility - User Interface  \"><\/a><\/center>\n<font size=\"2\"><center>Bank Master Export Utility &#8211; User Interface .jpg <\/center><\/font> \n\n\n\n\n<p><\/p>\n\n\n\n<p>As you can see in the above screenshot user will be able to specify \u2018From\u2019 and \u2018To\u2019 Bank code. Based on the same, the report will generate required data in Excel format at desired path which user will enter in the \u2018Select File\u2019 field. After entering the excel file path as well as range of Bank code user will be able to export the data. Once the data is exported successfully user can access that excel file by click of single button.<\/p>\n\n\n\n<p><strong>Below is the excel-based generated output of the \u201cBank Master Export\u201d report: &#8211;<\/strong><\/p>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/09\/Bank-Master-Export-Output-1024x185.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/09\/Bank-Master-Export-Output-1024x185.png\" alt=\"Bank Master Export-Output  \"><\/a><\/center>\n<font size=\"2\"><center>Bank Master Export-Output  <\/center><\/font> \n\n\n\n\n<p><\/p>\n\n\n\n<p><strong>This report includes following fields from Bank screen and can be modified according to your requirement.<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Bank Code.<\/li><li>Bank Description.<\/li><li>Transit Number.<\/li><li>Bank Account Number<\/li><li>Bank Account<\/li><li>Address (Full Address, City, Country, state, Zip Code, telephone,Fax.)<\/li><li>Current Balance.<\/li><\/ul>\n\n\n\n<p>In this way user can fetch the required Bank data which serves the purpose of this utility.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bank Services module in our Sage 300 ERP centralizes payments and receipts for all Sage 300 accounting programs. It maintains bank information, tracks payments and receipts, reverses payments, returns NSF items, performs reconciliations with bank statements, and creates General Ledger batches for information from bank statements and miscellaneous monthly transactions. The master screen, Bank, stores\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/09\/30\/bank-master-export-utility\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[328,909,935,2960],"class_list":["post-28825","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-bank","tag-excel-report","tag-export","tag-utility"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Bank Master Exporting Function<\/title>\n<meta name=\"description\" content=\"Learn about the Bank Master Export Utility, which allows users to export precise bank data. The utility&#039;s filter criteria are as follows:\" \/>\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\/2020\/09\/30\/bank-master-export-utility\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bank Master Exporting Function\" \/>\n<meta property=\"og:description\" content=\"Learn about the Bank Master Export Utility, which allows users to export precise bank data. The utility&#039;s filter criteria are as follows:\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/09\/30\/bank-master-export-utility\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2020-09-30T11:10:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-06T07:06:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/09\/Bank-Master-Export-Utility-User-Interface.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=\"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\/sageaccpacerp\/2020\/09\/30\/bank-master-export-utility\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/09\/30\/bank-master-export-utility\/\",\"name\":\"Bank Master Exporting Function\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/09\/30\/bank-master-export-utility\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/09\/30\/bank-master-export-utility\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/09\/Bank-Master-Export-Utility-User-Interface.png\",\"datePublished\":\"2020-09-30T11:10:46+00:00\",\"dateModified\":\"2024-05-06T07:06:14+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/93977cd8aa8fbd1f151d3f664e29c9f2\"},\"description\":\"Learn about the Bank Master Export Utility, which allows users to export precise bank data. The utility's filter criteria are as follows:\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/09\/30\/bank-master-export-utility\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/09\/30\/bank-master-export-utility\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/09\/30\/bank-master-export-utility\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/09\/Bank-Master-Export-Utility-User-Interface.png\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/09\/Bank-Master-Export-Utility-User-Interface.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/09\/30\/bank-master-export-utility\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bank Master Export Utility\"}]},{\"@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\/93977cd8aa8fbd1f151d3f664e29c9f2\",\"name\":\"Greytrix\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g\",\"caption\":\"Greytrix\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/greytrix\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bank Master Exporting Function","description":"Learn about the Bank Master Export Utility, which allows users to export precise bank data. The utility's filter criteria are as follows:","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\/2020\/09\/30\/bank-master-export-utility\/","og_locale":"en_US","og_type":"article","og_title":"Bank Master Exporting Function","og_description":"Learn about the Bank Master Export Utility, which allows users to export precise bank data. The utility's filter criteria are as follows:","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/09\/30\/bank-master-export-utility\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2020-09-30T11:10:46+00:00","article_modified_time":"2024-05-06T07:06:14+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/09\/Bank-Master-Export-Utility-User-Interface.png","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\/sageaccpacerp\/2020\/09\/30\/bank-master-export-utility\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/09\/30\/bank-master-export-utility\/","name":"Bank Master Exporting Function","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/09\/30\/bank-master-export-utility\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/09\/30\/bank-master-export-utility\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/09\/Bank-Master-Export-Utility-User-Interface.png","datePublished":"2020-09-30T11:10:46+00:00","dateModified":"2024-05-06T07:06:14+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/93977cd8aa8fbd1f151d3f664e29c9f2"},"description":"Learn about the Bank Master Export Utility, which allows users to export precise bank data. The utility's filter criteria are as follows:","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/09\/30\/bank-master-export-utility\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/09\/30\/bank-master-export-utility\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/09\/30\/bank-master-export-utility\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/09\/Bank-Master-Export-Utility-User-Interface.png","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/09\/Bank-Master-Export-Utility-User-Interface.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/09\/30\/bank-master-export-utility\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Bank Master Export Utility"}]},{"@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\/93977cd8aa8fbd1f151d3f664e29c9f2","name":"Greytrix","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g","caption":"Greytrix"},"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/greytrix\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/28825","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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/comments?post=28825"}],"version-history":[{"count":6,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/28825\/revisions"}],"predecessor-version":[{"id":28839,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/28825\/revisions\/28839"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=28825"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=28825"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=28825"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}