| □ | The Purchase Analysis Report provides quick, and easy to understand, Answers to some pretty complex questions. |
| • | What and how much did the Company Buy? |
| e. | For whatever Date Range is needed? |
| • | How are those results to be calculated? |
| a. | Purchases from a specified set of (one or more) Vendors? |
| f. | Purchases made within a specified Division? |
| g. | Or any combination of these! |
| □ | To print a Purchase Analysis Report, on the Main Menu Select Reports, Choose the Accounts Payable sub-menu and Click Purchase Analysis. |
| • | Options - Initially only the Options tab is shown (until you make your Options selections and Select Print). |
Purchase Analysis Report - Options
| • | Report Type - How much information do you want included on this Purchase Analysis Report? |
| ▪ | Detail - (This is the default option) - Sorted by Purchase Category, this Report Type includes the Purchases from every Vendor and the Total Amount and Quantity that was purchased on each Bill (and showing each Bill's Invoice Number), with sub-totals for the Purchase Amounts and Quantities of each Purchase Category - based on the specified Date Range (see below). |
| ▪ | Summary - Sorted by Purchase Category, this Report Type includes the total Amounts and Quantities that were purchased for each Purchase Category - within the specified Date Range (see below). |
| • | Ordered By - Choose the sequence in which the data will be listed on the Purchase Analysis Report. |
| ▪ | Vendor - Lists Vendors in Vendor ID (system assigned record number) order and their associated Invoices. |
| • | Date Range - What is the Date Range within which these Purchases should be reported? |
| ▪ | From - The default starting date is the first day of the most recently completed month. |
| o | Use the Drop-Down Date Selection Box to change the starting date, as needed. |
| ▪ | To - The default ending date is the last day of the most recently completed month. |
| o | Use the Drop-Down Date Selection Box to change the ending date, as needed. |
Purchase Analysis Report - For Selected Vendors & Selected Purchase Items
| • | Display Amount - Specify how the Purchase Amount will be reported: |
| ▪ | Net - Display the net cost of the Purchase Item(s) (exclusive of any Sales Tax). |
| ▪ | Gross - Display the gross cost of the Purchase Item(s) (including all Sales Taxes). |
| ▪ | All Vendors - By default, All Vendors from whom a qualified Purchase was made, within the Date Range specified above, will be included (only limited by any Specific Selection Options chosen below). |
| ▪ | Select Vendors - Click this button to only include those Purchases made from a selected set of (one or more) Vendors within the specified Date Range. |
| o | Click the Search button (as shown above) in the Select Vendors field to open the Select Vendor dialog. |
| o | Locate the desired Vendor(s). |
| o | Using the (F2)-Search field feature to locate a Vendors record: |
| i. | Click on the Field in the first record line of that selected Header Name Column to Select the Header Name to search by. |
| ii. | Press F2 to position the cursor (and clear any previous entries) in the(F2)-Search field. |
| iii. | Enter characters for the search which will then be compared to the data in the selected Column. |
| iv. | As characters are entered, an incremental search is performed on the data within that Column. |
| v. | Check the desired record(s) when the desired record(s) are located. |
| o | Repeat this process until you have located, and Checked each required record. |
Select Vendor dialog
| o | Check the Selected box for each Vendor's Purchases which are to be included in the report. |
| o | Remember, more than one Vendor may be selected. |
| o | Click the OK button to Close the Select Vendor dialog and insert the selected Vendor IDs in the Select Vendors field. |
| ▪ | All Items - By default, Any Purchase Categories that were Invoiced within the specified Date Range will be included (limited only by any Specific Selection Options chosen above or below). |
| o | Click the Search button (as shown above) in the Select Items field to open the Select Purchase Item dialog. |
| o | Locate the desired Purchase Item(s). |
| i. | Click on the Field in the first record line of that selected Header Name Column to Select the Header Name to search by. |
| ii. | Press F2 to position the cursor (and clear any previous entries) in the(F2)-Search field. |
| iii. | Enter characters for the search which will then be compared to the data in the selected Column. |
| iv. | As characters are entered, an incremental search is performed on the data within that Column. |
| v. | Check the desired record(s) when the desired record(s) are located. |
| o | Repeat this process until you have located, and Checked each required record. |
Select Purchase Items dialog
| o | Check the Selected box for each Purchase Item that is to be included in the report. |
| o | Click the OK button to Close the Select Purchase Items dialog and insert the selected Purchase Category Codes in the Select Items field. |
| ▪ | All - By default, any General Ledger Account assigned to any Purchase Categories that were on any Bills entered within the Date Range specified above, will be listed (limited only by any Specific Selection Options chosen above or below) |
| o | Click the Search button (as shown above) in the Select Accounts field to open the Select Purchase Item dialog. |
| o | Locate the desired Purchase Item(s). |
| i. | Click on the Field in the first record line of that selected Header Name Column to Select the Header Name to search by. |
| ii. | Press F2 to position the cursor (and clear any previous entries) in the(F2)-Search field. |
| iii. | Enter characters for the search which will then be compared to the data in the selected Column. |
| iv. | As characters are entered, an incremental search is performed on the data within that Column. |
| v. | Check the desired record(s) when the desired record(s) are located. |
| o | Repeat this process until you have located, and Checked each required record. |
Select GL Purchase Acct. dialog
| o | Remember, more than one Purchase Account Number may be selected. |
| o | Click the OK button to Close the Select GL Purchase Acct dialog and insert the selected General Ledger Account Numbers in the Select Accounts field. |
| • | Invoices - Specify which Invoice Numbers assigned to Bills are to be included in the report. |
| ▪ | All - By default, all Invoice Numbers assigned to Bills that were Invoiced within the specified Date Range will be included (limited only by any Specific Selection Options chosen above or below). |
| ▪ | Select Invoices - Click this button to choose which Invoice Numbers assigned to Bills are to be included in the report. |
| o | Enter the desired Invoice Numbers (each one separated by a comma) of the Bills with the Purchases that are to be included in the report |
| • | Division - Using the Drop-Down Selection List provided, Choose a Division or Division Group code to restrict the report to Purchases entered within the Date Range specified above (and limited by any Specific Selection Options chosen above) to Purchases made from Vendors that were assigned to the selected Division or Division Group. |
| • | Charts - If One or more Vendors and All Purchase Items, or All Vendors and One or more Purchase Item is Selected, a Chart may be included in the report so that option will be displayed automatically at the bottom of the Purchase Analysis Report dialog. |
| ▪ | A Chart selection is not required - the default is[none]. |
| ▪ | If a Chart is desired, use the Drop-Down Selection List provided to Choose either the Pie or Bar Chart (which will include an explanatory Legend) that is to be included as part of the Purchase Analysis Report output (see sample below). |
Purchase Analysis Report - Charts option - Selected Vendor(s) and All Items
| ▪ | The Charts Drop-Down Selection List is only offered when either the combination of the All Vendors and Select Items, or the Select Vendors and All Items Selection Option set is chosen. |
| ▪ | When one of these option sets is selected above, the Charts Drop-Down Selection List will be displayed. |
Purchase Analysis Report with Pie Chart and associated Legend
| • | Print - Click the Print button  to Preview and optionally Print (to a File or a Printer) this Purchases Analysis Report. |
| • | Preview - The Preview tab presents the report which resulted from the Options you've selected. |
| • | Click the Plus Sign ("+") to the left of any Invoice Number (within the Invoice # column as shown in the illustration below) to display that Bill Form. |
Purchases Analysis Report - Preview with Bill Form
| • | Arrows - Click the arrows to move through the record. |
| • | Home -  - Using either the screen or your Keyboard's Home key, moves the report to the top of the first page. |
| • | End -  - Using either the screen or your Keyboard's End key, moves the report to the bottom of the last page |
| • | Arrows - The arrows allow you to move back and forth, from page to page. |
| • | Number - Indicates the page number you are viewing. |
| ▪ | You may also type in a specific page number, Press 8 Enter and that page will be displayed immediately. |
| ▪ | If you enter an invalid page number, it will be ignored. |
Purchases Analysis Report - Preview tab
| • | Fit To Page - Click the first button after the arrows to size a full page of the report to fit the screen. |
| • | Zoom To 100% - Click the second button after the arrows to display the page at 100% (of the printed view). |
| • | Fit To Page Width - Click the third button after the arrows to size the page of the report to fit the full width of the screen. |
| • | Zoom To Percentage - Click the fourth button after the arrows to re-size the page of the report by percentage. |
| ▪ | When you Click the Zoom To Percentage button, the Percentage selector will be displayed. |
| ▪ | You may then Click the Up or Down ‚ arrows to set the exact amount of Zoom you want. |
| • | Print - Click the Print button to Print (to a File or a Printer)  the displayed Purchases Analysis Report. |
| • | Email - Click the Email button  to send the Report to an Email Address of your choosing. |
| • | Data View - This view provides a tabular (spreadsheet style) presentation of the selected data. |
Purchases Analysis Report - Data View
| • | Export - Exporting the data from this Data View Form (note the "fly-over" help available on these buttons): |
| ▪ | Export to CSV - Click the first button after the arrows to export the data to a Comma Separated Values (CSV) file format. |
| ▪ | Export To Excel - Click the second button after the arrows to export the data to an Excel (.xls) file format. |
| ▪ | Export To Html - Click the third button after the arrows to export the data to an HTML formatted file. |
| • | Exit the Form by Clicking the Close button x on the right at the top of the Form. |
