Exchange Balances - Revision history

Jgreco: Initial proofread pass - docs

2021-11-30T16:13:01Z

Initial proofread pass - docs

Jgullickson: /* How Exchange Type Affects Customer Balances */

2017-05-16T18:06:26Z

How Exchange Type Affects Customer Balances

Jgullickson: /* How Exchange Type Affects Customer Balances */

2017-05-16T17:20:54Z

How Exchange Type Affects Customer Balances

Jgullickson at 17:18, 16 May 2017

2017-05-16T17:18:47Z

Jwolbert at 04:00, 21 June 2016

2016-06-21T04:00:11Z

Eschurdak at 14:54, 28 April 2015

2015-04-28T14:54:43Z

Mwithum at 15:10, 18 March 2014

2014-03-18T15:10:02Z

Mwithum: Undo revision 3215 by Mwithum (talk)

2014-03-18T15:03:08Z

Undo revision 3215 by Mwithum (talk)

Mwithum at 15:02, 18 March 2014

2014-03-18T15:02:38Z

Jwolbert: Created page with "==Highlights== Some quick info on Exchange: * Exchange types can have negative balances * For exchange types, the list of barcodes is not related to the asset balance. * For ..."

2013-12-20T21:13:24Z

Created page with "==Highlights== Some quick info on Exchange: * Exchange types can have negative balances * For exchange types, the list of barcodes is not related to the asset balance. * For ..."

New page

==Highlights==
Some quick info on Exchange:
* Exchange types can have negative balances
* For exchange types, the list of barcodes is not related to the asset balance.
* For exchange types, the asset balance is just total ships minus the total returns over time.
** You can return a stolen exchange asset and still get credit for returning it.

==About==
"Exchange" asset types are small cylinders that are cheaper and are typically owned by the end customer (holder). A holder must normally "exchange" one of their tanks for one of the gas distributor. If the holder does not have any, he must buy one. A common example is an Acetylene MC size tank. It is only maybe a foot tall and worth $35. Distributors typically sell these rather than rent them. Most of our customers do not barcode these kinds of assets, but RBO does. Some customers do barcode medical exchange tanks, but not the industrial exchange tanks.

Rental was built before the issue of exchange types was introduced. Many clients would prefer to never rent these tanks and instead make the customer buy them. On further investigation though (the devil is in the details) there are cases where these tanks are rented. Even without rent, it is important to at least keep track of a running tally of which party owes the other party cylinders. For instance, if over several years a customer has been delivered 150 tanks and has returned 155 tanks, then the distributor owes the customer 5 tanks. If the distributor loses the business, they must give the customer 5 of these tanks.

Conceptually, for exchange type tanks, we need to have enough data to be able to calculate a running tally of delivers and returns over a time period without regard to exceptions or accounting adjustments. If an individual returns three exchange type tanks but doesn't pick up new ones, the vendor owes the individual three tanks. This means that the balance for the asset type can go negative, and TrackAbout should not "hold the line at zero", as it does for non-exchange types. It is for this reason that TrackAbout suppresses normal Asset Transfer Exception (ATE) processing during movement of the asset. If it did not suppress ATE processing, the line would be held at zero and the customer would not get credit for all returns.

Normally, we calculate a customer's balance by the following formula:
For each distinct Asset Type:
Count of unique (tagged) assets + DNS - RNS = Balance
For exchange types, this balance calculation will, over time, differ or drift away from the running Exchange Type rental balance. This is OK.

As mentioned, negative balances for exchange types are allowed. A negative balance just means that the distributor owes the holder some tanks.

If a distributor delivers a tank to holder A and then holder B returns it, this is ok. Holder A still owes the distributor a tank back. Also, the distributor now owes holder B a tank.

We support both unique and NS assets for exchange asset types.

For exchange types, end customers don't care if they get their unique, owned asset back. They just want to get any asset back of the same Asset Type. So though these assets are tracked uniquely with lot numbers and other properties, distributors don't care about tracking them uniquely on customer balances.

If a customer is delivered more exchange tanks than they have returned, then they owe the distributor rent. In the opposite case the balance goes negative. This negative balance indicates that the distributor owes the customer X number of tanks of this type. This negative has no affect on rent. It does not cause a credit. It is just used to indicate that the distributor owes this customer tanks.

Why even bother tracking them then? Why not just track using Not-Scanned Assets (DNS/RNS)?<br/>
* Lot # Control – there is value in this. You can't have lot numbers on Not-Scanned assets.
* Internal Quantity Control – we don't support NS at branch locations, only at Holders, so these assets must be tracked uniquely to maintain internal location balances.
* Internal Tracking – sometimes users want to find the exact tank returned from a given customer. Need to track them uniquely to find these tanks
* Consistent process – It is a simpler process to train and enforce when users must barcode and track all cylinders
* Some DNS/RNS logic prevents negative balances, so it's not ideal for exchange types.

@@ Line 5: / Line 5: @@
 ==Highlights==
 Some quick info on Exchange:
-* Exchange types can have negative balances
+* Exchange types can have negative balances.
 * For exchange types, the list of barcodes is not related to the asset balance.
 * For exchange types, the asset balance is just total ships minus the total returns over time.
@@ Line 11: / Line 11: @@
 ==About==
-"Exchange" asset types are small cylinders that are cheaper and are typically owned by the end customer (holder). A holder must normally "exchange" one of their tanks for one of the gas distributor. If the holder does not have any, he must buy one.  A common example is an Acetylene MC size tank. It is only maybe a foot tall and worth $35. Distributors typically sell these rather than rent them. Most of our customers do not barcode these kinds of assets. Some customers do barcode medical exchange tanks, but not the industrial exchange tanks.
+"Exchange" asset types are small cylinders that are cheaper and are typically owned by the end customer (holder). A holder must normally "exchange" one of their tanks for one of the gas distributor. If the holder does not have any, he must buy one. A common example is an Acetylene MC size tank. It is only maybe a foot tall and worth $35. Distributors typically sell these rather than rent them. Most of our customers do not barcode these kinds of assets. Some customers do barcode medical exchange tanks, but not the industrial exchange tanks.
-Rental was built before the issue of exchange types was introduced.  Many clients would prefer to never rent these tanks and instead make the customer buy them. On further investigation though (the devil is in the details) there are cases where these tanks are rented. Even without rent, it is important to at least keep track of a running tally of which party owes the other party cylinders. For instance, if over several years a customer has been delivered 150 tanks and has returned 155 tanks, then the distributor owes the customer 5 tanks. If the distributor loses the business, they must give the customer 5 of these tanks.
+Rental was built before the issue of exchange types was introduced. Many clients would prefer to never rent these tanks and instead make the customer buy them. On further investigation though (the devil is in the details) there are cases where these tanks are rented. Even without rent, it is important to at least keep track of a running tally of which party owes the other party cylinders. For instance, if over several years a customer has been delivered 150 tanks and has returned 155 tanks, then the distributor owes the customer 5 tanks. If the distributor loses the business, they must give the customer 5 of these tanks.
-Conceptually, for exchange type tanks, we need to have enough data to be able to calculate a running tally of delivers and returns over a time period without regard to exceptions or accounting adjustments.  If an individual returns three exchange type tanks but doesn't pick up new ones, the vendor owes the individual three tanks.  This means that the balance for the asset type can go negative, and TrackAbout should not "hold the line at zero", as it does for non-exchange types.  It is for this reason that TrackAbout suppresses normal Asset Transfer Exception (ATE) processing during movement of the asset.  If it did not suppress ATE processing, the line would be held at zero and the customer would not get credit for all returns.
+Conceptually, for exchange type tanks, we need to have enough data to be able to calculate a running tally of delivers and returns over a time period without regard to exceptions or accounting adjustments. If an individual returns three exchange type tanks but doesn't pick up new ones, the vendor owes the individual three tanks. This means that the balance for the asset type can go negative, and TrackAbout should not "hold the line at zero", as it does for non-exchange types. It is for this reason that TrackAbout suppresses normal Asset Transfer Exception (ATE) processing during movement of the asset. If it did not suppress ATE processing, the line would be held at zero and the customer would not get credit for all returns.
-Normally, we calculate a customer's balance by the following formula:
+Normally, we calculate a customer's balance by the following formula.
   For each distinct Asset Type:
-  Count of unique (tagged) assets + DNS - RNS = Balance
+ Count of unique (tagged) assets + DNS - RNS = Balance
 For exchange types, this balance calculation will, over time, differ or drift away from the running Exchange Type rental balance. This is OK.
 As mentioned, negative balances for exchange types are allowed. A negative balance just means that the distributor owes the holder some tanks.
-If a distributor delivers a tank to holder A and then holder B returns it, this is ok. Holder A still owes the distributor a tank back. Also, the distributor now owes holder B a tank.
+If a distributor delivers a tank to holder A and then holder B returns it, this is OK. Holder A still owes the distributor a tank back. Also, the distributor now owes holder B a tank.
 We support both unique and NS assets for exchange asset types.
@@ Line 43: / Line 43: @@
 Exchange types can be enabled in 3 different ways:
-*Asset Type - All asset balances of asset types set to exchange will be allowed to go negative
+*Asset Type - All asset balances of asset types set to exchange will be allowed to go negative.
-*Customer - All asset balances for a particular customer will be allowed to go negative
+*Customer - All asset balances for a particular customer will be allowed to go negative.
-*Customer Overrides - Specific asset types for a specific customer will be allowed to go negative
+*Customer Overrides - Specific asset types for a specific customer will be allowed to go negative.
-Before you can set up any Exchange Types or Overrides, this feature must be enabled by [[Contact Us|TrackAbout Support]]
+Before you can set up any Exchange Types or Overrides, this feature must be enabled by [[Contact Us|TrackAbout Support]].
 ===Set Asset Types to be Exchange===
@@ Line 53: / Line 53: @@
 To override an asset type to be exchange:
-*Go to the Asset Classification page ( TrackAbout Config > Asset Classifications)
+*Go to the Asset Classification page ( TrackAbout Config > Asset Classifications).
-*Expand the Category and Group to find the Asset Type you want to set to be exchange
+*Expand the Category and Group to find the Asset Type you want to set to be exchange.
-*Click on the Asset Type to expand the menu, then click on "Edit this Type"
+*Click on the Asset Type to expand the menu, then click on "Edit this Type".
-*Set the "Is Exchange Type" option to "Yes" and click "Save"
+*Set the "Is Exchange Type" option to "Yes" and click "Save".
 ===Set Customer to be Exchange Only===
@@ Line 62: / Line 62: @@
 To set a customer to have only exchange type balances:
-*Find the customer you want to set as exchange only
+*Find the customer you want to set as exchange only.
-*In the rental section of the Customer Detail View, click "Change" by "Exchange Overrides"
+*In the rental section of the Customer Detail View, click "Change" by "Exchange Overrides".
-*Change the Exchange Override option to be "Special Case: Treat All Asset Types As Exchange" and click "Save"
+*Change the Exchange Override option to be "Special Case: Treat All Asset Types As Exchange" and click "Save".
 ===Set Specific Asset Types to be Exchange for a Customer===
-*Find the customer you want to set as exchange only
+*Find the customer you want to set as exchange only.
-*In the rental section of the Customer Detail View, click "Change" by "Exchange Overrides"
+*In the rental section of the Customer Detail View, click "Change" by "Exchange Overrides".
-*Click "Add New Override" on the right-hand side of the screen
+*Click "Add New Override" on the right-hand side of the screen.
-*In the pop-up box, find the asset type you want to allow to be exchange
+*In the pop-up box, find the asset type you want to allow to be exchanged.
-*Check the Is-Exchange box and click "Save"
+*Check the Is-Exchange box and click "Save".
-*Repeat for all asset types you want to override and click "Save" when finished
+*Repeat for all asset types you want to override and click "Save" when finished.
 This method can also be used to make an asset type non-exchange for specific customers.

← Older revision		Revision as of 18:06, 16 May 2017
Line 83:		Line 83:
	## True - the asset will be treated as an Exchange Type asset for both Customer A and Customer B - Customer A will not get credit for the return, but Customer B will.		## True - the asset will be treated as an Exchange Type asset for both Customer A and Customer B - Customer A will not get credit for the return, but Customer B will.
	## False - an Accounting Adjustment will remove the asset from Customer A's balance. Customer B will also get credit since Customer B has no exceptions.		## False - an Accounting Adjustment will remove the asset from Customer A's balance. Customer B will also get credit since Customer B has no exceptions.
		+	# For the best information about customer balances that include exchange type balances, make sure to use the Balance Changes Summary page.

@@ Line 81: / Line 81: @@
 # For exchange balances, Failed RNS and No Credit Returns are treated as valid returns.
 # When an asset is delivered to Customer A, but returned from Customer B, and Customer B has an override making that asset type be Exchange, but it's a non-exchange asset for Customer A, then how the two customers' balances are handled depends on a TrackAbout Setting called : TreatAnAssetTypeAsExchangeIfEitherHolderInvolvedConsidersItExchange
-;# True -
+## True - the asset will be treated as an Exchange Type asset for both Customer A and Customer B - Customer A will not get credit for the return, but Customer B will.
-;# False - if assets are delivered to one customer but returned from another, an Accounting Adjustment will remove the asset from Customer A's balance and Customer B will also get credit since Customer B has no exceptions.
+## False - an Accounting Adjustment will remove the asset from Customer A's balance. Customer B will also get credit since Customer B has no exceptions.

← Older revision		Revision as of 17:18, 16 May 2017
Line 76:		Line 76:

	This method can also be used to make an asset type non-exchange for specific customers.		This method can also be used to make an asset type non-exchange for specific customers.
		+
		+	===How Exchange Type Affects Customer Balances ===
		+
		+	# For exchange balances, Failed RNS and No Credit Returns are treated as valid returns.
		+	# When an asset is delivered to Customer A, but returned from Customer B, and Customer B has an override making that asset type be Exchange, but it's a non-exchange asset for Customer A, then how the two customers' balances are handled depends on a TrackAbout Setting called : TreatAnAssetTypeAsExchangeIfEitherHolderInvolvedConsidersItExchange
		+	;# True -
		+	;# False - if assets are delivered to one customer but returned from another, an Accounting Adjustment will remove the asset from Customer A's balance and Customer B will also get credit since Customer B has no exceptions.

← Older revision		Revision as of 04:00, 21 June 2016
Line 1:		Line 1:
		+	{{TrackAbout Feature
		+	\|Parent Module=Core Tracking
		+	\|Feature Description=TrackAbout uses special logic to track "Exchange" assets that are typically not closely tracked.
		+	}}
	==Highlights==		==Highlights==
	Some quick info on Exchange:		Some quick info on Exchange:

← Older revision		Revision as of 14:54, 28 April 2015
Line 34:		Line 34:
	* Consistent process – It is a simpler process to train and enforce when users must barcode and track all cylinders		* Consistent process – It is a simpler process to train and enforce when users must barcode and track all cylinders
	* Some DNS/RNS logic prevents negative balances, so it's not ideal for exchange types.		* Some DNS/RNS logic prevents negative balances, so it's not ideal for exchange types.
		+
		+	==Enabling Exchange Types==
		+
		+	Exchange types can be enabled in 3 different ways:
		+
		+	*Asset Type - All asset balances of asset types set to exchange will be allowed to go negative
		+	*Customer - All asset balances for a particular customer will be allowed to go negative
		+	*Customer Overrides - Specific asset types for a specific customer will be allowed to go negative
		+
		+	Before you can set up any Exchange Types or Overrides, this feature must be enabled by [[Contact Us\|TrackAbout Support]]
		+
		+	===Set Asset Types to be Exchange===
		+
		+	To override an asset type to be exchange:
		+
		+	*Go to the Asset Classification page ( TrackAbout Config > Asset Classifications)
		+	*Expand the Category and Group to find the Asset Type you want to set to be exchange
		+	*Click on the Asset Type to expand the menu, then click on "Edit this Type"
		+	*Set the "Is Exchange Type" option to "Yes" and click "Save"
		+
		+	===Set Customer to be Exchange Only===
		+
		+	To set a customer to have only exchange type balances:
		+
		+	*Find the customer you want to set as exchange only
		+	*In the rental section of the Customer Detail View, click "Change" by "Exchange Overrides"
		+	*Change the Exchange Override option to be "Special Case: Treat All Asset Types As Exchange" and click "Save"
		+
		+	===Set Specific Asset Types to be Exchange for a Customer===
		+
		+	*Find the customer you want to set as exchange only
		+	*In the rental section of the Customer Detail View, click "Change" by "Exchange Overrides"
		+	*Click "Add New Override" on the right-hand side of the screen
		+	*In the pop-up box, find the asset type you want to allow to be exchange
		+	*Check the Is-Exchange box and click "Save"
		+	*Repeat for all asset types you want to override and click "Save" when finished
		+
		+	This method can also be used to make an asset type non-exchange for specific customers.