Open: Purchase Order Processing > Reports.
The following reports are accessed from the Reports menu. Additional documentation such as purchase orders and the purchase order negotiation reports are generated from windows in the relevant area of the system. Other reports are automatically generated when the system completes certain processes such as generating purchase orders.
A group of reports to help you track the current orders and returns as well as identify stock items that need to be ordered.
Items Requiring Ordering: helps you determine the items you need to purchase from your suppliers. The report is based on the stock levels set for stock items (type stock). Where an item has fallen below the re-order level it is listed in the report. The report includes the quantity required for each listed item. The required quantity is based on the usual order quantity specified for the item or the difference between the current stock level and the re-order level set for the item. The report displays the greater of the two.
If you are using multiple locations, the report groups the information by warehouse indicating the location used to store the item.
A group of reports to help you monitor orders and returns in more detail. These reports provide specific information on the goods that have been delivered and those that have been returned to your suppliers. Invoicing and credit details are also provided.
There are two reports, a detailed report and a summary report. The summary report lists orders and returns providing details of the order/return number, date, the status of the order/return, the requested delivery date and order/return value.
The detailed report provides the same information as the summary report and includes details of the items purchased/returned. This information covers the item code, the total quantity ordered/returned and its value. For an order, the report also displays the quantity that is on order with the supplier.
You can prepare the reports to list orders and returns, orders only or returns only.
Both the Detailed and Summary reports group the information by supplier, displaying the suppliers reference, name and currency.
These provide details of invoices and credit notes recorded in Purchase Order Processing. Invoices and credit notes are listed in numerical order together with the associated item details. This information covers the item code, description, quantity, unit of measure, value, user name, and the order or return the invoice/credit note is associated with. The report also indicates whether the invoice/credit note is marked as disputed. The report groups the information by supplier, displaying the supplier's reference, name and currency.
These provide details of receipts and despatches associated with purchase orders and returns recorded in Purchase Order Processing. Details include the order/return number, the item code and description, the quantity and the name of the person who recorded the receipt/return. If you are using multiple locations, the report also details the locations used to store the goods (warehouse and bin). The report groups the information by supplier, displaying the supplier's reference, name and currency.
These list disputed invoices and credit notes recorded in Purchase Order Processing. The disputed supplier documents are listed in numerical order indicating the dispute comments, dispute code and dispute description used. Details of the invoice/credit note are also displayed. This information covers the document date, item code and description, the quantity and unit of measure, the value and the order or return the document is associated with. The report also displays the name of the person who recorded the order/return. The report groups the information by supplier, displaying the supplier's reference, name and currency.
This report is only relevant if you have enabled the POP setting to Record details of cancelled orders. The report details the order lines that have been cancelled for purchase orders. Cancelled order lines are listed by item code. The cancellation details cover the date the order line was cancelled, the quantity cancelled, the buying unit, the associated order number and the person who cancelled the order. If you have cancelled purchase returns, the report can be used to view the associated cancelled return lines. The report groups the information by supplier, displaying the supplier's reference, name and currency.
This lists purchase order items that have been received. Items are grouped with the relevant purchase order. The associated delivery details cover the goods received number (GRN), delivery date, quantity delivered and the person who recorded the goods in. The invoice status is also provided to indicate whether the goods have been invoiced either in full or in part.
This lists any stock items on your purchase orders that you have flagged for a possible discount. This allows you to discuss costs with your supplier's supplier.
Lists existing additional charges. Details cover the charge's code, name, tax rate, value and the nominal code used to post values to the Nominal Ledger.
Overview
Reports and documents in Sage 200
Designing your own reports and documents
Other tasks
Sending reports and documents via email
Manage invoice and credit note layouts
Reference