Meter Data Reference

Overview

This functionality is ideal for managing products that depend on Meter Readings such as Digital Printing Machines.

Meter Readings can be linked to:

  • SM Tickets: Used when an asset is linked to a Service Ticket.
  • Transaction Items:
    • Used to generate invoices.
    • The Item Qty is calculated as the difference between the current and the last meter readings less the minimum quantity (Min Qty.)
    • The Min Qty is charged out at a Fixed Price. The fixed price can be zero if the minimum quantity is free.
    • The transaction item note is populated with the last and current readings as well as the calculation used to obtain the billable quantity.
    • NB. This feature only works on transactions that use Selling Price.
    • Inbox: Read incoming emails and update the Meter Data records by Serial No. and date.

Settings

User Settings

Navigation

Main Menu > Settings > Users (tab)

  • General > Meter Data – Access Allowed: Choose one of these options:
    • None
    • View Only
    • Full Access

Transaction Settings

Navigation

Main Menu > Settings > Transactions (tab)

Info

This process identifies the transaction that is used to charge the customer for the use of the asset.

  1. Click Add/Update (button).
  2. Select a transaction on the left (e.g. Customer Invoices).
  3. Type meter in the search block on the right.
  4. Click the setting: Transactions > Link Meter Data to Transaction Items.
  5. Click Add/Update (button).
  6. Click Close (button).
  7. Check the checkbox in the Value column next to the added setting.

Setting up Items Tutorials

Create a Class

Create a Class for Assets if one does not already exist.

  1. Navigate to Items (e.g. Main Menu > Items > Items).
  2. Click Menu (button) > Edit Classes.
  3. Click New (button) and complete the popup as follows:
    1. Name = Assets.
    2. Data Type = Assets.
  4. Click Save (button).

Create a Category

Create an Item Category for Assets if one does not already exist.

  1. Navigate to Items (e.g. Main Menu > Items > Items).
  2. Click Menu (button) > Edit Categories.
  3. Click New (button) and complete the new row as follows:
    1. Name = Enter a name for the category (e.g. Billable Assets).
    2. Class = Select Assets from the dropdown list.
    3. Leave the other fields blank.
  4. Right-click the new category and click Set default Tab.
    1. Click the following checkboxes:
      1. Units
      2. Costing & Pricing
      3. Accounting
    2. Click anywhere outside the list to close it.
  5. Right-click the new category and click Enable Fields.
    1. Click the following checkboxes:
      1. Make and Model
      2. Reference
      3. Entities (if you have multiple entities)
      4. Customer

Create an Item for each Asset

See Item Creation Tutorial for detailed instructions.

See Asset Items & Depreciation if you want to record depreciation automatically.

Notes:

  • Units: Create units for all the different meter-based charges (e.g. B/W Copy, Colour Copy).
  • Selling Price
    • Add a Unit Price for each created unit.
    • Add a Fixed Price and Min Qty for each unit.
    • For example,
      • If you charge a customer R200 for the first 1000 copies, then the Fixed Price is R200 and the Min Qty is 1000.
      • If the first 1000 copies are free, then the Fixed Price is zero, and the Min Qty is 1000.

Meter Data Module

  • The Meter Data module provides a unified interface where you can view all the meter data in the system.
  • If the current meter reading is less than the last reading, the Last reading is highlighted in red.
  • The Average column displays the average reading for the last 12 months and is highlighted in red if the current reading is below average. If the contract is less than 12 months old, the Average will be based on the number of months the contract has been running.
  • The Meter Data can be added to a menu by selecting Type = Fixed and then selecting Meter Data.
  • It can also be accessed from an asset by clicking View Meter Data on the Assets tab. However, this link filters the data to the specific asset. Click All next to the Asset filter to view all the records.

Buttons Explained

ButtonDescription
ViewDisplays the meter readings as per the selected filters.
EditAllows the data to be edited. The following fields can be edited: Date, Reading, Qty and Override. The Qty can be edited when Override = True.
NewCreates a new unlinked record.
SaveSaves any changes.
Actions
  • Batch Update: Updates the following fields for all the selected records if Update (button) is clicked and confirmed:
    • Transaction Status: Updates the transaction status to the one selected from the dropdown list. A transaction must be selected next to Linked.
    • Date: Updates the date of the meter reading.
    • Override Qty: Checks or unchecks the permission to override the quantity.
  • Insert/Update linked Meter Data records:
    • Requires a date and a transaction to be selected.
    • Updates the meter data readings for the selected date if confirmed.
    • The Action adds a meter data record for each Transaction Item that is linked to an asset which uses Meter Data. This Action is automatically executed when you click View (button) and the above conditions are met.
  • Update Meter Reading:
    • Updates the meter readings for the selected records.
    • This action can be executed on records that are linked to transactions and have a 0 quantity.
    • It updates the records from an unlinked or linked Meter Reading that meets the following criteria:
      • The month and year must match.
      • The meter date must be earlier than the transaction date.
      • The reading must be linked to the same Serial No. and unit (e.g. Colour, Mono) as on the Transaction (MATUNITID, MATCOSTID).
      • When a transaction reading has been updated from an unlinked meter reading, the unlinked meter reading is deleted.
Menu

Filters Explained

FilterDescription
DateA selection of predefined date filters.
LinkedA dropdown list to display:
  • All: Displays all the records. The date filter applies to the Meter Reading date.
  • All Transactions: Displays all the records linked to transactions. The date filter applies to the transaction date.
  • Unlinked: Displays unlinked records. The date filter applies to the Meter Reading date.
  • Service Manager: Displays all the records linked to the service manager. The date filter applies to the service ticket date.
  • Customer Invoices (CI) where customer invoices is an example of a transaction that is linked: Displays all the records linked to the specific transaction. The date filter applies to the transaction date.
CustomerA dropdown list of customers to select all or a specific customer.
AssetA dropdown list of assets to select all or a specific asset.
DepartmentA dropdown list of departments to select all or a specific department.

Fields Explained

FieldDescription
IDThe system-generated number for the entry.
StatusThe status of the entry.
MatCostIDThe system-generated number for the cost entry.
MatunitIDThe system-generated number for the unit entry.
LinkedA code and number of any linked service ticket or transaction.
Trans DateThe transaction or service ticket's date.
Trans CategoryThe transaction's category.
DepartmentThe department selected for the entry.
CategoryThe item's category.
SubcategoryThe item's subcategory.
DescriptionThe item's description.
Serial No.The asset's serial number.
ReferenceThe item's reference.
RemarkAny entered remark.
CustomerThe customer linked to the asset.
Meter DOMThe meter reading date (e.g. 20 for 20th of each month).
Billing DOMThe invoice date (e.g. 25 for the 25th of the month).
Billing MethodThe customer's billing method.
UnitThe unit linked to the meter reading.
Last DateThe last date on which the meter was read.
Last ReadingThe last reading for the meter.
AverageThe average reading.
DateThe date of the current reading.
ReadingThe actual reading.
QtyThe quantity (difference between last and current reading)
TotalThe cost of the reading.
Override QtyCheckbox. If checked the quantity can be edited.
Menu (...)A context menu that can also be accessed by right-clicking an entry with the following actions:
View/Edit Meter DataOpens a list of recent readings that are unlinked and can be assigned to a transaction.
Open Transaction / TicketOpens the linked ticket or transaction.
Open Asset in ItemsOpens the item record.
Open Asset SummaryDisplays an item summary for the asset.
Delete Meter DataDeletes the meter readings.

Use-Case Example: Add meter readings to monthly Contract Billing invoices.

  1. Create all the Contract Billing Invoices for this month and leave them in a Pending Status.
  2. Open the Meter Data module and set these filters:
    1. Date = This month.
    2. Linked = Select the transaction used for invoices.
  3. Click Actions (button) > Add/Update Meter Data. All the meter readings for the month are displayed.
  4. Enter the readings.
  5. When the readings are complete, click Actions (button) > Batch Update and update the Status of the Invoices that are ready to be sent.

Report an issue with this page

For more useful feedback, select the text on the page you're reporting about, then click Feedback again — or continue without selecting anything.