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
- General > Meter Data – Access Allowed: Choose one of these options:
- None
- View Only
- Full Access
Transaction Settings
Info
This process identifies the transaction that is used to charge the customer for the use of the asset.
- Click Add/Update (button).
- Select a transaction on the left (e.g. Customer Invoices).
- Type meter in the search block on the right.
- Click the setting: Transactions > Link Meter Data to Transaction Items.
- Click Add/Update (button).
- Click Close (button).
- 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.
- Navigate to Items (e.g. Main Menu > Items > Items).
- Click Menu (button) > Edit Classes.
- Click New (button) and complete the popup as follows:
- Name = Assets.
- Data Type = Assets.
- Click Save (button).
Create a Category
Create an Item Category for Assets if one does not already exist.
- Navigate to Items (e.g. Main Menu > Items > Items).
- Click Menu (button) > Edit Categories.
- Click New (button) and complete the new row as follows:
- Name = Enter a name for the category (e.g. Billable Assets).
- Class = Select Assets from the dropdown list.
- Leave the other fields blank.
- Right-click the new category and click Set default Tab.
- Click the following checkboxes:
- Units
- Costing & Pricing
- Accounting
- Click anywhere outside the list to close it.
- Click the following checkboxes:
- Right-click the new category and click Enable Fields.
- Click the following checkboxes:
- Make and Model
- Reference
- Entities (if you have multiple entities)
- Customer
- Click the following checkboxes:
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
| Button | Description |
|---|---|
| View | Displays 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. |
| New | Creates a new unlinked record. |
| Save | Saves any changes. |
| Actions |
|
| Menu |
|
Filters Explained
| Filter | Description |
|---|---|
| Date | A selection of predefined date filters. |
| Linked | A dropdown list to display:
|
| Customer | A dropdown list of customers to select all or a specific customer. |
| Asset | A dropdown list of assets to select all or a specific asset. |
| Department | A dropdown list of departments to select all or a specific department. |
Fields Explained
| Field | Description |
|---|---|
| ID | The system-generated number for the entry. |
| Status | The status of the entry. |
| MatCostID | The system-generated number for the cost entry. |
| MatunitID | The system-generated number for the unit entry. |
| Linked | A code and number of any linked service ticket or transaction. |
| Trans Date | The transaction or service ticket's date. |
| Trans Category | The transaction's category. |
| Department | The department selected for the entry. |
| Category | The item's category. |
| Subcategory | The item's subcategory. |
| Description | The item's description. |
| Serial No. | The asset's serial number. |
| Reference | The item's reference. |
| Remark | Any entered remark. |
| Customer | The customer linked to the asset. |
| Meter DOM | The meter reading date (e.g. 20 for 20th of each month). |
| Billing DOM | The invoice date (e.g. 25 for the 25th of the month). |
| Billing Method | The customer's billing method. |
| Unit | The unit linked to the meter reading. |
| Last Date | The last date on which the meter was read. |
| Last Reading | The last reading for the meter. |
| Average | The average reading. |
| Date | The date of the current reading. |
| Reading | The actual reading. |
| Qty | The quantity (difference between last and current reading) |
| Total | The cost of the reading. |
| Override Qty | Checkbox. 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 Data | Opens a list of recent readings that are unlinked and can be assigned to a transaction. |
| Open Transaction / Ticket | Opens the linked ticket or transaction. |
| Open Asset in Items | Opens the item record. |
| Open Asset Summary | Displays an item summary for the asset. |
| Delete Meter Data | Deletes the meter readings. |
Use-Case Example: Add meter readings to monthly Contract Billing invoices.
- Create all the Contract Billing Invoices for this month and leave them in a Pending Status.
- Open the Meter Data module and set these filters:
- Date = This month.
- Linked = Select the transaction used for invoices.
- Click Actions (button) > Add/Update Meter Data. All the meter readings for the month are displayed.
- Enter the readings.
- When the readings are complete, click Actions (button) > Batch Update and update the Status of the Invoices that are ready to be sent.