Meter Data Reference

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 and the calculation used to obtain the billable quantity.
    • NB. This feature only works on transactions that use Selling Price.

Settings

User Settings

Navigation Example

Main Menu > Settings > Users (tab)

Note

The defaults are the values for new databases, new users and new Transaction Types. Your database may have different values.

Setting Description Default
General > Meter Data - Access AllowedChoose one of these options:
  • None
  • View Only
  • Full Access
None

Transaction Settings

Info

This process identifies the transaction that charges the customer for the use of the asset.

Navigation Example

Main Menu > Settings > Transactions (tab)

  1. Click Add/Update (button).
  2. Select a transaction on the left (e.g. Customer Invoices).
  3. Enter 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 box in the Value column next to the added setting.

Setting Up Items Tutorials

Create a Class

Info

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

Info

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 select 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 select 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 1 000 copies, then the Fixed Price is R200 and the Min Qty is 1 000.
      • If the first 1 000 copies are free, then the Fixed Price is zero, and the Min Qty is 1 000.

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 is 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

Button Description
ViewDisplays the meter readings as per the selected filters.
Edit
  • Allows 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 an 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 is updated from an unlinked meter reading, the unlinked meter reading is deleted.
Menu

Filters Explained

Filter Description
DateA selection of predefined date filters.
LinkedSelect what 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.
  • A Transaction Type (for example, Customer Invoices (CI)): Displays all the records linked to that Transaction Type. 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

Info

Fields marked in blue (✎) can be edited.

Field Description
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.
MenuClick the button or right-click a meter reading for these options:
  • View/Edit Meter Data: Opens the meter reading.
  • Open Transaction: Opens the linked transaction. Only appears when the reading is linked to a transaction.
  • Open SM Ticket: Opens the linked SM Ticket. Only appears when the reading is linked to a ticket.
  • Open Asset in Items: Opens the asset in the Items module.
  • Open Asset Summary: Shows a summary of the asset.
  • Delete Meter Data: Deletes the meter reading. Does not appear with view-only access.
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 appear.
  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.