{"id":3495,"date":"2013-07-29T12:11:16","date_gmt":"2013-07-29T12:11:16","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=3495"},"modified":"2025-07-23T06:28:59","modified_gmt":"2025-07-23T06:28:59","slug":"invoice-retention-in-sage-300-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/07\/29\/invoice-retention-in-sage-300-erp\/","title":{"rendered":"Invoice Retention in Sage 300 ERP"},"content":{"rendered":"

Many a time customer withholds payment for part of an invoice until certain terms are met with the organization working on a project. Customer may retain amount until the project is completed, or until the project reaches a specified stage of completion.
\nSage 300 ERP allow us to setup these settings in the system, so that working with this type of invoices becomes easy and efficient.
\nBelow steps demonstrate how to set customer for retention Invoices.
\n1. Setting at Master Level:<\/b><\/p>\n

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

To set-up any customer for retain age payment, firstly we need to define some fields in customer master as mentioned below,<\/p>\n

a) Retainage %:<\/i><\/b> We have to define, what % of total invoice amount the customer is retaining with him. For Instance,<\/b> Suppose Invoice total is 10,000$ and Customer is retaining 2,000$ with him that makes 20% of total invoice. Here we will define 20%.
\nb) Retention Period<\/i><\/b>:<\/i> Here we need to define the number of days after which fresh invoice of retained amount to be send to the customer. Say for an instance; System will create a fresh invoice of amount 2000 $ after 60 days from invoice date.
\nc) Retainage Terms<\/i><\/b>: Here define due term of fresh invoice.<\/p>\n

Also Read:<\/strong><\/span>\u00a0Profit Margin Analysis in Sage 300 ERP<\/a><\/em>
\n2. Setting at Entry Level:<\/b><\/p>\n

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

To apply retainage functionality to a particular entry we need to check two check boxes at header level named as Job related<\/b> and Retainage<\/b> in order tab of order entry
\nAs we click Retainage check-box a new tab \u201cRetainage\u201d would appear.<\/p>\n

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

3. Create Retainage Batch:<\/b>
\nWe will find \u201cCreate Retainage batch\u201d option in Account Receivable >>A\/R Periodic Processing
\nWhen we run this utility a retainage invoice will automatically get created, provided that particular customer has exceeded his Retention Period.
\nRetainage invoice will be of amount the customer has retained.
\n4. Aged Retainage Report<\/b>
\nNavigate to Account Receivable >>A\/R Transaction Reports >>Aged Retainage, to print Retainage Report.<\/p>\n

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

The Aged Retainage Report form lets you print reports of outstanding retainage amounts, including retainage that is overdue and retainage that is due in future.
\nHence, if you follow these procedures retention invoices can be handle very efficiently in the Sage 300 ERP.
\nRelated Posts:<\/strong><\/p>\n

1.<\/strong>\u00a0Account Receivable Transaction Reports in Sage 300 ERP<\/a>
\n2.<\/strong>\u00a0Customer Transaction and Aged Trial Balance Report in Sage 300 ERP<\/a>
\n3.<\/strong>\u00a0Print Customer Statements in Sage 300 ERP<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Many a time customer withholds payment for part of an invoice until certain terms are met with the organization working on a project. Customer may retain amount until the project is completed, or until the project reaches a specified stage of completion. Sage 300 ERP allow us to setup these settings in the system, so\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":[2266,2268,2357,2451],"class_list":["post-3495","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-retainage-customer","tag-retention-invoices","tag-sage-300-erp","tag-sage-accpac-erp"],"yoast_head":"\nInvoice Retention in Sage 300 ERP<\/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\/2013\/07\/29\/invoice-retention-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=\"Invoice Retention in Sage 300 ERP\" \/>\n<meta property=\"og:description\" content=\"Many a time customer withholds payment for part of an invoice until certain terms are met with the organization working on a project. Customer may retain amount until the project is completed, or until the project reaches a specified stage of completion. Sage 300 ERP allow us to setup these settings in the system, so\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/07\/29\/invoice-retention-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=\"2013-07-29T12:11:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-23T06:28:59+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/07\/1.-AR-Customers.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\/2013\/07\/29\/invoice-retention-in-sage-300-erp\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/07\/29\/invoice-retention-in-sage-300-erp\/\",\"name\":\"Invoice Retention in Sage 300 ERP\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/07\/29\/invoice-retention-in-sage-300-erp\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/07\/29\/invoice-retention-in-sage-300-erp\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/07\/1.-AR-Customers.png\",\"datePublished\":\"2013-07-29T12:11:16+00:00\",\"dateModified\":\"2025-07-23T06:28:59+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/07\/29\/invoice-retention-in-sage-300-erp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/07\/29\/invoice-retention-in-sage-300-erp\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/07\/29\/invoice-retention-in-sage-300-erp\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/07\/1.-AR-Customers.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/07\/1.-AR-Customers.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/07\/29\/invoice-retention-in-sage-300-erp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Invoice Retention 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":"Invoice Retention in Sage 300 ERP","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\/2013\/07\/29\/invoice-retention-in-sage-300-erp\/","og_locale":"en_US","og_type":"article","og_title":"Invoice Retention in Sage 300 ERP","og_description":"Many a time customer withholds payment for part of an invoice until certain terms are met with the organization working on a project. Customer may retain amount until the project is completed, or until the project reaches a specified stage of completion. Sage 300 ERP allow us to setup these settings in the system, so\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/07\/29\/invoice-retention-in-sage-300-erp\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2013-07-29T12:11:16+00:00","article_modified_time":"2025-07-23T06:28:59+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/07\/1.-AR-Customers.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\/2013\/07\/29\/invoice-retention-in-sage-300-erp\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/07\/29\/invoice-retention-in-sage-300-erp\/","name":"Invoice Retention in Sage 300 ERP","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/07\/29\/invoice-retention-in-sage-300-erp\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/07\/29\/invoice-retention-in-sage-300-erp\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/07\/1.-AR-Customers.png","datePublished":"2013-07-29T12:11:16+00:00","dateModified":"2025-07-23T06:28:59+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/07\/29\/invoice-retention-in-sage-300-erp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/07\/29\/invoice-retention-in-sage-300-erp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/07\/29\/invoice-retention-in-sage-300-erp\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/07\/1.-AR-Customers.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/07\/1.-AR-Customers.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/07\/29\/invoice-retention-in-sage-300-erp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Invoice Retention 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\/3495","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=3495"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/3495\/revisions"}],"predecessor-version":[{"id":35496,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/3495\/revisions\/35496"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=3495"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=3495"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=3495"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}