Customer Transaction Details

ID : System unique identifier for the e-view row.

Customer Number : Number assigned to the customer in e-automate.

Customer Name : Customer's company name

Date : Date the contract was created.

Coverage Form : Beginning date of coverage period.

Coverage To : End date of coverage period.

Period : Period of the transaction

Type : Transaction type of the line item.

Reference : Displays a recognizable value associated with the transaction. Depending on the type of transaction there are several different references that may display. The following list outlines what displays in the reference column for each type of transaction:

All types of Invoices : e-automate Invoice Number.

Credit and Debit Memos : e-automate Credit Memo number or Debit Memo number respectively.

Contract Accruals : e-automate Accrual Number.

Sales Fulfillments : If the invoice is present, the e-automate invoice number displays. If the invoice is not present then the e-automate Fulfillment number displays.

GL Journal Entries : e-automate Journal Reference number.

Inventory Journal Entries : e-automate Journal number.

Cashbook Journal Entries : e-automate Journal number.

Purchase Order Receipts : e-automate Receipt number.

Accounts Receivable Receipts : e-automate Receipt number.

Accounts Receivable Payments : e-automate Payment number.

Inventory Transfers and Adjustments : e-automate Transfer number.

Inventory Manufacturing : e-automate Manufacturing number.

Asset Journal Entries (Asset Depreciation) : e-automate Journal number.

Overage Forecasts : BLANK (no reference number).

Sub Reference : Displays a secondary recognizable value associated with the transaction. Not all transaction records will have a Sub reference. The following list outlines what displays in the reference column for each type of transaction:

Service Invoice : e-automate Call number.

Sales Fulfillments : e-automate Sales order number.

Accounts Payable Invoices : e-automate Vendor's invoice number.

Detail Type : Displays the transaction's detail lines. For example, a Service Invoice could involve labor, travel, and parts activity. Thus the transaction type would be Service Invoice and the detail type may be Parts, Labor, etc. The following detail types exist in Analytics:

AP Expense

Base

Contract Base Adjustment

Contract Overage Adjustment

Labor

Lease

Mileage

Misc. Charge

Other items

Overages

Parts

Supplies

Travel

Item : e-automate Item number of inventory item associated with the transaction record, if any.

Description : Displays the description entered in the description field of the transaction type detail.

Detail Desc. : Displays detail description for the transaction. Where this pulls from in e-automate varies depending on the transaction type. Essentially the detail descriptions for the various transaction types will be the equivalent of the e-automate Invoice Detail Descriptions that a user sees when printing an invoice from e-automate. Not all transaction records will have a Detail Desc. The following list outlines what displays in the Detail Desc. column for each type of transaction:

Sales Invoices : Description of the individual line item within the e-automate sales invoice.

Misc. Charge Invoices : Description of the individual line item within the e-automate Misc. Charge invoices.

Sales Invoice Credit Memos : Description of the individual line item within the e-automate Sales Invoice Credit Memo.

Sales Invoice Debit Memos : Description of the individual line item within the e-automate Sales Invoice Debit Memo.

Sales Fulfillment : Description of the individual line item within the e-automate Sales Fulfillment.

Service Invoices : Technician's name associated with the individual line item within the e-automate Service Invoice.

Service Invoice Credit Memos : Technician's name associated with the individual line item within the e-automate Service Invoice Credit Memo.

Service Invoice Debit Memos : Technician's name associated with the individual line item within the e-automate Service Invoice Debit Memo.

Accounts Payable Invoices : Description of the individual line item within the e-automate invoice.

Contract Invoices : For Miscellaneous charges this will come from the e-automate contract’s Miscellaneous Charge Description, for Base and Overage Adjustments it will come from the e-automate contract’s Adjustment Description.

Quantity : Quantity associated with the transaction. For some types of transactions the system is set to look at different places in e-automate, in a specific order. If the first field Analytics is set to look at is unavailable, the system will look at the next field, and so on. The following lists each transaction type and where in e-automate Analytics looks for the values to display in the view. The e-automate locations are listed in order of priority.

Misc. Charge Invoices : The Quantity field is not applicable for this type of transaction.

Misc. Charge Debit Memo and Misc. Charge Credit Memo : The Quantity field is not applicable for these type of transactions.

Service Invoices, Credit Memos - Materials : The system looks in e-automate in two difference places to locate a number with which to populate the Quantity column for Service Invoices for Materials. The following locations are listed in order of priority.

The system first looks at the Quantity field in the invoice/credit memo Warehouse/bin/quantity detail. To locate this field in e-automate, on the Materials tab of the service invoice for which you want to locate the e-view column source, select the line item and click [View ] to open the View Report Material window. In the View Report Material window locate theWarehouse/bin/quantity region, select the warehouse/bin you want to view, and click [View ] to open the View Report Material Item Bin window. The Quantity field in this window is the field from which the value in the Quantity column of the e-view originates.

If the Quantity field in the Warehouse/bin/quantity detail is 0, than the system will look at the Quantity field in the item detail of the service invoice/credit memo. To locate this field in e-automate, on the Materials tab of the service invoice/credit memo, select the line item and click [View ] to open the View Report Material window. The Quantity field in this window is the field from which the value in the Quantity column of the e-view originates.

Service Invoices, Credit Memos - Labor : The system looks at the line item Labor Hours field on the service invoice in e-automate. To locate this field in e-automate on the Labor tab of the service invoice, select the line item and click [View ] to open the Edit Labor window. The field Labor hours under the Billing Entries region, is the field from which the number pulls.

Service Invoices, Credit Memos - Travel : The system looks at the line item Travel Hours field on the service invoice in e-automate. To located this field in e-automate on the Labor tab of the service invoice, select the line item and click [View ] to open the Edit Labor window. The field Travel hours under the Billing Entries region, is the field from which the number pulls.

Service Invoices, Credit Memos - Miles : The system looks at the line item Billable mileage field on the service invoice in e-automate. To locate this field in e-automate on the Labor tab of the service invoice, select the line item and click [View ] to open the Edit Labor window. The field Billable mileage under the Billing Entries region, is the field from which the number pulls.

Service Invoices, Credit Memos - Misc. Charges : The Quantity column is not applicable for these types of transactions.

Sales Fulfillments : The system looks in the Quantity field of the line item detail on the sales order associated with the fulfillment. To locate this field in e-automate, on the Items tab of the sales order associated with the fulfillment, select the line item, and click [View... ] to open the View Sales Order Item window. The Quantity field in this window is the field from which the number originates.

Sales Invoices : The system looks in e-automate in two different places to locate a value with which to populate the Quantity column for Sales Invoices. The following locations are listed in order of priority:

The system first looks in the Quantity field in the Warehouse/bin/quantity detail of the item detail. To locate this field in e-automate, open the invoice for which you want to locate the e-view column source; open the invoice in View mode. On the Materials tab select the line item and click [View ] to open the View Report Material window. In the View Report Material window locate the Warehouse/bin/quantity region, select the warehouse/bin you want to view, and click [View ] to open the View Report Material Item Bin window. The Quantity field in this window is the field from which the value in Quantity column of the e-view originates.

If the Quantit y field in the Warehouse/bin/quantity region is 0, than the system will look at the Quantity field in the item detail of the invoice. To locate this field in e-automate, open the invoice for which you want to locate the e-view column source; open the invoice in View mode. On the Materials tab of the invoice, select the line item, and click [View ] to open the View Report Material window. The Quantity field in this window is the field from which the value in the Quantity column of the e-view originates.

Sales Credit Memo and Debit Memos : The system looks in e-automate in two different places to locate a value with which to populate the Quantity column for Sales Credit/Debit Memos. The following locations are listed in order of priority.

The system first looks in the Quantity field in the Warehouse/bin/quantity detail of the item detail. To locate this field in e-automate, open the debit/credit memo for which you want to locate the e-view column source; open the credit/debit memo in View mode. On the Materials tab select the line item and click [View ] to open the View Report Material window. In the View Report Material window locate the Warehouse/bin/quantity region, select the warehouse/bin you want to view, and click [View ] to open the View Report Material Item Bin window. The Quantity field in this window is the field from which the value in Quantity column of the e-view originates.

If the Quantit y field in the Warehouse/bin/quantity region is 0, than the system will look at the Quantity field in the item detail of the debit/credit memo. To locate this field in e-automate, open the debit/credit memo for which you want to locate the e-view column source; open the debit/credit memo in View mode. On the Materials tab, select the line item, and click [View ] to open the View Report Material window. The Quantity field in this window is the field from which the value in the Quantity column of the e-view originates.

Contract Invoices, Credit Memos - Misc Charges : The Quantity field is not applicable for this type of transaction.

Contract Invoices, Credit Memos - Base Adjustments : The Quantity field is not applicable for this type of transaction.

Contract Invoices, Credit Memos - Overage Adjustments : The Quantity field is not applicable for this type of transaction.

Contract Invoices, Credit Memos - Lease : The Quantity field is not applicable for these types of transaction.

Contract Invoices, Credit Memos - Base : The Quantity field is not applicable for these types of transaction.

Contract Invoices, Credit Memos - Overages : The value for the contract invoice overage originates from the overage displayed for that contract on the Contract Invoices report. The Contract Invoices report is listed in the Service group of reports in the e-automate Reports Console .

AP Vendor Invoices : The Quantity field is not applicable for this type of transaction.

Bill : Indicates if this transaction has been billed.

Is Void : Indicates if this transaction has been voided.

Forecasted : Displays predicted meter usage based on previous usage. This column is not currently a functioning feature.

Contract Number : Contract number associated with this transaction.

Equipment Number : Equipment number of the equipment associated with this transaction.

Model : Model of the equipment associated with this transaction.

Make : Make of the equipment associated with this transaction.

Call Number : Call number associated with this transaction.

Sales Rep Number : Number assigned to the sales rep associated with this transaction.

Meter Type : Meter type assigned to the equipment associated with this transaction, if any.

Meter Type Category : Meter type category under which the meter type is assigned.

Revenue : Total revenue generated by this transaction. The following lists each transaction type and where Analytics looks in e-automate for the values that display in the e-view:

Misc. Charge Invoices :  The system looks at the number in the Charge amount column of the line item on the invoice. To locate the field in e-automate, from the Accounting menu, select Accounts Receivable > Miscellaneous charge invoices to display a list of Miscellaneous charge invoices. Select the invoice from the list and click [View ] to view the invoice. On the Charges tab locate the line item for which you want to view revenue. The number displayed in the Charge amount column is the location from which the revenue displayed in the view originates.

Misc. Charge Credit Memos , and Debit Memos : The system looks at the number in the Charge amount column of the line item on the credit/debit memo. To locate the field in e-automate, from the Accounting menu, select Accounts Receivable > Miscellaneous charge debit memos/Miscellaneous charge credit memos to display a list of Miscellaneous charge credit/debit memos respectively. Select the credit or debit memo from the list and click [View ] to view the credit/debit memo. On the Charges tab locate the line item for which you want to view revenue. The number displayed in the Charge amount column is the location from which the revenue displayed in the view originates.

Service Invoices, Service Invoice Credit Memos - Materials : The system looks in the Amount field in the line item detail of the service invoice. To locate this field in e-automate, on the Materials tab of the service invoice for which you want to locate the e-view column source, select the line item and click [View ] to open the View Report Material window. The Amount field in this window is the field from which the value in the Revenue column of the view originates.

Service Invoices, Service Invoice Credit Memos - Labor : The system looks at the number in the Labor field of the invoice Summary area. To locate this field in e-automate, from the Service menu, select Service invoices to display a list of service invoices. Select the service call invoice and click [View ] to view the service invoice. Locate the yellow Summary region found in the upper right side of the window. The number displayed adjacent to Labor is the location from which the revenue displayed in the view originates.

Service Invoices, Service Invoice Credit Memos - Travel : The system looks at the number in the Travel field of the invoice Summary area. To locate this field in e-automate, from the Service menu, select Service invoices to display a list of service invoices. Select the service call invoice and click [View ] to view the service invoice. Locate the yellow Summary region found in the upper right side of the window. The number displayed adjacent to Travel is the location from which the revenue displayed in the view originates.

Service Invoices, Service Invoice Credit Memos - Miles : This column is not applicable for this type of transaction. The mileage is included in the Services Invoices, Service Invoice Credit Memos - Travel column.

Service Invoices, Service Invoice Credit Memos - Misc Charges : The system looks at the value in the Charge field on the Miscellaneous tab of the service invoice. To located this field in e-automate, from the Service menu, select Service invoices to display a list of all service invoices. Select the service call invoice for which you want to view information and click [View ] to open the service invoice in view mode. Click the Miscellaneous tab to bring if forward. The Charge field on this tab is the location from which the revenue displayed in the view originates.

Sales Fulfillments : The system looks at the number in the Amount field of the line item detail on the sales order associated with the fulfillment. To locate this field in e-automate, on the Items tab of the sales order associated with the fulfillment select the line item and click [View... ] to open the View Sales Order Item window. The Amount field in this window is the field from which the number on the view originates.

Sales Invoices : The system looks at the number in the Amount column of the line item on the sales invoice. To locate this column in e-automate, from the Sales menu select Sales invoices to display a list of all sales invoices. Select the sales invoice for which you want to view information and click [View ]. On the Items tab of the sales invoice locate the line item for which you want to view the amount. The number in the Amount column for the line item is the location from which the number on the view originates. 

Sales Credit Memos and Debit Memos : The system looks at the number in the Amount column of the line item on the sales credit/debit memo. To locate this column in e-automate, from the Sales menu select Sales invoices to display a list of all sales invoices. Select the sales credit/debit memo for which you want to view information and click [View ]. On the Items tab of the sales invoice credit/debit memo locate the line item for which you want to view the amount. The number in the Amount column for the line item is the location from which the number on the view originates.

Contract Invoices , Credit Memos - Misc. Charges : The system looks at the number in the Amount field on the Misc tab on the contract record. To locate this column in e-automate, click [Contracts ] on the e-automate toolbar to open the Service Contracts console. Select the contract for which you want to view revenue and click [View ] to open the contract in view mode. Click the Misc tab to bring it forward. The value in the Amount field on this tab is the location from which the value on the view originates.

Contract Invoices , Credit Memos - Base Adjustments : The system looks at the base adjustment assigned to the contract associated with the invoice or credit memo. To locate the base adjustment in e-automate, open the contract associated with the invoice or credit memo. Click the Misc tab to bring it forward. In the Adjustment code field, click the down arrow and select Edit to open the Edit contract adjustment code window. The values in the fields of the Base region are where the revenue value in the view originates for this type of transaction.

Contract Invoices , Credit Memos - Overage Adjustments : The system looks at the overage adjustment assigned to the contract associated with the invoice or credit memo. To locate the overage adjustment in e-automate, open the contract associated with the invoice or credit memo. In the Adjustment code field, click the down arrow and select Edit to open the Edit contract adjustment code window. The values in the fields of the Overage region are where the revenue value in the view originates for this type of transaction.

Contract Invoice , Credit Memos - Lease : The system looks at the value in the Payment amount field on the Lease tab on the contract record. To locate this field in e-automate, click [Contracts ] on the e-automate toolbar to open the Service Contracts console. Select the contract for which you want to view revenue and click [View ] to open the contract in view mode. Click the Lease tab to bring it forward. The value in the Payment amount field on this tab is the location from which the value on the view originates.

Contract Invoices , Credit Memos - Base : The system looks at the value in the Base rate of field on the Base billing tab on the contract record. To locate this field in e-automate, click [Contracts ] on the e-automate toolbar to open the Service Contracts console. Select the contract for which you want to view revenue and click [View ] to open the contract in view mode. Verify the Base billing  tab is forward. The value in the Base billing of field on this tab is the location from which the value on the view originates.

Contract Invoices , Credit Memos - Overages : The value for the contract invoice overage originates from the overage displayed for that contract on the Contract Invoices report. The Contract Invoices report is listed in the Service group of reports in the e-automate Reports Console .

AP Vendor Invoices : The Revenue column is not applicable for this type of transaction.

Cost : Cost associated with this transaction. The following lists each transaction type and where Analytics looks in e-automate for the values that display in the e-view:

Misc. Charge Invoices : The system looks at the value in the Charge cost field, of the line item detail on the Miscellaneous Charge Invoice. To locate the field in e-automate, from the Accounting menu, select Accounts Receivable > Miscellaneous charge invoices to display a list of Miscellaneous charge invoices. Select the invoice from the list and click [View ] to view the invoice. On the Charges tab locate the line item for which you want to view cost and click [View... ]. The number displayed in the Charge cost field of the detail window is the location from which the cost displayed in the view originates.

Misc. Charge Debit and Credit Memos : The system looks at the number in the Charge cost field of the line item detail on the credit/debit memo. To locate the field in e-automate, from the Accounting menu, select Accounts Receivable > Miscellaneous charge debit memos/Miscellaneous charge credit memos to display a list of Miscellaneous charge credit/debit memos respectively. Select the credit or debit memo from the list and click [View ] to view the credit/debit memo. On the Charges tab select the line item for which you want to view cost and click [View... ]. The number displayed in the Charge cost field of the detail window is the location from which the revenue displayed in the view originates.

Service Invoices, Service Invoice Credit Memo - Materials : The system looks in two different places in e-automate to locate a number with which to populate the Cost column for Service Invoices for Materials. The following locations are listed in order of priority.

The system first looks at the Avg. cost field in the Warehouse/bin/quantity detail of the service invoice/credit memo item detail. To locate this field in e-automate, on the Materials tab of the service invoice/credit memo for which you want to locate the e-view column source, select the line item and click [View ] to open the View Report Material window. In the View Report Material window locate the Warehouse/bin/quantity tab, select the warehouse/bin you want to view, and click [View ] to open the View Report Material Item Bin window. The Avg. cost field in this window is the location from which the value in the Cost column of the view originates.

If the Avg. cost field is 0,  the system will look at the Average Cost field of the service invoice/credit memo line item detail. To locate this field in e-automate, on the Materials tab of the service invoice for which you want to locate the e-view column source, select the line item and click [View ] to open the View Report Material window. The Average cost field in this window is the field from which the value in the Cost column of the view originates.

Service Invoices, Service Invoice Credit Memo - Labor : The Cost column is not applicable for this type of transaction.

Service Invoices, Service Invoice Credit Memo - Travel : The Cost column is not applicable for this type of transaction.

Service Invoices, Service Invoice Credit Memo - Miles : The Cost column is not applicable for this type of transaction.

Service Invoices, Service Invoice Credit Memo - Misc. Charges : The Cost column is not applicable for this type of transaction.

Sales Fulfillments : The system looks in the Average Cost field of the line item detail on the sales order associated with the fulfillment. To locate this field in e-automate, on the Items tab of the sales order associated with the fulfillment, select the line item, and click [View... ] to open the View Sales Order Item window. The Average cost field in this window is the field from which the number originates.

Sales Invoices : The system looks in two different places in e-automate to locate a number with which to populate the Quantity column for Service Invoices for Materials. The following places are listed in order of priority.

The system first looks at the Avg. cost field in the Warehouse/bin/quantity detail of the item detail. To locate this field in e-automate open the sales invoice, in View mode, for which you want to locate the e-view column source. On the Items tab, select the line item for which you want to view quantity and click [View... ] to open the View Sales Invoice Item window. On the Warehouse/bin/quantity tab, select the appropriate warehouse/bin and click [View ] to open the View Invoice Item Bin window. The Avg. cost field in this window is the location from which the value in the view originates.

If the Bins Avg. cost field in the Warehouse/bin/quantity detail of the item detail is 0, the system will look at Average cost field of the line item detail. To locate this field in e-automate open the sales invoice, in View mode, for which you want to view quantity in View mode for which you want to locate the e-view column source. On the Items tab, select the line item for which you want to view quantity and click [View... ] to open the View Sales Invoice Item window. The Average cost field in this window is the location from which the value in the view originates.

Sales Credit Memos and Debit Memos :  The system looks at the number in the Average cost field on the sales credit/debit memo. If applicable, the system looks at the Warehouse/bin/quantity section of the item detail. To locate these fields in e-automate, from the Sales menu select Sales invoices to display a list of all sales invoices. Select the sales invoice for which you want to view cost and click [View ]. On the Items tab of the sales debit/credit memo locate the line item for which you want to view the cost and click [View... ]. The Average cost field in this window is the location from which the value in the view originates. If the Warehouse/bin/quantity section is applicable, select the appropriate line item in the Warehouse/bin/quantity section and click [View ]. The Average cost field of the View Invoice Item Bin window is the location from which the value in the view originates.

Contract Invoices , Credit Memos - Misc. Charges : The Cost column is not applicable for this type of transaction.

Contract Invoices , Credit Memos - Base Adjustments : The Cost column is not applicable for this type of transaction.

Contract Invoices , Credit Memos - Overage Adjustments : The Cost column is not applicable for this type of transaction.

Contract Invoice , Credit Memos - Lease : The Cost column is not applicable for this type of transaction.

Contract Invoices , Credit Memos - Base : The Cost column is not applicable for this type of transaction.

Contract Invoices , Credit Memos - Overages : The Cost column is not applicable for this type of transaction.

AP Vendor Invoices : The system looks at the value in the Amount field of the line item detail of the Accounts Payable invoice. To located this field in e-automate, from the Accounting menu select Accounts payable > Accounts payable invoices to display a list of AP invoices. Select the invoice for which you want to view cost from the list and click [View ] to open the AP invoice in view mode. Select the line item for which you want to view cost and click [View... ] to open the View Charge window. The Amount field in the View Charge window is the location from which the value in the view originates.

Margin : Revenue - Cost. The amount is the amount present in the Amount column of the e-automate invoice record.

Out Cost Extended : Total out cost for all items on the sales invoice. For example, if the sales invoice has an out cost of $10 and the quantity is 10 for one line item, then the out cost extended would be $100.

Clicks-Actual : Total meters for the equipment associated with the transaction.

Clicks-Base and Overage : Total amount of base and overage meters for the equipment associated with this transaction.

Clicks-Base : Total amount of base meters for the equipment associated with this transaction.

Clicks-Overage : Total amount of meters over the configured maximum for the equipment associated with this transaction.

Clicks-Underage : Total amount of meters under the configured minimum amount for equipment associated with the transaction.

Entered By : Name of the employee who entered the transaction.

Entered Date : Date the transaction was entered.

The columns listed above are the columns that display when the view is run as is without customizing. More columns can be added to this report when you customize. For more information on customizing a view, see the Creating and Customizing a View topic. The following columns are those that you can add when customizing:

Equipment Instance : Displays the number of times the same equipment record is added to the contract. If the equipment record is added a second time, this field will display 2. If the equipment record is added a third time, this field will display 3.

Fiscal Qtr : Displays the fiscal quarter in which the transaction occurred.

Fiscal Year : Displays the fiscal year in which the transaction occurred.

Ship To Number : Customer number assigned to the customer that is designated the ship to customer on the transaction.

Record Count : Amount of transaction records included in this view.

SUM (Quantity) : Total quantity for all transactions listed in the view.

SUM (Revenue) : Total revenue generated from ALL transactions in this view.

SUM (Cost) : Total cost associated with all equipment listed in this view.

SUM (Margin) : Total margin for all transactions included in this view.

SUM (Clicks-Actual) : Total meters for ALL transactions listed in the view.

SUM (Clicks-Base-and-Overage) : Total base and overage meters for ALL transactions listed in the view.

SUM (Clicks-Base) : Total base metes for ALL transactions listed in the view.

SUM (Clicks-Overage) : Total amount of meters over the configured maximum for the ALL equipment listed in this view.

SUM (Clicks-Underage) : Total meters under the configured minimum amount for ALL transactions listed in the view.