V9 - Purchases by vendor - summary report

---

 

Use case

The Purchases by vendor – summary report (Operations > Reports > Purchasing > Purchases by vendor - summary) provides a list of vendors with the totals purchased from each vendor.

 

While the basics for running any report in SOS Inventory are covered in Reporting introduction and Running a report, the filters, options, and columns specific to the Purchases by vendor – summary report are explained below.

 

Filters

From date and To date.

• Relative/Absolute toggle. Used for customized and scheduled reports. 
  • Relative automatically recalculates the date whenever the report is reopened or run. It must be used in tandem with the Quick date selector, which assigns a general time frame (e.g., Today, Yesterday, Start of last week, End of last month, etc.) instead of a specific date. 
  • Absolute, the default, keeps the exact date.
• The system automatically populates the current date in the date field by default. You can change specific dates manually according to the Date format established in your User settings (either MM/DD/YYYY or DD/MM/YYYY), or by using the Calendar (event). 
• Even if you are not creating or running a customized or scheduled report, you may find it more convenient to use the Quick date selector, which assigns a general time frame (e.g., Today, Yesterday, Start of last week, End of last month, etc.) instead of a specific date.

 

Vendor name contains. Type all or part of a vendor name to display matching vendors.

 

Options

Hide rows with no purchases. Items that were not received during the reporting period will not be displayed on the report. This option is checked by default.

 

Include archived vendors. SOS Inventory does not include archived vendors in reports by default. Check this option if you want archived vendors to be included when you run the report.

 

Show "from" and "to" dates. If checked, shows a date range at the top of the report, based on your From date and To date filters. The date range appears when Display is selected under Retrieve your report. If the report is retrieved by Email or Download, the header will appear only if you print your spreadsheet. If a header is also entered for the report, the date range will be displayed below the header.

 

Header. Enter header text for the report, if desired. The header appears when Display is selected under Retrieve your report. If the report is retrieved by Email or Download, the header will appear only if you print your spreadsheet.

 

Footer. Enter footer text for the report, if desired. The footer appears when Display is selected under Retrieve your report. If the report is retrieved by Email or Download, the footer will appear only if you print your spreadsheet and will show above the system-generated text, Report Generated [date] [timestamp].

 

Columns

The default column for the Purchases by vendor – summary report is Name. Four additional SOS column options are available, as well as any custom fields you have defined for vendors.

 

A vendor name is a clickable link to its record on the Vendors list. Columns on the report are sortable.

 

Sample Purchases by vendor - summary report

The sample Purchases by vendor – summary report below was filtered for a date range from Start of This Year to Today. In addition to the default column Name, Contact was selected. The columns Units received, % Total Units Received, Cost, and % Total Cost are built into the report. A Totals line displays the sum of each column. The values displayed in the Cost column are in the home currency.