Modify a Vendor Purchases Report

You must have access rights to Reports for Transactions in the Vendors & Purchases security option

1. In the Home window, open the Report Centre. Select Vendors & Purchases and then Vendor Purchases Summary. Click Modify this report.
2. (Optional) Select the Template you want to use for the report.
3. (Optional) Select Include inactive vendors.
4. Select the vendors you want to appear in the report. Click Select All to include all of your vendors.
5. In the Select From section, select the Inventory by Asset option or the type of items you want to report on.
6. (Optional) Select Include inactive items or Include inactive accounts.
7. Select the items or accounts you want to appear in the report. Click Select All to report on all of the listed items.
8. In the Report quantities in section, select the unit of measure you want to use in the report.
9. (Optional) Select Show foreign amounts to include foreign currency totals in the report.
10. (Optional) Select Show Locations and click Select Locations. (Sage 50 Premium Accounting)
11. Enter the Start and Finish dates for the report.
12. In the Report on section, select the revenue sources you want to include in the report:
• Inventory & Service amounts
• Freight amounts
• Other amounts - includes all goods and services not in the Inventory & Services List, such as items without an inventory record that are entered on an invoice, or items that have been deleted from your inventory list.
13. (Optional) Customize the:
    • Columns that appear in the report
    • Printer settings for the report
    • Fonts in the report
14. (Optional) Save the report as a template in My Reports.
15. Click OK to display the report.

1. In the Home window, open the Report Centre. Select Vendors & Purchases and then Vendor Purchases Detail. Click Modify this report.
2. (Optional) Select the Template you want to use for the report.
3. (Optional) Select Include inactive vendors.
4. Select the vendors you want to appear in the report. Click Select All to include all of your vendors.
5. In the Select From section, select the Inventory by Asset option or the type of items you want to report on.
6. (Optional) Select Include inactive items or Include inactive accounts.
7. Select the items or accounts you want to appear in the report. Click Select All to report on all of the listed items.
8. In the Report quantities in section, select the unit of measure you want to use in the report.
9. (Optional) Select Show foreign amounts to include foreign currency totals in the report.
10. (Optional) Select Show Locations and click Select Locations. (Sage 50 Premium Accounting)
11. Enter the Start and Finish dates for the report.
12. In the Report on section, select the revenue sources you want to include in the report:
• Inventory & Service amounts
• Freight amounts
• Other amounts - includes all goods and services not in the Inventory & Services List, such as items without an inventory record that are entered on an invoice, or items that have been deleted from your inventory list.
13. (Optional) Customize the:
    • Columns that appear in the report
    • Printer settings for the report
    • Fonts in the report
14. (Optional) Save the report as a template in My Reports.
15. Click OK to display the report.