This page is currently being edited by {{ model.editingBy }}.

SmartFusion Modules > Billing > Utility Billing > Reports > Transaction Report

Recent Changes:
6.229 - Added functionality on transaction report to pull Deposit Payments as a payment when Payments are selected as a transaction type

6.222 - Fixed an issue where the transactions were duplicated for posted converted transactions with system number as 1.

6.212(Supplemental Release) - Fixed an issue where the transactions were duplicated for non-posted transactions.

6.212 - Added checkbox "Show fund ledger posting". When this checkbox checked it will show system number and the posting date and hide the transaction number and batch number and when checkbox unchecked then show the transaction number and batch number and hide the system number and posting date. 

6.210 - Added a new Billing Cycle filter in include all section.

6.188 - Updated the data pull for the Transaction Report to look at the Actual Amount and BudgetBilledAmount in ar012 instead of referring to the BudgetBilledItem table when Budget Billing is Activated in the UB System File

6.183
- Added a new Master Code filter to include all section.
- Set headers and subtotals for reports run by Master Code sequence.
- Created a None Group for reports run by Service Code sequence.
- Set headers and created grouping for summary reports run by Master Code sequence.
- Set headers and displayed location descriptions for summary reports run by Location Zone sequence.

6.167
- Fixed an issue where certain transaction code(s) were not pulling on the report when 'All transaction types' is unchecked  and the user selects  a particular transaction type, if one time charge was saved as a null value.

6.156
- Removed Beginning and Ending user and replaced with combo checkbox control to allow for all/selected users
- Added Transaction Type filtering

Refer to bottom of page for changes prior to version 6.100

Introduction

This report shows any transactions that have been billed, paid, or any type of adjustments made to a customer’s record. This is the same report that can be run from the Transactions tab on the Customer Master.

Explanation

This report includes:

Summary View

Transaction Code
Transaction Description
Number of Customers
Amount
Usage

Detail View

Date
Account Number
Name
Amount
Check
User
Transaction Number (Conditional)
Batch (Conditional)
Posting Date (Conditional)
System Number (Conditional)

Sub Details

Service Address
Meter Number
Usage
Notes
Service Code

Form Options

Report Sequence - order by Account Number, Batch Number, Location Zone, Master Code, Transaction Code, User, Service Code. Additionally, if sorting by Transaction Code, one can add a secondary sort by Batch Number or Transaction Number.
Output Option - Select either a summary or detail view
Transaction Date Range - select a transaction date range
Batch Number Range - select a batch number range
Route Range - select a route range
User - select user(s)
Billing Date - Filter by billing date
Actual Amounts/Budget Billed Amounts - print either budget billed or actual amounts
Include Posted - include posted transactions
Include not posted - include transactions not posted
Print Service Address - print the service address on the report
Print Meter Number - print the meter number
Print Note Field - print notes for the transaction
Show Fund Ledger Posting - Is visible only when 'Include Posted' is checked. When checked will print the system number and posting date and hide the transaction number and batch.
Print Actual charges for budget billed customers - Print actual charges for budget billed customers
Print Service Code
Transaction Code - select specific transaction codes
Service Code - select specific service codes
Master Codes - select specific master codes
Location Zones - select specific location zones
Transaction Types - select transaction types for filtering

Changes Prior to Version 6.100

6.76 
- Added new sequence for Service Code
- Added new check box to include Service Code on report
- Added Include filter for Service Code
- Updated report to UX standards
- Updates to data pull to correct summary amounts not being consistent with detail totals
- Added grid reporting

6.69 - Add a sum field for usage to the summary report

{{ $tag }},