{"id":12779,"date":"2015-10-08T08:27:50","date_gmt":"2015-10-08T08:27:50","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=12779"},"modified":"2015-10-08T08:27:50","modified_gmt":"2015-10-08T08:27:50","slug":"auto-retention-amount-configuration-in-sage-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/10\/08\/auto-retention-amount-configuration-in-sage-erp\/","title":{"rendered":"Auto Retention Amount Configuration in Sage ERP"},"content":{"rendered":"<p>In <a href=\"http:\/\/www.sagesoftware.co.in\/product-sage-300-erp\" target=\"_blank\" rel=\"noopener\">SAGE 300<\/a>, a very useful feature helps in identifying the available retention money deduction at the time of AP Invoice. Most of the organizations practice that they book \/ deduct retention money from vendor invoice, which is refunded later on to vendor. <a href=\"http:\/\/www.sagesoftware.co.in\/product-sage-300-erp\" target=\"_blank\" rel=\"noopener\">In SAGE 300, this same function can be done easily.<\/a><br \/>\nYou can maintain retention percentage (%), Retention Period and Retention Term \u201cVendor\u201d wise separately and the system will auto deduct retention money at the time of vendor bill booking. First of all you have to mention retention percentage, period and term in Vendor master in Invoicing Tab.<br \/>\n<em><strong>New Stuff:\u00a0<\/strong><\/em><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/10\/08\/item-serial-registration\/\" target=\"_blank\">Item Serial Registration<\/a><br \/>\nSuppose you have a vendor and want to deduct the retention amount from each invoice or random invoice at the rate of 10%. Then you have to mention the retention % in vendor master as shown in the above screen.<br \/>\nNow you can book an invoice of a vendor, if the amount of an invoice is INR 5000\/-, then system will auto deduct retention amount from the AP Invoice INR 500\/- (Retention Amount @ 10% as defined in vendor master) and actual vendor account will be affected by INR 4500\/-. Please refer below screen shot.<br \/>\n<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/10\/15.png\" target=\"_blank\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-12780 size-full\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/10\/15.png\" alt=\"1\" width=\"712\" height=\"405\" \/><\/a><br \/>\nWhen you will post the invoice, then its GL effects will be such as<br \/>\nExpense A\/c\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5000 Dr.<br \/>\nVendor Control A\/C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4500 Cr.<br \/>\nRetention A\/c\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0500 Cr. <strong>(Mapped Ledger in Account Set)<\/strong><br \/>\nWhen you will try to release payment of that particular vendor against that particular Invoice, then system will show only INR 4500\/- due not INR 5000\/- because INR 500\/- adjusted with Retention A\/c as explained above. Please refer below screen shot.<br \/>\n<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/10\/16.png\" target=\"_blank\"><img decoding=\"async\" class=\"aligncenter wp-image-12781 size-full\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/10\/16.png\" alt=\"1\" width=\"627\" height=\"468\" \/><\/a><br \/>\nLater on you can generate \/ create a retention invoice against the same AP Invoice (890 as showing in above screen) for INR 500\/- when you have to release the remaining amount to vendor. Please refer below screen shot<br \/>\n<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/10\/17.png\" target=\"_blank\"><img decoding=\"async\" class=\"aligncenter wp-image-12782 size-full\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/10\/17.png\" alt=\"1\" width=\"627\" height=\"469\" \/><\/a><br \/>\nWhen you will post the retention invoice, then system will post the accounts such as<br \/>\nVendor Control A\/c\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 500 \u00a0Cr.<br \/>\nRetention A\/c\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 500 Dr.<br \/>\nWhen you will try to release the payment to that particular vendor, then retention Invoice of INR 500 will also be shown in the list and you can release the payment against that invoice as well.<br \/>\nHere you have seen that after mapping few masters, system take care all about the retention money control over AP Invoices.<br \/>\n<strong>Also Read:<\/strong><br \/>\n1.\u00a0<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/06\/11\/retainage-accounting\/\" target=\"_blank\">Retainage Accounting<\/a><br \/>\n2.\u00a0<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/01\/12\/allow-non-inventory-item-option-in-po\/\" target=\"_blank\">Allow Non Inventory Item Option in PO<\/a><br \/>\n3.\u00a0<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/01\/07\/allow-fractional-quantities-in-purchase-order\/\" target=\"_blank\">Allow Fractional Quantities in Purchase Order<\/a><br \/>\n4.\u00a0<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/10\/31\/allow-edit-of-system-generated-batches\/\" target=\"_blank\">Allow edit of System generated batches<\/a><br \/>\n5. \u00a0<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/10\/30\/allow-adjustments-in-payment-batches\/\" target=\"_blank\">Allow Adjustments in Payment batches<\/a><br \/>\n&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In SAGE 300, a very useful feature helps in identifying the available retention money deduction at the time of AP Invoice. Most of the organizations practice that they book \/ deduct retention money from vendor invoice, which is refunded later on to vendor. In SAGE 300, this same function can be done easily. You can\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/10\/08\/auto-retention-amount-configuration-in-sage-erp\/\">Read More &raquo;<\/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":[],"class_list":["post-12779","post","type-post","status-publish","format-standard","hentry","category-sage-accpac"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Auto Retention Amount Configuration in Sage 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\/2015\/10\/08\/auto-retention-amount-configuration-in-sage-erp\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Auto Retention Amount Configuration in Sage ERP - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"In SAGE 300, a very useful feature helps in identifying the available retention money deduction at the time of AP Invoice. Most of the organizations practice that they book \/ deduct retention money from vendor invoice, which is refunded later on to vendor. In SAGE 300, this same function can be done easily. You can\u2026 Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/10\/08\/auto-retention-amount-configuration-in-sage-erp\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2015-10-08T08:27:50+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/10\/15.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\/2015\/10\/08\/auto-retention-amount-configuration-in-sage-erp\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/10\/08\/auto-retention-amount-configuration-in-sage-erp\/\",\"name\":\"Auto Retention Amount Configuration in Sage 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\/2015\/10\/08\/auto-retention-amount-configuration-in-sage-erp\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/10\/08\/auto-retention-amount-configuration-in-sage-erp\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/10\/15.png\",\"datePublished\":\"2015-10-08T08:27:50+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/10\/08\/auto-retention-amount-configuration-in-sage-erp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/10\/08\/auto-retention-amount-configuration-in-sage-erp\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/10\/08\/auto-retention-amount-configuration-in-sage-erp\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/10\/15.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/10\/15.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/10\/08\/auto-retention-amount-configuration-in-sage-erp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Auto Retention Amount Configuration in Sage 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":"Auto Retention Amount Configuration in Sage 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\/2015\/10\/08\/auto-retention-amount-configuration-in-sage-erp\/","og_locale":"en_US","og_type":"article","og_title":"Auto Retention Amount Configuration in Sage ERP - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"In SAGE 300, a very useful feature helps in identifying the available retention money deduction at the time of AP Invoice. Most of the organizations practice that they book \/ deduct retention money from vendor invoice, which is refunded later on to vendor. In SAGE 300, this same function can be done easily. You can\u2026 Read More &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/10\/08\/auto-retention-amount-configuration-in-sage-erp\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2015-10-08T08:27:50+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/10\/15.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\/2015\/10\/08\/auto-retention-amount-configuration-in-sage-erp\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/10\/08\/auto-retention-amount-configuration-in-sage-erp\/","name":"Auto Retention Amount Configuration in Sage 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\/2015\/10\/08\/auto-retention-amount-configuration-in-sage-erp\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/10\/08\/auto-retention-amount-configuration-in-sage-erp\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/10\/15.png","datePublished":"2015-10-08T08:27:50+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/10\/08\/auto-retention-amount-configuration-in-sage-erp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/10\/08\/auto-retention-amount-configuration-in-sage-erp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/10\/08\/auto-retention-amount-configuration-in-sage-erp\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/10\/15.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/10\/15.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/10\/08\/auto-retention-amount-configuration-in-sage-erp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Auto Retention Amount Configuration in Sage 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\/12779","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=12779"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/12779\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=12779"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=12779"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=12779"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}