{"id":19304,"date":"2018-06-01T06:10:19","date_gmt":"2018-06-01T06:10:19","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=19304"},"modified":"2024-04-24T05:59:15","modified_gmt":"2024-04-24T05:59:15","slug":"vendor-transaction-report","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/01\/vendor-transaction-report\/","title":{"rendered":"Vendor Transaction Report"},"content":{"rendered":"<p>The Vendor Transactions report lists transactions that were posted to vendor accounts during the period you specify when you print the report. You can sort the transactions by document date, by document number, or by fiscal year and period.<\/p>\n<p>The number of days that the transaction is overdue on the date you print the report. This information shows your payment habits with each vendor and highlights seriously overdue transactions that may require immediate payment<\/p>\n<p><strong><em>New Stuff:<\/em>\u00a0<\/strong><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/05\/30\/add-widget-feature-in-sage-300c\/\" target=\"_blank\" rel=\"noopener\">Add Widget feature in Sage 300c<\/a><\/p>\n<p>To navigate Vendor Transactions screen: &#8211; Greytrix Extended Report pack Report AP Vendor Transaction (Refer Below screen)<br \/>\n<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/06\/1.png\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-19305 size-full\" title=\"Vendor Transaction\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/06\/1.png\" alt=\"Vendor Transaction\" width=\"473\" height=\"477\" \/><\/a><br \/>\nIn this blog, we will discuss how we have developed customized Vendor transaction Report to display additional fields in the report.<\/p>\n<p><strong>Note: &#8211; This will be crystal report format<\/strong><\/p>\n<p>If we look into the standard report there is some field already exist to showing batch and Entry details of the Transaction and we have customized the same report and added some details like Vendor information, Taxes information, vendor exchange rate etc. (Refer below screenshot )<br \/>\n<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/06\/2-1.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"aligncenter wp-image-19315\" title=\"Tax Information\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/06\/2-1.png\" alt=\"Tax Information\" width=\"686\" height=\"463\" \/><\/a><\/p>\n<ul>\n<li><strong>Fiscal year:-<\/strong>this will be Fiscal year details of same batch which user has been already printed<\/li>\n<li><strong>Fiscal period: &#8211;<\/strong> this will be Fiscal period details of same batch which user has been already printed<\/li>\n<li><strong>Due date: &#8211;<\/strong> this will be due date details of same batch which user has been already printed<\/li>\n<li><strong>Vendor Name: &#8211;<\/strong> this will be Vendor Name details of same batch which user has been already printed<\/li>\n<li><strong>Order no: &#8211;<\/strong> this will be header level Order no details of same batch which user has been already printed<\/li>\n<li><strong>BS GL code (Header):- <\/strong>payable control account based on Vendor account set details of the same batch<\/li>\n<li><strong>Expense GL (line):-<\/strong> detail level GL Account field details of the same batch<\/li>\n<li><strong>Transaction currency: &#8211; <\/strong>vendor currency field details of the same batch<\/li>\n<li><strong>Rate type: &#8211;<\/strong> Rate type field from Rate tab details of the same batch<\/li>\n<li><strong>Gross amount: &#8211; <\/strong>document total + total tax field details of the same batch<\/li>\n<li><strong>Tax amount: &#8211;<\/strong> tax amount field details of the same batch<\/li>\n<li><strong>Net amount: &#8211;<\/strong> Gross amount- Tax amount details of the same batch<\/li>\n<\/ul>\n<p><span style=\"font-size: Medium;\"><strong>About Us<\/strong><\/span><br \/>\nGreytrix 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><a href=\"http:\/\/www.greytrix.com\/\">Greytrix<\/a>\u00a0has unique solutions of\u00a0<a href=\"http:\/\/www.greytrix.com\/product\/sage-crm\/gumu-sage-300-erp-integration\">Sage 300 integration with Sage CRM,<\/a>\u00a0<a href=\"http:\/\/www.greytrix.com\/product\/sage-300-erp\/gumu-300-salesforce-integration\">Salesforce.com\u00a0<\/a>and\u00a0<a href=\"http:\/\/www.greytrix.com\/product\/sage-300-erp\/ecommerce-magento-integration\">Magento eCommerce<\/a>. We have the migration expertise of Sage 300 Migration from <a href=\"https:\/\/www.greytrix.com\/Greytrixpdf\/sage-erp-crm-integration-and-migration.pdf\">Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works<\/a>. We work on the latest Sage 300c technologies and offer best-in-class\u00a0<a href=\"http:\/\/www.greytrix.com\/product\/erp-development\/sage-300-erp-development\">Sage 300 | Sage 300c customization and development services<\/a>.\u00a0 This include upgrading old codes, creating new web screens, delivering new reporting tools like Sage Intelligence, PowerBI and SAP BO to Sage business partners, end users and Sage PSG worldwide.<\/p>\n<p>For more details on Sage 300 | Sage 300c Services, please contact us at\u00a0<a href=\"mailto:accpac@greytrix.com\">accpac@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Vendor Transactions report lists transactions that were posted to vendor accounts during the period you specify when you print the report. You can sort the transactions by document date, by document number, or by fiscal year and period. The number of days that the transaction is overdue on the date you print the report.\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/01\/vendor-transaction-report\/\">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":[2],"tags":[963,2225,2880,2982,3018],"class_list":["post-19304","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-fields","tag-report","tag-transaction","tag-vendor","tag-vendor-transaction-report"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>The report on vendor transactions.<\/title>\n<meta name=\"description\" content=\"Explore the Vendor Transactions report, which lists posted transactions within your specified period.\" \/>\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\/2018\/06\/01\/vendor-transaction-report\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The report on vendor transactions.\" \/>\n<meta property=\"og:description\" content=\"Explore the Vendor Transactions report, which lists posted transactions within your specified period.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/01\/vendor-transaction-report\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-01T06:10:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-24T05:59:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/06\/1.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=\"3 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\/2018\/06\/01\/vendor-transaction-report\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/01\/vendor-transaction-report\/\",\"name\":\"The report on vendor transactions.\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/01\/vendor-transaction-report\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/01\/vendor-transaction-report\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/06\/1.png\",\"datePublished\":\"2018-06-01T06:10:19+00:00\",\"dateModified\":\"2024-04-24T05:59:15+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"description\":\"Explore the Vendor Transactions report, which lists posted transactions within your specified period.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/01\/vendor-transaction-report\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/01\/vendor-transaction-report\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/01\/vendor-transaction-report\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/06\/1.png\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/06\/1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/01\/vendor-transaction-report\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vendor Transaction Report\"}]},{\"@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":"The report on vendor transactions.","description":"Explore the Vendor Transactions report, which lists posted transactions within your specified period.","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\/2018\/06\/01\/vendor-transaction-report\/","og_locale":"en_US","og_type":"article","og_title":"The report on vendor transactions.","og_description":"Explore the Vendor Transactions report, which lists posted transactions within your specified period.","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/01\/vendor-transaction-report\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2018-06-01T06:10:19+00:00","article_modified_time":"2024-04-24T05:59:15+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/06\/1.png","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/01\/vendor-transaction-report\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/01\/vendor-transaction-report\/","name":"The report on vendor transactions.","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/01\/vendor-transaction-report\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/01\/vendor-transaction-report\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/06\/1.png","datePublished":"2018-06-01T06:10:19+00:00","dateModified":"2024-04-24T05:59:15+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"description":"Explore the Vendor Transactions report, which lists posted transactions within your specified period.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/01\/vendor-transaction-report\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/01\/vendor-transaction-report\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/01\/vendor-transaction-report\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/06\/1.png","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/06\/1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/06\/01\/vendor-transaction-report\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Vendor Transaction Report"}]},{"@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\/19304","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=19304"}],"version-history":[{"count":2,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/19304\/revisions"}],"predecessor-version":[{"id":34129,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/19304\/revisions\/34129"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=19304"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=19304"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=19304"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}