IN THIS SECTION
Overview
The Purchases by Supplier Report shows Purchases grouped by supplier. Only approved Bills are included.
NOTE This report currently only includes Bills and Credit Notes. It does not include other items such as Payments, Receive Money or Journal Entries so may not reconcile exactly with other financial reports.
Report Filters
The Purchases by Supplier report includes the same report filters and actions as the other financial reports - such as selecting companies, dates and currencies, downloading to Excel and adding to Report Packs - more information on these filters can be found in the Running Reports article.
NOTE The Bill or Credit Note Date will be used to filter based on the dates selected.
Other Report Options
The report includes other options as follows:
| Option | Description |
| Show Tax | Display the tax amount for each bill/credit note and in the customer total. |
| Show Net | Display the Net Value of bills and credit notes - the customer total will show the total of the Net Values. |
| Show Gross | Display the Gross Value of bills and credit notes - the customer total will show the total of the Gross Values. |
| Show Balance | Display the customer account balance after the Bill or Credit Note has been applied - the customer total will show the total customer account balance for the selected period. |
| Compact View | Switch to compact view - this view reduces the number of columns being displayed by displaying the values in a single column. |
Sorting
You can sort the results by clicking on the column headings. Clicking once will sort ascending, clicking again will sort descending. The arrow icon next to the column heading shows the current sort order. Combining this with the Top 10 toggle gives you the ability to hone in on the most important results.
Viewing Bills and Credit Notes
To view the details of the Bills that relate to the supplier, click on the supplier name. A section will open on the right showing the contact details (name, telephone number etc.) and all the bills owed by that supplier, broken down by company.
Click on the Company name to see a list of bills for that company.
You can search for a particular bill by entering your search criteria in the search box.
You can download all bills for the supplier by clicking on the download icon.
FX
For more information on how FX is applied on the Purchase by Supplier report see this article.