Product Usage Reporting - Revision history

Jgullickson at 18:50, 10 April 2019

2019-04-10T18:50:09Z

Jgullickson at 18:48, 10 April 2019

2019-04-10T18:48:00Z

Lpickett at 19:29, 28 June 2017

2017-06-28T19:29:40Z

Jvargo at 19:05, 28 June 2017

2017-06-28T19:05:19Z

Jvargo at 19:04, 28 June 2017

2017-06-28T19:04:09Z

Jvargo: Created blank page

2017-06-28T18:54:18Z

Created blank page

New page

← Older revision		Revision as of 18:50, 10 April 2019
Line 12:		Line 12:

	For example, Product Code A represents gas cylinders that get filled with 1200 SCF (standard cubic feet) of Argon and 75 SCF of Helium. If we know that Location XYZ filled 10 cylinders of Product Code A last month, we can calculate that they should have used 1200 x 10 = 12,000 SCF of argon and 75 x 10 = 750 SCF of Helium. These numbers can then be used by the client to compare against the raw materials that Location XYZ took in over that same time frame (i.e. bulk argon/helium/oxygen/ect.) and begin to calculate how much product might be getting lost in storage and/or the fill process.		For example, Product Code A represents gas cylinders that get filled with 1200 SCF (standard cubic feet) of Argon and 75 SCF of Helium. If we know that Location XYZ filled 10 cylinders of Product Code A last month, we can calculate that they should have used 1200 x 10 = 12,000 SCF of argon and 75 x 10 = 750 SCF of Helium. These numbers can then be used by the client to compare against the raw materials that Location XYZ took in over that same time frame (i.e. bulk argon/helium/oxygen/ect.) and begin to calculate how much product might be getting lost in storage and/or the fill process.
		+
		+	===Summary Reporting===
		+
		+	The summary version of the Product Usage Report is currently hosted on a page within the website called 'Product Usage Summary'. The page allows you to enter a date range (maximum of 31 days), choose a location (or all locations), and a single component.
		+
		+	The columns for this report are built dynamically using the Asset Families belonging to a special Asset Family Collection. The Asset Family Collection must be named 'Product Usage Rollup Categories'.
		+
		+	Within that collection, one or more Asset Families need to be defined. The Asset Families within this collection can be setup using any combination of Asset Category, Group, Type, and Product Code values needed. In this way, our clients are free to create arbitrary groupings of their assets and have those groupings appear as separate columns on the report.
		+
		+	===Detailed Reporting===
		+
		+	The detailed version of the Product Usage report functions similarly to the Summary report, but the Asset Families do not come into play. Instead, the detailed report presents a breakdown of each component at the product code level. The columns for this report are created dynamically, with one column for each component defined in the database.
		+
		+	The following columns are displayed in the detailed report:
		+
		+	* Location
		+	* Category
		+	* Group
		+	* Type
		+	* Product Code
		+	* Product Code Description
		+	* Quantity (indicates the quantity of that product code that was filled)
		+	* Total Volume (sum of all of the components filled for that product code)

@@ Line 4: / Line 4: @@
 |Business Process=Production
 }}
-Each product code can be assigned a certain amount of each raw material that it uses when filled. For example an Argon/CO2 mix would have a certain amount of Argon and CO2 that it uses. Reports can then be run to calculate the total amount of raw material pumped into cylinders in a give timeframe.

← Older revision		Revision as of 19:29, 28 June 2017
Line 4:		Line 4:
	\|Business Process=Production		\|Business Process=Production
	}}		}}
		+
		+	Each product code can be assigned a certain amount of each raw material that it uses when filled. For example an Argon/CO2 mix would have a certain amount of Argon and CO2 that it uses. Reports can then be run to calculate the total amount of raw material pumped into cylinders in a give timeframe.

@@ Line 1: / Line 1: @@
 {{TrackAbout Module
-|Module Description=With the TrackAbout Product Usage Reporting module you can create reports showing the amount of gas that goes into the products you sell.v
+|Module Description=With the TrackAbout Product Usage Reporting module you can create reports showing the amount of gas that goes into the products you sell.
 |Supported In=TAMobile 5, TAMobile 6 Rugged, TAMobile 6 Desktop, TAMobile Android, TAMobile iOS
 |Business Process=Production
 }}

← Older revision	Revision as of 19:04, 28 June 2017
Line 1:	Line 1:
−	+	{{TrackAbout Module
	+	\|Module Description=With the TrackAbout Product Usage Reporting module you can create reports showing the amount of gas that goes into the products you sell.v
	+	\|Supported In=TAMobile 5, TAMobile 6 Rugged, TAMobile 6 Desktop, TAMobile Android, TAMobile iOS
	+	\|Business Process=Production
	+	}}