{"id":19797,"date":"2020-04-10T12:15:05","date_gmt":"2020-04-10T12:15:05","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagex3\/?p=19797"},"modified":"2020-04-10T12:20:48","modified_gmt":"2020-04-10T12:20:48","slug":"technical-how-to-solve-unbalanced-payment-error-while-creating-payment-through-import-export-template","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2020\/04\/10\/technical-how-to-solve-unbalanced-payment-error-while-creating-payment-through-import-export-template\/","title":{"rendered":"How to solve Unbalanced Payment Error while creating Payment through Import\/Export Template"},"content":{"rendered":"\n<p><p style=\"text-align: justify\"><strong>Introduction:<\/strong> After sales invoice generation,next process is payment creation,While creating payment through import\/export template using PAY object and GESPAY Function,we come across error Unbalance payment error as shown in below image .The solution for solving this error is following below,<\/p><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"337\" height=\"71\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/04\/Fig.-1.1-Unbalance-Error.png\" alt=\"Fig.-1.1-Unbalance-Error\" class=\"wp-image-19798\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/04\/Fig.-1.1-Unbalance-Error.png 337w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/04\/Fig.-1.1-Unbalance-Error-300x63.png 300w\" sizes=\"(max-width: 337px) 100vw, 337px\" \/><figcaption>                                <\/figcaption><\/figure><\/div>\n\n\n\n<p><strong>Solution:<\/strong><\/p>\n\n\n\n<p><strong>Setup&gt;Usgae&gt;Import\/Export Template.<\/strong><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"802\" height=\"481\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/04\/Fig-2.1-PAY-Import-Export-Template.png\" alt=\"Fig 2.1  PAY Import\/Export Template\" class=\"wp-image-19799\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/04\/Fig-2.1-PAY-Import-Export-Template.png 802w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/04\/Fig-2.1-PAY-Import-Export-Template-300x180.png 300w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/04\/Fig-2.1-PAY-Import-Export-Template-768x461.png 768w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/04\/Fig-2.1-PAY-Import-Export-Template-660x396.png 660w\" sizes=\"(max-width: 802px) 100vw, 802px\" \/><figcaption>Fig 2.1  PAY Import\/Export Template<\/figcaption><\/figure><\/div>\n\n\n\n<p>In Fig 2.1,There is a Sign field\nwhich plays important in solving this error.The value for the field is select\nby the below step <\/p>\n\n\n\n<p><strong>STEP <\/strong>: <strong>Navigate to Setup&gt;A\/P-A\/R Accounting &gt;payment entry types,choose appropriate payment type.<\/strong><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"808\" height=\"426\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/04\/Fig-2.2-Payment-Entry-Type.png\" alt=\"Fig 2.2 Payment Entry Type\" class=\"wp-image-19800\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/04\/Fig-2.2-Payment-Entry-Type.png 808w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/04\/Fig-2.2-Payment-Entry-Type-300x158.png 300w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/04\/Fig-2.2-Payment-Entry-Type-768x405.png 768w, https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2020\/04\/Fig-2.2-Payment-Entry-Type-660x348.png 660w\" sizes=\"(max-width: 808px) 100vw, 808px\" \/><figcaption>Fig 2.2 Payment Entry Type<\/figcaption><\/figure><\/div>\n\n\n\n<p>As in Fig 2.2 ,Check the Sign Field\nif it is Expense then assign value 1 to Sign field of the Template,If it is\nRevene then assign value&nbsp; 2 to sign field\nof the Template.<\/p>\n\n\n\n<p><strong>Conclusion:<\/strong>This blog helps to understand how to solve unbalance payment error while creating payment through Import\/Export Template<\/p>\n\n\n\n<h2 class=\"wp-block-heading has-text-color has-link-color wp-elements-c5e1638fe0db781fd132d689b469078c\" style=\"color:#c71d22\"><strong>About Us<\/strong><\/h2>\n\n\n\n<p>Greytrix \u2013 a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development, and implementation competence.<\/p>\n\n\n\n<p id=\"block-28013e99-0882-44c6-b705-7b16c85053b2\">Greytrix&nbsp;has some unique integration solutions developed for&nbsp;<a href=\"https:\/\/www.greytrix.com\/sage-crm\/\">Sage CRM<\/a>&nbsp;with Sage ERPs&nbsp;namely&nbsp;<a href=\"https:\/\/www.greytrix.com\/sage-x3-erp\/\">Sage X3<\/a>,&nbsp;<a href=\"https:\/\/www.greytrix.com\/sage-intacct\/\">Sage Intacct<\/a>,&nbsp;<a href=\"https:\/\/www.greytrix.com\/sage-100-erp\/\">Sage 100<\/a>,&nbsp;<a href=\"https:\/\/www.greytrix.com\/sage-500-erp\/\">Sage 500<\/a>,&nbsp;and&nbsp;<a href=\"https:\/\/www.greytrix.com\/sage-300-erp\/\">Sage 300<\/a>. We also offer best-in-class&nbsp;Sage ERP&nbsp;and&nbsp;Sage CRM&nbsp;customization and development services&nbsp;to&nbsp;Business&nbsp;Partners,&nbsp;End&nbsp;Users, and Sage PSG worldwide. Greytrix&nbsp;helps in&nbsp;the migration of Sage CRM from&nbsp;Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes&nbsp;addons like&nbsp;&nbsp;Greytrix Business Manager,&nbsp;Sage CRM Project Manager,&nbsp;Sage CRM Resource Planner,&nbsp;Sage CRM Contract Manager,&nbsp;Sage CRM Event Manager,&nbsp;Sage CRM Budget Planner,&nbsp;Gmail Integration,&nbsp;Sage CRM Mobile Service Signature,&nbsp;Sage CRM CTI Framework.<\/p>\n\n\n\n<p id=\"block-4bc42a09-fb13-4598-8137-ce5f7b91ce28\">Greytrix is a recognized&nbsp;Sage Champion Partner&nbsp;for GUMU&#x2122; Sage X3 \u2013 Sage CRM integration listed on&nbsp;<a href=\"https:\/\/www.sage.com\/marketplace\/asb_ListingDetail?listingId=a1h24000007PC3aAAG\" target=\"_blank\" rel=\"noreferrer noopener\">Sage Marketplace<\/a>&nbsp;and Sage CRM \u2013 Sage Intacct integration listed on&nbsp;<a href=\"https:\/\/marketplace.intacct.com\/MPListing?lid=a2D0H000007kiHyUAI\" target=\"_blank\" rel=\"noreferrer noopener\">Sage Intacct Marketplace<\/a>. The&nbsp;<a href=\"https:\/\/www.greytrix.com\/gumu\/\" target=\"_blank\" rel=\"noreferrer noopener\">GUMU&#x2122; Cloud framework<\/a>&nbsp;by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.<\/p>\n\n\n\n<p id=\"block-76376301-1c3e-4250-8a09-727595a606f0\">For more information on our integration solutions, please contact us at&nbsp;<a href=\"mailto:sage@greytrix.com\">sage@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction: After sales invoice generation,next process is payment creation,While creating payment through import\/export template using PAY object and GESPAY Function,we come across error Unbalance payment error as shown in below image .The solution for solving this error is following below, Solution: Setup&gt;Usgae&gt;Import\/Export Template. In Fig 2.1,There is a Sign field which plays important in solving\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2020\/04\/10\/technical-how-to-solve-unbalanced-payment-error-while-creating-payment-through-import-export-template\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,10,2796,11],"tags":[2951,2950,2948,2949],"class_list":["post-19797","post","type-post","status-publish","format-standard","hentry","category-sage-erp-x3","category-standard","category-technical","category-tips","tag-error-while-creating-payment","tag-payment-entry-types","tag-sign","tag-unbalanced-payment-error"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/19797","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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=19797"}],"version-history":[{"count":5,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/19797\/revisions"}],"predecessor-version":[{"id":19810,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/19797\/revisions\/19810"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=19797"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=19797"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=19797"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}