Generate XML data file for Utility Billing Bills




Description of Issue

Generate XML data files for Utility Billing Bills

Context
  • Munis 
  • Utility Billing CIS - UBCIS
  • Bills
Cause

Request from Tyler Forms Design to assist customer in creating a data file for UB Bills in XML format

Resolution


To generate this file from a completed Bill Run use the following steps.

       

  1. Find a Bill or Bills that contain the information you want to display on your printed bills.  Example: If you want to have credits,adjustments,past due balances, or payments display on your bills then select bills that would have that information.
  2. View that Bill in Bill Inquiry to get the Bill Run Type/Commitment information and note that along with the Account Number
  3. Navigate to Property Revenues>Utility Billing>Bill Processing>Bill Run Process
  4. Click Search.
  5. Enter the Bill Run Type and Commitment then click Accept
  6. Click Change
  7. Click Bill Print.
  8. Click Define.
  9. Enter Interest Date and Payment/Adjust Date that will reflect what you want to show on the bill.
  10. In the Reprint Accounts area enter the Account Number from Step 2 in both the Start and Stop fields.
  11. In the Print Options area select the Output Type of XML Export then click Accept
  12. Click Generate.
  13. Click Print Bills
  14. When the option to select Output Type use one of the following options 
    1. If you need the XML output for a third party print vendor or for support troubleshooting. Save and then OK this is save the file in your Munis Spool Directory.
    2. If you need the Ready Forms data file select Export ReadyForms data file and you can select Download to save immediately or use the option to Save to 'My Reports' and continue to step 15 to retrieve file
  15. Navigate to Departmental Functions> My Saved Reports.
  16. Locate your file.
  17. Highlight the file, click Accept or double click the correct file, the web browser should download and produce the data file.

To generate this file from an in progress Bill Run complete the Bill Run as you normally would until you reach the Bill Print step.

  1. Click Bill Print.
  2. Click Define.
  3. Fill in any options you would as part of your Bill Print step
  4. In the Print Options area select the Output Type of XML Export then click Accept
  5. Click Generate.
  6. Click Print Bills
  7. When the option to select Output Type use one of the following options

    1. If you need the XML output for a third party print vendor or for support troubleshooting. Save and then OK this is save the file in your Munis Spool Directory.

    2. If you need the Ready Forms data file select Export ReadyForms data file and you can select Download to save immediately or use the option to Save to 'My Reports' and continue to step 8 to retrieve file

  8. Navigate to Departmental Functions>My Saved Reports.
  9. Locate your file.
  10. Highlight the file, click Accept or double click the correct file, the web browser should download and produce the data file.
Additional Information