{"id":12454,"date":"2015-08-30T07:01:50","date_gmt":"2015-08-30T07:01:50","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=12454"},"modified":"2025-11-07T12:38:11","modified_gmt":"2025-11-07T12:38:11","slug":"schedule-vi-reporting-in-sage-300","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/08\/30\/schedule-vi-reporting-in-sage-300\/","title":{"rendered":"Schedule VI Reporting in Sage 300"},"content":{"rendered":"\n

As per companies act 1956, every registered company shall prepare Balance sheet and Profit and loss statement as prescribed in Schedule VI of companies act. As per the Schedule VI balance sheet format all Assets and Liabilities of company should be projected into current and non-current classification.<\/p>\n\n\n\n

In traditional accounting system Accounts manager\/CFO are required to collect the data from single\/multiple general ledger source and spend unproductive hours to projection as per the format of schedule VI. In this exercise, it is a possibility of incongruity of financial figures and heading.<\/p>\n\n\n\n

New Stuff: Bulk Sales Orders and Purchase Orders Processing from Sage CRM to Sage 300<\/a><\/strong><\/em><\/p>\n\n\n

\n
\"\"<\/a>
 <\/figcaption><\/figure><\/div>\n\n\n

 Sage 300 provides Financial Reporting Tool to generate your     schedule VI format without investing unproductive hours of your     finance manager\/CFO. This dynamic reporting tools are available in General Ledger module of Sage 300. Financial Reporting tool is  nothing but a simple excel template in   which you can pick and     formulate the financial figures in form of functions.<\/style><\/p>\n\n\n\n

With the help of defined functions as per the requirement of Schedule VI format you can project both the years\u2019 data in an accurate manner without any error. Sage 300 projected data on the real time basis only.<\/p>\n\n\n\n

Concept of Financial Report.<\/strong><\/p>\n\n\n\n

    \n
  1. A Financial report is a spreadsheet containing Functions. Functions that read data directly from the general ledger.<\/li>\n\n\n\n
  2. You can also use any other spreadsheet functions to further manipulate that data.<\/li>\n\n\n\n
  3. You can print the Actual and provisionally posted amount.<\/li>\n\n\n\n
  4. You can enter formulas that allow you to drilldown to associated transactions in the resulting report.<\/li>\n<\/ol>\n\n\n\n

     Column of Financial Report.<\/strong><\/p>\n\n\n\n

      \n
    1. A, B, C and D column are reserve for Control Information.<\/li>\n\n\n\n
    2. E onward for Data appearance.<\/li>\n<\/ol>\n\n\n\n

       <\/strong>Commands of Financial Report.<\/strong><\/p>\n\n\n\n

        \n
      1. FR View: Generates financial statements from report specifications.<\/li>\n\n\n\n
      2. FR Paste: Inserts Financial Reporter functions, account numbers, and selection criteria.<\/li>\n\n\n\n
      3. FR Clear: Clears a previously generated financial statement.<\/li>\n\n\n\n
      4. FR Options: Carry forward the opening budget<\/li>\n\n\n\n
      5. FR Drilldown: drilldown to associated transactions after you generate a financial statement.<\/li>\n<\/ol>\n\n\n\n

        Also Read:<\/em><\/strong>
        1) Include your Company Logo in Sage CRM Reports<\/a>
        2)         Get impressive reports by adjusting Report Styles in Sage CRM<\/a>
        3)         Generate Excel\/PDF reports on standard Sage CRM entities externally<\/a>
        4)         Set Schedule of Bulk Communication on Single Click<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

        As per companies act 1956, every registered company shall prepare Balance sheet and Profit and loss statement as prescribed in Schedule VI of companies act. As per the Schedule VI balance sheet format all Assets and Liabilities of company should be projected into current and non-current classification. In traditional accounting system Accounts manager\/CFO are required\u2026 Read More »<\/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":[],"class_list":["post-12454","post","type-post","status-publish","format-standard","hentry","category-sage-accpac"],"yoast_head":"\nSchedule VI Reporting in Sage 300 - 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\/08\/30\/schedule-vi-reporting-in-sage-300\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Schedule VI Reporting in Sage 300 - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"As per companies act 1956, every registered company shall prepare Balance sheet and Profit and loss statement as prescribed in Schedule VI of companies act. As per the Schedule VI balance sheet format all Assets and Liabilities of company should be projected into current and non-current classification. In traditional accounting system Accounts manager\/CFO are required\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/08\/30\/schedule-vi-reporting-in-sage-300\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2015-08-30T07:01:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-07T12:38:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/08\/close-up-business-team-using-digital-tablet-with-financial-d-300x200.jpg\" \/>\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\/2015\/08\/30\/schedule-vi-reporting-in-sage-300\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/08\/30\/schedule-vi-reporting-in-sage-300\/\",\"name\":\"Schedule VI Reporting in Sage 300 - 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\/08\/30\/schedule-vi-reporting-in-sage-300\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/08\/30\/schedule-vi-reporting-in-sage-300\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/08\/close-up-business-team-using-digital-tablet-with-financial-d-300x200.jpg\",\"datePublished\":\"2015-08-30T07:01:50+00:00\",\"dateModified\":\"2025-11-07T12:38:11+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/08\/30\/schedule-vi-reporting-in-sage-300\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/08\/30\/schedule-vi-reporting-in-sage-300\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/08\/30\/schedule-vi-reporting-in-sage-300\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/08\/close-up-business-team-using-digital-tablet-with-financial-d-scaled.jpg\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/08\/close-up-business-team-using-digital-tablet-with-financial-d-scaled.jpg\",\"width\":2560,\"height\":1707,\"caption\":\"Close-up of business team using digital tablet with financial diagram\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/08\/30\/schedule-vi-reporting-in-sage-300\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Schedule VI Reporting in Sage 300\"}]},{\"@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":"Schedule VI Reporting in Sage 300 - 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\/08\/30\/schedule-vi-reporting-in-sage-300\/","og_locale":"en_US","og_type":"article","og_title":"Schedule VI Reporting in Sage 300 - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"As per companies act 1956, every registered company shall prepare Balance sheet and Profit and loss statement as prescribed in Schedule VI of companies act. As per the Schedule VI balance sheet format all Assets and Liabilities of company should be projected into current and non-current classification. In traditional accounting system Accounts manager\/CFO are required\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/08\/30\/schedule-vi-reporting-in-sage-300\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2015-08-30T07:01:50+00:00","article_modified_time":"2025-11-07T12:38:11+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/08\/close-up-business-team-using-digital-tablet-with-financial-d-300x200.jpg","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\/2015\/08\/30\/schedule-vi-reporting-in-sage-300\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/08\/30\/schedule-vi-reporting-in-sage-300\/","name":"Schedule VI Reporting in Sage 300 - 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\/08\/30\/schedule-vi-reporting-in-sage-300\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/08\/30\/schedule-vi-reporting-in-sage-300\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/08\/close-up-business-team-using-digital-tablet-with-financial-d-300x200.jpg","datePublished":"2015-08-30T07:01:50+00:00","dateModified":"2025-11-07T12:38:11+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/08\/30\/schedule-vi-reporting-in-sage-300\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/08\/30\/schedule-vi-reporting-in-sage-300\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/08\/30\/schedule-vi-reporting-in-sage-300\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/08\/close-up-business-team-using-digital-tablet-with-financial-d-scaled.jpg","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/08\/close-up-business-team-using-digital-tablet-with-financial-d-scaled.jpg","width":2560,"height":1707,"caption":"Close-up of business team using digital tablet with financial diagram"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/08\/30\/schedule-vi-reporting-in-sage-300\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Schedule VI Reporting in Sage 300"}]},{"@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\/12454","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=12454"}],"version-history":[{"count":8,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/12454\/revisions"}],"predecessor-version":[{"id":36536,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/12454\/revisions\/36536"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=12454"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=12454"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=12454"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}