{"id":7861,"date":"2014-06-21T11:05:24","date_gmt":"2014-06-21T11:05:24","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=7861"},"modified":"2014-06-21T11:05:24","modified_gmt":"2014-06-21T11:05:24","slug":"how-to-set-fixed-discount-date-in-invoices","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/21\/how-to-set-fixed-discount-date-in-invoices\/","title":{"rendered":"How to set fixed Discount Date in Invoices"},"content":{"rendered":"<p style=\"text-align: justify\">In our last blog, we had discussed <a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/03\/29\/fixed-due-date-for-invoices-in-sage-300-erp\/\" target=\"_blank\">Due date table <\/a>feature for Terms in Sage 300 ERP where we have discussed how to define the fix due date for transactions in Account receivable.<\/p>\n<p style=\"text-align: justify\">Moving further on this topic for Terms code setup, we will now discuss about another feature in the Terms setup in Account Receivable module. We will see how to define the fixed discount date for transactions in Account receivable.<\/p>\n<p style=\"text-align: justify\"><strong><span style=\"color: #800000\">The New Stuff :<\/span><\/strong>\u00a0<a title=\"Sage 300 ERP Pending Payment Follow-ups through SageCRM\" href=\"http:\/\/bit.ly\/1kA5T1H\" target=\"_blank\" rel=\"noopener\">Sage 300 ERP Pending Payment Follow-ups through SageCRM<\/a><\/p>\n<p style=\"text-align: justify\">There are scenarios where a user needs to set up the discount date to a fixed date of the month based on the specific range of date in which the invoice is generated in Sage 300 for a particular Term Code.<\/p>\n<p style=\"text-align: justify\">Let\u2019s take an example:<\/p>\n<p style=\"text-align: justify\">1.\u00a0 If the invoice is created within 1st to 10th day of the month then standard discount dates should be the\u00a014th of the month<br \/>\n2. If invoice is created within the 11th to 20th then standard discount dates should be 21st of the month<\/p>\n<p style=\"text-align: justify\">Sage 300 has provided option in Discount Type \u201cDiscount Date Table\u201d which is used when user needs to set the fixed Discount date for invoices based on specific date range. Refer the below screenshot:<\/p>\n<p style=\"text-align: justify\">1. While setting the Term code; Discount Type\u201d As \u201cDiscount Date Table\u201d.<\/p>\n<p style=\"text-align: justify\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/06\/11.jpg\" target=\"_blank\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter  wp-image-7899\" alt=\"1\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/06\/11.jpg\" width=\"684\" height=\"406\" \/><\/a><br \/>\n2. \u201cDue Date Type\u201d can be set to any type.<\/p>\n<p style=\"text-align: center\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/06\/31.jpg\" target=\"_blank\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-7900\" alt=\"3\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/06\/31.jpg\" width=\"760\" height=\"451\" \/><\/a><\/p>\n<p>3. In above screen you can specify the below fields :<br \/>\n<strong>a. Range:<\/strong> &#8211; You can specify the number of tier for the month according to the starting and Ending Days.<br \/>\nb. Starting and \u201cEnding\u201d day.<br \/>\n<strong>c. Day of Month: &#8211;<\/strong> Day on which you need to set the due date of the invoice.<br \/>\n<strong>d. Add Months:<\/strong> With Add months you can add the number of months in the due date which can be set to number of days plus the number\u00a0 of months from the range of invoice date.<br \/>\n4. For e.g. With above setting when user generates an invoice on the date \u201c<strong>1st June 2014<\/strong>\u201d, and selects the terms code as \u201c<strong>DUETBL<\/strong>\u201d, then the Discount date will be set as \u201c<strong>14th June 2014\u2019<\/strong>.\u00a0 For any date within the range of 1st to 10th of the month the discount date of the invoice will be fixed as to \u201c<strong>14th<\/strong>\u201d of the next month. Refer the below screenshot:<\/p>\n<p style=\"text-align: center\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/06\/21.jpg\" target=\"_blank\"><img decoding=\"async\" class=\"aligncenter  wp-image-7901\" alt=\"2\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/06\/21.jpg\" width=\"706\" height=\"533\" \/><\/a><\/p>\n<p style=\"text-align: justify\">Hence with discount date table in Terms code, one can set Discount date to a fixed date when invoice is generated in Sage 300 ERP.<\/p>\n<p style=\"text-align: justify\"><strong>Also Read:<\/strong><br \/>\n1. <a title=\"Invoice Action Report\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/28\/invoice-action-report\/\" target=\"_blank\">Invoice Action Report<\/a><br \/>\n2. <a title=\"Create Invoice directly from Shipment Entry\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/26\/create-invoice-directly-from-shipment-entry\/\" target=\"_blank\">Create Invoice Directly From Shipment<\/a><br \/>\n3. <a title=\"Sales Invoice Reversals in Sage 300 ERP\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/12\/26\/sales-invoice-reversals-in-sage-300-erp\/\" target=\"_blank\">Sales Invoice Reversal In Sage 300 ERP<\/a><br \/>\n4. <a title=\"Bulk Invoicing Feature for Sage 300 ERP\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/31\/bulk-invoicing-feature-for-sage-300-erp\/\" target=\"_blank\">Bulk Invoicing Feature In Sage 300 ERP<\/a><br \/>\n5. <a title=\"Create Single Invoice Entry from Multiple Shipment Entry in Sage 300 ERP\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/25\/create-single-invoice-entry-from-multiple-shipment-entry-in-sage-300-erp\/\" target=\"_blank\">Create Single Invoice Entry from Multiple Shipment Entry in Sage 300 ERP<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In our last blog, we had discussed Due date table feature for Terms in Sage 300 ERP where we have discussed how to define the fix due date for transactions in Account receivable. Moving further on this topic for Terms code setup, we will now discuss about another feature in the Terms setup in Account\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/21\/how-to-set-fixed-discount-date-in-invoices\/\">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":[60,246,787,788,998,2357,2850],"class_list":["post-7861","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-account-receivable","tag-ar-invoice-entry","tag-discount-date","tag-discount-date-table","tag-fixed-discount-dates","tag-sage-300-erp","tag-terms-code"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to set fixed Discount Date in Invoices - 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\/2014\/06\/21\/how-to-set-fixed-discount-date-in-invoices\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to set fixed Discount Date in Invoices - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"In our last blog, we had discussed Due date table feature for Terms in Sage 300 ERP where we have discussed how to define the fix due date for transactions in Account receivable. Moving further on this topic for Terms code setup, we will now discuss about another feature in the Terms setup in Account\u2026 Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/21\/how-to-set-fixed-discount-date-in-invoices\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2014-06-21T11:05:24+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/06\/11.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\/2014\/06\/21\/how-to-set-fixed-discount-date-in-invoices\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/21\/how-to-set-fixed-discount-date-in-invoices\/\",\"name\":\"How to set fixed Discount Date in Invoices - 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\/2014\/06\/21\/how-to-set-fixed-discount-date-in-invoices\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/21\/how-to-set-fixed-discount-date-in-invoices\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/06\/11.jpg\",\"datePublished\":\"2014-06-21T11:05:24+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/21\/how-to-set-fixed-discount-date-in-invoices\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/21\/how-to-set-fixed-discount-date-in-invoices\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/21\/how-to-set-fixed-discount-date-in-invoices\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/06\/11.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/06\/11.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/21\/how-to-set-fixed-discount-date-in-invoices\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to set fixed Discount Date in Invoices\"}]},{\"@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":"How to set fixed Discount Date in Invoices - 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\/2014\/06\/21\/how-to-set-fixed-discount-date-in-invoices\/","og_locale":"en_US","og_type":"article","og_title":"How to set fixed Discount Date in Invoices - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"In our last blog, we had discussed Due date table feature for Terms in Sage 300 ERP where we have discussed how to define the fix due date for transactions in Account receivable. Moving further on this topic for Terms code setup, we will now discuss about another feature in the Terms setup in Account\u2026 Read More &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/21\/how-to-set-fixed-discount-date-in-invoices\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2014-06-21T11:05:24+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/06\/11.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\/2014\/06\/21\/how-to-set-fixed-discount-date-in-invoices\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/21\/how-to-set-fixed-discount-date-in-invoices\/","name":"How to set fixed Discount Date in Invoices - 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\/2014\/06\/21\/how-to-set-fixed-discount-date-in-invoices\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/21\/how-to-set-fixed-discount-date-in-invoices\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/06\/11.jpg","datePublished":"2014-06-21T11:05:24+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/21\/how-to-set-fixed-discount-date-in-invoices\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/21\/how-to-set-fixed-discount-date-in-invoices\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/21\/how-to-set-fixed-discount-date-in-invoices\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/06\/11.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/06\/11.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/06\/21\/how-to-set-fixed-discount-date-in-invoices\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"How to set fixed Discount Date in Invoices"}]},{"@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\/7861","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=7861"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/7861\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=7861"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=7861"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=7861"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}