Follow

ID754 - Serialized Inventory In Stock (Power BI) Overview & Sample:

Slice & Dice your In Stock Serialized Inventory

Jump to a specific section by clicking a link

Overview | Samples | Variables | Alert Functionality | Power BI Reporting | Related Alerts | Webinar

 

Click to Subscribe and Download Template

 

Overview

Overview

This PBI version of ID501 provides a list of serialized equipment (with the option to also show linked accessories) available in specified warehouse(s) and with set Status and/or Condition Codes. Intended to be a used inventory report for your Sales Team.

 

Type of Output: On Demand Report Power BI Report

 

*  *  *

Sample

Sample

ID754Sample.png

 

*  *  *

Variables

Variables

 

ID754VarY.png

Variable Y: Custom Property on Equipment Record storing a specific Sales Rep Cost

This enables us to pull that Cost Value into report when selecting SalesRepCost:

ID754SRCost.png

 

*  *  *

Alert Functionality

Alert Functionality

1. See here for getting Power BI in place. 

2. For ECi Hosted clients: We work with ECi to open up our access so we can set an ODBC connection for you. If you are interested, then please provide us the public static IP address for your company network so that ECi can whitelist it to allow us access.

3. Download template HERE

4. Built as very light weight report so you can easily refresh up to 8-times per day (with minimum Power BI Pro License) and easily build a dashboard for your Sales Team.

 

*  *  *

Power BI Reporting

Power BI Reporting

1. Landing Page provides sections of pre built reports and sections for custom report building:

ID754 landing page.png

2. The Equipment Cost (Pre-Built Reports) was created so you could create a Sales Department Dashboard showing all inventory available for sale:

ID754Like501a.png

ID754Like501aa.png

ID754Like501b.png

3. Report will show your Sales Rep cost (not actual cost), if you use SalesRepCost filter AND are populating  the Custom Property listed in VariableY of your ID754 subscription with the Sales Rep cost. You may already be doing this for ID501/Serialized In-Stock Host Equipment.

Please use THIS LINK to see how to build this Custom Property if you do not have it already.

ID754SRCost.png

ID754SRCost1.PNG

 

4. Build your own reports - not only do you have filters at top, but then use 'Slice By' section on left to select what data you want to see in report results on the right. 

ID754Custom.png

5. Use Filters at Top to narrow down to info you seek:

ID754Filters.png

6. Right click on rows to get to more detail:

ID754DrillThru.png

 

*  *  *

Related Alerts

Related Alerts

ID411 - Wholesale Inventory

ID772 - Inventory Management

*  *  * 

Webinar

Webinar

**COMING SOON**

 

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