{"id":27494,"date":"2019-11-27T06:39:56","date_gmt":"2019-11-27T06:39:56","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=27494"},"modified":"2024-05-02T04:34:15","modified_gmt":"2024-05-02T04:34:15","slug":"payment-banking-format","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2019\/11\/27\/payment-banking-format\/","title":{"rendered":"Payment Banking Format"},"content":{"rendered":"\n

Using Payment Entry screen user can enter new payment entries and enter the general information for a check, the vendor number, , the check date, and whether you are recording information for a check that is already issued or printing it from Accounts Payable but how we can manage all the details in the single file? <\/p>\n\n\n\n

New Stuff :- Mailing functionality in Payment Advice Report<\/a><\/p>\n\n\n\n

So In this blog, we are going to discuss about the \u201cPayment Banking Format\u201d which we have developed for one of our customers. The report will include details of Payment and the same will get exported in \u201ctext\u201d format.<\/p>\n\n\n\n

The report data will be produced as a text exported file based. This data will be extracted based on the user-specified ‘From’ and ‘To’ batch details and entry details (refer below screenshot for more clarification.)<\/p>\n\n\n\n

The user interface for \u201cPayment Banking Format\u201d is as displayed below.<\/p>\n\n\n\n

\"Payment

<\/figcaption><\/figure>\n\n\n\n

Note: – We have considered only\u201d Payment\u201d Transaction Type from the AP Payment screen.<\/p>\n\n\n\n

Below are some fields which get exported in the text format and we have fetched the data from header level and detail level from AP Payment Entry screen.<\/p>\n\n\n\n

Let\u2019s take short overview of generated output: <\/p>\n\n\n\n

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

We have mentioned some fields for understanding purpose and below is the details of the generated output. <\/p>\n\n\n\n

0001<\/strong>:-
This is the Identification number to differentiate the batch.<\/p>\n\n\n\n

150918<\/strong>:-
Header level Payment Date field from the AP Payment screen.<\/p>\n\n\n\n

00001<\/strong>:-
Total number of batches. For e.g.:
If there are two batches selected from the User interface, then this field displays the total number of batches selected, which means, the Number will display \u201d00002\u201d. For the total number of 10 batches it will be displayed like\u201d00010\u201d.<\/p>\n\n\n\n

0010<\/strong>:-
This will be Identification number to understand the batch details <\/p>\n\n\n\n

150918<\/strong>:-
This will be header level Payment date field from the AP Payment screen <\/p>\n\n\n\n

6155111000009245INR:-<\/strong>
This will be header level Bank Account field based on Selected Bank along with Currency which is present on Ap Payment screen<\/p>\n\n\n\n

The purpose of this utility, user can easily export data in the single txt format along with the payment details and which is confidential.<\/p>\n","protected":false},"excerpt":{"rendered":"

Using Payment Entry screen user can enter new payment entries and enter the general information for a check, the vendor number, , the check date, and whether you are recording information for a check that is already issued or printing it from Accounts Payable but how we can manage all the details in the single\u2026 Read More »<\/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":[776,935,1013,1873,1879],"class_list":["post-27494","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-details","tag-export","tag-format","tag-payment","tag-payment-details-in-sage300erp"],"yoast_head":"\nFormat for Payment Banking<\/title>\n<meta name=\"description\" content=\"We will talk about the "Payment Banking Format" that we created for one of our clients. Payment details will be included in the report.\" \/>\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\/2019\/11\/27\/payment-banking-format\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Format for Payment Banking\" \/>\n<meta property=\"og:description\" content=\"We will talk about the "Payment Banking Format" that we created for one of our clients. Payment details will be included in the report.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2019\/11\/27\/payment-banking-format\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-27T06:39:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-02T04:34:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2019\/11\/1.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\/2019\/11\/27\/payment-banking-format\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2019\/11\/27\/payment-banking-format\/\",\"name\":\"Format for Payment Banking\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2019\/11\/27\/payment-banking-format\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2019\/11\/27\/payment-banking-format\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2019\/11\/1.png\",\"datePublished\":\"2019-11-27T06:39:56+00:00\",\"dateModified\":\"2024-05-02T04:34:15+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/93977cd8aa8fbd1f151d3f664e29c9f2\"},\"description\":\"We will talk about the \\\"Payment Banking Format\\\" that we created for one of our clients. Payment details will be included in the report.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2019\/11\/27\/payment-banking-format\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2019\/11\/27\/payment-banking-format\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2019\/11\/27\/payment-banking-format\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2019\/11\/1.png\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2019\/11\/1.png\",\"width\":530,\"height\":160},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2019\/11\/27\/payment-banking-format\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Payment Banking Format\"}]},{\"@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":"Format for Payment Banking","description":"We will talk about the \"Payment Banking Format\" that we created for one of our clients. Payment details will be included in the report.","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\/2019\/11\/27\/payment-banking-format\/","og_locale":"en_US","og_type":"article","og_title":"Format for Payment Banking","og_description":"We will talk about the \"Payment Banking Format\" that we created for one of our clients. Payment details will be included in the report.","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2019\/11\/27\/payment-banking-format\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2019-11-27T06:39:56+00:00","article_modified_time":"2024-05-02T04:34:15+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2019\/11\/1.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\/2019\/11\/27\/payment-banking-format\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2019\/11\/27\/payment-banking-format\/","name":"Format for Payment Banking","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2019\/11\/27\/payment-banking-format\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2019\/11\/27\/payment-banking-format\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2019\/11\/1.png","datePublished":"2019-11-27T06:39:56+00:00","dateModified":"2024-05-02T04:34:15+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/93977cd8aa8fbd1f151d3f664e29c9f2"},"description":"We will talk about the \"Payment Banking Format\" that we created for one of our clients. Payment details will be included in the report.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2019\/11\/27\/payment-banking-format\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2019\/11\/27\/payment-banking-format\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2019\/11\/27\/payment-banking-format\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2019\/11\/1.png","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2019\/11\/1.png","width":530,"height":160},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2019\/11\/27\/payment-banking-format\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Payment Banking Format"}]},{"@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\/27494","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=27494"}],"version-history":[{"count":4,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/27494\/revisions"}],"predecessor-version":[{"id":34424,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/27494\/revisions\/34424"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=27494"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=27494"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=27494"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}