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
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 Allowed | Choose one of these options:
| None |
Transaction Settings
Info
This process identifies the transaction that charges the customer for the use of the asset.
- Click Add/Update (button).
- Select a transaction on the left (e.g. Customer Invoices).
- Enter 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 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.
- 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
Info
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 select 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 select 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 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 |
|---|---|
| View | Displays the meter readings as per the selected filters. |
| Edit |
|
| New | Creates an unlinked record. |
| Save | Saves any changes. |
| Actions |
|
| Menu |
|
Filters Explained
| Filter | Description |
|---|---|
| Date | A selection of predefined date filters. |
| Linked | Select what 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
Info
Fields marked in blue (✎) can be edited.
| 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 | Click the button or right-click a meter reading for these options:
|
| 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 appear.
- 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.