Vendor Line Reports

The Vendor Line Reports screen is used to generate the 'Lines / Supplier List Report', 'All Line List Report', and 'Suppliers With MFG Codes Report'. These reports provide easy-to-reference line specific information.

 

Menu Path: Reports, Inventory, Vendor Line Report, Vendor Line Reports screen

 

 

Quick Reporting Options

Vendor List Report

Reports Line and Supplier related information. Supplier only, Line Codes only, or Supplier and Line Code information displays based on the selected 'Report Criteria'.

All Lines List Report
Reports Line related information.

Suppliers with Line Codes Report
Reports all Suppliers with all Line Codes per Supplier information.

 

Supplier Part Costs

Reports the supplier part costs associated within a location, set up in the Supplier Part Costs screen.

 

When that report's button is clicked, the system hides all existing fields on the 'Report Criteria' section and instead displays two fields, 'Location' and 'Supplier'. 

 

The 'Location' field is a search button and textbox that allows you to select the location(s) with which to filter the report. Note: When you select more than one location, the system sets the 'Multi-Location' drop-down to a value of 'Consecutive' and disables the drop-down.

 

The 'Supplier' field allows you to filter by supplier, or use all suppliers, the default. This field only displays supplier codes that exist on the Supplier Part Costs screen.

Report Criteria

Location
The 'Location' field is a search button and textbox that allows you to select the location(s) with which to filter the report. Note: When you select more than one location, the system sets the 'Multi-Location' drop-down to a value of 'Consecutive' and disables the drop-down.

Supplier
The 'Supplier' field allows you to filter by supplier, or use all suppliers, the default. This field only displays supplier codes that exist on the Supplier Part Costs screen.

Line Vendor Only
Reports all Lines with the 'Use As Vendor' flag, when checked.

Supplier Vendor Only
Reports Supplier specific information only, when checked.

Line and Supplier Vendor
Reports both Line and Supplier specific information, when checked.

Line Type
Filters the line type, as set in the 'Type' field in the Line Code Entry screen. 

Click the button to display the 'Line Types' pop-up used to select specific line type(s). 

Options are:

 

• 'Freight'

• 'Gift Cards'

• 'Labor'

• 'Parts'

Include any 'Line Type' by checking the box(es). Check the checkbox in the header to report all line types. Uncheck the checkbox in the header to deselect all line types.

When all are checked, 'All' displays in the 'Line Type' field. 

When more than one but less than all types are checked, 'Multiple' displays in the 'Line Type' field. 

When only a single line type is checked, that type displays in the 'Line Type' field.

Note: Reports both gift cards and merchandise cards when 'Gift Cards' is selected.

Include PN Code
Reports the PN Codes and descriptions within all lines, when checked. 

Available for the 'All Lines List Report' only. Not available when 'Include Alt. Line Codes' is checked.

Include Alt. Line Codes
Reports the alternate line code mappings used for purchasing when vendors use a line code other than what the store is using for line code, when checked. 

Available for the 'All Lines List Report' only. Not available when 'Include PN Code' is checked.

Sort By
Sort the report output by 'Line' or 'Line Group'.

Lines / Supplier List Report

The 'Lines / Suppliers List Report' lists line code related information. The following is an example of the 'Lines / Suppliers List Report':

 

 

 
Line Code
Reports the line code.  

Line Vendor Name
Reports the name of the line vendor.

Line Vendor Description
Reports the description of the line vendor.

Vendor Pri/Sec
Reports if the vendor is primary or secondary.

Use As Source?
Reports if the vendor is used as a Supplier if the 'Use As Vendor' flag is checked on the Line Code Order Specifics screen.

Timed Orders?
Reports if the vendor is set up for Timed Orders.

Total Lines / Suppliers
Reports the total number of vendor lines.

All Lines List Report

The 'All Lines List Report' details specifics for each selected 'Line'. The following is an example of the 'All Lines List Report' with 'Include PN Code' checked:

 

 

 
Line
Reports the line code.  

Line Name
Reports the line name.

Line Description
Reports the line description.

PN Code
Reports the line related PN Code.

PN Code Description
Reports the PN Code description.

Total Lines
Reports the total number of lines reported.

 

The following is an example of the 'All Lines List Report' with 'Include Alt. Line Codes' checked:

 

 

 
Line
Reports the line code.  

Line Name
Reports the line name.

Line Description
Reports the line description.

Alt1
Reports the alternate (ALT1) line code mapping, if applicable.

Alt2
Reports the alternate (ALT2) line code mapping, if applicable.

Alt3
Reports the alternate (ALT3) line code mapping, if applicable.

Alt4
Reports the alternate (ALT4) line code mapping, if applicable.

Alt5
Reports the alternate (ALT5) line code mapping, if applicable.

Alt6
Reports the alternate (ALT6) line code mapping, if applicable.

Total Lines
Reports the total number of lines reported.

Supplier List Report

The 'Supplier List Report' lists vendor names and related information. The report is first sorted by 'Group', then by 'Supplier Code'. The following is an example of the 'Supplier List Report':

 

 

 
Group
Reports the Supplier Group code.

Supplier
Reports the vendor code.

Supplier Vendor Name
Reports the vendor name.

Supplier Vendor Description
Reports the vendor description.

Vendor Pri/Sec
Reports if the vendor is primary or secondary. 

Source
Reports the vendor's source type.

Block on PO
Displays a 'Y' if the 'Block From PO' checkbox on the Supplier Order Specifics screen is checked for this vendor. Displays a blank if the checkbox is unchecked.

Timed Orders?
Reports if the vendor is setup for Timed Orders. 

Supplier With Line Codes Report

The 'Supplier With Line Codes Report' lists Supplier codes and all Line Codes under each Supplier as well as related information, such as the Supplier name, description, PN Group, PN Code Sales Class, and Order Type. The following is an example of the 'Supplier With Line Codes Report':
 

 

 
Line
Reports the  line code name.  

Line Desc
Reports the line code description.

PN Group
Reports the PN Group.

PN Code
Reports the PN Code.

Sales Class
Reports the Sales Class code.

Order Type
Reports a user-entered description used for filtering reports and orders.

Total Line Codes
Reports the total number of product lines ordered using this Supplier.

Supplier Part Costs Report

The following is an example of the 'Supplier Part Costs Report':

 

 

 
Location
Reports the location(s) which you sorted by in the 'Report Criteria' section of the Vendor Line Reports screen.

Sup Code
Displays the supplier 'Sup Code' from the Supplier Part Costs screen.

Line
Displays the line code of the part from the Main Part Entry screen.

Part Number
Displays the part number of the part from the Main Part Entry screen.

Description
Displays the 'Description 1' value of the part from the Main Part Entry screen.

Sup Part Cost$
Displays the part cost associated with the chosen supplier(s) from the Supplier Part Costs screen.

Sup Core Cost$
Displays the part's core cost associated with the chosen supplier(s) from the Supplier Part Costs screen.

Use In Best Price?
Displays the 'Use Best Price' value associated with the chosen supplier(s) from the Supplier Part Costs screen. In the 'Use In Best Price?' column, the system displays a blank value on the report for a value of 'Yes' on the Supplier Part Costs screen, and display a value of 'No' on the report for a value of 'No' on the Supplier Part Costs screen.