Sales order reports
Additional documentation, such as the order acknowledgement or picking list, is generated from the information stored in the relevant area of the system. Other reports are automatically generated when the system completes certain processes, such as the conversion of quotations to orders, or posting invoices and credit notes.
Processing
You can produce reports to determine the status of outstanding sales orders and returns in the order processing life cycle.
Open: Sales Order Processing > Reports > Processing.
The order reports summarise the information for current orders as a whole, providing information such as the customer, order number and order value. They do not detail the stock items associated with the orders. The reports available are:
- Order status.
- Not fully allocated.
- Fully allocated not fully despatched.
- Fully despatched not fully invoiced.
- Sales orders not acknowledged.
The order line reports focus on the stock items requested for current orders. The reports available are:
- Sales orders allocation required.
- Sales orders allocations not despatched.
- Sales orders despatched not invoiced.
The return reports summarise the information for current returns as a whole, providing information such as the customer, return number and goods value. They do not detail the stock items associated with the returns. The reports available are:
- Returns status.
- Not fully received.
- Fully received not fully credited.
The return line reports focus on the stock items recorded for returns. The reports available are:
- Sales return receipts pending.
- Sales return receipts not credited.
- Payment methods totals summary. Details the payments received at the point of sales for each payment method set up for Sage 200 such as cash, Visa or Delta. For each payment method listed in the report, details of the order such as the order number, customer and payment value are provided.
Status
Open: Sales Order Processing > Reports > Status.
You can produce a report on sales orders, returns, pro forma invoices or quotations by customer. You can produce the report in detail or in summary form.
Provides a report of invoices and credit notes by customer. You can produce the report in detail or in summary form. If you choose the summary form then you can produce the report by customer and by document number per customer. If you choose the details form, then the items, quantities, VAT, line values, discount percentage and outstanding quantity per item are also shown.
Lists the stock allocations made for orders, by stock item, warehouse and customer. The report shows the allocated quantity at each warehouse for each customer for each item.
This report provides a copy of the despatch note details for a sales order. This shows the order or return number, the invoice or credit note number, item, quantity, warehouse and user name.
Lists the details from return receipts by customer and document number.
Lists cancelled order lines for an order by customer. It shows item, cancelled date, cancelled quantity, selling unit, order number and user.
Lists the sales orders that require stock to be allocated to them before the goods can be despatched. The report focuses on stock items detailing the items required, associated sales orders, the required allocation quantity and the date the goods have been promised to the customers.
A simple report that lists orders or returns where the invoice or credit note values have not been posted.
Lists cancelled invoices for customers. It shows the cancellation date, the order number, the reason for the cancellation and the user.
A report that lists orders that have been overpaid. It shows order number, customer reference, status, order net value, order VAT value, order gross value and the payment value. Overpaid orders cannot be processed until the payment value is amended.
The Converted Quotations report lists which quotes have been converted to sales orders. This can be either direct from a quote, or when converted to a pro forma and then a sales order.
The report shows the Sales Order and Pro Forma Invoice numbers.
This report shows you quotes that have been converted to pro formas, but the pro formas are still live and have not yet been completed. This is useful to find pro formas that require payment, or can be deleted.
Profitability
Open: Sales Order Processing > Reports > Profitability.
Two reports are available, a summary report and a detailed report.
The summary report lists customers in alphabetical order together with the orders they have placed and the sales order value. Both the profit value and the amount as a percentage of the order are displayed for each sales order.
The detailed report lists sales orders in numerical order together with the name of the customer who has placed the order. Additional details cover the stock items ordered and the quantity requested.
Note: Sales returns and credit notes are not included on sales order and invoice profitability reports.
Batch/serial items
Open: Sales Order Processing > Reports > Batch/Serial Items.
The following reports are applicable if you are using batch/serial numbered items to trace stock.
- Allocations with batch/serial items.
- Despatches and receipts with batch/serial items.
- Invoices for batch/serial items.
Archived
Open: Sales Order Processing > Reports > Archived.
There are several reports available to help analyse the orders and returns that have been moved into archive and are no longer classed as current. Using the invoice and credit note reports it is possible to reprint archived invoices or credit notes. The reports available are:
- Sales orders and returns archived.
- Sales orders and returns archived (summary).
- Invoices and credit notes archived.
- Invoices and credit notes archived (summary).
- Cancelled lines.
Maintenance
Open: Sales Order Processing > Reports > Maintenance.
You can produce reports to determine the support options that have been created and stored on the system. The reports available are:
- Additional charges: Lists the additional charges set up in the system.
- Repeat order templates: Lists the repeat order templates for customers, by customer.
- Sales order items: Lists the sales order items that you have defined.
Overview
Reports and documents in Sage 200
Designing your own reports and documents
Other tasks
Send reports and documents by email
Manage invoice and credit note layouts
Reference