270 likes | 389 Vues
This presentation provides an in-depth look at Total Revenue Management (TRM), covering key aspects such as user login and security, master data entry, billing processes, payment handling, and journal entries. It highlights essential functionalities including search and query tools, MIS reports, and database management. The presentation is tailored for data entry operators, clerks, and administrators, detailing procedures for consumer data entry, billing adjustments, payment imports, and journal entry corrections. Learn about the TRM's efficient reporting and database design features utilizing Oracle and VB technology.
E N D
Presentation on Total Revenue Management (TRM)
Total Revenue Management SCOPE • LOGIN / SECURITY • MASTER ENTRY • BILLING • PAYMENT • JOURNAL ENTRY (JE) • SEARCH / QUERY TOOL • MIS REPORTS
TRM – Login / Security Data Entry Operator Clerk (Ledger / Counter) A.O Admin A.E.E User - Rights Verification Database
New Consumer Entry Consumer Changes Account (Meter) Status Changes Master Data Changes TRM – Master Entry
Upload and Download (SBM) Manual Bill Generation Trivectory Bill Generation TRM – Billing
Manual Payment Entry Counter Payments Export master info Import Counter Payment SBM Payments Create master data Create header file Import Payments TRM – Payment
Journal Entry Cheque bounce Wrong account Other payments Meter reading Correct account Sluggish Deposit adjustment Cheque bounce Back billing charges Audit short claim Meter test charges Disconn and recon fee TRM – Journal Entry (JE)
Consumer Search (View) Ad-hoc Query TRM – Search / Query Tool
JSP Reports TRM – MIS Reports
TRM – Database Design P R O F I L E S V I E W S P A C K A G E S I N D E X E S C O N S T R A I N T S P H Y S I C A L D A T A B A S E B A C K – E N D T R A C K E R
TRM – Development Tools DATABASE : ORACLE 9i APPLICATION : VB 6 REPORTS : MIS Reports
TOTAL REVENUE MANAGEMENT THANK “U”