Non-supported ReleaseNon-supported Release
ECI no longer supports this version of e-automate, and this version of the online help is no longer being updated. ECI recommends upgrading to the current release. Contact your account manager for more information.

Configuring and Using Equipment Supply Order Entry

You use the supply order entry functionality of e-automate to automate the entry of supply orders from customers by adding equipment and contracts to the supply order. Supply orders can include any items you sell to a customer, as well as items you provide to the customer under their service maintenance contracts.

Supply order entry allows you to add the equipment for which the supplies are destined. e-automate can assist you in the order entry and determine whether the supplies are covered under a contract, provide a list of supplies available for the equipment, provide a list of supplies for the attached accessories, and determine the contract on which the equipment is covered.

When you sell supplies that are covered under contract, it is important to identify the contract so that when you calculate the contract profitability, your system can account for all items that are provided to the customer and covered under the contract.

In order to configure equipment supply order entry you must first identify the items that are supply items for your inventory items, both equipment and accessories. For example, if you have a copier, you can define the toner supplies for the copier.  You can also identify the accessory finisher, as well as the staples that serve as supplies for the finisher. Once you know the supplies for both the equipment and the accessory, you then link the supplies for each to the inventory item in e-automate. On the inventory item that is linked to the equipment you would associate the toner supplies, and on the inventory item that is the accessory finisher, you would associate the staples. You identify these supply items on the inventory item's Related Items tab. If you want e-automate to display related items for accessories on equipment, you must also associate accessories to equipment records. Associating the accessories allows e-automate to determine which accessories are associated with an equipment record at a given time.

When attaching accessories to equipment you can enable e-automate to consume in-stock accessories. When e-automate consumes in-stock accessories, it removes the item that was in inventory and transfers the cost associated with the inventory item attached to the equipment host that does the consuming. e-automate makes a distinction between serialized and non-serialized accessories. You enable either or both serialized or non-serialized accessories. You can also default your system to assume you are consuming either serialized or non-serialized. Finally, you can also remove accessories from hosts and put accessories back into inventory with their full cost.

Enabling Accessory ConsumptionEnabling Accessory Consumption

From the Tools menu, select Options to open the Options window.

In the Options window, in the left-hand pane, click on Equipment to display equipment options on the right.

When the equipment options display, you can enable accessory consumption under accessories.

Configure the following options for your company as appropriate:

Allow accessory consumption of serialized items: When checked, e-automate allows you to associate accessories to equipment and consume the cost of the accessory into the host equipment item. This removes the accessory item from inventory and transfers the cost to the host. Without this checkbox checked, when adding accessories, you cannot consume.

Default serialized items to consumed: When checked and you add accessories, e-automate assumes you always want to consume the accessories. The checkbox in the Add Accessories window is always checked based on this field. During accessory configuration, you can uncheck it as necessary.

Allow accessory consumption of non-serialized items: When checked, e-automate allows you to consume items that are not serialized. This transfers the cost of the item to the host item and removes the quantity on hand for the consumed non-serialized accessory. Without this checkbox checked, you cannot consume non-serialized accessories.

Default non-serialized items to consumed: When checked and you add non-serialized accessories, e-automate assumes you always want to consume, so the checkbox in the Add Accessories window is always checked for non-serialized items. You can uncheck it, but this checkbox configuration assumes you are consuming.

Click the [OK] button to save your changes and to close the Options window.
Note: If you made any changes, e-automate displays an Attention window, indicating that all users must restart e-automate in order for these changes to take effect. Do the following:

Click the [OK] button to acknowledge the message.

Restart e-automate so that these changes will take effect.

If you are running e-agent, restart e-agent as well.

Defining Related ItemsDefining Related Items

From the Inventory menu, select Items to open the Items list window.

From your e-automate inventory item list, identify inventory items that can consume supplies. Typically, this is a list of your equipment-coded items. You could also have supply consumers in accessory items that may not be equipment-coded. You may want to start with your highest supply consumer items.

Select an inventory item from the list and click [Edit].

In the Edit Inventory Item window, click the Related Items tab to bring it forward.

In the Item field, use the lookup icon to select a supply item used by this inventory item.

In the Yield Override field, enter the expected yield for this supply—but only if this supply's yield, when consumed by the equipment coded item, is different than the yield identified on the supply item.

Click [QuickAdd] to add the item.

Repeat Steps b through d until you have added all supply items used by this inventory item.

Repeat Step 3 for each item that consumes supplies.

Configuring, Accumulating History for, and Understanding Item Yield WarningsConfiguring, Accumulating History for, and Understanding Item Yield Warnings

You can configure e-automate to display item yield warning messages on sales transactions. To display these messages, the system requires product yield information, a prior sales transaction association between the product being consumed and the equipment consuming the product, meter history on which to base usage, and an expected yield percentage below which to display the warnings. When sufficient information is available for the system to detect a consumable product's actual usage is below expected usage at the time the item is placed on a sales transaction and if the item is not billable, the system will display the following information on the sales transaction:

On the Add/Edit Sales Order window, on the Items tab, the system will display a warning icon on each non-billable line where the item's actual usage is below the expected usage. If you hover over the icon, the system will display the message: "Usage is [shortage amount] less than the minimum expected value."

On the Add/Edit Sales Order Item window for the selected non-billable line item, in the Item Invoice Details region, the system will display the warning  icon with the message: Usage is [shortage amount] less than the minimum expected value."

Configuring Item Yield WarningsConfiguring Item Yield Warnings

To configure item yield warnings, do the following:

Verify a copy yield quantity and usage limit meter type are specified for each consumable product for which you want to receive an item yield warning message when applicable.  To verify a copy yield quantity and usage limit meter type are specified for a consumable item, do the following:

On the e-automate toolbar, click [Items] to open the Items list window.

Filter the inventory item list for consumable items.  For example, you may want to use the QuickSearch filter to locate items where Category begins with your designation for supplies. For more information on using QuickSearch functionality, see the Using the QuickSearch topic.

Select a consumable item from the list for which to verify a copy yield is present.

Click [Edit] to open the Edit Inventory item window.

In the Usage limit meter type field, use the lookup icon to select the meter type on which you want the system to base the usage (e.g., B\W for a toner cartridge that is only used for black-and-white copies; Color for a toner cartridge that is only used for color copies; Total Count for a toner cartridge that is used for creating all copies, both black-and-white copies and color copies).
Note: You can define a virtual meter if you need to specify a combination of meters on which you want the system to base the usage.
Note: If you have not previously been populating the Usage limit meter type field, you can use Bulk Updates to update this field.  For more information, see Performing Bulk Updates the topic.

On the Codes and Settings tab, verify the Copy yield field lists the number of copies or other units the item is expected to produce before the item must be replaced.  If this field is not populated, add the appropriate number of copies/units.

Click [OK] to save the information.
Note: For more information, see the Creating Items - Parts or Supply Items topic.

For products that consume consumable items at a rate other than the item's Copy yield rate, specify a copy yield override quantity that applies when the consumable item is used with that product.  To specify a copy yield override quantity for a consumable item when the item is used with a specific product, do the following:

From the Inventory menu, select Items to open the Items list window.

From your e-automate inventory item list, identify inventory items that can consume supplies. Typically, this is a list of your equipment-coded items. You could also have supply consumers in accessory items that may not be equipment-coded. You may want to start with your highest supply consumer items.

Select an inventory item from the list for which you want to verify a copy yield override is present.

Click [Edit] to open the Edit Inventory item window.

Click the Related Items tab to bring it forward.

In the Item field, use the lookup to select a supply item used by this inventory item.

In the Yield Override field, enter the expected yield for this supply, if any.

Click [QuickAdd] to add the item.

Repeat Steps f through h until you have added all supply items used by this inventory item.

Click [OK] to save the information.

Repeat Steps c through j for each item that consumes supplies.
Note: For item yield notifications, you do not have to set up related items; the item yield notification relies on a previous sales order/invoice equipment supply association. If you want to use an alternate yield, however, you must use related items.

To specify a yield percentage, do the following:

From the Tools menu, select Options to open the Options window.

In the left pane of the window, double-click on Sales. The Sales options display in the right pane of the window.

In the Yield percentage field, enter the percentage of a consumable item's Copy yield value that must be reached to prevent the system from displaying an item yield warning when a user adds the item to a sales transaction.
Note: By default, the Yield percentage field value is set to 0%, which effectively disables item yield warnings.  When this feature is disabled, the system will continue to display Item Invoice Details on the Add/Edit Sales Order Item window; however, the information displayed will not include a Minimum expected value and—when applicable—an item yield warning icon and message. If you want to use the item yield warning feature, you must enter a value in the Yield percentage field.

Click [OK] to save the information.
Note: For more information, see the Setting Sales Options topic.

If you are using e-info and want to display item yield information icons for your e-info users when applicable, you must also check the Item yield warning based on actual and expected usage box in e-info.  For more information, see the Configuring E-info End User Options topic.

Accumulating History on Which to Base Item Yield WarningsAccumulating History on Which to Base Item Yield Warnings

Once you have the system configured to generate item yield warning messages for non-billable items, you need to make sure sales transaction, service call, meter, and contract entry processes provide the system with the information necessary to calculate usage information and associate that usage information with the items being consumed.

The system calculates consumption based on the combination of the following components: the item being consumed, the equipment consuming the consumable item, and the equipment's install date and installed location.

When you enter a sales transaction for a consumable item, you associate the item with a specific piece of equipment by checking the Add equipment and contract box and specifying the equipment that is consuming the consumable item. This equipment-to-supply association allows e-automate to determine if the supply item is billable based on the associated bill code.  Typically, this bill code comes from a service contract, butin less common situationsthe bill code may also come from the equipment record.

E-automate uses only valid meter readings when calculating item yield warnings; invalid meter readings (readings for which the This is a valid reading box is not checked on the Add/Edit Meter Reading window) are not used.  A meter reading does not have to be billed on contract for the system to use the meter to calculate usage for yield warnings.

To assure usage is associated with a distinct equipment item for a specified period of time, the system uses the equipment item's Install date and Installed location in the equipment record. If you change an equipment item's Installed location and you do not want to use meter history from the previous location for determining usage at the new location, you should also update the equipment item's Install date.

Note: Items can be included at no charge based on the associated contract bill code or equipment bill code, or via manual override on the transaction. In all cases, e-automate can calculate and notify when yields on non-billable items were not met.

Understanding Item Yield Warning CalculationsUnderstanding Item Yield Warning Calculations

Following is a sample Item Invoice Details image involving a supply item included at no charge. The table below this image identifies the source of each item in this image and/or the calculations for arriving at the item's value.
Note: To jump to a specific explanation or calculation, click a number in the sample image.
Note: This sample is designed for the sole purpose of illustrating multiple calculation scenarios; it is not intended to represent a realistic or best practices portrayal of consumable supply item activity.

Item Invoice Details Image

This image is based on the following information:

In Tools > Options > Sales, the Yield Percentage is set to 80%.

In the consumable item's Item record, Usage limit meter type is set to Total Count and Copy yield is set to 5,000.

In the equipment item's Item record, a Related Items record exists for the consumable item and has a Yield override of 4,500.

The equipment was installed on 12/05/2016 with the following meter readings:

B\W: 0

Color: 0

Total Count: 0

On 12/15/2016, a service call was entered and invoiced for this equipment. The materials used on the call included a quantity of 1 of this consumable item at a price of $450.00, and the following meter readings were entered:

B\W: 1,000

Color: 100

Total Count: 1,100

Also on 12/15/2016, a sales order was entered and invoiced that included a quantity of 2 of this consumable item linked to this equipment. The price of $450 per item was discounted 10% for a price of $405 per item.

On 12/22/2016, a sales order was entered and invoiced that included a quantity of -1 (negative one) of this consumable item linked to this equipment.

On 01/06/2017, when this consumable item was linked to this equipment on a sales order, the system displayed the Item Invoice Details shown in this image.

The following table identifies the source of each item in this image and/or the calculations for arriving at the item's value.

Report Label

Calculations

Reference Date

The transaction date for which the invoice information for this item is being displayed.  When item yield warnings are enabled, this date is the most recent transaction date on which a positive net quantity of the consumable item being linked to the equipment on this order was previously linked to the equipment on an invoiced service call and/or sales transaction.

 

Example (based on the Item Invoice Details scenario above this table):

As of 01/06/2017, the date of the most recent invoiced transaction containing an order quantity for the combination of this consumable item and equipment was 12/22/2016.  As of that date, the net order quantity for the combination of this consumable item and equipment was a negative one (-1). Since no yield can occur from a negative quantity of a consumable item, the system does not use this date as the Reference Date.
The date of the next most recent invoiced transaction containing an order quantity for the combination of this consumable item and equipment was 12/15/2016. On that date both a service invoice and a sales invoice contained an order quantity for the combination of this consumable item and equipment. The service invoice contained a quantity of 1 for the combination of this consumable item and equipment.  If the service invoice had been the only invoice on that date with an invoiced quantity for the combination of this consumable item and equipment, the net order quantity would have been 0 (zero) and the system would have continued to look for the date of the next most recent invoiced transaction containing the combination of this consumable item and equipment until it found a positive net quantity for the combination of this consumable item and equipment.  Since a sales invoice also occurred on 12/15/2016 and contained a quantity of 2 for the combination of this consumable item and equipment, the net order quantity was a positive 2 so the system used 12/15/2016 as the Reference Date.

Transactions

The number of invoiced service call and/or sales transactions that occurred on the Reference Date.

 

Calculation:

Transactions = Sum of invoiced Service Call and/or Sales Transactions on the Reference Date that included a quantity (positive or negative) of the consumable item linked to the equipment

 

Example (based on the Item Invoice Details scenario above this table):

Transactions = 1 Invoiced Service Call on 12/15/2016 + 1 Invoiced Sales Order on 12/15/2016 = 2
Note: The system does not count the 12/22/2016 Invoiced Sales Order because this transaction did not occur on the Reference Date (12/15/2016).  Had this transaction also occurred on 12/15/2016, the Transactions count would have been 3.

Type

The type of transaction (Sales for Sales Transaction, Service for Service Call, or Sales/Service for both) on which a quantity of the consumable item being linked to the equipment on this order was previously linked to the equipment on the Reference Date.

Adj. quantity

The net quantity of the consumable item linked to the equipment on an invoiced service call and/or sales transaction from the day prior to the Date specified for the current sales transaction through the Reference Date.

 

Calculation:

Adj. quantity = Sum of Consumable Item's Quantities on Service Calls and/or Sales Transactions from the day prior to the Date specified for the current sales transaction through the Reference Date

 

Example (based on the Item Invoice Details scenario above this table):

Adj. quantity = 1 from Invoiced Service Call on 12/15/2016 + 2 from Invoiced Sales Order on 12/15/2016 + -1 from Invoiced Sales Order on 12/22/2016 = 2

Average price

The average price of any positive quantities of the consumable item linked to the equipment on all invoiced service call and/or sales transactions that occurred on the Reference Date.
Note: In most cases, only one transaction will have occurred for the equipment item and consumable product combination on the Reference Date, and this field will display the price for that transaction.  Since it is possible for multiple transactions to occur for the equipment item and consumable product combination on the Reference Date, the system calculates the average price rather than trying to determine which price to display if the prices are different (e.g., as a result of discounts given; applicable discounts include service call line-item and material discounts, sales line-item discounts, and deposit-based contract discounts, but do not include order discounts or terms discounts). Additionally, prices associated with negative (return) quantities for the equipment item and consumable product combination on the Reference Date and/or transactions that did not occur on the Reference Date are not taken into consideration.

 

Calculation:

Average price = Sum(Amounts for Consumable Item linked to Equipment on All Invoiced Service Call and/or Sales Transactions that Occurred on the Reference Date)/Quantity of Consumable Item linked to Equipment on All Invoiced Service Call and/or Sales Transactions that Occurred on the Reference Date

 

Example (based on the Item Invoice Details scenario above this table):

Average price = ($450 for Quantity of 1 of Consumable Item on Invoiced Service Call on 12/15/2016 + $810 for Quantity of 2 of Consumable Item on Invoiced Sales Order on 12/15/2016)/Quantity of 3 = $420

Yield

The Copy yield specified in the consumable item's Item record, or—if present—the Yield override specified in a Related Items record for the consumable item in the equipment item's item record. Based on the Item Invoice Details scenario above this table, the system uses the Yield override of 4,500.

Meter Type

The Usage limit meter type specified in the consumable item's Item record. For this example, the consumable item's Usage limit meter type was set to Total Count, which in this case includes the usage for both the B\W and Color meters for the equipment consuming the item.

Minimum expected

The minimum yield the customer should be able to get from the adjusted quantity of the consumable item linked to the equipment on an invoiced service call and/or sales transaction from the day prior to the Date specified for the current sales transaction through the Reference Date.

 

Calculation:

Minimum expected = Adjusted Quantity * Yield * Yield Percentage

 

Example (based on the Item Invoice Details scenario above this table):

Minimum expected = 2 Adjusted Quantity * 4,500 Yield * 80% Yield Percentage = 7,200

Usage

The usage of the consumable item by the linked equipment based on the specified usage limit meter type from the Reference Date through the Date of this sales transaction.
Note: If valid meter reads are available on the Reference Date and the Date of this sales transaction, the system uses those reads to calculate actual usage.  If valid reads are not available on both dates, the system uses the applicable monthly average (3 Mo., 6 Mo., or 12 Mo.) listed for the Usage Limit Meter Type in the Meter Read Console to determine the daily average for that meter type and then multiplies that daily average by the number of days between the Reference Date and the Date of this sales transaction to estimate the usage for that meter type as of the date of this sales transaction.

 

Calculation:

Actual Usage for Usage Limit Meter Type = (Meter Reading on Current Sales Transaction Date - Meter Reading on Reference Date)/DateDiff(Current Sales Transaction Date, Reference Date)
Average Usage per Day for Usage Limit Meter Type = Meter Average for Usage Limit Meter Type / 30.25 Days
Estimated Usage for Usage Limit Meter Type since Reference Date  = Average Usage for Usage Limit Meter Type per Day * DateDiff(Reference Date, Current Sales Transaction Date)

 

Example (based on the Item Invoice Details scenario above this table):

A meter reading is available for the Reference Date but not for the sales order date, so the system needs to calculate average usage and estimate the usage for the Usage Limit Meter Type.

Average Usage per Day for Usage Limit Meter Type = 3,328 / 30.25 = 110 (rounded)
Note: For this calculation, the system used the (3 Mo.) Monthly avg (3,328) listed for the Usage Limit Meter Type (in this example, the Total Count meter type) in the Meter Reading Console since the Reference Date occurred within the three months prior to the sales transaction date.
Estimated Usage for Usage Limit Meter Type since Reference Date = 110 Average Usage per Day for Usage Limit Meter Type * DateDiff(12/15/2016, 01/06/2017) = 2,420

Warning Message

This message lists the difference between the Minimum expected yield and the estimated Usage since the Reference Date.
Note: The system only displays this warning message when a shortage is present.

 

Calculation:

Shortage  = Minimum Expected Yield - Estimated Usage

 

Example (based on the Item Invoice Details scenario above this table):

Shortage  = 7,200 Minimum Expected Yield - 2,420 Estimated Usage = 4,780

 

Identifying Models Capable of HostingIdentifying Models Capable of Hosting

From the Inventory menu, select Models to open the Models list window.  If a model's Host column lists Yes, the model is capable of being a host.

To identify a model as capable of being a host, do the following:

Select the model in the list.

Click [Edit] to open the Edit Model window.

Check the Host check box.

Click [OK] to save the model changes.

Repeat Steps a through d for each model that is capable of being a host.
Note: You cannot associate an accessory with a model if the model is not capable of being a host.

Identifying Models Capable of Being AccessoriesIdentifying Models Capable of Being Accessories

If you track accessories on your equipment list, complete these steps:

From the Inventory menu, select Models to open the Models list window.  If a model's Accessory column lists Yes, the model is capable of being an accessory.

To identify a model as capable of being an accessory, do the following:

Select the model in the list.

Click [Edit] to open the Edit Model window.

Check the Accessory check box.

Click [OK] to save the model changes.

Repeat Steps a through d for each model that is capable of being an accessory.
Note: You cannot associate a model with a host if the model is not capable of being an accessory.

Associating Accessories on EquipmentAssociating Accessories on Equipment

From the Service menu, select Equipment to open the Equipment list window.

From the Equipment list, identify equipment items that are hosting accessories.
Note: Accessories can be identified as other equipment records or inventory items.

Select the equipment with which you want to associate accessories and click [Accessories] to open the Edit Accessories window.

In the Number field, you can enter a number or allow e-automate to automatically number this accessory attachment or removal.
Note: This transaction is identified by e-automate as an equipment build and numbers it accordingly.

In the Date field, you can specify the date this equipment build occurred.

To add an accessory, do the following:

Click [Add] to open the Add Accessory window.

In the Type field, use the drop-down menu to identify if you are attaching another equipment as an accessory, or if you are linking an inventory item as an accessory.
Note: When associating equipment, you must first have an equipment record to attach. When attaching an item, e-automate identifies that there is simply an item attached that does not exist on the equipment list.

In the Equipment/Item field, use the lookup to select the accessory attached to this equipment.
Note: This field is changed by e-automate based on the selected type.

In the Serial number field, enter the appropriate serial number.
Note: If the item has been in your inventory and is not associated with another equipment, you can select the serial number from a lookup when the Use system serial number checkbox is checked.

In the Quantity field, identify the quantity attached.

To flag the accessory as a permanent accessory, check the Permanent checkbox.

If your options enable consumption, you can consume the identified accessory if in inventory. To consume, check the Consume checkbox.

If consuming, check the Consume from checkbox, and in the appropriate fields identify the Warehouse and Bin.

Click [OK] to add the accessory and consume if applicable.

Repeat Steps a through i until you have added all the accessories for this equipment.

Click [OK] to save the accessory changes.

Entering a Supply OrderEntering a Supply Order

On the Sales menu, select Sales Order or Sales Invoices to open the Sales Orders or Sales Invoices list window, respectively.

Click [New] to open the New Sales Order or New Sales Invoice window.

In the bottom right of the New Sales Order or New Sales Invoice window, check the Add equipment and contract checkbox.

To view only those supply items associated with a piece of equipment, use the lookup icon in the Equipment field to select the equipment number.
Note: To display the supply items for a piece of equipment, they must be added to the Related Items tab in the equipment’s item profile.

If the equipment is on a current contract, e-automate adds the contract to the Contract field. You can change if necessary.
Note: Items added to the invoice when you are using equipment supply order entry are automatically associated with the contract and the equipment specified. If the equipment is associated with two contracts, e-automate asks you to select the contract with which to associate the items and cost.

In the Item field, use the lookup icon to select inventory items.
Note: You can configure e-automate to only display items defined on the selected equipment's Related Items tab. This functionality is called filtering. Filters are applied to the lookup automatically. You can tell if a filter is applied by locating a small down arrow beside the lookup icon in the field. If the previous user of this window turned off the filters, you can turn them back on by using the drop-down menu in the Item field and selecting Filter > Filter by related items of host equipment and accessories.
Note: Items added to the invoice when you are using equipment supply order entry are automatically associated with the contracts and the equipment specified.

Click [QuickAdd] to add the related item to the invoice.

Repeat Steps c through d to add items for the selected equipment.

Repeat Steps a through e to add items for different equipment.

Click [OK] to save the order or invoice.

For more information on the additional tabs on sales orders and invoices, see the Creating Equipment Sales Orders, Creating Supply Sales Orders, and Creating Sales Invoices topics.

 

Non-supported ReleaseNon-supported Release
ECI no longer supports this version of e-automate, and this version of the online help is no longer being updated. ECI recommends upgrading to the current release. Contact your account manager for more information.

©2022 ECI and the ECI logo are registered trademarks of ECI Software Solutions, Inc. All rights reserved.