IMPORT Meter Readings

METER READING IMPORT

The Storage and Billing Meter Parameters will need to be defined with a path to the Folder that will contain the meter readings.  The Rate Per KW in the Params will be used to calculate charges.

 

This path MUST be in a shared location if multiple folks will be running the process.

This is what an import csv file looks like

Column A = time hh:mm:ss

Column B = Meter Id on the slip

Column C = KW hours

Column D = date mm/dd/yyyy

 

 

When the import is run, the path will default to the path above, and the clerk will need to select the current meter reading file in the folder.

 

 

 

 

The clerk will receive a message on how many records were processed.

 

 

 

 

The process to review each reading and or modify a reading is the same as if manually entering the electric meters readings one by one..

 

Open the form, enter the date used in the import file.  Click on the process icon and the form will open with all the meters, hours, and charges.  Review for accuracy.

 

 

 

 

 

 The clerk should always review A/R CHARGES EDIT LIST, under the Billing Functions Menu.

 

 If all the readings are correct, then the clerk may Post the Meter Reading Charges.

 

 

If the readings were NOT correct, then then Non-posted Storage Bills should be Deleted.

**If at any point you run into any issues, feel free to email [email protected] for assistance.**