Vendor Analysis Report

This report prints the Vendor #, Class Code, Type Code, Name, Orders To Date, Commitments Outstanding, Invoices, Payments and a Balance for the Year specified.

If Reporting by Name or Number Sequence was Selected, the following prompts will display:

Vendor Summary/Invoice Detail

• Enter 'V' to view a summary balance for each vendor
• Enter 'I' to view an invoice count and total invoice balance for each vendor reported.

Enter Year

Start Period/End Period

The prompt that displays is dependent on what was entered for the first prompt (Vendor Summary/Invoice Detail).

• If 'V', you will be prompted to enter the year to report on, which will default to the year defined in the Finance Master Profile.  
• If 'I', you will be prompted for the starting and ending period, which will default to the starting and ending period for the year defined in the Finance Master Profile.

Starting at Name/Number

• Enter the vendor name/number at which you wish the report to begin.
• Accept the default for the report to begin at the first vendor name/number on file.

Ending at Name/Number

• Enter the vendor name/number at which you wish the report to end.
• Accept the default for the report to end at the last vendor name/number on file.

Suppress all Zero Lines

• Enter 'Y' to only report vendors with activity
• Enter 'N' to report all vendors, regardless of activity.

Enter Vendor Class

• Enter the vendor class on which you wish to report. Valid class types are:
  • 'F' - full range usage vendor
  • 'T' - temporary vendor
  • 'P' - purchasing vendor
  • 'S' - ship to vendor
• Accept the default to take the default of all vendor class types

Enter Vendor Type

• Accept the default to include all vendors in the report.
• Enter the vendor type if you wish to report on a selected vendor type.

Exclude Vendor Types (9 Max)

• Enter the vendor types to exclude from the report, (maximum of 9 types).
• Accept the default and no vendor types will be excluded.  This prompt will be bypassed if a vendor type code was selected for the previous prompt.

Sort by Type Code

• Enter 'Y' to sort the report based on the vendor type codes selected
• Enter 'N' to sort by vendor name/number only
• Enter 'S' to view a summary balance only for each vendor type code.  This prompt will be bypassed if a vendor type code was selected for the previous prompt.

Enter Vendor Status

• Enter 'A' to report on active vendors only.
• Enter 'D' to report on deleted vendors only.
• Enter 'B' to report on all vendors on file regardless of status.

Since Last Activity Date

• Enter the last activity date that you would like included on the report. The program will only report invoices that had any activity after the date entered.

Starting Postal Code

• Enter the starting postal code, as specifically as required

Examples:

• • Entering 'V' will begin at all postal codes beginning with 'V' (all of BC).
  • Entering 'V2V' will starts at all postal codes beginning with 'V2V' (all of Mission, BC).
• Accept the default to start at the beginning postal code ( '00000' – US postal code )

Ending Postal Code

• Enter the ending postal code, as specifically as required.

Examples:

• Entering 'V' will end at the last postal code beginning with 'V' ('V9Z 9Z9').
• Entering 'V2V' will end at the last postal code beginning with 'V2V' (V2V 9Z9').
• Accept the default to end at the last postal code ('Z9Z 9Z9' – Canadian postal code).

If the starting and ending postal codes are equal in the number of digits specified, the vendor report will be sorted by the postal code specified. (This could provide a cost savings in postage fees for the user.)

Example: Entering a starting postal code of 'V0A' and an ending postal code of 'V9Z' will sort all postal codes by the first three digits of the postal code. For example, all postal codes beginning with 'V0A' will be grouped together on the report, as well as in the mailing labels (if the export option is chosen for this purpose). In this example a postal group would be created for every major geographic area in an urban or rural location in BC based on the first three digits of the postal code.

Include Address]

• Enter 'Y' to include the address for each vendor in the report.
• Accept the default to select the option, which is 'No'.

Export Name, Address, Balances

The following fields are exported: vendor #, name, address, city, province, country, postal code, phone #, fax #, email, and financial balances (orders, outstanding orders, invoices, payments, balance).

The export file can be used to create mailing labels for the vendors in the report.  A file is created and displays in the top left corner of the report. If an export directory exists on your atrieve system.

IF Vendor Sort is Activated (In the Finance User Profile), the Following prompts will display when choosing a Report by Vendor Name

Starting at Sort Key

• Enter the sort key of the first vendor you wish to report on.

Ending at Sort Key

• Enter the sort key of the last vendor you wish to report on.