Follow

ID73 - HP Amplify Inventory Report Overview & Sample

HP Amplify Inventory Report

Jump to Overview | Samples | Variables | Alert Functionality | OnDemand Report Filters |  Related Alerts |

Click to Subscribe 

Overview

Overview

For HP's Amplify Program, CEO Juice has created On Demand SSRS Report and email process for you to easily send reporting requirements to HP. Our trio of alerts will email you a report you can then send on to HP (cdm.na.inquiry@hp.com). We do not send this on your behalf to HP.

Our trio of alert ID's: - be sure to subscribe to ALL three:

Our HP Amplify Inventory Report (ID73) is based on Current Inventory.

Our HP Amplify Transactional and Managed Sales Report (ID769) is based on items consumed on both Sales Orders and Service Calls.

Our HP Amplify MIF Report (ID620) is based on Contract Records.

 

Run Schedule: Sunday evenings

Type of Output: Email and On Demand SSRS Report

 

*  *  *

Sample

Sample

This entire report is based from required HP Template attached below.

Column headers are color coded:

Green = Required by HP

Blue = Business Conditional if required by HP

Gray = Optional

ID73Sample.PNG

Columns Explained

Columns Explained

ID73Header.PNG

Row 1 is your HP Dealer Information in format REQUIRED by HP, so please do not change.

Row 1 / Column A = IH - Information Header

Row 1 / Column B = Your Reported ID per Variable5 on ID73 subscription

Row 1 / Columns C, D, E = Your Main Branch Name, Country, City

Row 1 / Column F = Date of Report (always runs Sunday evenings)

Row 1 / Column G = Is re-submission, Y (Yes) or N (No), defaults to N (No). If you are re-submitting a report, you will need to manually change this to Y and change Column F to Date of Report

ID73_2.PNG

Rows 2+ are all ID - Information Data (Items in Inventory) per eAuto

Column A - ID - Information Data (leave this column as is)

Column B = Item Number

Column C = optional, Product Code 

Column D = optional, UPC Code

Column E = Item Number

Column F = Quantity on Order per eAuto

Column G = Quantity on Hand per eAuto

Column H = Quantity in stock allocated to be returned to supplier / Allocated as defective in eAuto

Column I = Reserved Inventory - Quantity Unavailable / On back order per eAuto

Column J = Quantity available for sale per eAuto

Column K = Quantity in float (In transit between partner warehouses)

Column L = Inventory Unit Value / eAuto's Unit Price

Column M = Inventory Valuation

ID73_3.PNG

Columns N, O, P = Your Main Branch Name, City, Currency

Column Q = Item Description per eAuto

Column R = Ageing Date

Column S = Purchasing Source wholesaler indicator

Column T = Quantity in holdout / Demo

Column U = Backorders

Column V = Sell In Quantity from HP / Receipts for that week direct from HP 

Column W = Sell In Quantity / Receipts for that week 

The very LAST row is summary:

ID73Summary.PNG

Column A is always 'IT' and is some sort of abbreviation needed by HP indicating totals

Column B is the count of records

Column C is the sum of the quantity on hand

Column D is the sum of the quantity available for sale.

 

*  *  *

Variables

Variables

All variables are optional, except for Variable5. Variables used to tell our reporting HOW you identify your HP Item Records. These variables are like filters and function as an AND filter. So a given Item Record would need to have all codes you list in each variable.

ID769Variables.PNG

Variable W: Item Categories to Include (separate multiples with comma)

Variable X: Inventory Codes to Include (separate multiple with commas)

Variable Y: Sales Codes to Include (separate multiples with commas)

Variable Z: Service Codes to Include (separate multiples with commas)

Variable 1: Yes or No, Include OEM Compatible Items?

Variable 2: Yes or No, Include only items with HPAmplifyReporting custom property set to Yes?

Variable 3: Makes on Item Records to Include (separate multiples with comma)

Variable 4: Models on Item Records to Include (separate multiples with comma)

Variable 5: HP assigned Partner Reporter ID

All of these variables (except for Variable5, your Reporter ID) are found on Item Record:

ID769ItemRecord.PNG

New variables as of 20210730 version:

New variables as of 20210730 version:

ID73Var6.PNG

Variable 6: Include/Exclude Managed/Transactional SKUs (as define by HP)

0 = Report both Managed and Transactional SKUs

1 = Report Managed SKUs only

2 = Report Transactional SKUs only

Variable 7: Item Number or OEM Number (this number will populate in ColumnB and ColumnE on report)

Which field to pull Partner Reported ProductID field and Reseller's Product Number from. 

0 = Pull from item number field in Eautomate

1 = Pull from OEM Number field in Eautomate

 

 

*  *  *

 

Alert Functionality

Alert Functionality

-This entire report is based from required HP Template attached below.

-Reports on HP items you've identified via your variable settings and is a snapshot of your eAuto Inventory at the time report runs. It can not be run for past period time filters. 

-Will show items that were in stock but aren't any longer.

-Our HP Amplify alerts email you .xls file format. HP requires .csv file, so you will need to save as .csv for submission to HP.  Format is V2_Type_AMPLIFY_ReporterID_DateFROM_DateTO:

ID73FileName.PNG

 

-Emailed report shows your variables selections, so be sure these are correct and make any needed changes to your variables on ID73 subscription:

ID73Email.PNG

Be sure to say YES to this warning:

ExcelError.PNG

AND save as CSV (comma delimited) (*.csv):

csv.PNG

 

 

*  *  *

OnDemand Report Filters

OnDemand Report Filters

Users will need eAuto permissions to run Inventory Reports.

When running via SSRS, you need to export it to Excel and save the file. Then open it and save it as csv before submitting it to HP. This ensures the column headers stay as needed.

All filters optional, except for ReporterID. Filters are used to tell SSRS Report HOW you identify your HP Item Records. These filters are an AND filter statement, so a given Item Record would need to have all codes you list in each variable.

Enter multiple entries in each field with comma(s).

ID73SSRS.PNG

 

The above filter settings correspond to these fields on an Item Record:

ID769ItemRecord.PNG

Item Number or OEM Number refers to which field to pull Partner Reported ProductID field and Reseller's Product Number from:

ID73SSRSOEM.PNG

ID73OEM.PNG

Include / Exclude Managed SKUs gives options on whether to include or exclude Managed and/or Transcations SKUs based on a table of SKU numbers, provided to us by HP, that are considered by HP to be "Managed" item numbers as opposed to "Transactional" item numbers:

ID73SSRSSKU.PNG

 

*  *  *

Related Alerts

Related Alerts

ID620: HP Amplify MIF Report

ID769: HP Amplify Transactional and Managed Sales Report

 

*  *  * 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk