{"id":6936,"date":"2015-06-30T15:05:31","date_gmt":"2015-06-30T15:05:31","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagex3\/?p=6936"},"modified":"2018-11-22T10:23:03","modified_gmt":"2018-11-22T10:23:03","slug":"how-to-use-bp-net-settlement-in-sage-x3","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2015\/06\/30\/how-to-use-bp-net-settlement-in-sage-x3\/","title":{"rendered":"How to use \u2018BP net Settlement\u2019 in Sage X3?"},"content":{"rendered":"<p>Have you ever come across a scenario where a BP is having Invoices &amp; Credit memos open?<br \/>\n\u2018BP Net Settlement\u2019 is used to settle open items for BPs that are customers, suppliers, or both. Open items that are available for settlement include invoices, unapplied prepayments, credit memos, and debit memos for customers and suppliers.<\/p>\n<p><em><strong>New Stuff: <\/strong><\/em><a title=\"Services Where-used\" href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2015\/06\/30\/services-where-used\/\">Services Where-used<\/a><em><strong><br \/>\n<\/strong><\/em><\/p>\n<p>Navigate to AP-AR Accounting &gt; Open Items &gt; BP net settlement<\/p>\n<p><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2015\/06\/img1.jpg\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-6937\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2015\/06\/img1.jpg\" alt=\"img1\" width=\"623\" height=\"196\" \/><\/a><\/p>\n<p>Details grid: The open item results grid allows you to select the open items and the amount of the open item to net (if different from the total open amount). A Selection total frame is also available to track amounts that have been selected for settlement.<\/p>\n<p>The open items will appear based on the selection criteria order specified. If there are open items with duplicate sort criterion values (for example, mutiple items with same due date, source date, or transaction type), the secondary sort will be the combination of the internal number and due date number.<\/p>\n<p>Clicking Apply runs the automatic calculation logic and will calculate the net result of the marked open items. The netting result is calculated for each item selected.<\/p>\n<p>Net Settlement scenarios:<\/p>\n<ul>\n<li>Standard POS transaction (which contains only Sale line) will be posted in the X3. It will create the Sales Invoice in the X3 and its linked payments will be created.<\/li>\n<li>Net Zero Return\/Exchange POS Processing:<\/li>\n<\/ul>\n<p>For this type of fusion transaction, we will follow the below process in Sage X3<br \/>\n<strong>Step #1<\/strong>: Creation of sales invoice for Sales lines of amount 7500<br \/>\n<strong>Step #2<\/strong>: Creation of credit memo for return lines of amount 7500<br \/>\n<strong>Step #3<\/strong>: Matching the above-created Sales invoice &amp; Credit memo through BP net settlement function. This will match the invoices and no payments to be created. Refer to below screenshots.<\/p>\n<p><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2015\/06\/img2.jpg\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-6938\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2015\/06\/img2.jpg\" alt=\"img2\" width=\"623\" height=\"196\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2015\/06\/img3.jpg\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-6939\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2015\/06\/img3.jpg\" alt=\"img3\" width=\"505\" height=\"292\" \/><\/a><\/p>\n<ul>\n<li>Net Positive Return\/Exchange POS Transaction Processing<br \/>\nStep #1: Creation of sales invoice for Sales lines of amount 9000<br \/>\nStep #2: Creation of credit memo for return lines of amount 7500<br \/>\nStep #3: Matching the above created Sales invoice &amp; Credit memo through BP net settlement function. Creating the payment for remaining 1500 positive open balance. Refer to below screen shots.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2015\/06\/img4.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6940\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2015\/06\/img4.jpg\" alt=\"img4\" width=\"649\" height=\"189\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2015\/06\/img5.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6941\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2015\/06\/img5.jpg\" alt=\"img5\" width=\"556\" height=\"323\" \/><\/a><\/p>\n<ul>\n<li>Net Negative Return\/Exchange POS Transaction Processing<br \/>\nStep #1: Creation of sales invoice for Sales lines 4500<br \/>\nStep #2: Creation of credit memo for return lines 7500<br \/>\nStep #3: Matching the above created Sales invoice &amp; Credit memo through BP net settlement function. Creating the payment for remaining negative open balance -3000.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2015\/06\/img6.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6942\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2015\/06\/img6.jpg\" alt=\"img6\" width=\"647\" height=\"188\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2015\/06\/img7.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6943\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2015\/06\/img7.jpg\" alt=\"img7\" width=\"548\" height=\"319\" \/><\/a><\/p>\n<p><span style=\"font-size: Medium;\"><strong>About Us<\/strong><\/span><br \/>\n<a href=\"https:\/\/www.greytrix.com\/\">Greytrix<\/a> \u2013 a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.<\/p>\n<p><a href=\"https:\/\/www.greytrix.com\/\">Greytrix<\/a>\u00a0caters to a wide range of Sage Enterprise Management (Sage X3) offerings \u2013 a Sage Business Cloud Solution. Our\u00a0unique GUMU&#x2122; integrations include <a href=\"https:\/\/www.greytrix.com\/product\/sage-crm\/gumu-sage-x3-integration\">Sage Enterprise Management (Sage X3) for Sage CRM<\/a>,\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/sage-x3\/gumu-x3-salesforce-integration\">Salesforce.com<\/a> and\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/magento-sage-integrations\/sage-x3-magento\">Magento eCommerce<\/a>\u00a0along with Implementation and Technical Support worldwide for <a href=\"https:\/\/www.greytrix.com\/africa\/product\/consulting\/implementation-planning\">Sage Enterprise Management (Sage X3)<\/a>. Currently we are <a href=\"https:\/\/www.greytrix.com\/africa\">Sage Enterprise Management Implementation Partner<\/a> in East Africa, Middles East, Australia, Asia.\u00a0We also offer best-in-class\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/erp-development\/sage-x3\">Sage X3 customization and development services<\/a>,\u00a0integrated applications such as <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/pos-system\">POS<\/a> | <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/warehouse-management-system\">WMS<\/a> | <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/payment-gateway\">Payment Gateway<\/a> | <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/shipping-system\">Shipping System<\/a> | <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/business-intelligence\">Business Intelligence<\/a> | <a href=\"https:\/\/www.greytrix.com\/product\/sage-x3\/ecommerce-magento-integration\">eCommerce<\/a> and have developed add-ons such as <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-add-ons\/catch-weight\">Catch \u2013 Weight <\/a>\u00a0and <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-add-ons\/letter-of-credit\">Letter of Credit<\/a> for Sage Enterprise Management to Sage business partners, end users and Sage PSG worldwide.<\/p>\n<p>Greytrix is a recognized <a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/07\/26\/greytrix-on-boards-sage-global-rockstar-isv-program-with-gumu-for-sage-crm-sage-x3-solution\/\">Sage Rockstar ISV Partner<\/a> for GUMU&#x2122; Sage Enterprise Management \u2013 Sage CRM integration also listed on <a href=\"https:\/\/www.sage.com\/marketplace\/asb_ListingDetail?listingId=a1h24000007PC3aAAG\" target=\"_blank\" rel=\"noopener\">Sage Marketplace<\/a>; GUMU&#x2122; integration for Sage Enterprise Management \u2013 Salesforce is a 5-star app listed on <a href=\"https:\/\/appexchange.salesforce.com\/listingDetail?listingId=a0N30000000psM5EAI\" target=\"_blank\" rel=\"noopener\">Salesforce AppExchange<\/a>.<\/p>\n<p>For more information on Sage X3 Integration and Services, please contact us at\u00a0<a href=\"mailto:x3@greytrix.com\">x3@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Have you ever come across a scenario where a BP is having Invoices &amp; Credit memos open? \u2018BP Net Settlement\u2019 is used to settle open items for BPs that are customers, suppliers, or both. Open items that are available for settlement include invoices, unapplied prepayments, credit memos, and debit memos for customers and suppliers. New\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2015\/06\/30\/how-to-use-bp-net-settlement-in-sage-x3\/\">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":[8],"tags":[225,1457,2078],"class_list":["post-6936","post","type-post","status-publish","format-standard","hentry","category-sage-erp-x3","tag-bp-net-settlement","tag-payments","tag-settlement"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/6936","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=6936"}],"version-history":[{"count":2,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/6936\/revisions"}],"predecessor-version":[{"id":16588,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/6936\/revisions\/16588"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=6936"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=6936"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=6936"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}