{"id":13310,"date":"2016-01-29T06:15:48","date_gmt":"2016-01-29T06:15:48","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=13310"},"modified":"2016-01-29T06:15:48","modified_gmt":"2016-01-29T06:15:48","slug":"vendor-outstanding-report-by-optional-field-value-in-sage-300-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2016\/01\/29\/vendor-outstanding-report-by-optional-field-value-in-sage-300-erp\/","title":{"rendered":"Vendor Outstanding Report by Optional Field Value in Sage 300 ERP"},"content":{"rendered":"

Optional Field is one of the best features in Sage 300<\/a> to capture various information at any level. It means we can link the Optional Fields at Masters as well as Transaction Level though the optional Field cannot be linked to the Bank Services (For Masters as well as Transactions).<\/p>\n

By using this feature we can generate many reports without any additional efforts. In previous blog we understood how to generate Customer Outstanding Report by using Optional Field value. Going further, in this blog we will check how we can generate Vendor Outstanding Report by Optional field value.<\/p>\n

New Stuff:\u00a0<\/em><\/strong>Account Roll Feature<\/a><\/p>\n

We have to map the required Optional Field to each Vendor at Master Level. After posting all transactional Batches successfully, we are in the position of generating report with Optional field without any extra efforts.<\/p>\n

For using this functionality follow the below steps:<\/p>\n

1) Creation of Optional Field.<\/p>\n

2)\u00a0Link Optional field to Account Payable (Vendor) Masters and Transactions as per your requirement.<\/p>\n

3)\u00a0All transactions should be posted successfully before printing Vendor Outstanding Report.<\/p>\n

\n

Prefer below detail process with screen shots to execute this operation successfully.<\/p>\n

1) Creation of Optional field :<\/p>\n

\n

Path: Common Services: Optional Field<\/strong><\/p>\n

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

Here we are defining Optional Field.<\/p>\n

2) Linking of Optional Field to Accounts Payable Masters :<\/p>\n

Path: Accounts Payable -> A\/P Setup -> Optional Field.<\/strong><\/p>\n

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

Here we can link Optional Field to the specific Transaction \/ Master.<\/p>\n

3) Linking of Optional Field value at Vendor Master :<\/p>\n

Path: Accounts Payable -> A\/P Vendor -> Vendor.<\/strong><\/p>\n

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

\n

Here we can create \/ update Vendor details. In Optional Field Tab we are updating Optional Field Value. It\u2019s treated as Master. At any time we can change this Value.<\/p>\n

4) Customer Outstanding Report :<\/p>\n

Path: Accounts Payable -> A\/P Transaction Reports -> Vendor Transactions.<\/strong><\/p>\n

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

Here we generate Vendor Outstanding Report by selecting appropriate options.<\/p>\n

Sample Report:<\/p>\n

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

Same feature will applicable for Accounts Receivable (Customer Master) to generate Customer Outstanding Report.<\/p>\n

Also Read:-<\/em><\/strong>
\n1\u00a0Retainage Accounting<\/a><\/p>\n

2\u00a0Cleanup Accounts Using Apply Document Feature in sage 300 ERP<\/a><\/p>\n

3\u00a0Email BOL reports to specified persons in Sage 300 ERP<\/a><\/p>\n

4\u00a0Dunning Messages<\/a><\/p>\n

5\u00a0AP Vendor Ledger Report for Sage 300 ERP<\/a><\/p>\n

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

Optional Field is one of the best features in Sage 300 to capture various information at any level. It means we can link the Optional Fields at Masters as well as Transaction Level though the optional Field cannot be linked to the Bank Services (For Masters as well as Transactions). By using this feature we\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":[2311,2357,3010],"class_list":["post-13310","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-sage","tag-sage-300-erp","tag-vendor-outstanding-report"],"yoast_head":"\nVendor Outstanding Report by Optional Field Value in Sage 300 ERP - 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\/2016\/01\/29\/vendor-outstanding-report-by-optional-field-value-in-sage-300-erp\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Vendor Outstanding Report by Optional Field Value in Sage 300 ERP - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Optional Field is one of the best features in Sage 300 to capture various information at any level. It means we can link the Optional Fields at Masters as well as Transaction Level though the optional Field cannot be linked to the Bank Services (For Masters as well as Transactions). By using this feature we\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2016\/01\/29\/vendor-outstanding-report-by-optional-field-value-in-sage-300-erp\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2016-01-29T06:15:48+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2016\/01\/aaaaaaaaaaaaaaaaaaaaaaaaa.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=\"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\/2016\/01\/29\/vendor-outstanding-report-by-optional-field-value-in-sage-300-erp\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2016\/01\/29\/vendor-outstanding-report-by-optional-field-value-in-sage-300-erp\/\",\"name\":\"Vendor Outstanding Report by Optional Field Value in Sage 300 ERP - 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\/2016\/01\/29\/vendor-outstanding-report-by-optional-field-value-in-sage-300-erp\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2016\/01\/29\/vendor-outstanding-report-by-optional-field-value-in-sage-300-erp\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2016\/01\/aaaaaaaaaaaaaaaaaaaaaaaaa.png\",\"datePublished\":\"2016-01-29T06:15:48+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2016\/01\/29\/vendor-outstanding-report-by-optional-field-value-in-sage-300-erp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2016\/01\/29\/vendor-outstanding-report-by-optional-field-value-in-sage-300-erp\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2016\/01\/29\/vendor-outstanding-report-by-optional-field-value-in-sage-300-erp\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2016\/01\/aaaaaaaaaaaaaaaaaaaaaaaaa.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2016\/01\/aaaaaaaaaaaaaaaaaaaaaaaaa.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2016\/01\/29\/vendor-outstanding-report-by-optional-field-value-in-sage-300-erp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vendor Outstanding Report by Optional Field Value in Sage 300 ERP\"}]},{\"@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":"Vendor Outstanding Report by Optional Field Value in Sage 300 ERP - 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\/2016\/01\/29\/vendor-outstanding-report-by-optional-field-value-in-sage-300-erp\/","og_locale":"en_US","og_type":"article","og_title":"Vendor Outstanding Report by Optional Field Value in Sage 300 ERP - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"Optional Field is one of the best features in Sage 300 to capture various information at any level. It means we can link the Optional Fields at Masters as well as Transaction Level though the optional Field cannot be linked to the Bank Services (For Masters as well as Transactions). By using this feature we\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2016\/01\/29\/vendor-outstanding-report-by-optional-field-value-in-sage-300-erp\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2016-01-29T06:15:48+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2016\/01\/aaaaaaaaaaaaaaaaaaaaaaaaa.png","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2016\/01\/29\/vendor-outstanding-report-by-optional-field-value-in-sage-300-erp\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2016\/01\/29\/vendor-outstanding-report-by-optional-field-value-in-sage-300-erp\/","name":"Vendor Outstanding Report by Optional Field Value in Sage 300 ERP - 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\/2016\/01\/29\/vendor-outstanding-report-by-optional-field-value-in-sage-300-erp\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2016\/01\/29\/vendor-outstanding-report-by-optional-field-value-in-sage-300-erp\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2016\/01\/aaaaaaaaaaaaaaaaaaaaaaaaa.png","datePublished":"2016-01-29T06:15:48+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2016\/01\/29\/vendor-outstanding-report-by-optional-field-value-in-sage-300-erp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2016\/01\/29\/vendor-outstanding-report-by-optional-field-value-in-sage-300-erp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2016\/01\/29\/vendor-outstanding-report-by-optional-field-value-in-sage-300-erp\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2016\/01\/aaaaaaaaaaaaaaaaaaaaaaaaa.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2016\/01\/aaaaaaaaaaaaaaaaaaaaaaaaa.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2016\/01\/29\/vendor-outstanding-report-by-optional-field-value-in-sage-300-erp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Vendor Outstanding Report by Optional Field Value in Sage 300 ERP"}]},{"@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\/13310","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=13310"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/13310\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=13310"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=13310"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=13310"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}