Home Up Feedback Search

MMX Tenant Billing
Up Report Generator CCS Tech Toolset Data Report UploadDecompileSave NWS Data Import Upload Automation Scheduling Manager Energy Report Master Shutdown MMX Tenant Billing MMX Call In Rpt PT Hist Tenant Billing Alarm Notifier M-Trend Data Remote Access RptRtr Scheduler OpTrans Viewer Trend Data Manager Tenant Billing Card Access Apps Report Notifier

 

Request Download

MMX Tenant Billing Application

Created by Custom Computer Systems

www.davidhagemann.com

Click on the following links to go directly to the information listed.

Home - Invoicing - The Invoice - Data Details - Tenant Info - Tenant Loads - Setup Tab - Setup Instructions

 

MMX Tenant Billing Application Requirements:

bullet

Install on a Metasys Operator Workstation or M5 Workstation.  

bullet

Have the MMX Log File (AWX32LOG.MDB or whatever it was named) available to this PC.

bullet

Have Microsoft Excel installed on this OWS or M5 workstation.  

bullet

Operating System - Win95, Win98, Win2000 or WinNT.  

MMX Tenant Billing Application Features:

bulletAutomatically assigns loads to tenants based on the event log.
bulletThe MMX Log File determines the number of minutes the load is ON based on the event log.
bulletYou can have Normal Hours where the tenant is not charged, or charge for all load use.
bulletSelect a date range and generate invoices for all tenants or a selected tenant with the press of a button.
bulletThe Excel file generated has two sheets.  The Invoice sheet and the Details sheet which shows all of the event log entries for each load used in generating the invoice.
bulletAn Invoice Number is generated for every invoice.  The file name will be the invoicenumber.xls.  The invoice number can either be the EndDate-TenantID (YYMMDD-ID) or an incrementing number.
bulletTenant info has a list of the invoice numbers generated for each tenant.  Double-clicking on the invoice number opens the invoice.
bulletYou can view and print the Data Details for any tenant, any date range, anytime.

 

Home - Invoicing - The Invoice - Data Details - Tenant Info - Tenant Loads - Setup Tab - Setup Instructions

Invoicing Tab

Select the Start Date and End Date of the billing period and click on Invoice.  An invoice is generated and printed for each Tenant.  You have the option to Print Details Sheet.  This sheet shows the date and time each load was commanded on or off.  The application uses the MMX Event Log to determine the time each load was on.  You specify the Cost Per Hour for each load the first time the application generates invoices - you will be prompted to enter the Cost Per Hour.  You can easily modify the Cost Per Hour at any time (See Tenant Load section).

The screen capture below shows how to generate an invoice for a selected tenant.

When invoicing a selected tenant you have the the addition options to Keep Excel open and Do not print.  They do exactly what they say.

Below is an example of the standard Excel Outputs.

Home - Invoicing - The Invoice - Data Details - Tenant Info - Tenant Loads - Setup Tab - Setup Instructions

Note - This invoice can be modified any way you like.  The Master file name is TenantBillingMaster.xls and is found in the "C:\Program Files\Tenant Billing" directory. Any changes you make to the master file will apply to all invoices generated.  The cells with the red note flag are named cells - Do Not Delete any named cells, this would cause an error.  The note tells you the name.  You can position the named cells anywhere on the sheet you like.  You can also add any text or graphics you like.  You can Bold or Underline, Size and position anything - anywhere.  Just be sure to include all the named cells in your master sheet.  I recommend leaving the details at the bottom of the invoice because the number of loads listed is variable.  

The name of the invoice file is invoicenumber.xls and is found in the "C:\Program Files\Tenant Billing\Invoices" directory.

 

The Details tab of the invoice contains all entries from the event log used in determining the time charged.

 

Home - Invoicing - The Invoice - Data Details - Tenant Info - Tenant Loads - Setup Tab - Setup Instructions

Details Tab

The screen capture above show the Load Summary.

For all of the display options, clicking on the To Notepad allows you to print the list that is currently displayed.

The screen capture above show the All Commands option.

The screen capture above shows the Call Log.

The screen capture above shows what you get if you click the To Notepad button with the Load Summary selected.

 

Home - Invoicing - The Invoice - Data Details - Tenant Info - Tenant Loads - Setup Tab - Setup Instructions

Tenant Info Tab

Click on a Tenant Name to display the info for that Tenant.

You can modify any Tenant info by selecting the Tenant, then click the Modify button.  When finished click the Save button.

Double-clicking on any Invoice number will open the file in Excel.

 

Home - Invoicing - The Invoice - Data Details - Tenant Info - Tenant Loads - Setup Tab - Setup Instructions

Tenant Loads Tab

The first time you click on a Tenant Name or try to generate an invoice, you will be prompted to enter the Cost Per Hour for the selected load as shown below.

 

Selecting a Tenant shows all loads currently assigned to the Tenant.  Clicking on a load shows the Display Name and Cost Per Hour for that load.  After the loads have been configured, you can change them anytime you like by selecting the load and changing the Display Name or Cost Per Hour, then click the Save button.  When you change a value, the Save button will appear.  The new value is not saved until you click on the Save button.

 

Home - Invoicing - The Invoice - Data Details - Tenant Info - Tenant Loads - Setup Tab - Setup Instructions

Setup Tab

Current Log File - This shows the location and file name of the current MMX Log File.  To Change the Log File click on the Change Log File button.

Owner Setup - This is the information used on the invoice.  For Normal Hours you have the choice of Mon - Fri, Mon - Sat, All Week and None.  The start and end times for normal hours are selected from the combo boxes.

Invoice Numbering - You have two choices for Invoice Numbering.  The invoice number is the Excel file name.

    YYMMDD-ID  is the End Date of the invoice period followed by the Tenant ID number. 

    Incrementing Number will begin at the Next Number listed and add one to that number for every invoice generated.

Home - Invoicing - The Invoice - Data Details - Tenant Info - Tenant Loads - Setup Tab - Setup Instructions

Setup Instructions

  1. Before you start the application -
        A. You must have Excel installed of this PC.
        B. You must have access to the MMX Log File from this PC.  The default MMX Log File name is AWX32LOG.MDB but could have been named something else.

  2. Start the Application.

  3. Go to the Setup Tab and click the Change Log File button.

  4. Select the Drive Path and Filename of the MMX Log File.

  5. Complete the rest of the information in the Owner Setup box.

  6. Select the desired Invoice numbering scheme.

  7. Go to the Invoicing tab.  You should see tenant names listed in the Tenants list.

  8. Select the Start Date and End Date.

  9. The Cost Per Hour for the loads can be setup by clicking on a Tenant Name or clicking the Invoice button.  You will be prompted to enter the Cost Per Hour for each load the tenant controls.

    The application is now set up to generate invoices.

If you have any questions, feel free to call David Hagemann at 262-989-2771.

Thank you for your business.

 

Home - Invoicing - The Invoice - Data Details - Tenant Info - Tenant Loads - Setup Tab - Setup Instructions

 

Hit Counter

 

 

Send mail to david@davidhagemann.com with questions or comments about this web site.
Copyright © 2003 Custom Computer Systems
Last modified: October 19, 2007