HP Amplify Transactional and Managed Sales Report
Jump to Overview | Samples | Variables | Alert Functionality | OnDemand Report Filters | Webinars | Related Alerts | Initial Steps to start
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.data.submission@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 Transactional and Managed Sales Report (ID769) is based on items consumed on both Sales Orders and Service Calls.
Our HP Amplify Inventory Report (ID73) is based on Current Inventory.
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
Column headers are color coded:
Green = Required by HP
Blue = Business Conditional if required by HP
Gray = Optional
Columns Explained
Columns Explained
Partner Purchase Price Currency Code = Currency of your company per the Main Branch Customer Record. If country contains US, then it will be USD. If country has CA in it, then it will show CAD.
Reporter ID = Your HP Reporter ID (set in Variable5)
Reporter Company Name = Your Company Name per the Main Branch Customer Record.
Sell From fields = from your Main Branch Customer Record **FYI Sell From Address Line 2 will ALWAYS be blank (eAuto's background tables group Address Line 2 into Address Line 1 - we cant get rid of this column as required by HP)
Ship To and Sell To fields = Populate from either Sales Order or Service Call. Ship To is Ship To in eAuto and Sell To is Bill To in eAuto
**PENCIL EDITS DO NOT POPULATE / DO NOT USE PENCIL EDITS**
Sales Order Bill To / Ship to found here:
Service Call Bill To /Ship To found here:
Partner Reported Product ID = eAuto Item Number
Channel Partner to Customer Transaction Date = eAuto Invoice Date
Reseller's Product Number = eAuto Item Number
Channel Partner to Customer Invoice ID = eAuto Invoice Number
Deal ID #'s = No common business practice, you will have to manually fill out if your business conditional requires
Marketing Sub Program Code = No common business practice, you will have to manually fill out if your business conditional requires
Product Serial ID Assigned by HP = Serial Number per Sales Order (nothing populating from Service Calls)
Sell from Location ID = per your Main Branch Customer Record
Sell From Name = per your Main Branch Customer Record
Contract ID = eAuto Contract Record Number - in order for this to populate Contract Record MUST be linked to Sales Order and/or Service Call
Contract STARTDATE = eAuto Contract Record Start Date
Contract ENDDATE = eAuto Contract Record Expiration Date, if NONE (i.e. auto renew/evergreen contract), then ENDDATE is 7-years from Start Date as HP requires this field
ALL of the above in gray are HP business program specific and will need to be manually filled in by you.
* * *
Variables
Variables
All variables are optional, except for Variables 5, 6, 7..
Variables W, X, Y, Z, 2, 3,4 are 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.
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:
Variable 6: Include/Exclude Managed/Transactional SKUs (as defined by HP) - blank defaults to 0
0 = Report both Managed and Transactional SKUs
1 = Report Managed SKUs only
2 = Report Transactional SKUs only
HP gave us a list of items that are considered Managed SKUs. We put those items in a table. If you have Var6 set to 1 then we only report on items in that table. If you set Var6 to 2 then we only report items not in that table based on their other variable settings. If set to 0 then we report on everything based on their other variable settings.
Variable 7: Item Number or OEM Number (this number will populate in ColumnAA and ColumnAC on report) - blank defaults to 0
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
Variable 8: Order Type(s) to include on report. Separate multiples with commas OR leave blank for All
Variable 9: Branch Numbers to include on report. Separate multiples with commas OR leave blank for All
* * *
Alert Functionality
Alert Functionality
1. Is based on items consumed on both eAuto Sales Orders and Service Calls.
2. We consider transaction based on invoice create date instead of invoice date to make sure we are capturing all transactions done in the time period regardless of manual invoice date change.
3. Excludes any transactions done against a fixed asset type warehouse.
4. 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:
5. While files need to be sent to cdm.na.data.submission@hp.com, if you have a data reporting questions or an inquiry, please email: cdm.na.inquiry@hp.com
6. Emailed report shows your variables selections, so be sure these are correct and make any needed changes to your variables on ID769 subscription:
Be sure to say YES to this warning:
AND save as CSV (comma delimited) (*.csv):
7. Formatting issues from HP? Some clients are getting file submissions rejections from HP. HP WILL NOT accept comma's or carriage returns in the .csv file (most eAuto users have both on their Customer Records). So you will need to "clean up" your excel file first using Find and Replace function in excel.
Step 1: Enter , (comma) in Find What and set Replace With as blank:
Step 2: Enter Ctrl-J (carriage returns which puts a blinking . (period) in the Find What cell, set Replace With as blank:
Step 3: Now save file as CSV UTF-8 (comma delimited) and send off to HP:
8. If HP has assigned a separate Location ID for each of your branches, then you can setup a Custom Property named 'HPAmplifyLocationID' on each of the branch customer records to populate with this Location ID. That Location ID will then be used for to populate ColumnAM (Sell From Location ID):
Creating Custom Property HPAmplifyLocationID:
Creating Custom Property HPAmplifyLocationID:
Step 1:
Via Tools / Lists & Codes / Attributes, create new:
Attribute name: HPAmplifyLocationID
Description: HPAmplifyLocationID
Data type: Text Box
Step 2:
Add this Attribute to your Customer Configuration via Tools / Lists & Codes / Configurations (custom properties):
Double click on Configuration listed for Customer Properties Group:
Then use search in Available attributes to add HPAmplifyLocationID, select QuickAdd, leave NO default value, then select OK:
Checklist as you get started:
Checklist as you get started for ALL HP Amplify Reports:
Step 1: Are you subscribed to all three needed alerts with email recipients listed as needed to receive emailed reports?
ID769: HP Amplify Transactional and Managed Sales Report
-be sure to fill in all needed variables
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.
ID73: HP Amplify Inventory Report
-be sure you fill in all needed variables
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.
ID620: HP Amplify MIF Report
Variables used to tell our reporting HOW you identify your HP MIF. These variables are like filters and function as an AND filter. So a given Equipment or Contract Record would need to have all codes you list in each variable.
-be sure you fill in all needed variables and create Custom Property for Equipment Records, per this link: https://support.ceojuice.com/hc/en-us/articles/360058164991-ID620-HP-Amplify-MIF-Report-Overview-Sample#h_01F0CNXBHHRE3J0KEJP1J3XPWS
Needed emails set as recipients on each subscription via Details tab on all three alert ID's? You CAN NOT list HP's emails address here, you will need to submit to them directly at cdm.na.data.submissions@hp.com
:
Step 2: HP Amplify requires country be listed on their report. Per HP must be US (for USA) or CA (for Canada), so be sure you have country populated on your Customer Records in eAuto (most dealers are not already doing this). You can complete this via Tools / Bulk Update in eAuto. We suggest updating ALL, even inactive Customer Records, just to ensure everything covered for HP.
(right click on image below to enlarge)
Step 3: Make sure you have needed coding in eAuto to identify Online and Drop Ship Sales Orders:
Step 4: Create needed Custom Properties.
HPAmplifyReporting - used on Item Records (for ID769 and ID73) and/or used on Equipment Records (for ID620) to identify which Item and/or Equipment Records to consider for reporting
HPAmplifyLocationID - used on Branch Customer Records to specifiy a separate Location ID for each of your branches in ColumnAM/Sell From Location ID
Custom Property
Custom Property
Custom Property HPAmplifyReporting
Step 1:
Via Tools / Lists & Codes / Attributes create new:
Attribute Name = HPAmplifyReporting
Description = HPAmplifyReporting
Data type = Yes/No
Custom Property Step 2:
Then go to Configurations (custom properties) and double click on Configuration typically named Item that is set for Group = Item Properties (this is enables you to assign the Custom Property to Item Records):
Use Quick Search to find HPAmplifyReporting, select quick add and leave default value blank, then select OK to save:
Custom Property HPAmplifyLocationID:
Step 1:
Via Tools / Lists & Codes / Attributes, create new:
Attribute name: HPAmplifyLocationID
Description: HPAmplifyLocationID
Data type: Text Box
Step 2:
Add this Attribute to your Customer Configuration via Tools / Lists & Codes / Configurations (custom properties):
Double click on Configuration listed for Customer Properties Group:
Then use search in Available attributes to add HPAmplifyLocationID, select QuickAdd, leave NO default value, then select OK:
Step 5: If you would like CEO Juice to update Custom Property to YES on your Item Records, please email us an excel list of Item Record Numbers needing to set with YES to help@ceojuice.com. Please be sure you have created the Custom Property per Step 3 above first. (We can also do this for your ID620/HP MIF Report which will need Custom Property set to YES on Equipment Records-please send us excel list of Equipment ID's)
Step 6: If you haven't already, be sure to notify MarketBridge PlayCaller you have moved to submitting directly to HP. There isn't a specific contact at MarketBridge that you need to let know. If you get one of their automated emails asking you to submit the HP files then respond by saying you are using the CEOjuice reports and will be reporting directly to HP and ask them to remove you from their list.
* * *
OnDemand Report Filters
OnDemand Report Filters
1 - Be sure your filters match your ID769 variables (filters) EXACTLY.
All filters optional. Filters are used to tell SSRS Report HOW you identify your HP MIF/Equipment Records. These filters are an AND filter, so a given Equipment/Contract Record would need to have all codes you list in each filter.
2 - Enter multiple entries in each field with comma(s).
3 - Users will need eAuto permissions to run Inventory Reports.
4 - When running via SSRS, you need to export to Excel and save as excel. Then open it again and save it as .csv before submitting it to HP. This ensures the column headers stay as needed. Be sure to save the file with this naming convention required by HP: V2_Type_AMPLIFY_ReporterID_DateFROM_DateTO:
Step 1:
Step 2:
* * *
Custom Property HPAmplifyReporting MUST be set to YES on Item Records for Custom Property filter to work.
The above filter settings correspond to these fields on an Item Record:
Item Number or OEM Number refers to which field to pull Partner Reported ProductID field and Reseller's Product Number from:
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:
* * *
Related Alerts
Related Alerts
ID73: HP Amplify Inventory Report
ID620: HP Amplify MIF Report
* * *
Webinars
Webinars
Webinar on HP Amplify Reporting 03/09/2021:
(OLD) Webinar on HP Amplify Reporting 02/16/21:
0 Comments