Purchases by vendor

Question

Is there a report for total purchases by supplier? We want to know the total purchases from each vendor for a period in time to know which are our key suppliers.

Richard S. Ridings · Accepted Answer

On the same Reports, Payables/Suppliers menu, you can see the Vendor/Supplier Purchases report as well. This may be what you are looking for. It ignores sales tax and includes totals per vendor.

Erzsi_I · Answer

Hi Cheryl TM , 
 Thank you for reaching out. To identify total purchases from each vendor over a specific period, and thereby determine your key suppliers, you can utilize the report for " Vendor Aged Detail " and then export this data to Microsoft Excel for further analysis. Here's a step-by-step guide based on the provided article content below : 
 
 Navigate to Reports > Vendor / Supplier > Vendor Aged, Detail in Sage 50. 
 Select the Vendor(s) you're interested in analyzing from the list. 
 Verify the as at Date to ensure it covers the period you're interested in. 
 Adjust the Include invoices paid in the last "x" days option to cover the period you're interested in (e.g., for a full year, you might set this to 365 or a higher number like 999 for an extended range). 
 Click OK to generate the report. 
 Click Open in Excel to export the report data to Microsoft Excel. 
 In Excel, you can save the file for your records. Then, utilize Excel's filtering capabilities to focus on the Transaction Type column, specifically filtering to only show the Payment type . 
 
 This process will give you a detailed view of all payments made to specific vendors, from which you can calculate the total purchases for each vendor for the specified period. By analyzing these totals, you'll be able to identify your key suppliers based on the volume or value of purchases made. 
 If you need further assistance or have more questions, please don't hesitate to ask. We're here to help! 
 Warm Regards, Erzsi 
 If this helps, please mark it as verified :)

Sage 50 Canada

Purchases by vendor

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING