{"id":3205,"date":"2018-04-19T14:12:13","date_gmt":"2018-04-19T13:12:13","guid":{"rendered":"http:\/\/vger.datos.co.uk\/ClientKnowledgebase\/?p=3205"},"modified":"2026-04-30T13:33:12","modified_gmt":"2026-04-30T13:33:12","slug":"how-to-print-a-supplier-balances-report","status":"publish","type":"post","link":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/?p=3205","title":{"rendered":"How to Print a Supplier Balances Report"},"content":{"rendered":"\n<p>The <strong>&#8216;Supplier Balances report&#8217;<\/strong> will produce a report showing the outstanding balance for each supplier up until your chosen accounting period. See below how to run this:-<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>On the reports menu, go to <strong>Purchase Ledger> Supplier Balances Report.<\/strong><\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"160\" height=\"286\" src=\"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/wp-content\/uploads\/2018\/04\/PL-Balances-report.jpg\" alt=\"\" class=\"wp-image-49804\" style=\"width:200px;height:auto\"\/><\/figure>\n<\/div>\n\n\n<ol class=\"wp-block-list\">\n<li>At the top of the report menu you will be able to choose how to output your report, either by <strong>PDF preview,<\/strong>\u00a0<strong>printer <\/strong>or <strong>export CSV<\/strong>.<img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"437\" class=\"wp-image-49805\" style=\"width: 700px;\" src=\"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/wp-content\/uploads\/2018\/04\/supplier-balances.jpg\" alt=\"\"><\/li>\n\n\n\n<li>You have multiple options for how to run the report, <strong>by supplier, area, currency, control account, sort keys<\/strong>. Choose the option that you prefer.<\/li>\n\n\n\n<li>Tick the <strong>&#8216;Change Period&#8217;<\/strong> checkbox to change the period you want to run it for. By default it will be your current period.<\/li>\n\n\n\n<li>The advanced options allows you to choose <strong>extended ageing, print foreign values, print zero value suppliers<\/strong> <strong>or print received not invoiced<\/strong>.<\/li>\n\n\n\n<li>When you have chosen the settings, click the print button at the bottom right hand corner of the screen and your report will be produced.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">Season 26 Grid Report<\/h2>\n\n\n\n<p>In Season 26 the above supplier balances report was replaced with a grid view report. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1077\" height=\"724\" src=\"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/wp-content\/uploads\/2018\/04\/sup-bal-grid.jpg\" alt=\"\" class=\"wp-image-49806\"\/><\/figure>\n\n\n\n<p>You have the same options as the previous report version. <\/p>\n\n\n\n<p><strong>Report By &#8211;<\/strong> Supplier, Currency, Area, Control Account Sort 1, Sort 2 and Payment Method.<\/p>\n\n\n\n<p><strong>Additional Options &#8211; <\/strong>Extended Ageing Report, Print Foreign Values and Zero Value Suppliers. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">View PDF invoce<\/h2>\n\n\n\n<p>If you have been using the Auto Purchase Invoice program and have been assigning your invoice PDFs to the invoices you are entering in Season then you are able to view the PDF invoice by right clicking on the invoice and selecting to view PDF. As seen in the image above, if there is a PDF invoice attached you will see the PDF logo to the right of the invoice reference. <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"335\" height=\"257\" src=\"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/wp-content\/uploads\/2018\/04\/pdf.jpg\" alt=\"\" class=\"wp-image-49807\"\/><\/figure>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>The &#8216;Supplier Balances report&#8217; will produce a report showing the outstanding balance for each supplier up until your chosen accounting period. See below how to run this:- Season 26 Grid Report In Season 26 the above supplier balances report was replaced with a grid view report. You have the same options as the previous report [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,20],"tags":[],"class_list":["post-3205","post","type-post","status-publish","format-standard","hentry","category-howtoguides","category-howtooffice"],"_links":{"self":[{"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/posts\/3205","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3205"}],"version-history":[{"count":2,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/posts\/3205\/revisions"}],"predecessor-version":[{"id":49808,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/posts\/3205\/revisions\/49808"}],"wp:attachment":[{"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3205"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3205"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3205"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}