{"id":2937,"date":"2018-04-11T11:58:03","date_gmt":"2018-04-11T10:58:03","guid":{"rendered":"http:\/\/vger.datos.co.uk\/ClientKnowledgebase\/?p=2937"},"modified":"2026-08-05T14:49:55","modified_gmt":"2026-08-05T14:49:55","slug":"how-to-print-off-a-sales-journal-report","status":"publish","type":"post","link":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/?p=2937","title":{"rendered":"How to Print a Sales Journal Report"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Season 25 and older<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Go to <strong>Sales Ledger<\/strong> &gt; <strong>Sales Journal<\/strong><\/li>\n\n\n\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>&nbsp;,<strong>printer&nbsp;<\/strong>or to a&nbsp;<strong>spreadsheet<\/strong> .<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img decoding=\"async\" src=\"http:\/\/vger.datos.co.uk\/ClientKnowledgebase\/wp-content\/uploads\/2018\/04\/2-18.png\" alt=\"\" class=\"wp-image-2956\" style=\"aspect-ratio:1.2060355432250636;width:492px;height:auto\"\/><\/figure>\n<\/div>\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>For this option you can choose to use a query for your report. To use a query tick the check box and search for the query you would like to use.<\/li>\n\n\n\n<li>The report type option allows you to choose whether you want a <strong>sales journal<\/strong> or <strong>sales allocation<\/strong><\/li>\n\n\n\n<li>For the date range you can choose whether to select between two dates or a period such as a month within the year.<\/li>\n\n\n\n<li>For the <strong>summary<\/strong> or <strong>detail<\/strong> tab you can chose to have the report summarised or to be detailed.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img decoding=\"async\" src=\"http:\/\/vger.datos.co.uk\/ClientKnowledgebase\/wp-content\/uploads\/2018\/04\/6-5.png\" alt=\"\" class=\"wp-image-2960\" style=\"aspect-ratio:1.2003363083689045;width:495px;height:auto\"\/><\/figure>\n<\/div>\n\n\n<ol start=\"7\" class=\"wp-block-list\">\n<li>In the <strong>advanced<\/strong> options you can choose the display type for invoices\/credits, only invoices or only credits.<\/li>\n\n\n\n<li>In the<strong> options tab<\/strong> you can choose more preferences such as the ability to filter customer credit status or show order analysis on report.<\/li>\n\n\n\n<li>Click the <strong>print<\/strong> button at the bottom right hand corner of the window and your report will be printed.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Advanced Options<\/strong><\/h2>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"459\" height=\"203\" src=\"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/wp-content\/uploads\/2018\/04\/Screenshot-2026-08-05-142438.jpg\" alt=\"\" class=\"wp-image-49860\"\/><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"208\" height=\"106\" src=\"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/wp-content\/uploads\/2018\/04\/Untitled.jpg\" alt=\"\" class=\"wp-image-49861\"\/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>Display Type &#8211; <\/strong><br><br><strong>Invoices\/Credits &#8211; <\/strong>The report will show details of invoices and credits<br><strong>Only Invoices &#8211;<\/strong> The report will only show details of invoices<br><strong>Only Credits &#8211;<\/strong> The report will only show credits<br><br><strong>Filter Credit Reason\/Filter Order Analysis &#8211;<\/strong> Only available when Only Invoices or Only Credits has been selected. This option allows you to select one of your order or credit reasons and the report will only show the invoices or credits that have been given the selected reason. <br><br><strong>Options &#8211;<\/strong><br><br><strong>Show Analysis Codes on Report &#8211;<\/strong> This adds a breakdown showing which analysis codes have been used for orders or credits to the end of the report and how many of each code has been used<br><strong>Print Nominal Adjustments Only &#8211; <\/strong>Only available when Show Analysis codes has not been selected. With this selected, you will only see details of any debtor journal adjustments that have been made for the selected period. <br><strong>Show Foreign Values &#8211; <\/strong>Only available if neither of the previous two options have been selected. When selected. a currency selection will appear for you to select the currency you want to see details for. This will filter the report down to only show the details of the selected currency and you will see the foreign value along with your base currency value. <br><strong>Filter Customer Credit Status &#8211;<\/strong> When selected, a credit status selection will appear for you to select the credit status you want to see details for. This will filter the report down to only showing details for invoices\/credits for customers with the selected credit status. <br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Season 26<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">In Season 26, the sales journal report was updated and now displays via an on screen grid rather than a digital screen printed page. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1052\" height=\"570\" src=\"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/wp-content\/uploads\/2018\/04\/Screenshot-2026-08-05-151622.png\" alt=\"\" class=\"wp-image-49862\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">All options available on the older version of the report are still available within the new grid report. Report Type gives you the option to switch between Sales Journal and Sales Allocation reports. Report By gives you the option to switch between running the report By Period, By Invoice Date or Posted Date. Along the top of the window, you also have the options to show all, just invoices or just credits. When you select the option for invoices or credits, a new box will appear for you to filter on the order analysis code\/credit reason code. Filtering by credit status can also be done from the option at the top of the window. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Invoice Report &#8211;<\/strong> Can be used when an invoice line has been selected on the grid, will print details of the invoice. Customer, date, delivery route, products etc. <br><strong>Reprint Invoice &#8211;<\/strong> Can be used when an invoice line has been selected on the grid, will print the invoice for the selected line. <br><strong>Print Report or Export &#8211;<\/strong> There is no predefined export for this report (press CTRL + E on your keyboard to export the details as seen on the grid). When printing the report, you have options to, Preview (screen) or Printer (print) the report. There is also a check box to Show Journals and VAT Analysis Only. This option will just show you the breakdown of nominal codes and values that the invoices have counted toward. <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"586\" height=\"202\" src=\"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/wp-content\/uploads\/2018\/04\/Screenshot-2026-08-05-154531.png\" alt=\"\" class=\"wp-image-49863\"\/><\/figure>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Season 25 and older Advanced Options Display Type &#8211; Invoices\/Credits &#8211; The report will show details of invoices and creditsOnly Invoices &#8211; The report will only show details of invoicesOnly Credits &#8211; The report will only show credits Filter Credit Reason\/Filter Order Analysis &#8211; Only available when Only Invoices or Only Credits has been selected. [&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-2937","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\/2937","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=2937"}],"version-history":[{"count":3,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/posts\/2937\/revisions"}],"predecessor-version":[{"id":49864,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/posts\/2937\/revisions\/49864"}],"wp:attachment":[{"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2937"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2937"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2937"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}