Summary
Description


Reports created on the back of wish list requests can be found here
Sales Order / Invoice reports
| Report | Example | File | Added |
|---|---|---|---|
| Quotations (Detailed) by Customer with Expiry Date A list of quotation item line values, quantities and expiry date grouped by customer.
| View report | Download | Oct 2023 |
| 12 Month Invoiced Quantities by Customer and Stock Code 12 Month report listing quantity invoiced for each customer for each product with a grand total | View report | Download | May 2022 |
| 12 Month Invoiced Net Sales by Customer and Stock Code 12 Month report listing net invoiced for each customer with a grand total | View report | Download | Apr 2022 |
| 12 Month Invoiced Net Sales by Stock Code 12 Month report net turnover per month | View report | Download | Jan 2022 |
| 12 Month Invoiced Quantities by Stock Code 12 month product quantity sold per month | View report | Download | Dec 2021 |
| Monthly Invoiced Products Grouped by Sales Ledger Analysis 1 Grouped by Sales Ledger Analysis 1 showing total per month of each product code sold by them | View report | Download | Aug 2021 |
| SOP Invoiced Free Text Items Listing all free item lines of SOP's | View report | Download | Jul 2021 |
| SOP Sales Order with Project Code (Single) SOP layout showing Project code each line assigned to | View report | Download | Feb 2021 |
| Monthly Invoiced Quantities by Product Group and Stock Code Monthly product sales grouped by Product group | View report | Download | Oct 2020 |
| Sales Order and Returns Totals Only Total Sales orders and returns within the date range | View report | Download | Jul 2020 |
| Sales Order Products by Customer Product Sales By Customer | View report | Download | Mar 2020 |
| Invoiced Monthly Net Sales by Product Group and Stock Code Monthly Sales Net by Product Group and Stock Code | View report | Download | Feb 2020 |
| Sales by Customer Analysis 3 Quantity and sales value by Customer Analysis 3 | View report | Download | Feb 2019 |
| Sales By Nominal Sales Quantity and amount grouped by nominal code | View report | Download | Sep 2018 |
| SOP by stock type (Detailed) Product sales by product code grouped by stock type | View report | Download | May 2018 |
| Sales by Customer Analysis 2 Quantity and sales value grouped by Customer Analysis 2 | View report | Download | Sep 2017 |
| Product Sales by Nominal and Customer Quantity and sales value grouped by Nominal and Customer | View report | Download | Jun 2017 |
| Sales by Customer Analysis 1 Quantity and sales value grouped by Customer Analysis 1 | View report | Download | Mar 2017 |
| SOP Invoice with Project Code (Single) SOP layout showing Project code each line is assigned to | View report | Download | May 2016 |
| Sales Orders Product Sales by Nominal and Customer Grouped by customer then product code then showing sales per Nominal code | View report | Download | Jan 2016 |
| Monthly Product Sales Grouped by product code showing number of invoices and credits with quantity and net amounts | View report | Download | Aug 2015 |
| Monthly Product Sales By Customer Grouped by customer then individual stock codes showing number of invoices and credits with quantity and net amounts | View report | Download | Aug 2015 |
| Monthly Product Sales By Customer By Product Group Grouped by customer then product group showing number of invoices and credits with quantity and net amounts | View report | Download | Aug 2015 |
| Monthly Product Sales By Product Group By Customer Grouped by product group then customer showing number of invoices and credits with quantity and net amounts | View report | Download | Aug 2015 |
| Monthly Product Sales By Product Group Grouped by product group then monthly totals showing number of invoices and credits with quantity and net amounts | View report | Download | Aug 2015 |
| Sales By Product (Detailed) Grouped by product code listing all Invoices and credit raised to that code. | View report | Download | Aug 2015 |
| Sales By Product (Summary) Grouped by product code showing 1 line per code showing number of invoices and credits with quantity and net amounts | View report | Download | Aug 2015 |
| Sales By Product By Customer (Detailed) Grouped by customer then product code listing all Invoices and credit raised to that code. | View report | Download | Aug 2015 |
| Sales By Product By Customer (Summary) Grouped by customer then product code showing 1 line per code showing number of invoices and credits with quantity and net amounts | View report | Download | Aug 2015 |
| Sales By Product By Customer By Product Group (Detailed) Grouped by customer then product group then product code listing all Invoices and credit raised to that code. | View report | Download | Aug 2015 |
| Sales By Product By Customer By Product Group (Summary) Grouped by customer then product group then product code showing 1 line per code showing number of invoices and credits with quantity and net amounts | View report | Download | Aug 2015 |
| Sales By Product By Product Group (Detailed) Grouped by product group then product code listing all Invoices and credit raised to that code. | View report | Download | Aug 2015 |
| Sales By Product By Product Group (Summary) Grouped by product group then product code showing 1 line per code showing number of invoices and credits with quantity and net amounts | View report | Download | Aug 2015 |
| Sales By Product By Product Group By Customer (Detailed) Grouped by product group then customer then product code listing all Invoices and credit raised to that code. | View report | Download | Aug 2015 |
| Sales By Product By Product Group By Customer (Summary) Grouped by product group then customer then product code showing 1 line per code showing number of invoices and credits with quantity and net amounts | View report | Download | Aug 2015 |
| Sales Orders No. of Orders & Turnover (Detailed) Grouped by customer, listing individual orders with a total number of orders, returns and a total turn over | View report | Download | May 2015 |
| Sales Orders No. of Orders & Turnover (Summary) List each customer with a total number of orders, returns, Net/Vat/Gross and a total turn over | View report | Download | May 2015 |
| Invoiced Product Sales by Customer (Detailed) Grouped by customer then listing each invoice per product code | View report | Download | Feb 2015 |
| Invoiced Product Sales by Customer (Summary) Grouped by customer then summary for each product code | View report | Download | Feb 2015 |
To download and add a report to Sage 200
- Locate your report in the list and click Download.
- When prompted, enter your login details.
- Make a note of the filename, for example: 12 Month Invoiced Net Sales by Stock Code.report
- Click Download.
- In the Save As window, browse to and select the required destination, for example, Windows desktop then click Save.
You've now downloaded the report, you then need to add the report to Sage 200, if you already know how to do this, great, if you need some guidance, refer to the following article >
If you're using Sage 200 Standard or Education please refer to your program help guide for help adding it to your menu.
Licence information
The software and other material sent with or attached to this article is copyright Sage (UK) Limited. You do not own it, but may use it as described in, and subject to the terms of, the software licence agreement which accompanied the associated Sage product, for which you have already acquired a licence.
CAUTION: