Create Export File

Use the Create Export File routine to create a work file of the accounts and associated meter information to be included in the meter export file. The Create Export File is controlled by the meter export ID.

Notes:

Messages display the status of the process. When Done displays the routine is complete. Review all of the processing messages to make sure the routine completed properly. You can print the exception report and review any exceptions to the account and meter information. For example, the exception report lists inactive accounts and customers with missing meter numbers. If the exception report lists customers with missing meter errors, make the necessary corrections and process the Create Export File again.
You can specify the customer cycle numbers to be excluded by this process during Meter Export Maintenance.
The read variance table determines the minimum and maximum readings for the meter export file.
For information about minimum and maximum reading variance calculations, click More.
The Create Export file calculates the estimated minimum reading, the maximum reading, the minimum usage and the maximum usage for the hand-held device validation. Some hand-held devices use readings while other hand-held devices use usage.

The calculations are as follows:

Variables: Last Read = 1111, Last Usage = 1000, Minimum Variance = 45%, Maximum Variance = 130%
- Minimum Reading = LastRead + (Minimum % X usage), or 1561 = 1111 + (0.45 * 1000)
- Maximum Reading =-LastRead + (Maximum % X usage) or 2411 = 1111 + (1.30 * 1000)
- Minimum Usage = LastUsage + (Minimum % X usage) or 1450 = 1000 + (0.45 * 1000)
- Maximum Usage =-LastUsage + (Maximum % X usage) or 2300 = 1000 + (1.30 * 1000)
To see an example of the report, click Create Export File Printout Sample.

Directions:

To open:

From the Export/Import Control panel, click Create Export File .

Or, click Daily Work from the Menu, click Billing, click Meter Communications, and then click Export File.

Or, use the keyboard shortcut: [ALT] [y [b] [m] [f].

Create Export File Window Example:

Create Export File Prompts
Meter Export	Enter the meter export ID for creating the Meter Export file. (up to 20 characters) Note: To search for a Meter Export ID, click or press [CTRL + f].
Meter Reader	The name of the meter reading device assigned to the meter export ID displays for your reference.
Read Date	Enter the date the meters will be read or an approximate date the meters will be read. (mm/dd/ccyy)
Cycle	Enter the meter reader export cycle for the export, if applicable. (2.0 numeric) Notes: This field is only active for certain types of meter readers. Do not confuse the meter export cycle with the customer cycle number. They are two separate fields and have separate functions.
Book Numbers	To select the book numbers to include in the export, check the desired boxes. Tip: It is important to review the selected book numbers to verify which ones are being exported.
	To begin, click Create. Keyboard shortcut: [ALT + r] To escape from this routine without beginning, click Cancel . Keyboard shortcut: [ALT + c]
	To print the exception report, click Print. Keyboard shortcut: [ALT + p] Note: Print the exception report if the following message displays:
Process Status	Displays information pertaining to the various phases of the process to guide you.
Process Status	Important: The status displays Complete when the process is ended. In addition, the Message window displays Process Ended and Process Ended to alert you when the routine is complete, as well as the following message:
	To close out of the window, click Close . Keyboard shortcut: [ALT + d]