Using Vendor Report Card

Features of Vendor Report Card

• Report Card – Excel output with metrics for:

• • Sales

  • Inventory

  • Orders

  • Freight and Adjustments

• Basic Program Information

• • Vendor Report Card definition UI in Compass

  • Vendor Viewer

  • Vendor Report Card Viewer

  • Market Basket by Category Enhancements

  • Mapped MVR Contacts

  • Mapped Vendor Change Log

  • 100+ new fields in Eagle MVR and Compass

Minimum Eagle and Eagle for Windows PCO Levels

• Compass – 12.1.0.280

• E4W – 24.2913.001

• PCO – 36.0745

Eagle for Windows Licensing Options

• E4W1325 – Vendor Report Card on System = Y

• E4W1017 – Compass Client on System = Y

• E4W8829 – Compass Analytics on System = Y

• E4W1096 – Vendor Viewers on System = Y

• E4W1032 – Purchase Order Lifecycle on System = Y

• 1. • Option 9676 – 365 days

     • Option 9677 – 999 days

     • Option 9617 – 1, 2, 3, 4, 5, 6, 7, 8, 9, A, B, C, D, E, F, G       

• MSY2001 – Compass Database on System = Y

• E4W43 – Inventory Transaction Register = Y

• E4W8628 – Advanced Receiving

Important:

Eagle Options Required

• Option ID 496 – Large Field Sizes

• Option ID 8857 – 10 Digit PO Numbers

• Option ID 100 – Assign PO Automatically

• Option ID 101 – Set Next Available PO Number

Compass Data-Cubes Required

Inventory Valuation Cube in Compass (IN_SNAP) or Historical Inventory Cube in Compass (IN_SNAPEXT)  

Note: These cubes may need to be derived if they don’t exist in your system already.  Talk to your implementation specialist.

Eagle for Windows Security Bits

• MSE 1065 – Ability to access the VRC tabs of MVR

• MSE 1066 – Ability to change fields on the VRC tabs of MVR

• MSE 834 – Access to Compass Analytics (if building any reports)

Getting Started with Vendor Report Card

Adding a Vendor Report Card Definition

1. Add a report card definition on the left panel by clicking the green plus sign
2. Fill definition page as desired

Important: If you do not have Advanced Receiving, do not check the box for “Freight and Adjustments”

3. Save, or Save and Run Now – this places the results in the Spooled Task pages in Compass

Note: These report cards may also be scheduled in a task.

Vendor Market Basket

Vendor Viewers

1. Viewers allow changes to Eagle data via a grid. Both of these viewers are included in the Vendor Report package.

2. Security / Option settings for Viewers to work.

• • MSE813 – Allowed to change vendor name

  • MSE176 – Allow changes to vendor information

  • MSE175 – Ability to delete vendors

  • MSE174 – Ability to add vendors

  •  MSE173 – Ability to view vendor history

  • MSE172 – Ability to view basic vendor information

  • VRC – MSE1066 – Ability to change tabs 7, 8, and 9 in MVR

  • VRC – MSE1065 – Ability to view tabs 7, 8, and 9 in MVR

  • VRC – E4W1325 – VRC on system

MVR Enhancements – UI and Fields

Note: Over 100 new fields in tabs 7, 8, and 9 of MVR

 Report Card Output

1. Report Definition Tab

2. Report Card Definition – Name given to the Report Card  

3. As of Date – Point in time that determines the “last possible date” for sales, inventory valuation, orders, and adjustments

4. Remaining fields are self-explanatory

2. Sales Tab  

3. These metrics use “current” department, class, fineline, and manufacturer – “historical” vendor, or vendor at time of transaction is used for vendor.

1. • Net Sales Units, Net Sales Dollars, GM%, GM Dollars – From sales detail – YTD and LYTD are “as of date” or today, if report card definition “as of date” is blank

   • Returns Sales Dollars, Defective Sales Dollars, and Number of Transactions – From Sales Detail – Returns and Defectives percentages are using Total Sales as the denominator. Number of Transactions increment wherever a return or defective “unit” exist.

3. Inventory Tab

Things Vendor Report Card checks for:

• MIC102 – which cost should be used – Average or Replacement

• Code first checks to see if INsnap_ext table exists and if so, uses that table:

• Target Average

• Target Replacement

• Overstock Average

• Overstock Replacement

• 1. •  If INsnap_ext doesn’t exist on the system, these rows are blank

• “As of Columns” find closest date to report card’s “As of Date”, uses today if blank or if “As of Date” is in the future

• Keep Stock Data = Y

These metrics use “current” department, class, fineline, and manufacturer – “historical” vendor, or vendor at time of snapshot is used for vendor.

1. Inventory Value – This is an average value – adds up all entries it finds for desired time period and divides by the number of entries found.  For most recent 12 months, it adds the current value to the total, and adds one to the denominator.

   • If INsnap_ext doesn’t exist, we check for INsnap – INsnap only has Average Cost however.

2. Order Point $, % of Order Point, Overstock –

   • If INsnap_ext is available, we pull “Target Inventory At Average (or replacement)”  - else cells are left blank

3. Sales – Net Sales from Sales Detail for desired time period

4. Cost – Cost from Sales Detail for desired time period

5. GM% – GM% from Sales Detail for desired time period

6. Units Sold – Net Sales Units from Sales Detail for desired time period

7. Avg QOH – Add the QOH for every record in either INsnap or INsnap_ext divided by number of entries found

8. Turns – COGS / Average Inventory Value – both factors are for the same time period

9. GMROI – Turns * GM%

10. Days of Supply – 365 / Turns

11. Sell Thru % Units – Units Sold / (QOH + Units Sold)

12. Sell Thru % Dollars – Dollars Sold / (Current On Hand Value + Dollars Sold)

4. Orders Tab

Things Vendor Report Card checks for:

• Only “claims” rows include type C and D orders – all other counts and dollars exclude type C and D orders

• Open Purchase Orders (those that still exist in the PO Header or PO Detail tables) are always excluded from analysis.

• Lead Times for this application are computed as the number of days between the last receipt of items and the original “Date of Record” (date of first event – 201, 202, 602)

• Some of the values on the Program tab are numberic calculations such as dollars received last year. These values are summed across stores and are taken directly from the VM table. The time period for those values can be different from used on the Orders tab, open POs are included in the VM numbers but not the order analysis and various department / class / fineline filters will not be applied to the values on the Program tab. So, it should be alarming if the values on the Program tab don’t exactly match the corresponding values on the Orders tab.

Field Definitions

1. # Orders – count of all purchase orders that have their first event (“date of record”) as a 201, 202, or 602.

2. # Order Lines – count of distinct Store/SKU on the purchase orders above – if a PO has both a 201 and a 602 for example, we only count the Store/SKU for the first event

3. # Shipments – count of distinct dates for each PO for each store that was received on any of the POs above.

4. # SKUs Received – counting distinct PO / Store / Item on the shipments

5. # Orders Not Received – List of POs in “# Orders” that aren’t received, or still in MPO

6. # Claims – count of type C and D POs

7. Claims % of Orders – calculation (# Claim Orders / (# Claim Orders + # Orders)

5. Freight Tab

• Two new fields in Advanced Receiving Header

• Accumulated Freight

• Accumulated Other Charges

• From ITR

• Shrinkage Qty

• Shrinkage Cost

6. Program Tab

7. Various fields from MVR

8. New fields from new tabs in MVR

9. Other standard fields in MVR

10. If fields are different for each store, and multiple stores are selected in the report card, then each unique field value will be displayed

11. If multiple vendors are included in the report card, then a column for each vendor will be reported