{"id":13456,"date":"2018-04-03T14:22:30","date_gmt":"2018-04-03T14:22:30","guid":{"rendered":"https:\/\/kb.sambapos.com\/?p=13456"},"modified":"2020-09-30T14:19:31","modified_gmt":"2020-09-30T14:19:31","slug":"9-8-1-remaining-balanced-customers-report","status":"publish","type":"post","link":"https:\/\/kb.sambapos.com\/en\/9-8-1-remaining-balanced-customers-report\/","title":{"rendered":"9.8.1. Remaining Balanced Customers Report"},"content":{"rendered":"<p>In order to create remaining balanced customers report go to <strong>Manage &gt; Reports &gt; Reports<\/strong> from here click on <strong>Add Report<\/strong> link.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-13457 size-large\" src=\"https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/04\/9-8-1-Remaining-Balanced-Customers-Report-01-1024x576.jpg\" alt=\"\" width=\"640\" height=\"360\" srcset=\"https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/04\/9-8-1-Remaining-Balanced-Customers-Report-01-1024x576.jpg 1024w, https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/04\/9-8-1-Remaining-Balanced-Customers-Report-01-300x169.jpg 300w, https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/04\/9-8-1-Remaining-Balanced-Customers-Report-01-768x432.jpg 768w, https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/04\/9-8-1-Remaining-Balanced-Customers-Report-01.jpg 1366w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/p>\n<ul>\n<li><strong>Name:<\/strong>\u00a0Field to write name of report. (For example; Remaining Balanced Customers)<\/li>\n<li><strong>Page Size:<\/strong>\u00a0Field to set size of page. (In the example; 500px)<\/li>\n<li><strong>Display in Report Explorer:<\/strong>\u00a0Activate it by selecting the box.<\/li>\n<li><strong>Template:<\/strong>\u00a0Write Remaining Balanced Customers as template title and copy the code below and paste into template area.<\/li>\n<\/ul>\n<table style=\"height: 51px; width: 101.034%; border-collapse: collapse; border-color: #dedede; background-color: #dedede;\">\n<tbody>\n<tr>\n<td style=\"width: 100%;\"><code>[#Debtor and Creditor Accounts:2,2,1,1]<br \/>\n&gt;Name|Address|Phone|Balance<br \/>\n{REPORT ENTITY DETAILS:E.Name,EC.Address,EC.Phone,E.Balance.sum:(ET=Customers) &amp;&amp; E.AccountId&gt;0:::$4!=0}<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>After completing necessary editings, click on Save button. You can display related report on navigation screen in the Reports menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-13459 size-large\" src=\"https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/04\/9-8-1-Remaining-Balanced-Customers-Report-02-1024x576.jpg\" alt=\"\" width=\"640\" height=\"360\" srcset=\"https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/04\/9-8-1-Remaining-Balanced-Customers-Report-02-1024x576.jpg 1024w, https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/04\/9-8-1-Remaining-Balanced-Customers-Report-02-300x169.jpg 300w, https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/04\/9-8-1-Remaining-Balanced-Customers-Report-02-768x432.jpg 768w, https:\/\/kb.sambapos.com\/wp-content\/uploads\/2018\/04\/9-8-1-Remaining-Balanced-Customers-Report-02.jpg 1366w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In order to create remaining balanced customers report go to Manage &gt; Reports &gt; Reports from here click on Add Report link. Name:\u00a0Field to write name of report. (For example; Remaining Balanced Customers) Page Size:\u00a0Field to set size of page. (In the example; 500px) Display in Report Explorer:\u00a0Activate it by selecting the box. Template:\u00a0Write Remaining [&hellip;]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-13456","post","type-post","status-publish","format-standard","hentry","category-reports"],"_links":{"self":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts\/13456","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/comments?post=13456"}],"version-history":[{"count":2,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts\/13456\/revisions"}],"predecessor-version":[{"id":25084,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/posts\/13456\/revisions\/25084"}],"wp:attachment":[{"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/media?parent=13456"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/categories?post=13456"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.sambapos.com\/en\/wp-json\/wp\/v2\/tags?post=13456"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}